Table of Contents

About

JDBC information on Hive

Management

Dependency

hadoop-*-core.jar
hive-jdbc-*.jar

Example:

  • hadoop-core-1.2.1.jar
  • hive-jdbc-2.3.2.jar

hive-jdbc-*-standalone.jar. Example: http://central.maven.org/maven2/org/apache/hive/hive-jdbc/1.2.1/hive-jdbc-1.2.1-standalone.jar

URI

see Hive - URI (Connection URL )

Sample code

Class.forName("org.apache.hive.jdbc.HiveDriver");
Connection cnct = DriverManager.getConnection("jdbc:hive2://<host>:<port>", "<user>", "<password>");
Connection con = DriverManager.getConnection("jdbc:hive2://localhost:10000/default", "hive", "");

More … Kerberos, ..