Support Questions
Find answers, ask questions, and share your expertise

Unable to make a jdbc connection with impala

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

Cloudera Employee

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

Explorer

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

Contributor

@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

; ;