[IMPALA-1425] Subqueries are not supported in a UNION query

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.0
• Fix Version/s: Impala 2.1
• Labels: Subquery, Union
• Environment: running on cluster of 3 AMD powered servers
• Assignee: Unassigned
• Reporter: Alex Finch
• Created: 27/Oct/14 13:56
• Updated: 20/Dec/15 00:05
• Resolved: 27/Oct/14 16:54

Description

Query:
select * from logs where field1 in (select field2 from logs) union all select * from logs;

Result:
ERROR: AnalysisException: Subqueries are not supported in a UNION query: SELECT * FROM default.logs WHERE field1 IN (SELECT field2 FROM default.logs) UNION ALL SELECT * FROM default.logs

Documentation doesn't state this shouldn't work.