Easysoft ODBC-JDBC Gateway

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

Article:
01021
Last Reviewed:
26th January 2024
Revision:
1
ODBC-JDBC Gateway DSN 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

Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)