question Getting timeout while connecting to impala from DBWeaver in Support Questions

Getting timeout while connecting to impala from DBWeaver

golibrary — Thu, 23 Sep 2021 04:04:03 GMT

Hi,

I am trying to connect to impala form dbweaver and constantly getting the below error. I have imported all the necessary drivers.

[Simba][ImpalaJDBCDriver](500164) Error initialized or created transport for authentication: java.net.ConnectException: Connection refused: connect.
java.net.ConnectException: Connection refused: connect
java.net.ConnectException: Connection refused: connect
Connection refused: connect
Connection refused: connect

connection string format:- jdbc:impala://hostname:21050/pmmcounter_db

Re: Getting timeout while connecting to impala from DBWeaver

Chella — Fri, 24 Sep 2021 07:28:37 GMT

@golibrary It looks it fails with authentication. Please try with "AuthMech" property based on your Cluster setup.

Using No Authentication

To use no authentication:

 Set the AuthMech property to 0 For example:

jdbc:impala://localhost:21050;AuthMech=0

Using Kerberos

For information on operating Kerberos, refer to the documentation for your operating system.

To configure the Cloudera JDBC Driver for Impala to use Kerberos authentication:

Set the AuthMech property to 1.
If your Kerberos setup does not define a default realm or if the realm of your Impala server is not the default, then set the appropriate realm using the KrbRealm property.
Set the KrbHostFQDN property to the fully qualified domain name of the Impala host.
Set the KrbServiceName property to the service name of the Impala server.

For example:

jdbc:impala://localhost:21050;AuthMech=1;KrbRealm=EXAMPLE.COM;Krb HostFQDN=impala.example.com;KrbServiceName=impala

Please refer the below document

Check Authentication informations on page number -> 13 & 14

https://docs.cloudera.com/documentation/other/connectors/impala-jdbc/2-5-24/Cloudera-JDBC-Driver-for-Impala-Install-Guide-2-5-24.pdf

Cheers!
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

Re: Getting timeout while connecting to impala from DBWeaver

golibrary — Sun, 26 Sep 2021 00:59:29 GMT

Hi @Chella ,

Thanks for the reply, I have already set AuthMech = 0 in DbWeaver driver properties, but i still see the same error

url format is like :- jdbc:impala://<domain_name>:21050/<schema_name>

i have imported the drivers like below

Please advise.