Impala

Try Pentaho Data Integration and Analytics

Version
9.3.x
Audience
anonymous
Part Number
MK-95PDIA000-11
Vendor Name Details
Recommended Native Driver
Cloudera

Company URL:

http://cloudera.com

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.