[
https://issues.apache.org/jira/browse/HIVE-14652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15450203#comment-15450203
]
Sergey Shelukhin edited comment on HIVE-14652 at 8/30/16 9:27 PM:
------------------------------------------------------------------
Adding the struct handling separately from IN. This restores the predicate
removal in most of the tests; one of the filters restored in pcs appears to be
restored correctly, the removal was only valid by coincidence, as a mixed
predicate has the same condition in this query.
was (Author: sershe):
Adding the struct handling separately from IN. This reverts back some of the
tests; one of the filters restored in pcs appears to be restored correctly, the
removal was only valid by coincidence, as a mixed predicate has the same
condition in this query.
> incorrect results for not in on partition columns
> -------------------------------------------------
>
> Key: HIVE-14652
> URL: https://issues.apache.org/jira/browse/HIVE-14652
> Project: Hive
> Issue Type: Bug
> Affects Versions: 2.1.0, 2.2.0
> Reporter: stephen sprague
> Assignee: Sergey Shelukhin
> Priority: Blocker
> Attachments: HIVE-14652.01.patch, HIVE-14652.02.patch,
> HIVE-14652.patch
>
>
> {noformat}
> create table foo (i int) partitioned by (s string);
> insert overwrite table foo partition(s='foo') select cint from alltypesorc
> limit 10;
> insert overwrite table foo partition(s='bar') select cint from alltypesorc
> limit 10;
> select * from foo where s not in ('bar');
> {noformat}
> No results. IN ... works correctly
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
