Hive table staging - 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

When reading Hive sources and connecting via JDBC, Hive stages the data as a text-backed Hive table.

When writing Hive targets, Connect for Big Data stages the data as a text-backed Hive table when connecting via:

Note:

  • In all cases, sufficient space as well as CREATE TABLE privileges are needed to stage the tables.
  • For the ODBC cases, Connect for Big Data writes the tables using the hive command, which must be in the path.