Hive基础[Beeline连接hiveserver2报错 User: XXX is not allowed to impersonate XXX(YYY)]

报错 User: XXX is not allowed to impersonate XXX(YYY)]"/>

Hive基础[Beeline连接hiveserver2报错 User: XXX is not allowed to impersonate XXX(YYY)]

报错信息

WARN jdbc.HiveConnection: Failed to connect to hadoop101:10000
Error: Could not open client transport with JDBC Uri: jdbc:hive2://hadoop101:10000: Failed to oang.RuntimeException: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorizn): User: hike is not allowed to impersonate hike (state=08S01,code=0)

解决方案

把hadoop/core-site.xml文件添加如下内容,然后分发到各个服务器

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

将name标签中root改为hike(自己的用户名)

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

修改完成之后,重启集群(hdfs,yarn),否则仍然不成功!