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 data object 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.