[ 
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 <[email protected]>
Reviewed-by: Tim Armstrong <[email protected]>


> 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: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to