Impala configuration - Connect_ETL - 9.13

Connect ETL Installation Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect (ETL, Sort, AppMod, Big Data)
Version
9.13
ft:locale
en-US
Product name
Connect ETL
ft:title
Connect ETL Installation Guide
Copyright
2025
First publish date
2003
ft:lastEdition
2025-01-24
ft:lastPublication
2025-01-24T21:47:52.840000

Connecting to Impala from Connect for Big Data requires the following configuration components:

  • Impala JDBC connection
  • Impala table staging
  • Apache Sentry authorization when applicable

Impala JDBC connection

To connect to Impala via JDBC on Windows at design time, download the JDBC driver and specify the mandatory driver name and driver class path parameters in the JDBC configuration file:

See Configuring Impala to Work with JDBC.

  • Set the driver name and driver class path in the JDBC configuration file.

Impala table staging

When reading Impala sources and writing Impala targets, Connect for Big Data stages the data as a text-backed Impala table.

To stage the tables, sufficient space and CREATE TABLE privileges are required.