--! qt:dataset:srcpart | |
create table nzhang_part4 (key string) partitioned by (ds string, hr string, value string); | |
set hive.exec.dynamic.partition=true; | |
insert overwrite table nzhang_part4 partition(value = 'aaa', ds='11', hr) select key, hr from srcpart where ds is not null; | |
drop table nzhang_part4; |