6

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
WestCoastProjects
  • 58,982
  • 91
  • 316
  • 560

1 Answers1

6

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.

Matt
  • 4,318
  • 1
  • 27
  • 28