Cloudera Impala

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