/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/load_dyn_part8.q
text | 24 lines | 15 code | 9 blank | 0 comment | 0 complexity | a7cbaaa53a1f80fb5d031d514b2d95bf MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
- show partitions srcpart;
- create table if not exists nzhang_part8 like srcpart;
- describe extended nzhang_part8;
- set hive.merge.mapfiles=false;
- set hive.exec.dynamic.partition=true;
- set hive.exec.dynamic.partition.mode=nonstrict;
- explain extended
- from srcpart
- insert overwrite table nzhang_part8 partition (ds, hr) select key, value, ds, hr where ds <= '2008-04-08'
- insert overwrite table nzhang_part8 partition(ds='2008-12-31', hr) select key, value, hr where ds > '2008-04-08';
- from srcpart
- insert overwrite table nzhang_part8 partition (ds, hr) select key, value, ds, hr where ds <= '2008-04-08'
- insert overwrite table nzhang_part8 partition(ds='2008-12-31', hr) select key, value, hr where ds > '2008-04-08';
- show partitions nzhang_part8;
- select * from nzhang_part8 where ds is not null and hr is not null;