Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Failure to connect to HIVE using SQL Developer

avatar
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

avatar
Super 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.

avatar
Explorer

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

avatar
Explorer

Hello.

Has the clue provided below helped?