[jira] [Resolved] (IMPALA-9905) Allow runtime scalar subquery check when group by clause is present

["Shant Hovsepian (Jira)" <ji...@apache.org>]

     [ 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)