PowerExchange for Hive User Guide

10.4.1
- 10.5.9
- 10.5.8
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5.3
- 10.5
- 10.4.0

Back Next

Relational Data Object

A relational data object is a physical data object that uses a relational table or view as a source.

Import a relational data object with a Hive connection to access data in the Hive data warehouse.

Create a relational data object to perform the following tasks:

Filter rows when the Data Integration Service reads source data. If you include a filter condition, the Data Integration Service adds a

where

clause to the default query.

Specify a join instead of the default join. If you include a user-defined join, the Data Integration Service replaces the join information specified by the metadata in the SQL query.

Create a custom query to issue a special

SELECT

statement for the Data Integration Service to read source data. The custom query replaces the default query that the Data Integration Service uses to read data from sources.

You can include relational data objects in mappings and mapplets. You can add a relational data object to a mapping or mapplet as the following transformations:

Read transformation if the run-time environment is native or Hadoop.

Write transformation if the run-time environment is native or Hadoop.

Data Objects for Hive

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal