| set hive.stats.fetch.column.stats=true; |
| |
| create table date_dim_n1 (d_date date) partitioned by (d_date_sk bigint) stored as orc; |
| insert into date_dim_n1 partition(d_date_sk=2416945) values('1905-04-09'); |
| insert into date_dim_n1 partition(d_date_sk=2416946) values('1905-04-10'); |
| insert into date_dim_n1 partition(d_date_sk=2416947) values('1905-04-11'); |
| analyze table date_dim_n1 partition(d_date_sk) compute statistics for columns; |
| |
| explain select count(*) from date_dim_n1 where d_date > date "1900-01-02" and d_date_sk= 2416945; |
| |
| insert into date_dim_n1 partition(d_date_sk=2416948) values('1905-04-12'); |
| |
| explain extended select d_date from date_dim_n1; |