Job Example 17: Extract Rows and Write Them to a Hadoop File - Parallel Transporter

Teradata Parallel Transporter User Guide

Product
Parallel Transporter
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2445
lifecycle
previous
Product Category
Teradata Tools and Utilities

Job Example 17: Extract Rows and Write Them to a Hadoop File

Job Objective

This Teradata Parallel Transporter sample script loads five rows from a teradata table to flat file in Hadoop.

Data Flow Diagram

Figure 42 shows a diagram of the elements for Job Example 17.

Figure 42: Job Example PTS00031-- Extract Rows and Write Them to a Hadoop File

Sample Script

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

PTS00031: Extract Rows and Write Them to a Hadoop File

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 Teradata Database table.
  • DataConnector operator along with the HDFS Interface because it is the only producer operator that writes data to Hadoop HDFS.