Hive2

Vendor Name	Details
Recommended Native Driver
Apache	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.