hive 插入数据,insert后报错 FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.Ma

hive 插入数据的时候,不能直接运行,报错

Error during job, obtaining debugging information...

FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask

错误原因:
namenode内存空间不够,JVM剩余内存空间不够新job运行所致

错误提示

Starting Job = job_1594085668614_0006, Tracking URL = http://kudu:8088/proxy/application_1594085668614_0006/
Kill Command = /root/soft/hadoop-3.2.1/bin/mapred job -kill job_1594085668614_0006
Hadoop job information for Stage-1: number of mappers: 0; number of reducers: 0
2020-07-07 09:43:24,559 Stage-1 map = 0%, reduce = 0%
Ended Job = job_1594085668614_0006 with errors
Error during job, obtaining debugging information…

FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
MapReduce Jobs Launched:
Stage-Stage-1: HDFS Read: 0 HDFS Write: 0 FAIL
Total MapReduce CPU Time Spent: 0 msec
1

解决办法:

在hive> 下,输入
set hive.exec.mode.local.auto=true;

Original: https://blog.csdn.net/m0_62783212/article/details/126325650
Author: mazankang
Title: hive 插入数据,insert后报错 FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.Ma

原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/817682/

转载文章受原作者版权保护。转载请注明原作者出处!

(0)

大家都在看

亲爱的 Coder【最近整理,可免费获取】👉 最新必读书单  | 👏 面试题下载  | 🌎 免费的AI知识星球