[jira] [Created] (HIVE-15175) NOT IN condition is not handled correctly with predicate push down

["Teruyoshi Zenmyo (JIRA)" <ji...@apache.org>]

Teruyoshi Zenmyo created HIVE-15175:
---------------------------------------

             Summary: NOT IN condition is not handled correctly with predicate push down
                 Key: HIVE-15175
                 URL: https://issues.apache.org/jira/browse/HIVE-15175
             Project: Hive
          Issue Type: Bug
    Affects Versions: 2.1.0
            Reporter: Teruyoshi Zenmyo


With predicate pushdown enabled, NOT IN conditions are treated as FALSE.

Example (pkey is a partition key)
{code}
hive> select * from test;
OK
test.key        test.val        test.pkey
a       1       a
b       2       a
c       3       a
a       1       b
b       2       b
c       3       b
Time taken: 0.171 seconds, Fetched: 6 row(s)
hive> set hive.optimize.ppd=false;
hive> select * from test where not pkey in ('a');
OK
test.key        test.val        test.pkey
a       1       b
b       2       b
c       3       b
Time taken: 0.237 seconds, Fetched: 3 row(s)
hive> set hive.optimize.ppd=true;
hive> select * from test where not pkey in ('a');
OK
test.key        test.val        test.pkey
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)