[IMPALA-8954] Support uncorrelated subqueries in the select list

• Type: Sub-task
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: Impala 3.3.0
• Fix Version/s: Impala 4.0.0
• Component/s: Frontend
• Labels: sql-language tpc-ds
• Epic Color: ghx-label-12
• Assignee: Shant Hovsepian
• Reporter: Tim Armstrong
• Created: 18/Sep/19 20:47
• Updated: 13/Jul/20 23:01
• Resolved: 10/Jul/20 03:57

Description

[localhost:21000] default> select 'foo', (select 'bar');
Query: select 'foo', (select 'bar')
Query submitted at: 2019-09-18 13:44:43 (Coordinator: http://tarmstrong-box:25000)
ERROR: AnalysisException: Subqueries are not supported in the select list.

I think we can support these, implemented as a nested loop join with a cardinality check node if needed.

Issue Links

• breaks: IMPALA-9949 Subqueries in select can result in rows not being returned