Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
2024-09-07 16:19:11
hive运行查询语句时报错：
Error: org.apache.hive.service.cli.HiveSQLException: Error while processing statement:
FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask
at org.apache.hive.service.cli.operation.Operation.toSQLException
(Operation.java:380)
at org.apache.hive.service.cli.operation.SQLOperation.runQuery
(SQLOperation.java:257)
at org.apache.hive.service.cli.operation.SQLOperation.access$800
(SQLOperation.java:91)
at org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork$1.run
(SQLOperation.java:348)
at java.security.AccessController.doPrivileged(Native Method)
at javax.security.auth.Subject.doAs(Subject.java:422)
at org.apache.hadoop.security.UserGroupInformation.doAs
(UserGroupInformation.java:1628)
at org.apache.hive.service.cli.operation.SQLOperation$BackgroundWork.run
(SQLOperation.java:362)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745) (state=08S01,code=2)
不要慌，看日志，什么出错了？
打开浏览器：http://192.168.1.24:8042/logs/yarn-root-resourcemanager-bigboss2.log
找到错误：System times on machines may be out of sync. Check system time and time zones.
Note: System times on machines may be out of sync. Check system time and time zones.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance
(NativeConstructorAccessorImpl.java:62)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance
(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
at
org.apache.hadoop.yarn.api.records.impl.pb.SerializedExceptionPBImpl.instantiateException
(SerializedExceptionPBImpl.java:168)
at
org.apache.hadoop.yarn.api.records.impl.pb.SerializedExceptionPBImpl.deSerialize
(SerializedExceptionPBImpl.java:106)
at org.apache.hadoop.yarn.server.resourcemanager.amlauncher.AMLauncher.launch
(AMLauncher.java:123)
at org.apache.hadoop.yarn.server.resourcemanager.amlauncher.AMLauncher.run
(AMLauncher.java:254)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
小意思，时间不一致问题；
yum -y install ntp ntpdate
ntpdate cn.pool.ntp.org
hwclock --systohc
最新文章
- 大神的Blog挂了，从Bing快照里复制过来的备份
- 15分钟学会使用Git和远程代码库
- CCActionManager
- Ubuntu文本编辑时vi和nano命令的区别（建议使用nano）
- MFC之目录结构及消息流转（一）
- Java核心技术II读书笔记（二）
- iOS面试小题集锦
- 前端编辑神器Brackets
- Codeforces Round #346 (Div. 2) B Qualifying Contest
- MySQL查询in操作 查询结果按in集合顺序显示_Mysql_脚本之家
- oracle表空间扩容
- GLSL Versions和GLSL ES Versions 对比
- Android P Beta发布！最新版本抢先体验！
- 源码阅读经验谈-slim,darknet,labelimg,caffe(1)
- 856. Score of Parentheses
- 域名DNS解析工具ping/nslookup/dig/host
- 你真的了解restful api吗？
- Hdu1342 Lotto 2017-01-18 17:12 44人阅读 评论(0) 收藏
- Eigen学习之简单线性方程与矩阵分解
- 基础url、相对url、绝对url