Hive2

Company URL:

http://hive.apache.org/

Driver URL:

https://www.cloudera.com/downloads/connectors/hive/jdbc/2-6-21.html

or

https://mvnrepository.com/artifact/org.apache.hive/hive-jdbc

JDBC URL Syntax by Type:

Server

jdbc:hive2://<server>[:<port>]/<db>

Default Port:

10000

JDBC Class:

org.apache.hive.jdbc. HiveDriver

JDBC JAR File Name:

pentaho-hadoop-shims-common-fragment-Vx-x.x.x.jar

Shipped with Pentaho products:

• Pentaho Server
• Pentaho Data Integration
• Pentaho Metadata Editor
• Pentaho Report Designer

Comments:

The pentaho-hadoop-shims-common-fragment-Vx-x.x.x.jar library includes a proxy driver. The actual Hive JDBC implementation for the specific distribution and version of Hadoop is located in the Pentaho driver for that distro. See the Install Pentaho Data Integration and Analytics document for more information.

Hive2 does not support the full SQL capabilities. It uses a subset and is more accurately referred to as HiveQL.