[
https://issues.apache.org/jira/browse/IMPALA-9905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17152117#comment-17152117
]
ASF subversion and git services commented on IMPALA-9905:
---------------------------------------------------------
Commit 2dca55695ef3c208ece543ad36bece2a985cf8da in impala's branch
refs/heads/master from Shant Hovsepian
[ https://gitbox.apache.org/repos/asf?p=impala.git;h=2dca556 ]
IMPALA-9784, IMPALA-9905: Uncorrelated subqueries in HAVING.
Support rewriting subqueries in the HAVING clause by nesting the
aggregation query and pulling up the subquery predicates into the outer
WHERE clause.
Testing:
* New analyzer tests
* New functional subquery tests
* Added Q23, Q24 and Q44 to the tpcds workload
* Ran subquery rewrite tests
Change-Id: I124a58a09a1a47e1222a22d84b54fe7d07844461
Reviewed-on: http://gerrit.cloudera.org:8080/16052
Tested-by: Impala Public Jenkins <[email protected]>
Reviewed-by: Tim Armstrong <[email protected]>
> 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]
