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)