blob: 22a9e7126c1f070be047cfa4eee2002f467c6736 [file] [log] [blame]
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;