Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

IMPALA JDBC connection

avatar
Explorer

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.

14 REPLIES 14

avatar
Explorer

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

avatar
Contributor

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

avatar
Explorer

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? 

avatar
New Contributor

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>

avatar
New Contributor
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