[ https://issues.apache.org/jira/browse/HIVE-12231?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
WangMeng reassigned HIVE-12231: ------------------------------- Assignee: WangMeng > 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 > Assignee: 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)