My Oracle Support Banner

Accessing External Tables through Big Data SQL fails with "error processing "error getting Sentry metadata" with BDA Clusters (Doc ID 2772006.1)

Last updated on APRIL 29, 2021

Applies to:

Oracle Big Data SQL - Version 4.0 and later
Linux x86-64

Symptoms

Accessing external tables through Big Data SQL (BDSQL) with BDA clusters fails with:

ERROR at line 1:
ORA-29913: error in executing ODCIEXTTABLEOPEN callout
ORA-29400: data cartridge error
KUP-11504: error from external driver: oracle.hadoop.sql.JXADException: IO
error processing "error getting Sentry metadata"

1. The query can hang for a couple minutes.

2. It is possible to query the same table from Hue.

3. The Sentry service is healthy.

4. On Database side the latest java logs in $ORACLE_HOME/bigdatasql/log/ show messages like below indicating a SentryTRansportPool error:

[describe.open] <TIMESTAMP> ERROR transport.SentryTransportPool: Failed to obtain transport for <HOST>.<DOMAIN>:<SENTRY_PORT>: null
[describe.open] <TIMESTAMP> WARN security.UserGroupInformation: PriviledgedActionException as:oracle/ bigdatasql@<REALM> (auth:KERBEROS) cause:org.apache.thrift.transport.TTransportException: java.net.ConnectException: Connection refused (Connection refused)

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
 Option 1: Set up iptables rules to redirect traffic from the Ethernet port to the Infiniband interface on BDA servers with Sentry roles
 Option 2: Disable Sentry on the Database side


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.