varunrao / aws-blog-emr-ranger

Repo for Amazon EMR and Apache Ranger Integration
6 stars 2 forks source link

S3 access not ALLOWED!!! hive : [hive] : s3 #5

Closed suryadevarauday closed 4 years ago

suryadevarauday commented 4 years ago

Found another issue with hive. I gave Ranger permissions for my account and while creating a database i get this error

hive> create database int_test1; FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:Got exception: org.apache.hadoop.security.AccessControlException S3 access not ALLOWED!!! hive : [hive] : s3://hive-warehouse/warehouse/int_test1.db) hive> quit;

I even tried creating a internal user and group on ranger called "hive". And i am not sure why it's taking user/group as "hive".

Same result from Hue/ hive/ Beeline