问题User: root is not allowed to impersonate root(state=08S01,code=0)的解决方案

问题

21/03/17 18:04:41 [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: kuber is not allowed to impersonate kuber (state=08S01,code=0)

解决方法

这个问题网上很多解决办法，首先在./etc/hadoop/core-site.xml文件里面加上：

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

这两段，然后重启hdfs和yarn，重启hiveserver,hiveserver2但是对我来说并没用。
随后，我在hive/conf/hive.site.xml里面加了下面一句：

	<property>
        <name>hive.server2.enable.doAs</name>
        <value>false</value>
    </property>

成功！