OBIEE 11g/12c: Unable to See Tables List While Importing Tables from Hive in BI Administration Tool (RPD)

(Doc ID 2298027.1)

Last updated on JULY 08, 2018

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.9.0 and later
Generic Windows

Symptoms

On Oracle Business Intelligence Enterprise Edition 11.1.1.9.X version, 

In BI Administration Tool, Hive DSN is created and tested successfully.

Cloudera ODBC or Data direct driver / ODBC 3.5 can be used which is compatible with HiveServer2.

In Admin tool, while importing tables in RPD, Connection to Hive is successful but tables list is not displayed.

Changes

OBIEE Upgraded from 11.1.1.7 to 11.1.1.9.x / 12.2.1.x version.

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