hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jonathan Hseu (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-13481) Hive drops boolean column filters when CBO is disabled
Date Mon, 11 Apr 2016 18:37:25 GMT
Jonathan Hseu created HIVE-13481:
------------------------------------

             Summary: Hive drops boolean column filters when CBO is disabled
                 Key: HIVE-13481
                 URL: https://issues.apache.org/jira/browse/HIVE-13481
             Project: Hive
          Issue Type: Bug
    Affects Versions: 2.0.0, 1.2.1
            Reporter: Jonathan Hseu


Reproduce with:
create table test_partitioned (a boolean) partitioned by (b string);
insert into test_partitioned partition (b='x') values (true);
insert into test_partitioned partition (b='x') values (false);
set hive.cbo.enable=false;
hive> select a from (select a,b from test_partitioned) x where a and b='x';
OK
true
false

Note we expect the above to just show true.

If you disable ppd, it works:
set hive.optimize.ppd=false;
hive> select a from (select a,b from test_partitioned) x where a and b='x';
OK
true

Probably an issue with PPD, because enabling CBO disables PPD:
https://issues.apache.org/jira/browse/HIVE-11865



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

Mime
View raw message