CREATE TABLE src_null_n2(a bigint) STORED AS TEXTFILE;
LOAD DATA LOCAL INPATH '../../data/files/nulls.txt' INTO TABLE src_null_n2;

create table all_nulls as SELECT a, cast(a as double) as b, cast(a as decimal) as c  FROM src_null_n2 where a is null limit 5;
analyze table all_nulls compute statistics for columns;

describe formatted all_nulls a;
describe formatted all_nulls b;

drop table all_nulls;
drop table src_null_n2;