探索之后我得到了答案。

create table table (id string) partitioned by (value string) stored as ORC tblproperties ("orc.compress" = "SNAPPY");

SET hive.exec.dynamic.partition.mode=nonstrict;
SET hive.exec.dynamic.partition=true;

SET hive.exec.max.dynamic.partitions=2048;
SET hive.exec.max.dynamic.partitions.pernode=256;

INSERT INTO table1 PARTITION (value)
select * from table where value is not NULL;

SET hive.exec.dynamic.partition.mode=nonstrict;
SET hive.exec.dynamic.partition=true;

create table table (id string) partitioned by (value string) stored as ORC tblproperties ("orc.compress" = "SNAPPY");

INSERT INTO table1 PARTITION (value)
select * from table where value is not NULL;