beeline连接不上hive2

最新推荐文章于 2024-09-22 17:04:11 发布

辣条涨价了

最新推荐文章于 2024-09-22 17:04:11 发布

阅读量1.7k

点赞数 2

文章标签： hive

本文链接：https://blog.csdn.net/IT_tyro/article/details/109738718

版权

hadoop103用beeline连接hadoop102报错

beeline> ! connect jdbc:hive2://hadoop102:10000
Connecting to jdbc:hive2://hadoop102:10000
Enter username for jdbc:hive2://hadoop102:10000: root
Enter password for jdbc:hive2://hadoop102:10000: *****
20/11/17 18:53:47 [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: root is not allowed to impersonate root (state=08S01,code=0)

解决办法：
在hadoop/etc/core-site.xml下面添加下面的内容，保存
然后重启hdfs

stop-dfs.sh
start-dfs.sh

<property>
	<name>hadoop.proxyuser.root.groups</name>
	<value>root</value>
	<description>Allow the superuser oozie to impersonate any members of the group group1 and group2</description>
</property>
<property>
	<name>hadoop.proxyuser.root.hosts</name>
	<value>*</value>
	<description>The superuser can connect only from host1 and host2 to impersonate a user</description>
</property>