Job Example 18: Extract Rows and Write Them to a Hadoop Table - Parallel Transporter

Teradata® Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-02-04
dita:mapPath
kyx1608578396289.ditamap
dita:ditavalPath
tvt1507315030722.ditaval
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities

Job Objective

Extract rows from a database table and write them to a Hadoop table; the Hadoop table's data should be stored in the RCFile format.

Data Flow Diagram

The following figure shows a diagram of the elements for Job Example 18.

Job Example PTS00032 – Extract Rows and Write Them to a Hadoop Table

Sample Script

For the sample script that corresponds to this job, see the following script in the sample/userguide directory:

PTS00032: Extract Rows and Write Them to a Hadoop Table

Rationale

This job uses the operators shown for the following reasons:
  • Export operator because it is the fastest way to extract large amounts of data from a database table.
  • DataConnector operator along with the TDCH-TPT Interface because it is the only producer operator that writes data to Hadoop tables in the RCFile format.