set hive.exec.dynamic.partition=true;
set hive.exec.dynamic.partition.mode=nostrict;
set hive.exec.max.dynamic.partitions=2;


create table dynamic_partition (key string) partitioned by (value string);

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