Write permission for my login is denied

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

@anbu You cant use other user databases.

Create a database and load the data.

same problem here,

job job_1540458187951_81582 failed with state FAILED due to: Job setup failed : org.apache.hadoop.security.Ac
cessControlException: Permission denied: user=slunawat, access=WRITE, inode="/user/sudeep/nyse/stocks_eod/_temporary/1":hdfs:hdfs:

i am facing same issue …even at my directory itself

org.apache.hadoop.security.AccessControlException: Permission denied: user=saro1507, access=WRITE, inode="/home/saro1507/test/_temporary/0":hdfs:hdfs:drwxr-xr-x
at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.check(FSPermissionChecker.java:353)
at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.check(FSPermissionChecker.java:325)
at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkPermission(FSPermissionChecker.java:246)

Hi @Saravanan_Murugan,

Please go through below link-