You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Ashish Thusoo (JIRA)" <ji...@apache.org> on 2009/01/07 14:38:44 UTC

[jira] Commented: (HIVE-22) Output invalid when choose all columns from left table of a join

    [ https://issues.apache.org/jira/browse/HIVE-22?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12661561#action_12661561 ] 

Ashish Thusoo commented on HIVE-22:
-----------------------------------

I believe that this has been fixed by Namit.

> Output invalid when choose all columns from left table of a join 
> -----------------------------------------------------------------
>
>                 Key: HIVE-22
>                 URL: https://issues.apache.org/jira/browse/HIVE-22
>             Project: Hadoop Hive
>          Issue Type: Bug
>          Components: Query Processor
>            Reporter: Joey Pan
>
> Here is what I observed, in a hive command:  from ad_stat2 join ad  on(ad_stat2.ad_id=ad.ad_id) select ad_stat2.*,  ad.ad_id where ad_stat2.ad_clk>1000;
> In the command, 2 tables are involved, the observation is if the output includes all columns of left table(ad_stat2.*), then no matter what columns you pick for the right table, it will print out all columns of right table.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.