[HIVE-15758] Allow correlated scalar subqueries with aggregates which has non-equi join predicates

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 3.0.0
• Component/s: Logical Optimizer
• Labels: TODOC3.0 sub-query
• Assignee: Vineet Garg
• Reporter: Vineet Garg
• Created: 31/Jan/17 00:59
• Updated: 22/May/18 23:57
• Resolved: 18/Jul/17 19:23

Description

Queries such as

 select * from part where p_size <> (select count(p_size) from part pp where part.p_type <> pp.p_type); 

are currently not allowed since HIVE doesn't know how to rewrite such queries to preserve the correctness for cases when there is zero row

Issue Links

• is duplicated by: HIVE-16773 Support non-equi join predicate in scalar subqueries with aggregate
• links to: ReviewBoard