目录

描述：

过程

解决

描述：

可以建库建表

但无法插入数据

hive> insert into stu1 values(1,"ss");
Query ID = atguigu_20230316212603_bd0f5655-043f-4fe3-93b5-57e2d8782d44
Total jobs = 3
Launching Job 1 out of 3
Number of reduce tasks determined at compile time: 1
In order to change the average load for a reducer (in bytes):set hive.exec.reducers.bytes.per.reducer=
In order to limit the maximum number of reducers:set hive.exec.reducers.max=
In order to set a constant number of reducers:set mapreduce.job.reduces=
Starting Job = job_1678967218927_0006, Tracking URL = http://hadoop103:8088/proxy/application_1678967218927_0006/
Kill Command = /opt/module/hadoop-3.1.3/bin/mapred job  -kill job_1678967218927_0006
Hadoop job information for Stage-1: number of mappers: 0; number of reducers: 0
2023-03-16 21:26:10,910 Stage-1 map = 0%,  reduce = 0%
Ended Job = job_1678967218927_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

过程

刚开始：Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask

从网上找这个的报错

https://blog.csdn.net/weixin_48874360/article/details/125508644

安照上面的博客改报错，以为是yarn没有配置好，改完后，未解决，于是去看hive日志。

tail -200 /tmp/用户名/hive.log

看到很多error，查完资料后，发现还是不行。

于是从上面的hive命令行的信息找

vim mapred-site.xml

http://hadoop103:8088

打开这个web后，从history中发现是

Error: Could not find or load main class org.apache.hadoop.mapreduce.v2.app.MRAppMaster

照着这个更改后，发现还是不行。

去网上找资料后发现，还需要添加一下配置信息。

解决

hadoop classpath

将输出的结果复制 

vim mapred-site.xml

mapreduce.application.classpath$HADOOP_MAPRED_HOME/share/hadoop/mapreduce/*:$HADOOP_MAPRED_HOME/share/hadoop/mapreduce/lib/*yarn.app.mapreduce.am.envHADOOP_MAPRED_HOME=${HADOOP_HOME}mapreduce.map.envHADOOP_MAPRED_HOME=${HADOOP_HOME}mapreduce.reduce.envHADOOP_MAPRED_HOME=${HADOOP_HOME}yarn.application.classpath复制的信息(将其中的:改成,)

来源：

(25条消息) Error: Could not find or load main class org.apache.hadoop.mapreduce.v2.app.MRAppMaster_「已注销」的博客-CSDN博客