Getting timeout while connecting to impala from DBWeaver

[#1]

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

[#2]

@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:

1. Set the AuthMech property to 1.

2. 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.

3. Set the KrbHostFQDN property to the fully qualified domain name of the Impala host.

4. 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...

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.

[#3]

Hi @Chella ,

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

golibrary_0-1632617622450.png

golibrary_1-1632617655272.png

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

i have imported the drivers like below 

golibrary_2-1632617962504.png

Please advise.