Geek Answers Handbook

The bush throws a permission error when creating a table / database

I get a permission error in the hive.

I use the IBM cloud - my.imdemocloud.com

hive> create table a(key INT); FAILED: Error in metadata: MetaException(message:Got exception: org.apache.hadoop.security.AccessControlException org.apache.hadoop.security.AccessControlException: Permission denied: user=nehpraka, access=WRITE, inode="warehouse":biadmin:biadmin:rwxrwxr-x) FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask

Where I set all the roles for the user.

hive> SHOW GRANT USER nehpraka on DATABASE default; OK

database default principalName nehpraka principalType USER privilege Create grantTime Wed Apr 16 14:17:51 EDT 2014 grantor nehpraka Time taken: 0.051 seconds

Please help me with this.

Thanks and Ragards

+7
hadoop hive permission-denied
source share
3 answers

I got a solution.

I used the IBM Big Insight cloud, so we can create the database this way.

 create database DataBaseName location 'hdfs://master-1-internal.imdemocloud.com:9000/user/<user_name>';

Thanks for helping me.

+6
source share

This seems like a write permission issue in the HDFS folder.

Have you tried with hdfs? Basically check the hive warehouse on HDFS, and this folder should have RW permission for your user.

+3
source share

if you are using the cloudera hadoop and hive versions, try opening the bush using the command below:

 sudo hive

if it asks for a password, enter cloudera . In cloudera version, only superuser has permission to use hdf write permissions. This will help you.

+1
source share

More articles:


All Articles