[SPARK-29078] Spark shell fails if read permission is not granted to hive warehouse directory

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Not A Problem
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Mihaly Toth
• Created: 13/Sep/19 20:25
• Updated: 12/Dec/22 18:10
• Resolved: 11/Oct/19 06:17

Description

Similarly to SPARK-20256, in SharedSessionState when GlobalTempViewManager is created, it is checked that there is no database exists that has the same name as of the global temp database (name is configurable with spark.sql.globalTempDatabase) , because that is a special database, which should not exist in the metastore. For this, a read permission is required on the warehouse directory at the moment, which on the other hand would allow listing all the databases of all users.

When such a read access is not granted for security reasons, an access violation exception should be ignored upon such initial validation.