Impala

Vendor Name

Details

Recommended Native Driver

Cloudera

Driver URL:

Built in

JDBC URL Syntax by Type:

jdbc:hive2://<server>[<port>]/;auth=noSasl

Default Port:

21050

JDBC Class:

org.apache.hadoop.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 isncludesa 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.

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

Last updated

Was this helpful?