| --! qt:dataset:src | |
| set hive.mapred.mode=nonstrict; | |
| create table tst_n0(a string, b string) partitioned by (d string); | |
| alter table tst_n0 add partition (d='2009-01-01'); | |
| insert overwrite table tst_n0 partition(d='2009-01-01') | |
| select tst_n0.a, src.value from tst_n0 join src ON (tst_n0.a = src.key); | |
| select * from tst_n0 where tst_n0.d='2009-01-01'; | |