执行hive2.0中hplsql 遇到问题（未解决）

最新推荐文章于 2024-04-29 15:17:58 发布

风语飘摇

最新推荐文章于 2024-04-29 15:17:58 发布

阅读量2.6k

点赞数

分类专栏： hive

本文链接：https://blog.csdn.net/swing2008/article/details/51744710

版权

hive 专栏收录该内容

15 篇文章 0 订阅

订阅专栏

[root@master Desktop]# hplsql -f /home/hive/1.sql
SLF4J: Class path contains multiple SLF4J bindings.
SLF4J: Found binding in [jar:file:/home/hive/apache-hive-2.0.0-bin/lib/hive-jdbc-2.0.0-standalone.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/hive/apache-hive-2.0.0-bin/lib/log4j-slf4j-impl-2.4.1.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/spark/spark-1.6.1/lib/spark-assembly-1.6.1-hadoop2.6.0.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: Found binding in [jar:file:/home/hadoop/hadoop-2.7.0/share/hadoop/common/lib/slf4j-log4j12-1.7.10.jar!/org/slf4j/impl/StaticLoggerBinder.class]
SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
Unhandled exception in HPL/SQL
org.apache.hive.service.cli.HiveSQLException: Failed to open new session: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): User: root is not allowed to impersonate hive
   at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:258)
   at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:249)
   at org.apache.hive.jdbc.HiveConnection.openSession(HiveConnection.java:579)
   at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:167)
   at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:107)
   at java.sql.DriverManager.getConnection(DriverManager.java:571)
   at java.sql.DriverManager.getConnection(DriverManager.java:215)
   at org.apache.hive.hplsql.Conn.openConnection(Conn.java:208)
   at org.apache.hive.hplsql.Conn.getConnection(Conn.java:161)
   at org.apache.hive.hplsql.Conn.executeQuery(Conn.java:58)
   at org.apache.hive.hplsql.Exec.executeQuery(Exec.java:554)
   at org.apache.hive.hplsql.Exec.executeQuery(Exec.java:563)
   at org.apache.hive.hplsql.Stmt.forCursor(Stmt.java:739)
   at org.apache.hive.hplsql.Exec.visitFor_cursor_stmt(Exec.java:1638)
   at org.apache.hive.hplsql.Exec.visitFor_cursor_stmt(Exec.java:51)
   at org.apache.hive.hplsql.HplsqlParser$For_cursor_stmtContext.accept(HplsqlParser.java:11614)
   at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:70)
   at org.apache.hive.hplsql.Exec.visitStmt(Exec.java:987)
   at org.apache.hive.hplsql.Exec.visitStmt(Exec.java:51)
   at org.apache.hive.hplsql.HplsqlParser$StmtContext.accept(HplsqlParser.java:891)
   at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:70)
   at org.apache.hive.hplsql.HplsqlBaseVisitor.visitBlock(HplsqlBaseVisitor.java:28)
   at org.apache.hive.hplsql.HplsqlParser$BlockContext.accept(HplsqlParser.java:412)
   at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visitChildren(AbstractParseTreeVisitor.java:70)
   at org.apache.hive.hplsql.Exec.visitProgram(Exec.java:895)
   at org.apache.hive.hplsql.Exec.visitProgram(Exec.java:51)
   at org.apache.hive.hplsql.HplsqlParser$ProgramContext.accept(HplsqlParser.java:355)
   at org.antlr.v4.runtime.tree.AbstractParseTreeVisitor.visit(AbstractParseTreeVisitor.java:42)
   at org.apache.hive.hplsql.Exec.run(Exec.java:753)
   at org.apache.hive.hplsql.Exec.run(Exec.java:729)
   at org.apache.hive.hplsql.Hplsql.main(Hplsql.java:23)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:606)
   at org.apache.hadoop.util.RunJar.run(RunJar.java:221)
   at org.apache.hadoop.util.RunJar.main(RunJar.java:136)
Caused by: org.apache.hive.service.cli.HiveSQLException: Failed to open new session: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): User: root is not allowed to impersonate hive
   at org.apache.hive.service.cli.session.SessionManager.openSession(SessionManager.java:324)
   at org.apache.hive.service.cli.CLIService.openSessionWithImpersonation(CLIService.java:187)
   at org.apache.hive.service.cli.thrift.ThriftCLIService.getSessionHandle(ThriftCLIService.java:424)
   at org.apache.hive.service.cli.thrift.ThriftCLIService.OpenSession(ThriftCLIService.java:318)
   at org.apache.hive.service.cli.thrift.TCLIService$Processor$OpenSession.getResult(TCLIService.java:1257)
   at org.apache.hive.service.cli.thrift.TCLIService$Processor$OpenSession.getResult(TCLIService.java:1242)
   at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
   at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
   at org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56)
   at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286)
   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)
Caused by: java.lang.RuntimeException: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): User: root is not allowed to impersonate hive
   at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:89)
   at org.apache.hive.service.cli.session.HiveSessionProxy.access$000(HiveSessionProxy.java:36)
   at org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:63)
   at java.security.AccessController.doPrivileged(Native Method)
   at javax.security.auth.Subject.doAs(Subject.java:415)
   at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628)
   at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59)
   at com.sun.proxy.$Proxy34.open(Unknown Source)
   at org.apache.hive.service.cli.session.SessionManager.openSession(SessionManager.java:315)
   ... 12 more
Caused by: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): User: root is not allowed to impersonate hive
   at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:554)
   at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:489)
   at org.apache.hive.service.cli.session.HiveSessionImpl.open(HiveSessionImpl.java:156)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:606)
   at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:78)
   ... 20 more
Caused by: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException:User: root is not allowed to impersonate hive
   at org.apache.hadoop.ipc.Client.call(Client.java:1468)
   at org.apache.hadoop.ipc.Client.call(Client.java:1399)
   at org.apache.hadoop.ipc.ProtobufRpcEngine$Invoker.invoke(ProtobufRpcEngine.java:232)
   at com.sun.proxy.$Proxy29.getFileInfo(Unknown Source)
   at org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolTranslatorPB.getFileInfo(ClientNamenodeProtocolTranslatorPB.java:752)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
   at java.lang.reflect.Method.invoke(Method.java:606)
   at org.apache.hadoop.io.retry.RetryInvocationHandler.invokeMethod(RetryInvocationHandler.java:187)
   at org.apache.hadoop.io.retry.RetryInvocationHandler.invoke(RetryInvocationHandler.java:102)
   at com.sun.proxy.$Proxy30.getFileInfo(Unknown Source)
   at org.apache.hadoop.hdfs.DFSClient.getFileInfo(DFSClient.java:1988)
   at org.apache.hadoop.hdfs.DistributedFileSystem$18.doCall(DistributedFileSystem.java:1118)
   at org.apache.hadoop.hdfs.DistributedFileSystem$18.doCall(DistributedFileSystem.java:1114)
   at org.apache.hadoop.fs.FileSystemLinkResolver.resolve(FileSystemLinkResolver.java:81)
   at org.apache.hadoop.hdfs.DistributedFileSystem.getFileStatus(DistributedFileSystem.java:1114)
   at org.apache.hadoop.fs.FileSystem.exists(FileSystem.java:1400)
   at org.apache.hadoop.hive.ql.session.SessionState.createRootHDFSDir(SessionState.java:639)
   at org.apache.hadoop.hive.ql.session.SessionState.createSessionDirs(SessionState.java:597)
   at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:526)
   ... 27 more
[root@master Desktop]# hplsql -f /home/hive/1.sql