Failure to connect to HIVE using SQL Developer

[#1]

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 .

[#2]

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.

[#3]

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

[#4]

Hello.

Has the clue provided below helped?