is it a bug, or a desired feature that the create external table (or change location of external table) is allowed only for serveradmin roles?
Based on the documentation the database ALL permission should be sufficient, but there is a statement that also the URI should be accessible.
However when I change my test user permission and remove serveradmin, he cannot create an external table pointing to his home directory such like this:
create table part ( i int, s string ) stored as textfile location '/user/testuser/part';
ERROR: AuthorizationException: User 'testuser@MYREALM.LOCAL' does not have privileges to access: hdfs://hdfscluster/user/testuser/part
After enabling the serveradmin right for testuser the command executes correctly and the table is created.
Any hints on this?