使用spark往hive插数报错Dynamic partition strict mode requires at least one static partition column. To tur

最新推荐文章于 2024-11-13 11:08:32 发布

squeue2019

最新推荐文章于 2024-11-13 11:08:32 发布

阅读量4.4k

点赞数 1

分类专栏：解决方案 Spark 文章标签： spakr hive

本文链接：https://blog.csdn.net/sunkun2013/article/details/101051963

版权

在尝试使用Spark将数据插入到Hive的动态分区时遇到错误：'Dynamic partition strict mode requires at least one static partition column.' 该错误表明在执行动态分区操作时，至少需要一个静态分区列。解决办法是在Spark配置中关闭动态分区严格模式或确保至少有一个静态分区列。

摘要由CSDN通过智能技术生成

#报错

User class threw exception: org.apache.spark.SparkException: Dynamic partition strict mode requires at least one static partition column. To turn this off set hive.exec.dynamic.partition.mode=nonstrict
at org.apache.spark.sql.hive.execution.InsertIntoHiveTable.processInsert(InsertIntoHiveTable.scala:157)
at org.apache.spark.sql.hive.execution.InsertIntoHiveTable.run(InsertIntoHiveTable.scala:99)
at org.apache.spark.sql.execution.command.DataWritingCommandExec.sideEffectResult$lzycompute(commands.scala:104)
at org.apache.spark.sql.execution.command.DataWritingCommandExec.sideEffectResult(commands.scala:102)
at org.apache.spark.sql.execution.command.DataWritingCommandExec.executeCollect(commands.scala:115)
at org.apache.spark.sql.Dataset$$anonfun$6.apply(Dataset.scala:194)
at org.apache.spark.sql.Dataset$$anonfun$6.apply(Dataset.scala:194)
at org.apache.spark.sql.Dataset$$anonfun$53.apply(Dataset.scala:3364)
at org.apache.spark.sql.execution.SQ

最低0.47元/天解锁文章