sql报错：Dynamic partition strict mode requires at least one static partition column.

Dynamic partition strict mode requires at least one static partition column. To turn this off set hive.exec.dynamic.partition.mode=nonstrict

原因是：

建表里面有动态分区。（动态分区：比如以时间作为分区，那么分区就是每天都在增加，即是动态分区）

解决方案：

建表语句前增加2行：

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