OAC-CM : Unable to create connection to Hive Datasources
(Doc ID 2657876.1)
Last updated on APRIL 20, 2020
Applies to:Oracle Analytics Cloud - Classic - Version 105.5.0 and later
Information in this document applies to any platform.
After upgrading OAC instance to the latest version 105.5.0-308 the connectivity between OAC and Hive database hosted in Oracle Big data cluster stopped working for normal Kerberos users.
So you get below error while trying to establish a connection via Hive Datasource
Failed with the following errors:
Error message while trying to save the connection in DV:
Cause: java.io.IOException: execute query failed[nQSError: 43113] Message returned from OBIS. [nQSError: 16028] ODBC error state: 08001 code: 0 message: [Oracle DataDirect][ODBC Apache Hive Wire Protocol driver]Client unable to establish connection.GSS initiate failed. Action: Invalid Host or Port details specified
Errors seen in obis1-diagnostic.log:
[nQSError: 16028] ODBC error state: 08001 code: 0 message: [Oracle DataDirect][ODBC Apache Hive Wire Protocol driver]Client unable to establish connection.GSS initiate failed. [[
: server/Query/Execution/DbGateway/Odbc35/../Odbc/Src/SQXDGOdbcConnection.cpp; line: 1102
Upgraded to OAC 105.5.0-308 from the previous version
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