OHSH: "Permission Denied" During CREATE EXTERNAL TABLE After Enabled Sentry Service on a Mammoth Cluster

(Doc ID 2303933.1)

Last updated on OCTOBER 08, 2017

Applies to:

Oracle Loader for Hadoop - Version 1.1.0 to 3.1.0 [Release 1.0 to 3.1]
Linux x86-64

Symptoms

Oracle Loader for Hadoop versions less than 3.1.0 have an issue creating external tables in Hive after Sentry is enabled on a Mammoth cluster.

Access to hue, hive and impala works fine, but some Oracle Shell for Hadoop Loaders (OHSH) jobs do not.

OHSH is installed at the database end and retrieves dmp files from an Oracle Database and loads it into HDFS.

Symptoms of this issue are that at the end of the OHSH load a hive external table is created but the following error is raised:




Changes

This issue is seen when Sentry is enabled on a Mammoth cluster.

This occurs since the "impersonation" of hive is disabled.  The reason for this is that Sentry installations require that impersonation be disabled.

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