HIVE2 Error: Failed to open new session: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteExc

最新推荐文章于 2023-01-27 00:09:31 发布
原创 最新推荐文章于 2023-01-27 00:09:31 发布 · 7.5k 阅读 · 2 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

部署运行你感兴趣的模型镜像
LF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation.
SLF4J: Actual binding is of type [org.apache.logging.slf4j.Log4jLoggerFactory]
Connecting to jdbc:hive2://localhost:10000/default
Enter username for jdbc:hive2://localhost:10000/default: root
Enter password for jdbc:hive2://localhost:10000/default: ******

Error: 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 root (state=,code=0)


解决方案：在hadoop>etc>hadoop>core-site.xml 中添加如下部分，重启服务即可：

<property>
  <name>hadoop.proxyuser.root.hosts</name>
  <value>*</value>
 </property>
 <property>
  <name>hadoop.proxyuser.root.groups</name>
  <value>*</value>
</property>

您可能感兴趣的与本文相关的镜像

Llama Factory

Llama Factory

模型微调
LLama-Factory

LLaMA Factory 是一个简单易用且高效的大型语言模型（Large Language Model）训练与微调平台。通过 LLaMA Factory，可以在无需编写任何代码的前提下，在本地完成上百种预训练模型的微调

Hive beeline客户端启动报错Could not open client transport with JDBC Uri: jdbc:hive2://hadoop101:10000: Fail
qq_32118757的博客
01-14 4270
Hive beeline客户端启动报错`Could not open client transport with JDBC Uri: jdbc:hive2://hadoop101:10000: Failed to open new session: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): Use
DBeaver连接Hive错误总结
weixin_38023225的博客
01-14 8530
1.错误1 Required field 'serverProtocolVersion' is unset! Struct:TOpenSessionResp(status:TStatus(statusCode:ERROR_STATUS, infoMessages:[*org.apache.hive.service.cli.HiveSQLException:Failed to open new s...
【Hive问题】Failed to open new session: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteExceptio
小廖的博客
02-11 2642
Failed to open new session: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): User:xiaosiis not allowed to impersonate anonymous
Failed to open new session: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.ap
csding11的博客
04-01 2222
这是hive想使用hiveserver2的服务时报错信息（首先要开启元数据服务，再开启hiveserver2服务，然后bin/beeline -u jdbc:hive2://hadoop102:10000 -n ding报错信息如下） Error: Could not open client transport with JDBC Uri: jdbc:hive2://hadoop102:10000: Failed to open new session: java.lang.RuntimeException
33.日常问题整理[2022/10/09]Failed to open new session: java.lang.RuntimeException
weixin_46876034的博客
10-09 312
hive报错：Failed to open new session: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException
The specified database user/password combination is rejected: [ 08S01] Could not establish connection to jdbc:hive2://192.168.88.80:10000: Required field 'serverProtocolVersion' is unset! Struct:TOpenSessionResp(status:TStatus(statusCode:ERROR_STATUS, infoMessages:[*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 root:14:13, org.apache.hive.service.cli.session.SessionManager:createSession:SessionManager.java:420, org.apache.hive.service.cli.session.SessionManager:openSession:SessionManager.java:363, org.apache.hive.service.cli.CLIService:openSessionWithImpersonation:CLIService.java:189, org.apache.hive.service.cli.thrift.ThriftCLIService:getSessionHandle:ThriftCLIService.java:424, org.apache.hive.service.cli.thrift.ThriftCLIService:OpenSession:ThriftCLIService.java:313, org.apache.hive.service.rpc.thrift.TCLIService$Processor$OpenSession:getResult:TCLIService.java:1377, org.apache.hive.service.rpc.thrift.TCLIService$Processor$OpenSession:getResult:TCLIService.java:1362, org.apache.thrift.ProcessFunction:process:ProcessFunction.java:39, org.apache.thrift.TBaseProcessor:process:TBaseProcessor.java:39, org.apache.hive.service.auth.TSetIpAddressProcessor:process:TSetIpAddressProcessor.java:56, org.apache.thrift.server.TThreadPoolServer$WorkerProcess:run:TThreadPoolServer.java:286, java.util.concurrent.ThreadPoolExecutor:runWorker:ThreadPoolExecutor.java:1149, java.util.concurrent.ThreadPoolExecutor$Worker:run:ThreadPoolExecutor.java:624, java.lang.Thread:run:Thread.java:748, *java.lang.RuntimeException:java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): User: root is not allowed to impersonate root:22:8, org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:89, org.apache.hive.service.cli.session.HiveSessionProxy:access$000:HiveSessionProxy.java:36, org.apache.hive.service.cli.session.HiveSessionProxy$1:run:HiveSessionProxy.java:63, java.security.AccessController:doPrivileged:AccessController.java:-2, javax.security.auth.Subject:doAs:Subject.java:422, org.apache.hadoop.security.UserGroupInformation:doAs:UserGroupInformation.java:1875, org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:59, com.sun.proxy.$Proxy35:open::-1, org.apache.hive.service.cli.session.SessionManager:createSession:SessionManager.java:411, *java.lang.RuntimeException:org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): User: root is not allowed to impersonate root:29:7, org.apache.hadoop.hive.ql.session.SessionState:start:SessionState.java:602, org.apache.hadoop.hive.ql.session.SessionState:start:SessionState.java:538, org.apache.hive.service.cli.session.HiveSessionImpl:open:HiveSessionImpl.java:171, sun.reflect.NativeMethodAccessorImpl:invoke0:NativeMethodAccessorImpl.java:-2, sun.reflect.NativeMethodAccessorImpl:invoke:NativeMethodAccessorImpl.java:62, sun.reflect.DelegatingMethodAccessorImpl:invoke:DelegatingMethodAccessorImpl.java:43, java.lang.reflect.Method:invoke:Method.java:498, org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:78, *org.apache.hadoop.ipc.RemoteException:User: root is not allowed to impersonate root:54:25, org.apache.hadoop.ipc.Client:getRpcResponse:Client.java:1499, org.apache.hadoop.ipc.Client:call:Client.java:1445, org.apache.hadoop.ipc.Client:call:Client.java:1355, org.apache.hadoop.ipc.ProtobufRpcEngine$Invoker:invoke:ProtobufRpcEngine.java:228, org.apache.hadoop.ipc.ProtobufRpcEngine$Invoker:invoke:ProtobufRpcEngine.java:116, com.sun.proxy.$Proxy29:getFileInfo::-1, org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolTranslatorPB:getFileInfo:ClientNamenodeProtocolTranslatorPB.java:875, sun.reflect.NativeMethodAccessorImpl:invoke0:NativeMethodAccessorImpl.java:-2, sun.reflect.NativeMethodAccessorImpl:invoke:NativeMethodAccessorImpl.java:62, sun.reflect.DelegatingMethodAccessorImpl:invoke:DelegatingMethodAccessorImpl.java:43, java.lang.reflect.Method:invoke:Method.java:498, org.apache.hadoop.io.retry.RetryInvocationHandler:invokeMethod:RetryInvocationHandler.java:422, org.apache.hadoop.io.retry.RetryInvocationHandler$Call:invokeMethod:RetryInvocationHandler.java:165, org.apache.hadoop.io.retry.RetryInvocationHandler$Call:invoke:RetryInvocationHandler.java:157, org.apache.hadoop.io.retry.RetryInvocationHandler$Call:invokeOnce:RetryInvocationHandler.java:95, org.apache.hadoop.io.retry.RetryInvocationHandler:invoke:RetryInvocationHandler.java:359, com.sun.proxy.$Proxy30:getFileInfo::-1, org.apache.hadoop.hdfs.DFSClient:getFileInfo:DFSClient.java:1624, org.apache.hadoop.hdfs.DistributedFileSystem$29:doCall:DistributedFileSystem.java:1495, org.apache.hadoop.hdfs.DistributedFileSystem$29:doCall:DistributedFileSystem.java:1492, org.apache.hadoop.fs.FileSystemLinkResolver:resolve:FileSystemLinkResolver.java:81, org.apache.hadoop.hdfs.DistributedFileSystem:getFileStatus:DistributedFileSystem.java:1507, org.apache.hadoop.fs.FileSystem:exists:FileSystem.java:1668, org.apache.hadoop.hive.ql.session.SessionState:createRootHDFSDir:SessionState.java:710, org.apache.hadoop.hive.ql.session.SessionState:createSessionDirs:SessionState.java:648, org.apache.hadoop.hive.ql.session.SessionState:start:SessionState.java:578], errorCode:0, errorMessage: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 root), serverProtocolVersion:null) org.apache.thrift.protocol.TProtocolException: Required field 'serverProtocolVersion' is unset! Struct:TOpenSessionResp(status:TStatus(statusCode:ERROR_STATUS, infoMessages:[*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 root:14:13, org.apache.hive.service.cli.session.SessionManager:createSession:SessionManager.java:420, org.apache.hive.service.cli.session.SessionManager:openSession:SessionManager.java:363, org.apache.hive.service.cli.CLIService:openSessionWithImpersonation:CLIService.java:189, org.apache.hive.service.cli.thrift.ThriftCLIService:getSessionHandle:ThriftCLIService.java:424, org.apache.hive.service.cli.thrift.ThriftCLIService:OpenSession:ThriftCLIService.java:313, org.apache.hive.service.rpc.thrift.TCLIService$Processor$OpenSession:getResult:TCLIService.java:1377, org.apache.hive.service.rpc.thrift.TCLIService$Processor$OpenSession:getResult:TCLIService.java:1362, org.apache.thrift.ProcessFunction:process:ProcessFunction.java:39, org.apache.thrift.TBaseProcessor:process:TBaseProcessor.java:39, org.apache.hive.service.auth.TSetIpAddressProcessor:process:TSetIpAddressProcessor.java:56, org.apache.thrift.server.TThreadPoolServer$WorkerProcess:run:TThreadPoolServer.java:286, java.util.concurrent.ThreadPoolExecutor:runWorker:ThreadPoolExecutor.java:1149, java.util.concurrent.ThreadPoolExecutor$Worker:run:ThreadPoolExecutor.java:624, java.lang.Thread:run:Thread.java:748, *java.lang.RuntimeException:java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): User: root is not allowed to impersonate root:22:8, org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:89, org.apache.hive.service.cli.session.HiveSessionProxy:access$000:HiveSessionProxy.java:36, org.apache.hive.service.cli.session.HiveSessionProxy$1:run:HiveSessionProxy.java:63, java.security.AccessController:doPrivileged:AccessController.java:-2, javax.security.auth.Subject:doAs:Subject.java:422, org.apache.hadoop.security.UserGroupInformation:doAs:UserGroupInformation.java:1875, org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:59, com.sun.proxy.$Proxy35:open::-1, org.apache.hive.service.cli.session.SessionManager:createSession:SessionManager.java:411, *java.lang.RuntimeException:org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): User: root is not allowed to impersonate root:29:7, org.apache.hadoop.hive.ql.session.SessionState:start:SessionState.java:602, org.apache.hadoop.hive.ql.session.SessionState:start:SessionState.java:538, org.apache.hive.service.cli.session.HiveSessionImpl:open:HiveSessionImpl.java:171, sun.reflect.NativeMethodAccessorImpl:invoke0:NativeMethodAccessorImpl.java:-2, sun.reflect.NativeMethodAccessorImpl:invoke:NativeMethodAccessorImpl.java:62, sun.reflect.DelegatingMethodAccessorImpl:invoke:DelegatingMethodAccessorImpl.java:43, java.lang.reflect.Method:invoke:Method.java:498, org.apache.hive.service.cli.session.HiveSessionProxy:invoke:HiveSessionProxy.java:78, *org.apache.hadoop.ipc.RemoteException:User: root is not allowed to impersonate root:54:25, org.apache.hadoop.ipc.Client:getRpcResponse:Client.java:1499, org.apache.hadoop.ipc.Client:call:Client.java:1445, org.apache.hadoop.ipc.Client:call:Client.java:1355, org.apache.hadoop.ipc.ProtobufRpcEngine$Invoker:invoke:ProtobufRpcEngine.java:228, org.apache.hadoop.ipc.ProtobufRpcEngine$Invoker:invoke:ProtobufRpcEngine.java:116, com.sun.proxy.$Proxy29:getFileInfo::-1, org.apache.hadoop.hdfs.protocolPB.ClientNamenodeProtocolTranslatorPB:getFileInfo:ClientNamenodeProtocolTranslatorPB.java:875, sun.reflect.NativeMethodAccessorImpl:invoke0:NativeMethodAccessorImpl.java:-2, sun.reflect.NativeMethodAccessorImpl:invoke:NativeMethodAccessorImpl.java:62, sun.reflect.DelegatingMethodAccessorImpl:invoke:DelegatingMethodAccessorImpl.java:43, java.lang.reflect.Method:invoke:Method.java:498, org.apache.hadoop.io.retry.RetryInvocationHandler:invokeMethod:RetryInvocationHandler.java:422, org.apache.hadoop.io.retry.RetryInvocationHandler$Call:invokeMethod:RetryInvocationHandler.java:165, org.apache.hadoop.io.retry.RetryInvocationHandler$Call:invoke:RetryInvocationHandler.java:157, org.apache.hadoop.io.retry.RetryInvocationHandler$Call:invokeOnce:RetryInvocationHandler.java:95, org.apache.hadoop.io.retry.RetryInvocationHandler:invoke:RetryInvocationHandler.java:359, com.sun.proxy.$Proxy30:getFileInfo::-1, org.apache.hadoop.hdfs.DFSClient:getFileInfo:DFSClient.java:1624, org.apache.hadoop.hdfs.DistributedFileSystem$29:doCall:DistributedFileSystem.java:1495, org.apache.hadoop.hdfs.DistributedFileSystem$29:doCall:DistributedFileSystem.java:1492, org.apache.hadoop.fs.FileSystemLinkResolver:resolve:FileSystemLinkResolver.java:81, org.apache.hadoop.hdfs.DistributedFileSystem:getFileStatus:DistributedFileSystem.java:1507, org.apache.hadoop.fs.FileSystem:exists:FileSystem.java:1668, org.apache.hadoop.hive.ql.session.SessionState:createRootHDFSDir:SessionState.java:710, org.apache.hadoop.hive.ql.session.SessionState:createSessionDirs:SessionState.java:648, org.apache.hadoop.hive.ql.session.SessionState:start:SessionState.java:578], errorCode:0, errorMessage: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 root), serverProtocolVersion:null)
最新发布
10-04
Connection con = DriverManager.getConnection("jdbc:hive2://192.168.88.80:10000", "root", "your_password"); Statement stmt = con.createStatement(); // 执行查询 String sql = "SHOW TABLES"; ...
[root@hadoop102 ~]# netstat -tuln | grep 10000 tcp6 0 0 :::10000 :::* LISTEN [root@hadoop102 ~]# beeline -u jdbc:hive2://hadoop102:10000 -n lzp Connecting to jdbc:hive2://hadoop102:10000 25/03/04 22:13:48 [main]: WARN jdbc.HiveConnection: Failed to connect to hadoop102:10000 Error: Could not open client transport with JDBC Uri: jdbc:hive2://hadoop102:10000: Failed to open new session: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): User: lzp is not allowed to impersonate lzp (state=08S01,code=0) Beeline version 3.1.3 by Apache Hive
03-08
Failed to open new session: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): User: lzp is not allowed to impersonate ...
[root@hadoop2 conf]# beeline -u jdbc:hive2://hadoop3:10000 -n root SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/export/servers/hive-3.1.3/lib/log4j-slf4j-impl-2.17.1.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/export/servers/hadoop-3.3.0/share/hadoop/common/lib/slf4j-log4j12-1.7.25.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] Connecting to jdbc:hive2://hadoop3:10000 25/05/30 11:58:49 [main]: WARN jdbc.HiveConnection: Failed to connect to hadoop3:10000 Error: Could not open client transport with JDBC Uri: jdbc:hive2://hadoop3:10000: Failed to open new session: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): Unauthorized connection for super-user: root from IP 192.168.216.162 (state=08S01,code=0) Beeline version 3.1.3 by Apache Hive
06-06
beeline -u jdbc:hive2://<hive-server-host>:<port>/<database> -n <username> -p ``` 例如： ```bash beeline -u jdbc:hive2://bigdata1:10000/default -n hive -p password ``` 如果仍然无法连接，请检查以下...
Could not open client transport with JDBC Uri: jdbc:hive2://hadoop01:10000: java.net.ConnectException: Connection refused: connect
07-27
引用\[2\]:Error: Could not open client transport with JDBC Uri: jdbc:hive2://192.168.136.128:10000/mydb/: Failed to open new session: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException...
beeline连接hive出错 Error: Could not open client transport with JDBC Uri
小鲤鱼丶汤真好喝
05-05 2303
出现的错误：Error: Could not open client transport with JDBC Uri: jdbc:hive2://NODE01:10000: Failed to open new session: java.lang.RuntimeException:org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.se...
Error: Failed to open new session: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException
热门推荐
swing2008的专栏
11-19 1万+
User root is not allowed to impersonate anonymous 使用HiveServer2 and Beeline模式运行时，启动好HiveServer后运行 beeline -u jdbc:hive2://localhost:10000 -n root 连接server时 出现 java.lang.RuntimeException: o
Error: Failed to open new session: java.lang.RuntimeException: java.lang.RuntimeException: org.apach
m0_46307091的博客
03-06 700
spark 启动连接 bin/beeline ： 出现如下结果： 0: jdbc:hive2://bd1-server1.com:10000 (closed)> 问题解决：一是解决HDFS上的 tmp目录的用户和用户组改为自己的普通用户； 二是将tmp的other权限修改为rwx ,777，
jdbc:hive2://hadoop2:10000: Failed to open new session: java.lang.RuntimeException: org.apache.hadoo
蒯厅博客
05-19 1839
hive 错误信息 beeline> !connect jdbc:hive2://hadoop2:10000 Connecting to jdbc:hive2://hadoop2:10000 Enter username for jdbc:hive2://hadoop2:10000: root Enter password for jdbc:hive2://hadoop2:10000: 22/05/19 14:30:23 [main]: WARN jdbc.HiveConnection: Faile
org.apache.hive.service.cli.HiveSQLException: Failed to open new session: java.lang.RuntimeException
T_Y_F_的博客
01-27 2578
org.apache.hive.service.cli.HiveSQLException: Failed to open new session: java.lang.RuntimeException
Could not open client transport with JDBC Uri: jdbc:hive2://hadoop102:10000: Failed to open new ses
qq_43224174的博客
12-01 4830
解决远程连接hive报错： jdbc:hive2://hadoop102:10000: Failed to open new session: java.lang.RuntimeException: org.apache.hadoop.ipc.RemoteException (org.apache.hadoop.security.authorize.AuthorizationException): The specified database user/password combination is rej
hive中beeline连接报错：Error Failed to open new session java
ddzzz_的博客
10-25 2171
hive中beeline连接报错：Error: Failed to open new session: java.lang.RuntimeException: java.lang.RuntimeException: org.apache.hadoop.security.AccessControlException: Permission denied: 这是hdfs中/tmp和/user/hive/warehouse读写权限造成的，本人由于是虚拟机所以直接就 hadoop fs -chmod -R 77
hiveserver2遇到的问题
beijihukk的博客
03-01 8444
对于hiveserver，看教程是直接一个bin/hiveserver指令就启动了，但是我的总是不行，贴下输出： [root@hadoop apache-hive-2.1.1-bin]# bin/hiveserver2 which: no hbase in (/usr/share/java:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/
使用hive和impala遇到的一些错误
qq_41892833的博客
08-23 2938
1.问题描述：首先在浏览器启动hue时会出现如下报错界面： 然后点开hue里的hive的Query Editor时，DATABASE一直刷不出来，并且写句查询语句执行时，会出现连接不到10000的错误。 解决方法： netstat -anp |grep 9083 查看9083端口发现被占用，所以将占用9083端口的所有进程kill掉后，重新启动metastore和hiveserve...
hive启动出错 org.apache.hadoop.hive.ql.metadata.HiveException
bwddd的博客
02-13 1万+
刚设置好hive的配置文件, 元数据存储使用的是mysql, 然后进行hive进入命令行模式, 使用show databases发现报异常 看报错信息是元数据异常. 那么一定是与mysql的连接,或者元数据的存储出现了问题. 上网百度找了一些答案,说是需要进行元数据格式化, 于是尝试了下, 发现还是报错. # 格式化元数据 schematool -dbType mysql -initS...
[ 08S01] Could not open client transport with JDBC Uri: jdbc:hive2://192.168.1.191:10000: 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 root org.apache.hadoop.ipc.RemoteException:User: root is not allowed to impersonate root
09-13
当出现 `[08S01] Could not open client transport with JDBC Uri: jdbc:hive2://192.168.1.191:10000: 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 root` 错误，通常是由于 Hadoop 的代理用户配置问题导致的。以下是一些可能的解决方法： ### 配置 Hadoop 的代理用户 需要在 `core-site.xml` 文件中配置允许代理的用户和主机。在 NameNode 所在节点的 `core-site.xml` 中添加以下配置： ```xml <property> <name>hadoop.proxyuser.root.hosts</name> <value>*</value> </property> <property> <name>hadoop.proxyuser.root.groups</name> <value>*</value> </property> ``` 上述配置中，`hadoop.proxyuser.root.hosts` 设置为 `*` 表示允许从任何主机进行代理，`hadoop.proxyuser.root.groups` 设置为 `*` 表示允许代理任何用户组。如果需要更严格的安全控制，可以将 `*` 替换为具体的主机名或用户组名。 ### 重启 Hadoop 服务 在修改 `core-site.xml` 文件后，需要重启 Hadoop 相关服务，使配置生效。可以使用以下命令重启 HDFS 和 YARN： ```bash $ stop-dfs.sh $ start-dfs.sh $ stop-yarn.sh $ start-yarn.sh ``` ### 检查 HiveServer2 配置 确保 HiveServer2 配置正确，并且使用的用户具有足够的权限。可以检查 HiveServer2 的启动用户和配置文件。 ### 检查网络连接 确保 JDBC 连接的主机和端口正确，并且网络连接正常。可以使用 `ping` 和 `telnet` 命令来测试网络连接： ```bash $ ping 192.168.1.191 $ telnet 192.168.1.191 10000 ``` ### 检查防火墙设置 确保防火墙没有阻止 JDBC 连接的端口（通常是 10000）。可以临时关闭防火墙进行测试： ```bash $ systemctl stop firewalld ``` 如果关闭防火墙后可以正常连接，需要配置防火墙规则允许该端口的流量通过。
评论 4
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值