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)

Reply via email to