[ https://issues.apache.org/jira/browse/HIVE-22?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12878497#action_12878497 ]
Soundararajan Velu commented on HIVE-22: ---------------------------------------- Ashish/Mamit, In which version has this been fixed, it will be great if you can confirm the release and the patch location. Thanks. > 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.