2023/11/25 Hive自动分区特性向分区表各个分区中插入对应数据报错

错误信息

 Error while compiling statement: 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

set hive.exec.dynamic.partition=true;

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

set hive.exec.max.dynamic.partitions.pernode=1000;

insert overwrite table dividends partition(`exchange`,`symbol`) select

`ymd`,`dividend`,`exchange`,`symbol` from dividends_unpartitioned