/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/load_dyn_part8.q

 1show partitions srcpart;
 2
 3
 4
 5create table if not exists nzhang_part8 like srcpart;
 6describe extended nzhang_part8;
 7
 8set hive.merge.mapfiles=false;
 9set hive.exec.dynamic.partition=true;
10set hive.exec.dynamic.partition.mode=nonstrict;
11
12explain extended
13from srcpart
14insert overwrite table nzhang_part8 partition (ds, hr) select key, value, ds, hr where ds <= '2008-04-08'
15insert overwrite table nzhang_part8 partition(ds='2008-12-31', hr) select key, value, hr where ds > '2008-04-08';
16
17from srcpart
18insert overwrite table nzhang_part8 partition (ds, hr) select key, value, ds, hr where ds <= '2008-04-08'
19insert overwrite table nzhang_part8 partition(ds='2008-12-31', hr) select key, value, hr where ds > '2008-04-08';
20
21show partitions nzhang_part8;
22
23select * from nzhang_part8 where ds is not null and hr is not null;
24