Dynamic partition strict mode requires at least one static partition column

作者：我家自动化 | 2024-04-23 15:11:26

踩

dynamic partition strict mode requires at least one static partition column.

由于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

使用shell脚本时报错

解决方法1：hive/conf/hive-site.xml添加参数


<!--非严格模式-->
  <property>
    <name>hive.exec.dynamic.partition.mode</name>
    <value>nonstrict</value>
  </property>
</configuration>

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/我家自动化/article/detail/474535