首页 > 其他分享 >Hive Beeline连接报错:Error: Could not open client transport with JDBC Uri: jdbc:hive2://hadoop102:10000

Hive Beeline连接报错:Error: Could not open client transport with JDBC Uri: jdbc:hive2://hadoop102:10000

时间:2022-12-04 10:04:15浏览次数:40  
标签:JDBC 10000 hadoop jdbc 报错 moran hadoop102 open


使用 JDBC 方式访问 Hive 时出现以下报错:


Connecting to jdbc:hive2://hadoop102:10000
22/11/27 15:00:53 [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: moran is not allowed to impersonate moran (state=08S01,code=0)
Beeline version 3.1.2 by Apache Hive

解决方案如下:

在hadoop的配置文件core-site.xml增加如下配置,重启hdfs,其中“moran”是连接beeline的用户,将“moran”替换成自己的用户名即可。

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

注意:

1)在修改完配置文件之后,一定要重启Hadoop集群

2)重启Hadoop集群前,先看下有没有多余进程,有的话,就先kill掉,再重启

Hive Beeline连接报错:Error: Could not open client transport with JDBC Uri: jdbc:hive2://hadoop102:10000_大数据

 再次连接,即可成功了

Hive Beeline连接报错:Error: Could not open client transport with JDBC Uri: jdbc:hive2://hadoop102:10000_bc_02

标签:JDBC,10000,hadoop,jdbc,报错,moran,hadoop102,open
From: https://blog.51cto.com/u_15553407/5909910

相关文章