Hive Query Failing After BDA 4.1 Upgrade with "RuntimeException Cannot create staging directory"

(Doc ID 1998329.1)

Last updated on APRIL 23, 2015

Applies to:

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

Symptoms

After upgrade hive query fails for user due to lack of write privilege.

FAILED: RuntimeException Cannot create staging directory 'hdfs://<node>/user/hive/warehouse/directory/.hive-staging_hive_2015-02-02_15-47-47_506_111111111111111-1': Permission denied: user=<username>, access=WRITE, inode="/user/hive/warehouse/directory":xxxx:hive:drwxr-xr-x
at org.apache.hadoop.hdfs.server.namenode.DefaultAuthorizationProvider.checkFsPermission(DefaultAuthorizationProvider.java:257)
at org.apache.hadoop.hdfs.server.namenode.DefaultAuthorizationProvider.check(DefaultAuthorizationProvider.java:238)

 

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