[HIVE-14594] CBO: Calcite Operator To Hive Operator(Calcite Return Path): Fix wrong result in join_filters_overlap

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: CBO
• Assignee: Vineet Garg Assign to me
• Reporter: Vineet Garg
• Created: 21/Aug/16 22:22
• Updated: 04/May/20 19:52

Description

Setup

 create table a as SELECT 100 as key, a.value as value FROM src LATERAL VIEW explode(array(40, 50, 60)) a as value limit 3; 

Query:

 select * from a left outer join a b on (a.key=b.key AND a.value=50 AND b.value=50) left outer join a c on (a.key=c.key AND a.value=60 AND c.value=60); 

Expected Result:

100	40	NULL	NULL	NULL	NULL
100	50	100	50	NULL	NULL
100	60	NULL	NULL	100	60

Actual Result:

100	40	NULL	50	NULL	60
100	50	100	50	NULL	60
100	60	NULL	50	100	60

Issue Links

• relates to: CALCITE-1338 JoinProjectTransposeRule makes wrong transformation when the right child of left outer join has a RexLiteral project expression