报错：Error: Could not open client transport with JDBC Uri: jdbc:hive2://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: atguigu is not allowed to impersonate atguigu (state=08S01,code=0)

解决方案：

xxx是你使用的用户名字，“*”表示可通过超级代理“xxx”操作hadoop的用户、用户组和主机。

步骤：

1. 在hadoop中/etc/hadoop/core-site.xml（这是我的路径：/opt/module/hadoop-3.1.3/etc/hadoop/core-site.xml）增加如下配置

2. 用xsync命令分发core-site.xml

3.把metastore和hiveserver2停了，然后关闭再开启hadoop集群

4.开启metastore和hiveserver2，继续报错前的操作

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

如果开启metastore报端口被占用的错误，可能是因为重复开启服务，使用jps命令，查看进程，把除hadoop集群正常启动的进程和Jps，其他都kill

[atguigu@Hadoop102 hadoop-3.1.3]$ jps
24064 NodeManager
24883 Jps
21942 RunJar
23703 DataNode
24471 RunJar
21336 RunJar
20313 RunJar
18970 RunJar
23582 NameNode
24639 RunJar
[atguigu@Hadoop102 hadoop-3.1.3]$ kill -9 24471
[atguigu@Hadoop102 hadoop-3.1.3]$ kill -9 21336
[atguigu@Hadoop102 hadoop-3.1.3]$ kill -9 20313
[atguigu@Hadoop102 hadoop-3.1.3]$ kill -9 18970
[atguigu@Hadoop102 hadoop-3.1.3]$ kill -9 24639
[atguigu@Hadoop102 hadoop-3.1.3]$ jps
24064 NodeManager
21942 RunJar
23703 DataNode
24906 Jps
23582 NameNode
 

参考：https://blog.csdn.net/u011495642/article/details/84305944