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