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

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