[HIVE-1657] join results are displayed wrongly for some complex joins using select *

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.7.0
• Hadoop Flags: Reviewed
• Assignee: Amareshwari Sriramadasu
• Reporter: Amareshwari Sriramadasu
• Created: 20/Sep/10 10:06
• Updated: 17/Dec/11 00:01
• Resolved: 29/Oct/10 21:36

Description

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.