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.