• 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
    
  • 相关阅读:
    vim使用
    linux下编译openjdk8
    《鸟哥的Linux私房菜》学习笔记(9)——条件判断
    《鸟哥的Linux私房菜》学习笔记(8)——bash脚本编程之变量
    《鸟哥的Linux私房菜》学习笔记(7)——grep及正则表达式
    《鸟哥的Linux私房菜》学习笔记(6)——管道及IO重定向
    《鸟哥的Linux私房菜》学习笔记(5)——权限管理
    《鸟哥的Linux私房菜》学习笔记(4)——用户和组
    《鸟哥的Linux私房菜》学习笔记(0)——磁盘与文件系统管理
    Intellij Idea 创建JavaWeb项目
  • 原文地址:https://www.cnblogs.com/BIG-BOSS-ZC/p/11807315.html
Copyright © 2020-2023  润新知