hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sergey Shelukhin (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-14652) incorrect results for not in on partition columns
Date Fri, 26 Aug 2016 01:33:20 GMT
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)

Mime
View raw message