在hive中把查询出来的数据导入数据表时报FAILED: SemanticException [Error 10096]: Dynamic partition strict mode...

报错如下：

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

hive (sdw_data)> insert overwrite table SDW_DATA.SDW_LOAN_DK  
               > partition(LN_DB_PART_ID)select * from SDA_DATA.SDA_CBOD_LNLNSLNS ;
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

解决办法：

在hive中添加配置，执行下列命令，重新运行就可以成功了

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