SQL 错误 [40000] [42000]: Error while compiling statement: FAILED

错误如下：

SQL 错误 [40000] [42000]: Error while compiling statement: FAILED: SemanticException table is not partitioned but partition spec exists: {month=null, day=null}

解决方法：

解决办法，在sql语句前面加

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