[HIVE-12232] Create external table failed when enabled StorageBasedAuthorization

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.2.1
• Assignee: WangMeng
• Reporter: WangMeng
• Created: 22/Oct/15 12:04
• Updated: 30/Oct/15 22:32
• Resolved: 30/Oct/15 22:32

Description

Please look at the stacktrace, when enabled StorageBasedAuthorization, creating external table will failed with write permission about the default warehouse path "/user/hive/warehouse":

> CREATE EXTERNAL TABLE test(id int) 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.

Issue Links

• duplicates: HIVE-12231 StorageBasedAuthorization requires write permission of default Warehouse when create external database