--! qt:dataset:src
set hive.mapred.mode=nonstrict;
set hive.vectorized.execution.enabled=false;

create table n(key int);

insert overwrite table n select null from src;

explain analyze table n compute statistics for columns;

analyze table n compute statistics for columns;

desc formatted n key;


create table i(key int);

insert overwrite table i select key from src;

explain analyze table i compute statistics for columns;

analyze table i compute statistics for columns;

desc formatted i key;

drop table i;

create table i(key double);

insert overwrite table i select key from src;

analyze table i compute statistics for columns;

desc formatted i key;

drop table i;

create table i(key decimal);

insert overwrite table i select key from src;

analyze table i compute statistics for columns;

desc formatted i key;

drop table i;

create table i(key date);

insert into i values ('2012-08-17');
insert into i values ('2012-08-17');
insert into i values ('2013-08-17');
insert into i values ('2012-03-17');
insert into i values ('2012-05-17');

analyze table i compute statistics for columns;

desc formatted i key;