Permission denied: access=WRITE, inode="/tmp/hive-yarn"

INSERT INTO TABLE session1 PARTITION(year, month)

SELECT * FROM session2

FAILED: RuntimeException org.apache.hadoop.security.AccessControlException: Permission denied: user=a, access=WRITE, inode="/tmp/hive-yarn":b:supergroup:drwxr-xr-x

  at org.apache.hadoop.hdfs.server.namenode.FSPermissionChecker.checkFsPermission(FSPermissionChecker.java:271)


Solution: 
SET hive.exec.scratchdir = /tmp/hive-${user.name}

Scratch space for Hive jobs, otherwise it will run as yarn.

If pig inserts to Hive table with this issue:

set hive.exec.scratchdir  /tmp/hive-${user.name}

Reference:

https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties