[IMPALA-1901] Support subqueries in disjunctions

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: Impala 2.1.1
• Component/s: Frontend
• Labels: sql-language
• Target Version: Product Backlog
• Assignee: Unassigned
• Reporter: Bharath Vissapragada
• Created: 18/Mar/15 07:10
• Updated: 02/Jul/17 01:28
• Resolved: 02/Jul/17 01:28

Description

For example a query like

select count from t1 where
( t1.a > 5 and not exists (select * from t2 where t1.a=t2.b))
or
( t1.a > 5 and not exists (select * from t2 where t1.a=t2.b));

Currently this gives,

ERROR: AnalysisException: Subqueries in OR predicates are not supported

Issue Links

• duplicates: IMPALA-5226 Add support for arbitrary subqueries in WHERE/HAVING, including inside disjuncts