blob: 6f69821c666acee4cedda2a8c0a6d267d48b2e1f [file] [log] [blame]
--! 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;