Permission denied when creating table in Hive

hive
#1

I am getting below error while creating table

java.lang.Exception: java.sql.SQLException: Error while processing statement: FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:java.security.AccessControlException: Permission denied: user=gobisubramani, access=WRITE, inode="/":hdfs:hdfs:drwxr-xr-x

I have successfully created database, but I couldn’t create table

Command i ran :
create EXTERNAL table IF NOT EXISTS bill_Header
( bill_num int , bill_amt double , city String ,
district String , shopName String , state String ,
total_item int,total_qty int )
row format delimited fields terminated by ‘,’ lines terminated by ‘\n’ location “/gobisubramani/data/bill_Header”;

googled it for the same issue, that demanded su …
any help ?

0 Likes

#2

Location is incorrect. IT should be /user/<your_user_id>/ and then sub directories.

Please mark it as solved if it resolve the issue.

0 Likes