Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

IMPALA JDBC connection

Re: IMPALA JDBC connection




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.



Re: IMPALA JDBC connection


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


Re: IMPALA JDBC connection

New Contributor

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? 

Re: IMPALA JDBC connection

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:


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>

Re: IMPALA JDBC connection

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,