Rui Li created SPARK-24010: ------------------------------ Summary: Select from table needs read access on DB folder when storage based auth is enabled Key: SPARK-24010 URL: https://issues.apache.org/jira/browse/SPARK-24010 Project: Spark Issue Type: Bug Components: SQL Affects Versions: 2.1.0 Reporter: Rui Li
When HMS enables storage based authorization, SparkSQL requires read access on DB folder in order to select from a table. Such requirement doesn't seem necessary and is not required in Hive. The reason is when Analyzer tries to resolve a relation, it calls [SessionCatalog::databaseExists|https://github.com/apache/spark/blob/v2.1.0/sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/analysis/Analyzer.scala#L469]. This will call the metastore get_database API which will perform authorization check. -- This message was sent by Atlassian JIRA (v7.6.3#76005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org