--! qt:dataset:src


create table if not exists nzhang_part5 (key string) partitioned by (value string);
describe extended nzhang_part5;

set hive.merge.mapfiles=false;
set hive.exec.dynamic.partition=true;
set hive.exec.max.dynamic.partitions=2000;
set hive.exec.max.dynamic.partitions.pernode=2000;

explain
insert overwrite table nzhang_part5 partition (value) select key, value from src;

insert overwrite table nzhang_part5 partition (value) select key, value from src;

show partitions nzhang_part5;

select * from nzhang_part5 where value='val_0';
select * from nzhang_part5 where value='val_2';