Overview

PowerCenter customers can now build mappings that can read from and write to Hive. Hive connectivity is now supported through ODBC.

 

Features

Some salient features include:

  • Reading from both internally and externally managed Hive tables
  • Extensive data type support
  • Easily ingest data from relational tables, flat files and others sources into Hive or vice-versa
  • Query override support for complex and custom HiveQLs
  • Read support for partitioned and bucketed Hive tables
  • ANSI SQL-92 support

 

Known limitations

Following are the known limitations of the driver*:

  • Write to partitioned Hive tables
  • Write to bucketed Hive tables

 

* Support may vary between Hadoop distributions

 

References

Here are the KB articles that describe the simple steps that allow PowerCenter to read from and write to Hive.