"THRIFT protocol error" when Testing Hive Connection in ODI 12.2.1

(Doc ID 2394861.1)

Last updated on MAY 17, 2018

Applies to:

Oracle Data Integrator - Version 12.2.1.0.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to test a Hive data server in Oracle Data Server 12.2.1, the following error occurs:

oracle.odi.runtime.agent.invocation.InvocationException: oracle.odi.core.exception.OdiRuntimeException: java.sql.SQLException: [FMWGEN][Hive JDBC Driver]THRIFT protocol error.
  at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invoke(RemoteRuntimeAgentInvoker.java:439)
  at oracle.odi.runtime.agent.invocation.support.InternalRemoteRuntimeAgentInvoker.invoke(InternalRemoteRuntimeAgentInvoker.java:162)
  at oracle.odi.runtime.agent.invocation.RemoteRuntimeAgentInvoker.invokeTestDataServer(RemoteRuntimeAgentInvoker.java:1118)
  at com.sunopsis.graphical.dialog.SnpsDialogTestConnet.remoteTestConn(SnpsDialogTestConnet.java:664)
  at com.sunopsis.graphical.dialog.SnpsDialogTestConnet$9.doInBackground(SnpsDialogTestConnet.java:622)
  at oracle.odi.ui.framework.AbsUIRunnableTask.run(AbsUIRunnableTask.java:258)
  at oracle.ide.dialogs.ProgressBar.run(ProgressBar.java:961)
  at java.lang.Thread.run(Thread.java:745)

The JDBC connection URL is set to the following:

jdbc:weblogic:hive://<host>:10000;DatabaseName=default;User=default;Password=default;AuthenticationMethod=kerberos;ServicePrincipalName=hive/<host>;ssl=true;sslTrustStore=/opt/cloudera/security/jks/truststorefile.local.jks

Changes

Enabling Kerberos connection to a Big Data Appliance server.

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