[
https://issues.apache.org/jira/browse/IMPALA-5100?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Greg Rahn updated IMPALA-5100:
------------------------------
Labels: planner ramp-up sql-language tpc-ds (was: planner ramp-up tpc-ds)
> add run time scalar subquery check
> ----------------------------------
>
> Key: IMPALA-5100
> URL: https://issues.apache.org/jira/browse/IMPALA-5100
> Project: IMPALA
> Issue Type: Improvement
> Components: Backend, Frontend
> Reporter: Greg Rahn
> Priority: Major
> Labels: planner, ramp-up, sql-language, tpc-ds
>
> If an scalar subquery is used with an equality predicate, it must return only
> one row/column to be valid. If this can not be guaranteed at parse time
> through a single row aggregate or limit clause, Impala fails the query like
> such.
> {noformat}
> select i_manufact from item where i_item_sk = (select i_item_sk from item
> where i_item_sk = 1);
> ERROR: AnalysisException: Subquery must return a single row: (SELECT
> i_item_sk FROM tpcds_10000_parquet.item WHERE i_item_sk = 1)
> {noformat}
> Impala should allow these to run successfully by adding a run time assert in
> these cases if the SQ returns > 1 row when it should not.
> This impacts TPC-DS query6, query54, query58.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
