PowerCenter customers can now build mappings that can read from and write to Hive. Hive connectivity is now supported through ODBC.
Some salient features include:
Following are the known limitations of the driver*:
* Support may vary between Hadoop distributions
Here are the KB articles that describe the simple steps that allow PowerCenter to read from and write to Hive.