You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Sergey Shelukhin (JIRA)" <ji...@apache.org> on 2016/08/26 01:33:20 UTC

[jira] [Created] (HIVE-14652) incorrect results for not in on partition columns

Sergey Shelukhin created HIVE-14652:
---------------------------------------

             Summary: 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)