Hive:hive is not allowed to impersonate anonymous

柔光的暖阳◎ 2022-06-09 01:22 337阅读 0赞

1、用kettle通过jdbc连接hiveserver2的时候抛出异常

  1. Exception in thread "main" 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: hadoop is not allowed to impersonate anonymous
  2.     at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:258)
  3.     at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:249)
  4.     at org.apache.hive.jdbc.HiveConnection.openSession(HiveConnection.java:579)
  5.     at org.apache.hive.jdbc.HiveConnection.<init>(HiveConnection.java:167)
  6.     at org.apache.hive.jdbc.HiveDriver.connect(HiveDriver.java:107)
  7.     at java.sql.DriverManager.getConnection(DriverManager.java:571)
  8.     at java.sql.DriverManager.getConnection(DriverManager.java:215)
  9.     at client.main(client.java:21)
  10.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  11.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
  12.     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  13.     at java.lang.reflect.Method.invoke(Method.java:606)
  14.     at com.intellij.rt.execution.application.AppMain.main(AppMain.java:140)
  15. 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: hadoop is not allowed to impersonate anonymous
  16.     at org.apache.hive.service.cli.session.SessionManager.openSession(SessionManager.java:324)
  17.     at org.apache.hive.service.cli.CLIService.openSessionWithImpersonation(CLIService.java:187)
  18.     at org.apache.hive.service.cli.thrift.ThriftCLIService.getSessionHandle(ThriftCLIService.java:424)
  19.     at org.apache.hive.service.cli.thrift.ThriftCLIService.OpenSession(ThriftCLIService.java:318)
  20.     at org.apache.hive.service.cli.thrift.TCLIService$Processor$OpenSession.getResult(TCLIService.java:1257)
  21.     at org.apache.hive.service.cli.thrift.TCLIService$Processor$OpenSession.getResult(TCLIService.java:1242)
  22.     at org.apache.thrift.ProcessFunction.process(ProcessFunction.java:39)
  23.     at org.apache.thrift.TBaseProcessor.process(TBaseProcessor.java:39)
  24.     at org.apache.hive.service.auth.TSetIpAddressProcessor.process(TSetIpAddressProcessor.java:56)
  25.     at org.apache.thrift.server.TThreadPoolServer$WorkerProcess.run(TThreadPoolServer.java:286)
  26.     at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
  27.     at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
  28.     at java.lang.Thread.run(Thread.java:745)
  29. Caused by: java.lang.RuntimeException: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): User: hadoop is not allowed to impersonate anonymous
  30.     at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:89)
  31.     at org.apache.hive.service.cli.session.HiveSessionProxy.access$000(HiveSessionProxy.java:36)
  32.     at org.apache.hive.service.cli.session.HiveSessionProxy$1.run(HiveSessionProxy.java:63)
  33.     at java.security.AccessController.doPrivileged(Native Method)
  34.     at javax.security.auth.Subject.doAs(Subject.java:422)
  35.     at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1657)
  36.     at org.apache.hive.service.cli.session.HiveSessionProxy.invoke(HiveSessionProxy.java:59)
  37.     at com.sun.proxy.$Proxy35.open(Unknown Source)
  38.     at org.apache.hive.service.cli.session.SessionManager.openSession(SessionManager.java:315)
  39.     ... 12 more
  40. Caused by: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): User: hadoop is not allowed to impersonate anonymous
  41.     at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:554)
  42.     at org.apache.hadoop.hive.ql.session.SessionState.start(SessionState.java:489)
  43.     at org.apache.hive.service.cli.session.HiveSessionImpl.open(HiveSessionImpl.java:156)
  44.     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  45.     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

2、原因：hive不允许匿名用户访问

3、解决办法：

在hdfs的core-site.xml文件添加两个属性

  1. hadoop.proxyuser.hive.groups=*
  2. hadoop.proxyuser.hive.hosts=*

重启hdfs、hive、yarn，MR

发表评论

表情：
评论列表 （有 0 条评论，337人围观）

还没有评论，来说两句吧...

相关阅读