Pyspark, create table in Hive metastore, which permissions?

[#1]

Which permissions do I need to set to store a table in the Hive metastore from pyspark?

[#2 · Accepted solution]

@wiljan van ravensteijn

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.