[ 
https://issues.apache.org/jira/browse/HIVE-12231?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

WangMeng updated HIVE-12231:
----------------------------
    Description: 
Please look at the stacktrace, when enabled StorageBasedAuthorization, I set 
external location to create database. However, 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)

  was:
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)


> StorageBasedAuthorization requires write permission of default Warehouse 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
>         Attachments: HIVE-12231.01.patch
>
>
> Please look at the stacktrace, when enabled StorageBasedAuthorization, I set 
> external location to create database. However, 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)

Reply via email to