Just to clarify, we had this same issue and resolved it by recursively setting the permissions correctly on the folders below /tmp/hive in HDFS (not the filesystem of your Hive Server) and then restarting the Hive services in Ambari. Generally the folders below /tmp/hive/ required 700, apart from "_resultscache_" which needed 733. ... View more