Big Data Management : 2017 : December Skip navigation
2017

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.