hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ankit Kamboj (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-2791) filter is still removed due to regression of HIVE-1538 althougth HIVE-2344
Date Thu, 29 Nov 2012 20:22:58 GMT

    [ 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

Mime
View raw message