Reply
Explorer
Posts: 14
Registered: ‎05-20-2016

Re: IMPALA JDBC connection

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

New Contributor
Posts: 4
Registered: ‎04-27-2016

Re: IMPALA JDBC connection

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? 

New Contributor
Posts: 1
Registered: ‎01-24-2017

Re: IMPALA JDBC connection

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>
Explorer
Posts: 15
Registered: ‎04-23-2015

Re: IMPALA JDBC connection

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

Highlighted
New Contributor
Posts: 1
Registered: ‎11-01-2016

Re: IMPALA JDBC connection

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
Announcements