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)
