hive执行报错 cdh5.1.2中？

Question

在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

Answer 1

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

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

试试看。

Answer 2

这样不好吧

Answer 3

您好：

    在linux中，先将用户su - hdfs下，然后用hadoop fs -chmod -R 777 /

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