hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Teruyoshi Zenmyo (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-15175) NOT IN condition is not handled correctly with predicate push down
Date Thu, 10 Nov 2016 07:57:58 GMT
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)

Mime
View raw message