hadoop-common-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Joey Pan (JIRA)" <j...@apache.org>
Subject [jira] Created: (HADOOP-4561) Output invalid when choose all columns from left table of a join
Date Fri, 31 Oct 2008 17:33:44 GMT
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.


Mime
View raw message