Hive动态分区参数配置

Caused by: org.apache.hadoop.hive.ql.metadata.HiveFatalException: [Error 20004]: Fatal error occurred when node tried to create too many dynamic partitions. The maximum number of dynamic partitions is controlled by hive.exec.max.dynamic.partitions and hive.exec.max.dynamic.partitions.pernode. Maximum was set to: 5000

set hive.exec.dynamic.partition=true;  
set hive.exec.dynamic.partition.mode=nonstrict;  
  
-- 特别大时，执行以下参数设置
set hive.exec.dynamic.partitions.pernode=1024;  
set hive.exec.dynamic.partitions.partitions=2048;  
set hive.exec.max.created.files=20000;