-- create testing table. create table part_boolexpr(key int, value string) partitioned by (dt int, ts string); -- both the below queries should return 0 rows select count(*) from part_boolexpr where key = 'abc'; select * from part_boolexpr where dt = 'abc'; explain select count(1) from srcpart where true; explain select count(1) from srcpart where false; explain select count(1) from srcpart where true and hr='11'; explain select count(1) from srcpart where true or hr='11'; explain select count(1) from srcpart where false or hr='11'; explain select count(1) from srcpart where false and hr='11';