Error: Could not open client transport with JDBC Uri

最新推荐文章于 2025-03-14 21:15:46 发布

菜鸟一枚之一

最新推荐文章于 2025-03-14 21:15:46 发布

阅读量3.1k

点赞数 1

文章标签： hive

本文链接：https://blog.youkuaiyun.com/weixin_41877582/article/details/110928673

版权

Error: Could not open client transport with JDBC Uri: jdbc:hive2://farm1:10000: 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 (state=08S01,code=0)
root用户不能模拟自己
解决方案：

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

root; 自己电脑的用户组名

Error: Could not open client transport with JDBC Uri: jdbc:hive2://farm1:10000: Failed to open new session: java.lang.RuntimeException: org.apache.hadoop.security.AccessControlException: Permission denied: user=anonymous, access=EXECUTE, inode="/tmp/hive":root:supergroup:drwxrwx—
haoop上的tmp文件的权限
修改为可读可写（只是可写权限也会报错）
hadoop dfs -chmod -R 777/tmp/hive