JDBC Connect Impala

Client

Dbvisualizer 9 also does not support Impala connections (but can support hive), Dbeaver already supports Impala, and I am using Dbeaver.

Several errors were encountered during configuration, [Simba][impalajdbcdriver] (500151) Error setting/closing session: {0}. It is important to note that the port and JDBC parameters Authmech and SSL.

JDBC Connection string

The following is a generic Impala JDBC connection string
Jdbc:impala://{host}:{port}/{database}; authmech=3; Ssl=0

Impala Default Connection port:
port:21000, for Impala-shell and ODBC driver 1.2.
port:21050, for JDBC and for ODBC driver 2.
Other service ports See https://www.cloudera.com/documentation/enterprise/5-7-x/topics/impala_ports.html
Java Program Connection string example JDBC:IMPALA://NODE1.EXAMPLE.COM:21050/DEFAULT2; authmech=3; Uid=cloudera; Pwd=cloudera

Common errors

Refer to the documentation in the JDBC installation package for more information: cloudera-jdbc-driver-for-impala-install-guide.pdf

Https://stackoverflow.com/questions/38775150/impala-jdbc-connection-error-setting-closing-session-open-session-error

Authmech parameters
Set the value to one of the following numbers:

• 0 for No Authentication
• 1 for Kerberos
• 2 for User Name
• 3 for User Name and Password

SSL parameters

• 0, not connect to ssl-enabled sockets.
• 1, through an ssl-enabled socket.

JDBC Connect Impala