HiveAccessControlException Permission denied user [user] does not have [WRITE] privilege on …
Source: https://community.hortonworks.com/questions/112754/insert-overwrite-directory-beeline.html
Error
Error: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [user] does not have [WRITE] privilege on [/tmp/*] (state=42000,code=40000)
The above error appears, even though you’ve setup ranger policies, hdfs policies are set up. You’ve checked everything and your head is still spinning. Did you upgrade to HDP 2.6.x ?
Resolution
Provide fully qualified cluster resource. Prepend hdfs://clustername to the path
Affected versions: Hortonworks HDP version 2.6.1
HTH