天天看点

hive 用beeline远程连接Permission denied: user=NONE, access=EXECUTE, inode=“/tmp/hive“:root:root:drwx-----

[root@zjj101 ~]# beeline
Beeline version 1.2.1 by Apache Hive
beeline> !connect jdbc:hive2://172.16.10.101:10000/default
Connecting to jdbc:hive2://172.16.10.101:10000/default
Enter username for jdbc:hive2://172.16.10.101:10000/default: NONE
Enter password for jdbc:hive2://172.16.10.101:10000/default: ****
Error: Failed to open new session: java.lang.RuntimeException: java.lang.RuntimeException: org.apache.hadoop.security.AccessControlException: Permission denied: user=NONE, access=EXECUTE, inode="/tmp/hive":root:root:drwx------      

大致意思是无法创建一个连接, 然后是没有权限

我折腾半天,各种百度,最后解决方案是

[root@zjj101 hive]# hdfs dfs -chmod -R 777 /tmp      
[root@zjj101 ~]# beeline
Beeline version 1.2.1 by Apache Hive
beeline> !connect jdbc:hive2://xxxx:10000/default
Connecting to jdbc:hive2://xxxx:10000/default
Enter username for jdbc:hive2://xxxx:10000/default: NONE
Enter password for jdbc:hive2://xxxx:10000/default: ****
Connected to: Apache Hive (version 1.2.1)
Driver: Hive JDBC (version 1.2.1)
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://xxxx:10000/default>