# Hive2

| Vendor Name                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        | Details                                                                                         |
| -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------- |
| Recommended Native Driver                                                                                                                                                                                                                                                                                                                                                                                                                                                                          |                                                                                                 |
| Apache                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             | <p>Company URL:</p><p><a href="http://hive.apache.org/"><http://hive.apache.org/></a></p>       |
| <p>Driver URL:</p><p><a href="https://www.cloudera.com/downloads/connectors/hive/jdbc/2-6-21.html"><https://www.cloudera.com/downloads/connectors/hive/jdbc/2-6-21.html></a></p><p>or</p><p><a href="https://mvnrepository.com/artifact/org.apache.hive/hive-jdbc"><https://mvnrepository.com/artifact/org.apache.hive/hive-jdbc></a></p>                                                                                                                                                          |                                                                                                 |
| <p>JDBC URL Syntax by Type:</p><ul><li><strong>Server</strong></li></ul><p><code>jdbc:hive2://\<server>\[:\<port>]/\<db></code></p>                                                                                                                                                                                                                                                                                                                                                                | <p>Default Port:</p><p>10000</p>                                                                |
| <p>JDBC Class:</p><p><code>org.apache.hive.jdbc. HiveDriver</code></p>                                                                                                                                                                                                                                                                                                                                                                                                                             | <p>JDBC JAR File Name:</p><p><code>pentaho-hadoop-shims-common-fragment-Vx-x.x.x.jar</code></p> |
| <p>Shipped with Pentaho products:</p><ul><li>Pentaho Server</li><li>Pentaho Data Integration</li><li>Pentaho Metadata Editor</li><li>Pentaho Report Designer</li></ul>                                                                                                                                                                                                                                                                                                                             |                                                                                                 |
| <p>Comments:</p><p>The <code>pentaho-hadoop-shims-common-fragment-Vx-x.x.x.jar</code> 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 <strong>Install Pentaho Data Integration and Analytics</strong> document for more information.</p><p>Hive2 does not support the full SQL capabilities. It uses a subset and is more accurately referred to as HiveQL.</p> |                                                                                                 |