WangMeng created HIVE-12231: ------------------------------- Summary: StorageBasedAuthorization requires write permission of default Warehouse PATH when execute "CREATE DATABASE $Name LOCATION '$ExternalPath' " Key: HIVE-12231 URL: https://issues.apache.org/jira/browse/HIVE-12231 Project: Hive Issue Type: Bug Affects Versions: 1.2.1 Reporter: WangMeng
Please look at the stacktrace, when enabled StorageBasedAuthorization , I set external Location of creating database, it will also check write permission of default Warehouse "/user/hive/warehouse" : > create database test location '/tmp/wangmeng/test' ; Error: Error while compiling statement: FAILED: HiveException java.security.AccessControlException: Permission denied: user=wangmeng, access=WRITE, inode="/user/hive/warehouse":hive:hive:drwxr-x--t at org.apache.hadoop.hdfs.server.namenode.DefaultAuthorizationProvider.checkFsPermission(DefaultAuthorizationProvider.java:255) at org.apache.hadoop.hdfs.server.namenode.DefaultAuthorizationProvider.check(DefaultAuthorizationProvider.java:236) at org.apache.hadoop.hdfs.server.namenode.DefaultAuthorizationProvider.checkPermission(DefaultAuthorizationProvider.java:151) -- This message was sent by Atlassian JIRA (v6.3.4#6332)