There is a strange (may be not) issue i am facing while creating table in hive editor.
when i create table like -
CREATE EXTERNAL TABLE abc ( id BIGINT, time STRING, log STRING )
row format delimited fields terminated by ‘,’ lines terminated by ‘\n’
STORED AS TEXTFILE;
its get created successfully in the location of the database that is s3:///user/xxxxx/abc
but when i create table by giving location like -
CREATE EXTERNAL TABLE abc2 ( id BIGINT, time STRING, log STRING )
row format delimited fields terminated by ‘,’ lines terminated by ‘\n’
STORED AS TEXTFILE
LOCATION ‘s3:///user/xxxxx/abc2’;
it gives me permission error stating-
Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [xxxxx] does not have [READ] privilege on [s3://<bucket-id>/user/xxxxx]
But the user has all the permission on that path as the above table is created on the same path.
same works fine in hive CLI.
Am i missing anything?
or is it because i am using s3 to store the table but hue is looking at it as hdfs and expecting hdfs ranger policies?
BR.