Download ODBC Drivers for Oracle, SQL Server, Salesforce, MongoDB, Access, Derby, InterBase & DB2.

What settings are required to run the ODBC-JDBC Gateway with Apache Hadoop Hive?

ODBC-JDBC Gateway data dource setting Value
Driver Class org.apache.hadoop.hive.jdbc.HiveDriver
Class Path hive-jdbc-0.6.0.jar;hive-metastore-0.6.0.jar;hive-exec-0.6.0.jar;libfb303.jar;hive-service-0.6.0.jar;hadoop-0.20.2-core.jar;log4j-1.2.15.jar;commons-logging-1.0.4.jar;
URL jdbc:hive://server:port/database

where:

  • server is the name or IP address of the machine on which the Hive server is running.
  • port is the port on which the Hive server is listening, which, by default, is 10000.
  • database is the database you want to connect to.

For example:

jdbc:hive://192.168.0.10:10000/default

Note The Hive JDBC driver 0.6 does not support the getMoreResults method. It's therefore necessary to enable the Disable MoreResults Easysoft ODBC-JDBC Gateway setting.