ql/src/test/queries/clientpositive/null_column.q

--! qt:dataset:src




create table temp_null(a int) stored as textfile;
load data local inpath '../../data/files/test.dat' overwrite into table temp_null;

select null, null from temp_null;

create table tt_n1(a int, b string);
insert overwrite table tt_n1 select null, null from temp_null;
select * from tt_n1;

create table tt_b(a int, b string) row format serde "org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe";
insert overwrite table tt_b select null, null from temp_null;
select * from tt_b;

insert overwrite directory "target/warehouse/null_columns.out" select null, null from temp_null;
dfs -cat ${system:test.warehouse.dir}/null_columns.out/*;


create table temp_null2 (key string, value string) partitioned by (ds string);
insert overwrite table temp_null2 partition(ds='2010-04-01') select '1',NULL from src limit 1;
select * from temp_null2 where ds is not null;