[jira] [Resolved] (IMPALA-8954) Support uncorrelated subqueries in the select list

["Tim Armstrong (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-8954?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Tim Armstrong resolved IMPALA-8954.
-----------------------------------
    Fix Version/s: Impala 4.0
       Resolution: Fixed

> Support uncorrelated subqueries in the select list
> --------------------------------------------------
>
>                 Key: IMPALA-8954
>                 URL: https://issues.apache.org/jira/browse/IMPALA-8954
>             Project: IMPALA
>          Issue Type: Sub-task
>          Components: Frontend
>    Affects Versions: Impala 3.3.0
>            Reporter: Tim Armstrong
>            Assignee: Shant Hovsepian
>            Priority: Critical
>              Labels: sql-language, tpc-ds
>             Fix For: Impala 4.0
>
>
> {noformat}
> [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.
> {noformat}
> I think we can support these, implemented as a nested loop join with a cardinality check node if needed.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org