[HIVE-18173] Improve plans for correlated subqueries with non-equi predicate

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0.0
• Component/s: Query Planning
• Assignee: Vineet Garg
• Reporter: Vineet Garg
• Created: 29/Nov/17 02:34
• Updated: 22/May/18 23:14
• Resolved: 07/Dec/17 03:56

Description

HIVE-17767 optimized plan to not generate value generator (i.e. an extra join with outer query to fetch correlated columns) for EQUAL and NOT EQUAL predicates e.g.

select * from src b where b.key in (select key from src a where b.value <> a.value)

This should be improved and implemented for rest of the predicates e.g. LESS THAN etc

Issue Links

• links to: ReviewBoard