Cloudera Impala

You can query data on Hadoop using the low latency Impala implementation of SQL. For more information see Apache Impala Overview

Impala itself has become an Apache project which you can find at the Apache Impala Homepage.

Check the documentation to see how you can connect to Cloudera Impala using Kerberos security. Set the required options in the Options tab of your relational database connection metadata:

  • AllowSelfSignedCerts=1

  • AuthMech=1

  • KrbHostFQDN=IMPALA HOSTNAME

  • KrbRealm=Kerberos Realm

  • KrbServiceName=Impala Service name

  • SSL=1

  • principal=Principal name

Option Info

Type

Relational

Driver

Use Cloudera Impala Drivers. You can Download the latest versions from the Cloudera website.

Version Included

None

Hop Dependencies

Cloudera Impala Database Plugin

Documentation

Documentation Link

JDBC Url

jdbc:impala://hostname:port;principal=principalName

Driver folder

<Hop Installation>/lib/jdbc