[ https://issues.apache.org/jira/browse/HIVE-14652?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15438275#comment-15438275 ]
Sergey Shelukhin commented on HIVE-14652: ----------------------------------------- The partition pruning is performed correctly and the partition is added to inputs, locks and all > 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 > > {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)