Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

(Zeppelin) pyspark query hive java.security.AccessControlException: Permission denied: user=anonymous, access=READ, inode="/warehouse/tablespace/managed/hive

avatar
Explorer

in zeppelin i run show databases; and show tables works but when pyspark to select * from tables

get error permission denied user = anonymous 

 

java.security.AccessControlException: Permission denied: user=anonymous, access=READ, inode="/warehouse/tablespace/managed/hive

 

myzard_0-1670904290960.png

when i check getfacl in /warehouse/tablespace/managed/hive user zeppelin can rwx the directory

myzard_1-1670904341303.png

 why does zeppelin read as user anonymous ?  anybody can help ? thanks

 

1 ACCEPTED SOLUTION

avatar
Explorer

its admin:admin but its solve by add user=hive in 

spark.sql.hive.hiveserver2.jdbc.url = jdbc:hive2://ipserver:2181,ipserver:2181,ipserver:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2;user=hive

 

View solution in original post

3 REPLIES 3

avatar
Master Collaborator

Hello @myzard 

Can you confirm with which user you logged in into zeppelin UI 

avatar
Explorer

its admin:admin but its solve by add user=hive in 

spark.sql.hive.hiveserver2.jdbc.url = jdbc:hive2://ipserver:2181,ipserver:2181,ipserver:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2;user=hive

 

avatar
Explorer

this setting in spark interpreter zeppelin