Executing Hive Queries and getting Hue Permissiion Error

(Doc ID 1958011.1)

Last updated on FEBRUARY 02, 2015

Applies to:

Big Data Appliance Integrated Software - Version 3.0.1 and later
Linux x86-64

Symptoms

Executing Hive queries from Hue fails with:

Exception: org.apache.hadoop.security.AccessControlException: Permission denied: user=<user name>, access=WRITE, inode="/tmp/hive-hive":<user name>:supergroup:drwxr-xr-x
hadoop-cmf-hive-HIVESERVER2-dbda1node04.domain.com.log.out.1:Caused by: org.apache.hadoop.security.AccessControlException: Permission denied: user=<user name>, access=WRITE, inode="/tmp/hive-hive":<user name>:supergroup:drwxr-xr-x
hadoop-cmf-hive-HIVESERVER2-bda1node04.domain.com.log.out.1:Caused by: org.apache.hadoop.ipc.RemoteException(org.apache.hadoop.security.AccessControlException): Permission denied: user=<user name>, access=WRITE, inode="/tmp/hive-hive":<user name>:supergroup:drwxr-xr-x
hadoop-cmf-hive-HIVESERVER2-bda1node04.domain.com.log.out.1:2014-11-03 15:45:26,614 WARN org.apache.hadoop.security.UserGroupInformation: PriviledgedActionException as:<user name> (auth:PROXY) via hive/bda1node04.domain.com@<REALM> (auth:KERBEROS) cause:org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: RuntimeException org.apache.hadoop.security.AccessControlException: Permission denied: user=<user name>, access=WRITE, inode="/tmp/hive-hive":<user name>:supergroup:drwxr-xr-x
hadoop-cmf-hive-HIVESERVER2-bda1node04.domain.com.log.out.1:org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: RuntimeException org.apache.hadoop.security.AccessControlException: Permission denied: user=<user name>, access=WRITE, inode="/tmp/hive-hive":<user name>:supergroup:drwxr-xr-x

 

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms