jdbc连接hive时出现的hivserer2连接报错
java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://192.168.137.11:10000/default: Failed to open new session:
java.lang.RuntimeException:
org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): User: root is not allowed to impersonate anonymous
修改hadoop 配置文件 etc/hadoop/core-site.xml,加入如下配置项
<property>
<name>hadoop.proxyuser.root.hosts</name>
<value>*</value>
</property>
<property>
<name>hadoop.proxyuser.root.groups</name>
<value>*</value>
</property>
hadoop.proxyuser.root.hosts配置项名称中root部分为报错User:* 中的用户名部分
因为报错是root不允许,则hadoop.proxyuser.root.hosts里是root
最后重启hadoop
应该是能够连接成功了
java.sql.SQLException: Could not open client transport with JDBC Uri: jdbc:hive2://192.168.137.11:10000/default: Failed to open new session:
java.lang.RuntimeException:
org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.authorize.AuthorizationException): User: root is not allowed to impersonate anonymous
修改hadoop 配置文件 etc/hadoop/core-site.xml,加入如下配置项
<property>
<name>hadoop.proxyuser.root.hosts</name>
<value>*</value>
</property>
<property>
<name>hadoop.proxyuser.root.groups</name>
<value>*</value>
</property>
hadoop.proxyuser.root.hosts配置项名称中root部分为报错User:* 中的用户名部分
因为报错是root不允许,则hadoop.proxyuser.root.hosts里是root
最后重启hadoop
应该是能够连接成功了