hadoop fs -ls /apps/hive/
Found 1 items drwxrwxrwx - hive hadoop 0 2017-10-02 14:00 /apps/hive/warehouse
You mean the Load statement and not the insert, right?
Attached is the error and last lines from log.
In this case we see that user "hive" is actually trying to write data inside the "" directory
Permission denied: user=hive, access=WRITE, inode="/user/admin/MOCK_DATA.csv":admin:hadoop:drwxr-xr-x
So either you should give write access to the "hive" user on the mentioned directory "/user/admin/" As we see that it does not have the "WRITE" permission Or you should run the job using "admin" user with the following setup:
If you want to run as "admin"
# hdfs dfs -chown admin:hadoop /user/admin # hdfs dfs -chmod 777 /user/admin
Or else if you want to run the hive job using "hive" user then you should change the ownership to "hive" user and the permission accordingly.
# hdfs dfs -chown hive:hadoop /user/admin # hdfs dfs -chmod 777 /user/admin
Good to know that it works now. It will be great if you can mark this HCC Thread as "Accepted" (Answered) so that other HCC users can quickly find the solution for this issue , instead of reading the whole thread.