Search code examples
jdbchiveimpala

Jdbc settings for connecting to Impala

What is the combination of driver and jdbc URL to use for CDH5 (I am on CDH5.3)?

I have tried a few including:

jdbc:hive2://myserver:21050/;auth=noSasl

And with the following driver:

org.apache.hive.jdbc.HiveDriver

I have added 

   /opt/cloudera/parcels/CDH/lib/impala/lib/*:/opt/cloudera/parcels/CDH/lib/hive/lib/*

to the classpath (but still no success)

The result is:

java.sql.SQLException: No suitable driver found for jdbc:hive2://myserver:20150/;auth=noSasl
Solution

  • Firstly, make sure you're using the correct driver. You should use the Impala JDBC driver (rather than the Hive driver).

    Then you should be able to use the com.cloudera.impala.jdbc3.Driver driver with a connection string like: jdbc:impala://host:21050

    The Impala JDBC driver guide has more details and examples.