Use the

Data Integration

Mapping Designer to create a mapping. When you create a mapping, you configure a source or target to represent a Hive object.

Describe the flow of data from source and target along with the required transformations before the agent writes data to the target.

Select the mapping that you want to use in a mapping task. Use the

Mapping

Task wizard to create a

mapping

task. The

mapping

task processes data based on the data flow logic you define in the mapping.

In advanced mode, the Mapping Designer updates the mapping canvas to include transformations and functions that enable advanced functionality.

You can use Hive Connector to perform the following tasks:

Connect to Hive to perform the relevant data operations.
Access Hive from Kerberos or non-Kerberos clusters.
Use mappings or mappings in advanced mode to access Hive on an Amazon EMR 6.3 kerberized cluster where the Hive metastore is on AWS Glue.
Use mappings in advanced mode to access Hive on an Amazon EMR 6.3 kerberized cluster where the Hive metastore is on MySQL.
Use all the operators supported in HiveQL.
Use the AND conjunction in filters. You can use both the AND and OR conjunctions in advanced filters.
Apply filter on all filterable columns in Hive tables.
You can configure only Informatica passthrough partitioning for Hive target objects.