Hive is throwing permission error while creating table/database

hadoop hive permission-denied
orNehPraka picture orNehPraka · Apr 16, 2014 · Viewed 15.4k times · Source

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

Answer

orNehPraka picture orNehPraka · Apr 22, 2014

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.

Related questions

How to delete and update a record in Hive

I have installed Hadoop, Hive, Hive JDBC. which are running fine for me. But I still have a problem. How to delete or update a single record using Hive because delete or update command of MySQL is not working in …

Read More
How to know Hive and Hadoop versions from command prompt?

How can I find which Hive version I am using from the command prompt. Below is the details- I am using Putty to connect to hive table and access records in the tables. So what I did is- I opened …

Read More
Hive insert query like SQL

I am new to hive, and want to know if there is anyway to insert data into hive table like we do in SQL. I want to insert my data into hive like INSERT INTO tablename VALUES (value1,value2..) I …

Read More