[HIVE-8298] Incorrect results for n-way join when join expressions are not in same order across joins

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 0.13.0, 0.13.1
• Fix Version/s: 0.14.0
• Component/s: Logical Optimizer
• Assignee: Ashutosh Chauhan
• Reporter: Ashutosh Chauhan
• Created: 29/Sep/14 23:51
• Updated: 18/Dec/14 13:55
• Resolved: 30/Sep/14 15:56

Description

select * from srcpart a join srcpart b on a.key = b.key and a.hr = b.hr join srcpart c on a.hr = c.hr and a.key = c.key;
is minimal query which reproduces it

Issue Links

• is duplicated by: HIVE-9146 Query with left joins produces wrong result when join condition is written in different order
• is duplicated by: HIVE-8856 Multiple joins must have conditionals in same order
• links to: RB request