Write permission for my login is denied


#1

pls find below

hive (default)> create external table orders_sqoop
> STORED AS AVRO
> LOCATION ‘/user/hive/warehouse/retail_stage.db/orders’
> TBLPROPERTIES (‘avro.schema.url’=’/tmp/orders.avsc’);
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. MetaException(message:java.security.AccessControlException: Permission denied: user=eanbuselvi1, access=WRITE, inode="/user/hive/warehouse/retail_stage.db/orders":jesuiswang:hadoopthoughtworks:drwxr-xr-x


#2

@anbu You cant use other user databases.

Create a database and load the data.