IMPALA JDBC connection

[#1]

Hi,

  I want to connect Impala through Sql Developer or in general through JDBC way on 21050 port. I installed all thing to connection but I do not how to connect Impala Server to jdbc client.

Any suggestion?

Regards.

Sebastiano.

[#2]

Hi,

thanks for the answer. Neither of the 3 is an option for me. I need to use JDBC without LDAP / Kerberos. According to the official documentation it should work - but it doesnt seem to.

Cheers

[#3]

Use Hive JDBC Driver (with port 21050) to connect to Impala. It works fine in non-Kerberized cluster/without authentication.

https://www.cloudera.com/documentation/enterprise/5-8-x/topics/impala_jdbc.html

[#4]

I am trying to use the JDBC driver with AuthMech=2 and pass the UID with no password. It connects using 

transportMode=binary , but doesn't pass the UID or username. I have tried with both the Driver and the DataSource. Any ideas? 

[#5]

I am having the same problem with the Cloudera drivers.

For connection to Impala (CDH 5.8/5.9) I am using "Apache Hive JDBC standalone driver".

Links to jars:
hive-jdbc-2.1.1-standalone.jar
hadoop-common-2.7.3.jar

Below you can see an examples of setting connections to Impala.

Setup Squirrel connection:

1. Run SQuirrel and add driver with following parameters:
   - driver name: hive-jdbc-2.1.1
   - class name: org.apache.hive.jdbc.HiveDriver
   - example url: jdbc:hive2://<host>:21050/;auth=noSasl
   - extra class path: <path_to_jars>
2. Add alias with following parameters:
   - name: impala
   - driver: hive-jdbc-2.1.1
   - username: <your_username>
   - password: <your_password>
3. Test connection 

Setup JMeter connection:

1. Add jars to classpath
2. Add "JDBC Connection Configuration" with following parameters:
   - Auto commit: True
   - Database URL: jdbc:hive2://<host>:21050/;auth=noSasl
   - JDBC Driver class: org.apache.hive.jdbc.HiveDriver
   - username: <your_username>
   - password: <your_password>

[#6]

We have workaround first point is inplace but we have experienced connection establishment issues from webserver to impala with below error. It got fixed itself after couple of hours and would like to know what causes this behavior.

[Simba][ImpalaJDBCDriver](500176) Error connecting to HiveServer2, please verify connection details.

Please help us to understand what causes this issue.

Thank you,
Aj