set hive.insert.into.external.tables=false;


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

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