https://community.cloudera.com/t5/Support-Questions/Zeppelin-pyspark-query-hive-java-security/m-p/359408#M238106 <P>this setting in spark interpreter zeppelin</P> Tue, 13 Dec 2022 06:10:53 GMT myzard 2022-12-13T06:10:53Z https://community.cloudera.com/t5/Support-Questions/Zeppelin-pyspark-query-hive-java-security/m-p/359391#M238097 <P>in zeppelin i run show databases; and show tables works but when pyspark to select * from tables</P><P>get error permission denied user = anonymous&nbsp;</P><P>&nbsp;</P><P><SPAN>java.security.AccessControlException: Permission denied: user=anonymous, access=READ, inode="/warehouse/tablespace/managed/hive</SPAN></P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="myzard_0-1670904290960.png" style="width: 400px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/36440i1692295416F1A1C4/image-size/medium?v=v2&amp;px=400" role="button" title="myzard_0-1670904290960.png" alt="myzard_0-1670904290960.png" /></span></P><P>when i check getfacl in&nbsp;<SPAN>/warehouse/tablespace/managed/hive user zeppelin can rwx the directory</SPAN></P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="myzard_1-1670904341303.png" style="width: 400px;"><img src="https://community.cloudera.com/t5/image/serverpage/image-id/36441i1B3346C0CE7943C5/image-size/medium?v=v2&amp;px=400" role="button" title="myzard_1-1670904341303.png" alt="myzard_1-1670904341303.png" /></span></P><P><SPAN>&nbsp;why does zeppelin read as user anonymous ?&nbsp; anybody can help ? thanks</SPAN></P><P>&nbsp;</P> Tue, 13 Dec 2022 04:08:23 GMT https://community.cloudera.com/t5/Support-Questions/Zeppelin-pyspark-query-hive-java-security/m-p/359391#M238097 myzard 2022-12-13T04:08:23Z https://community.cloudera.com/t5/Support-Questions/Zeppelin-pyspark-query-hive-java-security/m-p/359392#M238098 <P>Hello&nbsp;<a href="https://community.cloudera.com/t5/user/viewprofilepage/user-id/100422">@myzard</a>&nbsp;</P><P>Can you confirm with which user you logged in into zeppelin UI&nbsp;</P> Tue, 13 Dec 2022 04:14:39 GMT https://community.cloudera.com/t5/Support-Questions/Zeppelin-pyspark-query-hive-java-security/m-p/359392#M238098 Scharan 2022-12-13T04:14:39Z https://community.cloudera.com/t5/Support-Questions/Zeppelin-pyspark-query-hive-java-security/m-p/359407#M238105 <P>its admin:admin but its solve by add user=hive in&nbsp;</P><LI-CODE lang="markup">spark.sql.hive.hiveserver2.jdbc.url = jdbc:hive2://ipserver:2181,ipserver:2181,ipserver:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2;user=hive</LI-CODE><P>&nbsp;</P> Tue, 13 Dec 2022 06:10:17 GMT https://community.cloudera.com/t5/Support-Questions/Zeppelin-pyspark-query-hive-java-security/m-p/359407#M238105 myzard 2022-12-13T06:10:17Z https://community.cloudera.com/t5/Support-Questions/Zeppelin-pyspark-query-hive-java-security/m-p/359408#M238106 <P>this setting in spark interpreter zeppelin</P> Tue, 13 Dec 2022 06:10:53 GMT https://community.cloudera.com/t5/Support-Questions/Zeppelin-pyspark-query-hive-java-security/m-p/359408#M238106 myzard 2022-12-13T06:10:53Z