My Oracle Support Banner

OBIEE 12c: Support For TIMESTAMPADD And TIMESTAMPADIFF For IMPALA Cloudera ODBC Driver (Doc ID 2299853.1)

Last updated on FEBRUARY 11, 2019

Applies to:

Business Intelligence Server Enterprise Edition - Version 12.2.1.2.0 and later
Information in this document applies to any platform.

Symptoms

 To implement OBIEE 12c with Impala as the Database and using cloudera odbc driver version 2.5.36 for integration

In the RPD Physical Layer for the Impala datasource --> In the database Features tab, default value unchecked and greyed out by default

for TIMESTAMP_ADD_SUPPORTED and TIMESTAMP_DIFF_SUPPORTED

 

Even though in DBFeatures.default file default flags for Impala target type are enabled, the issue still persists
IS_TIMESTAMP_ADD_SUPPORTED = Yes ;
IS_TIMESTAMP_DIFF_SUPPORTED = Yes ;

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
References


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