question Pyspark, create table in Hive metastore, which permissions? in Archives of Support Questions (Read Only) https://community.cloudera.com/t5/Archives-of-Support-Questions/Pyspark-create-table-in-Hive-metastore-which-permissions/m-p/99149#M12456 <P>Which permissions do I need to set to store a table in the Hive metastore from pyspark?</P> Tue, 15 Dec 2015 01:52:30 GMT wiljan_van_rave 2015-12-15T01:52:30Z Pyspark, create table in Hive metastore, which permissions? https://community.cloudera.com/t5/Archives-of-Support-Questions/Pyspark-create-table-in-Hive-metastore-which-permissions/m-p/99149#M12456 <P>Which permissions do I need to set to store a table in the Hive metastore from pyspark?</P> Tue, 15 Dec 2015 01:52:30 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Pyspark-create-table-in-Hive-metastore-which-permissions/m-p/99149#M12456 wiljan_van_rave 2015-12-15T01:52:30Z Re: Pyspark, create table in Hive metastore, which permissions? https://community.cloudera.com/t5/Archives-of-Support-Questions/Pyspark-create-table-in-Hive-metastore-which-permissions/m-p/99150#M12457 <P><A rel="user" href="https://community.cloudera.com/users/1411/wiljanvanravensteijn.html" nodeid="1411">@wiljan van ravensteijn</A></P><P>If you are running Hive with doAs=false, metastore service must have write permission in /app/hive/warehouse and also in new directories/tables you create. If you are using Sandbox 2.3.2, easiest way is to define a Ranger police to grant access to hive user, another solution would be to execute pyspark using hive user.</P> Wed, 16 Dec 2015 09:27:55 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Pyspark-create-table-in-Hive-metastore-which-permissions/m-p/99150#M12457 gbraccialli3 2015-12-16T09:27:55Z