开发者社区> 问答> 正文

hive执行报错 cdh5.1.2中??报错

在cdh5.1.2中执行hive,

执行诸如select id,name from test的语句

只有使用hdfs用户能正常执行,使用其他用户不可以

另外,使用hive jdbc执行SQL时,

Connection conn = DriverManager.getConnection(hiveJDBC, "hdfs","1eTbI7MrXa");

用户名一定要指定为hdfs,指定为其他用户报同样的错误

请大神解答?

其他用户执行时,yarn-RESOURCEMANAGER报如下错误

2014-09-23 23:06:01,210 INFO org.apache.hadoop.yarn.server.resourcemanager.scheduler.AppSchedulingInfo: Application application_1411466603254_0044 requests cleared
2014-09-23 23:06:01,232 INFO org.apache.hadoop.yarn.server.resourcemanager.rmapp.RMAppImpl: Application application_1411466603254_0044 failed 2 times due to AM Container for appattempt_1411466603254_0044_000002 exited with  exitCode: 1 due to: Exception from container-launch: org.apache.hadoop.util.Shell$ExitCodeException: 
org.apache.hadoop.util.Shell$ExitCodeException: 
        at org.apache.hadoop.util.Shell.runCommand(Shell.java:511)
        at org.apache.hadoop.util.Shell.run(Shell.java:424)
        at org.apache.hadoop.util.Shell$ShellCommandExecutor.execute(Shell.java:656)
        at org.apache.hadoop.yarn.server.nodemanager.DefaultContainerExecutor.launchContainer(DefaultContainerExecutor.java:195)
        at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:300)
        at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:81)
        at java.util.concurrent.FutureTask.run(FutureTask.java:262)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)




Container exited with a non-zero exit code 1
.Failing this attempt.. Failing the application.
2014-09-23 23:06:01,233 INFO org.apache.hadoop.yarn.server.resourcemanager.rmapp.RMAppImpl: application_1411466603254_0044 State change from FINAL_SAVING to FAILED
2014-09-23 23:06:01,233 WARN org.apache.hadoop.yarn.server.resourcemanager.RMAuditLogger: USER=hive     OPERATION=Application Finished - Failed TARGET=RMAppManager     RESULT=FAILURE  DESCRIPTION=App failed with state: FAILED  PERMISSIONS=Application application_1411466603254_0044 failed 2 times due to AM Container for appattempt_1411466603254_0044_000002 exited with  exitCode: 1 due to: Exception from container-launch: org.apache.hadoop.util.Shell$ExitCodeException: 
org.apache.hadoop.util.Shell$ExitCodeException: 
        at org.apache.hadoop.util.Shell.runCommand(Shell.java:511)
        at org.apache.hadoop.util.Shell.run(Shell.java:424)
        at org.apache.hadoop.util.Shell$ShellCommandExecutor.execute(Shell.java:656)
        at org.apache.hadoop.yarn.server.nodemanager.DefaultContainerExecutor.launchContainer(DefaultContainerExecutor.java:195)
        at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:300)
        at org.apache.hadoop.yarn.server.nodemanager.containermanager.launcher.ContainerLaunch.call(ContainerLaunch.java:81)
        at java.util.concurrent.FutureTask.run(FutureTask.java:262)
        at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
        at java.lang.Thread.run(Thread.java:745)




Container exited with a non-zero exit code 1
.Failing this attempt.. Failing the application.        APPID=application_1411466603254_0044

展开
收起
爱吃鱼的程序员 2020-06-14 21:32:49 626 0
1 条回答
写回答
取消 提交回答
  • https://developer.aliyun.com/profile/5yerqm5bn5yqg?spm=a2c6h.12873639.0.0.6eae304abcjaIB

    您好:

      在linux中,先将用户su-hdfs下,然后用hadoopfs-chmod-R 777/

      就是将hdfs文件夹的权限变成777,你试试吧!


    这样不好吧

    ls查看一下hive文件的所属用户和用户组,我记得hive解压之后不是用户和用户组不是当前用户,修改改变

    chown-R当前用户:当前用户hive根目录

    试试看。

    2020-06-14 21:33:05
    赞同 展开评论 打赏
问答分类:
问答标签:
问答地址:
问答排行榜
最热
最新

相关电子书

更多
Comparison of Spark SQL with Hive 立即下载
Hive Bucketing in Apache Spark 立即下载
2019大数据技术公开课第五季—Hive迁移到MaxCompute最佳实践 立即下载