User Guide

Back Next

Hive Mappings

Based on the mapping environment, you can read data from or write data to Hive.

In a native environment, you can read data from Hive. To read data from Hive, complete the following steps:

Create a Hive connection.

Configure the Hive connection mode to access Hive as a source or target.

Use the Hive connection to create a data object to read from Hive.

Add the data object to a mapping and configure the mapping to run in the native environment.

You can write to Hive in a Hadoop environment. To write data to Hive, complete the following steps:

Create a Hive connection.

Configure the Hive connection mode to access Hive as a source or target.

Use the Hive connection to create a data object to write to Hive.

Add the data object to a mapping and configure the mapping to run in the Hadoop environment.

You can define the following types of objects in a Hive mapping:

A Read Transformation to read data from Hive

Transformations

A target or an SQL data service. You can write to Hive if you run the mapping in a Hadoop cluster.

Validate and run the mapping. You can deploy the mapping and run it or add the mapping to a Mapping task in a workflow.