[
https://issues.apache.org/jira/browse/HIVE-2791?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13506756#comment-13506756
]
Ankit Kamboj commented on HIVE-2791:
------------------------------------
Hi guys,
There is a use case I have attached: ppd-dropped-filter.q. The last 2 insert
queries in the file contain following 'in' predicates:
where t3.crit5 in ('a' , 'b' ) and where t3.crit5 in ('c' , 'd' , 'e' )
The explain output doesn't contain Filter Operators for these 'in' predicates.
This results in execution of incorrect query (without in clauses).
The workaround is set hive.ppd.remove.duplicatefilters=false;
Is this use case related to this patch?
> filter is still removed due to regression of HIVE-1538 althougth HIVE-2344
> --------------------------------------------------------------------------
>
> Key: HIVE-2791
> URL: https://issues.apache.org/jira/browse/HIVE-2791
> Project: Hive
> Issue Type: Bug
> Reporter: binlijin
> Assignee: binlijin
> Fix For: 0.9.0
>
> Attachments: HIVE-2791.2.patch, HIVE-2791.patch, ppd-dropped-filter.q
>
>
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
