17.00 - Designing a Filter Operator - Parallel Transporter

Teradata® Parallel Transporter Operator Programmer Guide

Parallel Transporter
June 2020
Programming Reference

Use the following process guidelines for implementing the Initiate, Execute, and Terminate functions for a filter operator.

Designing a Filter Operator
Function Process
Initiate None.
  1. Use the Get Table Schema List function to get the input data schema handle.
  2. Use the Get Row function to read a row.
  3. Use the Get Column Schema function to get the column handles associated with the input data schema.
  4. Do the following for each of the column handles involved in the filter task:
    1. Use the Get Column Value function to get the column value.
    2. Compare the column value with the filter value.
  5. If all column values satisfy the filter criteria, return PXSTC_EndMethod status, otherwise return PXSTC_DiscardRow status.
Terminate None.

Example - Sample Filter Operator

On Windows, see the following text file in the Teradata Parallel Transporter installation folder for a sample filter operator: TPT_install_directory\sdk\src\samplefilter.cpp.