[
https://issues.apache.org/jira/browse/HIVE-9334?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14273132#comment-14273132
]
Navis commented on HIVE-9334:
-----------------------------
PredicateTransitivePropagate is for propagating predicates in "on" condition in
JOIN operators only. Others should be dealt with generic PPD optimizer. So it's
right order to run PredicateTransitivePropagate first before PPD. (Yes, these
two can be merged into one optimizer, but PPD was too unstable in those days)
I don't know where "not-null" predicates is from but it's redundant and should
not be added (It's once removed by ConstantPropagateOptimizer).
> PredicateTransitivePropagate optimizer should run after PredicatePushDown
> -------------------------------------------------------------------------
>
> Key: HIVE-9334
> URL: https://issues.apache.org/jira/browse/HIVE-9334
> Project: Hive
> Issue Type: Improvement
> Components: Logical Optimizer
> Affects Versions: 0.10.0, 0.11.0, 0.12.0, 0.13.0, 0.14.0
> Reporter: Ashutosh Chauhan
> Assignee: Ashutosh Chauhan
> Attachments: HIVE-9334.1.patch, HIVE-9334.patch
>
>
> This way PredicateTransitivePropagate will be more effective as it has more
> filters to push for other branches of joins.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
