[
https://issues.apache.org/jira/browse/HIVE-7304?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14047773#comment-14047773
]
Ashutosh Chauhan commented on HIVE-7304:
----------------------------------------
Is not null check should be added only if there is no other filter predicate
already being present. eg, we are now getting filter predicates as follows
where {{is not null}} is redundant.
{code}
((key < 100) and key is not null)
{code}
Perhaps, could be taken up in a follow-up.
> Transitive Predicate Propagation doesn't happen properly after HIVE-7159
> ------------------------------------------------------------------------
>
> Key: HIVE-7304
> URL: https://issues.apache.org/jira/browse/HIVE-7304
> Project: Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Harish Butani
> Assignee: Harish Butani
> Attachments: HIVE-7304.1.patch, HIVE-7304.2.patch
>
>
> The reason for the regression is that PredicateTransitivePropagate looks at
> the FilterOperator below the ReduceSink.
> SemanticAnalyzer::genNotNullFilterForJoinSourcePlan was stacking another
> FilterOp for the not null check, so only that predicate was being applied
> transitively by PredicateTransitivePropagate.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
