You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "ASF subversion and git services (Jira)" <ji...@apache.org> on 2020/07/06 15:49:00 UTC

[jira] [Commented] (IMPALA-9784) Support uncorrelated scalar subqueries in HAVING

    [ https://issues.apache.org/jira/browse/IMPALA-9784?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17152116#comment-17152116 ] 

ASF subversion and git services commented on IMPALA-9784:
---------------------------------------------------------

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 <im...@cloudera.com>
Reviewed-by: Tim Armstrong <ta...@cloudera.com>


> Support uncorrelated scalar subqueries in HAVING
> ------------------------------------------------
>
>                 Key: IMPALA-9784
>                 URL: https://issues.apache.org/jira/browse/IMPALA-9784
>             Project: IMPALA
>          Issue Type: Sub-task
>            Reporter: Shant Hovsepian
>            Assignee: Shant Hovsepian
>            Priority: Major
>




--
This message was sent by Atlassian Jira
(v8.3.4#803005)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org