Support Questions

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

Unable to make a jdbc connection with impala

avatar
Explorer

Hi 

Im using CDP 7.1 and I am unable to make a jdbc connection with impala from a java application using Cloudera_ImpalaJDBC3_2.5.5.1007.Following is the list of drivers shown in screenshot:

hxn_0-1634114608233.png

We are are using Auto TLS provided by cloudera with no kerberos authentication.

The connection string which we are using on the node where our impala daemon is runnning using Hiveserver2 port 21050: 

ConnectionURL = "jdbc:impala://mstl005:21050;AuthMech=4;SSLKeyStore=/var/lib/cloudera-scm-agent/agent-cert/cm-auto-host_keystore.jks;SSLKeyStorePwd=/var/lib/cloudera-scm-agent/agent-cert/cm-auto-host_key.pw;UID=impala;PWD=impala";

 

We are using AutoTLS  .It is throwing me the following error:

hxn_1-1634114927704.png

 

ConnectionURL = "jdbc:impala://mstl005:21050; this connection string works fine with the mentioned JDBC driver on our other server with no tls enabled.

 

Thanks

 

3 REPLIES 3

avatar
Expert Contributor

Hello,

 

Please try with the below connection URL and let us know how it goes

 

jdbc:impala://nightly57-3.gce.cloudera.com:21050/default;AuthMech=1;SSL=1;KrbRealm=GCE.CLOUDERA.COM;KrbHostFQDN=nightly57-4.gce.cloudera.com;KrbServiceName=impala;SSLTrustStore=/etc/cdep-ssl-conf/CA_STANDARD/truststore.jks

avatar
Explorer

not working...actually kerberos is not enabled on our cluster....only autoTLS is configured. 

avatar
Master Collaborator

@hxn Could you enter the password here instead of the the path to keystore pass file?

 

> SSLKeyStorePwd=/var/lib/cloudera-scm-agent/agent-cert/cm-auto-host_key.pw