Errors while Accessing HiveServer2 on Kerberos Enabled Oracle Big Data Appliance CDH Cluster (Doc ID 1986058.1)

Last updated on OCTOBER 11, 2016

Applies to:

Big Data Appliance Integrated Software - Version 2.4.0 and later
Information in this document applies to any platform.

Symptoms

Trying to access HiveServer2 on Kerberos Enabled Oracle Big Data Appliance (BDA) CDH Cluster from a Client or a BDA node using Cloudera Hive Jdbc driver fails with below errors ...

Error 1

Exception in thread "main" java.sql.SQLException: [Simba][HiveJDBCDriver](500164) Error initialized or created transport for authentication: Peer indicated failure: Unsupported mechanism type PLAIN.
       at com.cloudera.hive.hivecommon.api.HiveServer2ClientFactory.createTransport(Unknown Source)
       at com.cloudera.hive.hive.api.ExtendedHS2Factory.createClient(Unknown Source)
       at com.cloudera.hive.hivecommon.core.HiveJDBCConnection.connect(Unknown Source)
       at com.cloudera.hive.jdbc.common.BaseConnectionFactory.doConnect(Unknown Source)
       at com.cloudera.hive.jdbc.common.AbstractDriver.connect(Unknown Source)
       at java.sql.DriverManager.getConnection(DriverManager.java:571)
       at java.sql.DriverManager.getConnection(DriverManager.java:233)

Error 2

Exception in thread "main" java.sql.SQLException: [Simba][HiveJDBCDriver](500164) Error initialized or created transport for authentication: Unable to connect to server:.
      at com.cloudera.hive.hivecommon.api.HiveServer2ClientFactory.createTransport(Unknown Source)
      at com.cloudera.hive.hive.api.ExtendedHS2Factory.createClient(Unknown Source)
      at com.cloudera.hive.hivecommon.core.HiveJDBCConnection.connect(Unknown Source)
      at com.cloudera.hive.jdbc.common.BaseConnectionFactory.doConnect(Unknown Source)
      at com.cloudera.hive.jdbc.common.AbstractDriver.connect(Unknown Source)
      at java.sql.DriverManager.getConnection(DriverManager.java:571)
      at java.sql.DriverManager.getConnection(DriverManager.java:233)

Error 3

Exception in thread "main" java.sql.SQLException: [Simba][HiveJDBCDriver](500164) Error initialized or created transport for authentication: CONN_KERBEROS_AUTHENTICATION_ERROR_GET_TICKETCACHE.
      at com.cloudera.hive.hivecommon.api.HiveServer2ClientFactory.createTransport(Unknown Source)
      at com.cloudera.hive.hive.api.ExtendedHS2Factory.createClient(Unknown Source)
      at com.cloudera.hive.hivecommon.core.HiveJDBCConnection.connect(Unknown Source)
      at com.cloudera.hive.jdbc.common.BaseConnectionFactory.doConnect(Unknown Source)
      at com.cloudera.hive.jdbc.common.AbstractDriver.connect(Unknown Source)
      at java.sql.DriverManager.getConnection(DriverManager.java:571)
      at java.sql.DriverManager.getConnection(DriverManager.java:233)

  

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