Error while connecting Impala through JDBC

Options
fk
fk Partner, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Registered Posts: 4 Partner
edited July 16 in Setup & Configuration

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>

· Share on FacebookShare on Twitter

Best Answer

  • fk
    fk Partner, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Registered Posts: 4 Partner
    edited July 17 Answer ✓
    Options

    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>

    · Share on FacebookShare on Twitter

Answers

  • CoreyS
    CoreyS Dataiker Alumni, Dataiku DSS Core Designer, Dataiku DSS Core Concepts, Registered Posts: 1,150 ✭✭✭✭✭✭✭✭✭
    Options

    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.

    · Share on FacebookShare on Twitter
Bookmark this topic

Categories

Setup Info
    Tags
      Help me…