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

Jesus Camacho Rodriguez updated HIVE-11865:
-------------------------------------------
    Attachment: HIVE-11865.05.patch

After checking q files changes, I needed to extend the simpler version of PPD. 
In particular, synthetic join predicates (for dynamic partition pruning) are 
introduced just below join, so those particular predicates need to be pushed. 
Further, if we have a Filter operator that is an ancestor of a PTF operator, 
and between the Filter and the PTF there are only Select operators, we also 
need to push its predicates on top of the PTF; the reason is that otherwise 
LimitPushdownOptimizer will not kick in for the Rank function.

[~jpullokkaran], QA run should come clean. Could you review the code? Thanks

> Disable Hive PPD optimizer when CBO has optimized the plan
> ----------------------------------------------------------
>
>                 Key: HIVE-11865
>                 URL: https://issues.apache.org/jira/browse/HIVE-11865
>             Project: Hive
>          Issue Type: Bug
>          Components: CBO, Logical Optimizer
>    Affects Versions: 2.0.0
>            Reporter: Jesus Camacho Rodriguez
>            Assignee: Jesus Camacho Rodriguez
>         Attachments: HIVE-11865.01.patch, HIVE-11865.02.patch, 
> HIVE-11865.02.patch, HIVE-11865.03.patch, HIVE-11865.04.patch, 
> HIVE-11865.05.patch, HIVE-11865.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to