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

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

Shant Hovsepian created IMPALA-9905:
---------------------------------------

             Summary: 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


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)