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 ?