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