You are viewing a plain text version of this content. The canonical link for it is here.
Posted to common-dev@hadoop.apache.org by "Joey Pan (JIRA)" <ji...@apache.org> on 2008/10/31 18:33:44 UTC
[jira] Created: (HADOOP-4561) Output invalid when choose all
columns from left table of a join
Output invalid when choose all columns from left table of a join
-----------------------------------------------------------------
Key: HADOOP-4561
URL: https://issues.apache.org/jira/browse/HADOOP-4561
Project: Hadoop Core
Issue Type: Bug
Components: contrib/hive
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.