Support Questions
Find answers, ask questions, and share your expertise

Failure to connect to HIVE using SQL Developer

New Contributor

I got the following error message when trying to connect to HIVE via Kerberos authentication. I have verified that the ticket issued by Kerberos is valid. Would really appreciate if someone can provide some insights into this problem. Thank you in advance!

 

Status : Failure -Test failed: [Cloudera][HiveJDBCDriver](500168) Error creating login context using ticket cache: Unable to obtain Principal Name for authentication .

3 REPLIES 3

Guru
Hi,

Based on the error:

Unable to obtain Principal Name for authentication

This can happen when the JCE jars are not up to date on the client machine and not able to use the encryption key provided by Kerberos KDC.

The solution is to download the latest/appropriate jce jars and place them in directory $JAVA_HOME/jre/lib/security. The files are:

US_export_policy.jar
local_policy.jar

Please give it a try and see if it can be helpful.

New Contributor

I have the same issue with the latest SQL Developer sqldeveloper-20.4.1.407.0006-x64.zip which has bundled JDK. Use the latest version of Cloudera JDBC driver for today (hive_jdbc_2.6.15.108.zip) to be precise 4.1. Hive 3.1 goes as a component of HDP 3.1

New Contributor

Hello.

Has the clue provided below helped?

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.