set hive.fetch.task.conversion=none; | |
create table test_table_n7(d date); | |
insert into test_table_n7 values(null), (null), (null); | |
analyze table test_table_n7 compute statistics for columns; | |
describe formatted test_table_n7; | |
explain select * from test_table_n7 where d is not null; | |
select * from test_table_n7 where d is not null; | |