Unable to make a jdbc connection with impala

[#1]

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:

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:

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

Thanks

[#2]

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

[#3]

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

[#4]

@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