完美解决Dynamic partition strict mode requires at least one static partition column. To turn this off se

今天使用本地搭建的集群运行一个hive脚本任务的时候,发现插入表的时候报错如下
FAILED: SemanticException [Error 10096]: Dynamic partition strict mode requires at least one static partition column. To turn this off set hive.exec.dynamic.partition.mode=nonstrict

意思是:动态分区至少需要在严格模式
所以需要在脚本中添加如下命令将模式改变为非严格模式

set hive.exec.dynamic.partition=true;
set hive.exec.dynamic.partition.mode=nostrick;

完美解决Dynamic partition strict mode requires at least one static partition column. To turn this off se最先出现在Python成神之路。