blob: ea609df32a48b100d5d4b70f007fd362baa6f20d [file] [log] [blame]
--! qt:dataset:src
set hive.mapred.mode=nonstrict;
dfs ${system:test.dfs.mkdir} hdfs:///target/tmp/test_empty_table;
create external table roottable (key string) row format delimited fields terminated by '\\t' stored as textfile location 'hdfs:///target/tmp/test_empty_table';
select count(*) from roottable;
insert into table roottable select key from src where (key < 20) order by key;
select count(*) from roottable;
dfs ${system:test.dfs.mkdir} hdfs:///target/tmp/test_empty_table/empty;
select count(*) from roottable;