Hive is throwing permission error while creating table/database
Solution 1
I got the solution.
I was using IBM Big Insight cloud, on this we can create a database in this manner.
create database DataBaseName location 'hdfs://master-1-internal.imdemocloud.com:9000/user/<user_name>';
Thanks all for helping me.
Solution 2
This looks like a HDFS folder write permission issue.
Have you tried with hdfs user? Basically check the warehouse of hive on HDFS and that folder should have RW permission for your user.
Solution 3
if you are using Cloudera version of hadoop and hive then try to open hive using below command :
sudo hive
if it asks for password then enter cloudera
.
In cloudera version, only super user have permission to hive write permissions on hdfs.
This will help you.
orNehPraka
Working as a IT Professional, surf sites in my free time. Working on hadoop and Big Data.
Updated on June 22, 2022Comments
-
orNehPraka almost 2 years
I am getting permission error in hive.
I am using 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 as I have given all the roles to m 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 out in this.
Thanks & Ragards
-
orNehPraka about 10 yearsI am using IBM cloud bigsql.imdemocloud.com my.imdemocloud.com
-
orNehPraka about 10 yearsI am not permitted to do so, I am using IBM's cloud bigsql.imdemocloud.com my.imdemocloud.com I am not authorized.
-
Jari Turkia about 6 yearsFor some strange reason my Cloudera installation managed to initialize Hive only as user
hdfs
. Something likesudo -u hdfs hive
.