Additional permission for Delta compared to Parquet

[User16869510359]

I am trying to create a Delta table and it seems the Delta table requires additional permissions on the parent folder of the table. The command failed telling permission errors. I tried to create a parquet table and it works fine. 

[User16869510359 · Accepted solution]

Delta table is the non-hive compatible format. So there must also be permissions for a client to access the path to the database’s location so that it can create a new temporary “directory” there. This comes from Spark SQL’s handling of external tables. Delta tables just happen to always go through this path. 

See Apache Spark code https://github.com/apache/spark/blob/branch-2.4/sql/hive/src/main/scala/org/apache/spark/sql/hive/Hi... for more information