Jdbc settings for connecting to Impala

Jdbc settings for connecting to Impala,jdbc,hive,impala,Jdbc,Hive,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

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

#1

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.


#2

Bottom link is dead.