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
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

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.