Failed to execute hive queries :[: Access denied: Unable to move source to destination]

asked 2018-03-21 03:15:58 -0600

amank gravatar image

updated 2018-03-21 04:19:17 -0600

I am trying to build pipeline which would be executing Hive query when my file loaded into the hdfs. While executing hive ,it creates ANNONYMOUS user and getting error

Permission denied: user=anonymous, access=WRITE, inode="/user/amank/newData/sms":amank:amank:drwxr-xr-x

access denied: Unable to move source hdfs://hostname:8020/user/amank/newData/sms/fileName to destination hdfs://hostname:8020/user/hive/warehouse/test.db/smsc_data.

I also tried to follow this but still having trouble to resolve it.

The permission of the file in the "/user/amank/newData/sms"->-rw-r--r-- 3 amank amank 19481639 2018-03-21 13:31 /user/amank/newData/sms/sdc-7

The permission in the hive warehouse directory "/user/hive/warehouse" ->

drwxrwxrwt - anonymous hive 0 2018-03-21 12:30 /user/hive/warehouse/smsc_data

drwxrwxrwt - amank hive 0 2018-03-21 11:47 /user/hive/warehouse/test.dB

edit retag flag offensive close merge delete