You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Greg Rahn (Jira)" <ji...@apache.org> on 2019/09/18 22:57:00 UTC
[jira] [Commented] (IMPALA-8954) Support subqueries in the select
list
[ https://issues.apache.org/jira/browse/IMPALA-8954?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16932904#comment-16932904 ]
Greg Rahn commented on IMPALA-8954:
-----------------------------------
See also TPC-DS query 9
https://github.com/gregrahn/tpcds-kit/blob/master/query_templates/query9.tpl
> Support 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
> Priority: Major
> Labels: tpc-ds
>
> {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