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
Language
English
Product name
Connect ETL
Title
Connect ETL Installation Guide
Copyright
2024
First publish date
2003
Last updated
2024-11-08
Published on
2024-11-08T16:36:35.232000

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.