Job Example 11: Loading Hadoop Tables Using the TDCH-TPT Interface - Parallel Transporter

Job Example 11: Loading Hadoop Tables Using the TDCH-TPT Interface

Job Objective:

Use a TPT script with multiple job steps to accomplish the following tasks:

Create a new table in the Teradata Database.

Read data from a Hadoop table and write data to the newly created Teradata Database table.

Data Flow Diagrams

Figure 35 shows a flow diagram of the elements in Job Example 11.

Figure 35: Job Example PTS00030-- Loading Hadoop Tables Using the TDCH-TPT Interface

Sample Script

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

PTS00030: Loading Hadoop Tables Using the TDCH-TPT Interface.

Rationale

In the first job step, this script uses:

DDL operator because it can DROP/CREATE tables prior to loading.

In the second job step, this script uses:

DataConnector operator as the producer operator because it can read data from Hadoop tables via the TDCH-TPT interface.

Load operator template as the consumer because it is the consumer operator that offers the best performance for high speed writing of a large number of rows into an empty Teradata Database table.