sql - Hive:失败:执行错误，从org.apache.hadoop.hive.ql.exec.mr.MapRedTask返回代码2

Question

FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask error while inserting record into hive table.

select * from tablename运行正常。

我是否需要在hive-site.xml中添加任何属性？

Answer 1

看来您正在尝试插入分区表。
在插入之前设置下面的属性。

SET hive.exec.dynamic.partition = true;
SET hive.exec.dynamic.partition.mode = nonstrict;
set hive.exec.max.dynamic.partitions=10000;
set hive.exec.max.dynamic.partitions.pernode=1000;