[
https://issues.apache.org/jira/browse/IMPALA-9905?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Shant Hovsepian resolved IMPALA-9905.
-------------------------------------
Target Version: Impala 4.0
Resolution: Fixed
> Allow runtime scalar subquery check when group by clause is present
> -------------------------------------------------------------------
>
> Key: IMPALA-9905
> URL: https://issues.apache.org/jira/browse/IMPALA-9905
> Project: IMPALA
> Issue Type: Improvement
> Components: Frontend
> Reporter: Shant Hovsepian
> Assignee: Shant Hovsepian
> Priority: Minor
> Labels: planner, tpc-ds
>
> We can also use a runtime scalar subquery check for subqueries that have a
> scalar return type and also contain a grouping expression.
>
> For example the following query would pass a runtime scalar check, given the
> predicate on the grouping expression.
> {{select * from functional.alltypes where id < (select count(bool_col) from
> functional.alltypes where int_col=1 group by int_col);}}
>
> Ideally we could detect situation like the above at plan time and avoid the
> runtime scalar check all together with
> [IMPALA-1285|https://issues.apache.org/jira/browse/IMPALA-1285]
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
