| --! 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; |