[jira] Updated: (HIVE-1657) join results are displayed wrongly for some complex joins using select *
[ https://issues.apache.org/jira/browse/HIVE-1657?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-1657: - Resolution: Fixed Hadoop Flags: [Reviewed] Status: Resolved (was: Patch Available) Committed. Thanks Amareshwari > join results are displayed wrongly for some complex joins using select * > > > Key: HIVE-1657 > URL: https://issues.apache.org/jira/browse/HIVE-1657 > Project: Hive > Issue Type: Bug >Reporter: Amareshwari Sriramadasu >Assignee: Amareshwari Sriramadasu > Attachments: patch-1657.txt > > > Noticed that the output of the join is displayed wrongly for queries > involving more than one table and mixture of left and outer joins, with > different join conditions. > For ex: SELECT * from T1 a RIGHT OUTER JOIN T2 b ON (a.value=b.value) LEFT > OUTER JOIN T3 c ON (b.key=c.key); > displays the table T2 first, then T1 and T3. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1657) join results are displayed wrongly for some complex joins using select *
[ https://issues.apache.org/jira/browse/HIVE-1657?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Amareshwari Sriramadasu updated HIVE-1657: -- Assignee: Amareshwari Sriramadasu Status: Patch Available (was: Open) > join results are displayed wrongly for some complex joins using select * > > > Key: HIVE-1657 > URL: https://issues.apache.org/jira/browse/HIVE-1657 > Project: Hive > Issue Type: Bug >Reporter: Amareshwari Sriramadasu >Assignee: Amareshwari Sriramadasu > Attachments: patch-1657.txt > > > Noticed that the output of the join is displayed wrongly for queries > involving more than one table and mixture of left and outer joins, with > different join conditions. > For ex: SELECT * from T1 a RIGHT OUTER JOIN T2 b ON (a.value=b.value) LEFT > OUTER JOIN T3 c ON (b.key=c.key); > displays the table T2 first, then T1 and T3. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1657) join results are displayed wrongly for some complex joins using select *
[ https://issues.apache.org/jira/browse/HIVE-1657?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Amareshwari Sriramadasu updated HIVE-1657: -- Attachment: patch-1657.txt Here is a patch to add the output columns for select plan in the order of aliases specified in the query. > join results are displayed wrongly for some complex joins using select * > > > Key: HIVE-1657 > URL: https://issues.apache.org/jira/browse/HIVE-1657 > Project: Hive > Issue Type: Bug >Reporter: Amareshwari Sriramadasu > Attachments: patch-1657.txt > > > Noticed that the output of the join is displayed wrongly for queries > involving more than one table and mixture of left and outer joins, with > different join conditions. > For ex: SELECT * from T1 a RIGHT OUTER JOIN T2 b ON (a.value=b.value) LEFT > OUTER JOIN T3 c ON (b.key=c.key); > displays the table T2 first, then T1 and T3. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
[jira] Updated: (HIVE-1657) join results are displayed wrongly for some complex joins using select *
[ https://issues.apache.org/jira/browse/HIVE-1657?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Namit Jain updated HIVE-1657: - Summary: join results are displayed wrongly for some complex joins using select * (was: join results are displayed wrongly for some complex joins) > join results are displayed wrongly for some complex joins using select * > > > Key: HIVE-1657 > URL: https://issues.apache.org/jira/browse/HIVE-1657 > Project: Hive > Issue Type: Bug >Reporter: Amareshwari Sriramadasu > > Noticed that the output of the join is displayed wrongly for queries > involving more than one table and mixture of left and outer joins, with > different join conditions. > For ex: SELECT * from T1 a RIGHT OUTER JOIN T2 b ON (a.value=b.value) LEFT > OUTER JOIN T3 c ON (b.key=c.key); > displays the table T2 first, then T1 and T3. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.
