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

324 阅读1分钟

本文已参与「新人创作礼」活动,一起开启掘金创作之路。

报错信息

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),否则仍然不成功!