You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@drill.apache.org by "Gautam Kumar Parai (JIRA)" <ji...@apache.org> on 2018/07/26 20:46:00 UTC

[jira] [Updated] (DRILL-6589) Push transitive closure generated predicates past aggregates

     [ https://issues.apache.org/jira/browse/DRILL-6589?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Gautam Kumar Parai updated DRILL-6589:
--------------------------------------
    Summary: Push transitive closure generated predicates past aggregates  (was: Push transitive closure generated predicates past aggregates/projects)

> Push transitive closure generated predicates past aggregates
> ------------------------------------------------------------
>
>                 Key: DRILL-6589
>                 URL: https://issues.apache.org/jira/browse/DRILL-6589
>             Project: Apache Drill
>          Issue Type: Bug
>    Affects Versions: 1.13.0
>            Reporter: Gautam Kumar Parai
>            Assignee: Gautam Kumar Parai
>            Priority: Major
>              Labels: ready-to-commit
>             Fix For: 1.15.0
>
>
> Here is a sample query that may benefit from this optimization:
> SELECT * FROM T1 WHERE a1 = 5 AND a1 IN (SELECT a2 FROM T2); 
> Here the transitive predicate a2 = 5 would be pushed past the aggregate due to this optimization.



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)