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文件添加如下内容,然后分发到各个服务器

	
        hadoop.proxyuser.root.hosts
        *
    
    
        hadoop.proxyuser.root.groups
        *
    

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

	
        hadoop.proxyuser.hike.hosts
        *
    
    
        hadoop.proxyuser.hike.groups
        *
    

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