"THRIFT protocol error" when Testing Hive Connection in ODI 12.2.1 (Doc ID 2394861.1)

Last updated on MAY 26, 2022

Applies to:

Symptoms

When attempting to test a Hive data server in Oracle Data Server 12.2.1 which is part of Oracle Big Data Lite Virtual Machine v 4.11, 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://<HOSTNAME>:<PORT>;DatabaseName=default;User=default;Password=default;AuthenticationMethod=kerberos;ServicePrincipalName=hive/<HOSTNAME>;ssl=true;sslTrustStore=/<DIR>/cloudera/security/jks/truststorefile.local.jks

Changes

Enabling Kerberos connection to a Big Data Appliance server in Oracle Big Data Lite Virtual Machine v 4.11

Cause

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