[HIVE-1534] Join filters do not work correctly with outer joins

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.7.0
• Component/s: Query Processor
• Hadoop Flags: Reviewed
• Assignee: Amareshwari Sriramadasu
• Reporter: Amareshwari Sriramadasu
• Created: 12/Aug/10 06:05
• Updated: 06/Sep/16 23:39
• Resolved: 21/Sep/10 21:00

Description

SELECT * FROM T1 LEFT OUTER JOIN T2 ON (T1.c1=T2.c2 AND T1.c1 < 10)
and SELECT * FROM T1 RIGHT OUTER JOIN T2 ON (T1.c1=T2.c2 AND T2.c1 < 10)
do not give correct results.

Issue Links

• is blocked by: HIVE-5321 Join filters do not work correctly with outer joins again
• is related to: HIVE-14522 CBO: Calcite Operator To Hive Operator(Calcite Return Path): Fix test failure for auto_join_filters
• is related to: HIVE-1621 Disable join filters for outer joins.
• relates to: HIVE-1621 Disable join filters for outer joins.