Failed to execute hive queries :[: Access denied: Unable to move source to destination]
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