Error while connecting Impala through JDBC
fk
Partner, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Registered Posts: 4 Partner
Hi Team,
I am trying to connect Impala via JDBC connection. However, I get Error: Creating Login Context. Unable to obtain Principal Name for authentication exception. Following is the connection string which I am using:
jdbc:impala://<hostname>:21050;AuthMech=1;KrbRealm=<REALM>;KrbHostFQDN=<fqdn>;KrbServiceName=impala;SSL=1;SSLKeyStore=<KSPATH>
Best Answer
-
Hi @CoreyS
, I managed to connect kudu table via impala external table on top of it using configuration below:JDBC Driver Class -
org.apache.hive.jdbc.HiveDriver
JDBC URL -
jdbc:hive2://impala.demo.com:21050/;principal=impala/impala.demo.com@DEMO.COM;ssl=true;sslTrustStore=<truststore.jks>;trustStorePassword=<password>;sslKeyStore=<keystore-impala.jks>;keyStorePassword=<password>
Answers
-
CoreyS Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Registered Posts: 1,150 ✭✭✭✭✭✭✭✭✭
Hi, @fk
! Can you provide any further details on the thread to assist users in helping you find a solution (insert examples like DSS version etc.) Also, can you let us know if you’ve tried any fixes already?This should lead to a quicker response from the community.