--! qt:dataset:src


create table texternal_n0(key string, val string) partitioned by (insertdate string);

dfs ${system:test.dfs.mkdir} ${system:test.tmp.dir}/texternal/temp;
dfs -rmr ${system:test.tmp.dir}/texternal;
dfs ${system:test.dfs.mkdir} ${system:test.tmp.dir}/texternal/2008-01-01;

alter table texternal_n0 add partition (insertdate='2008-01-01') location 'pfile://${system:test.tmp.dir}/texternal/2008-01-01';
from src insert overwrite table texternal_n0 partition (insertdate='2008-01-01') select *;

select * from texternal_n0 where insertdate='2008-01-01';

dfs -rmr ${system:test.tmp.dir}/texternal;