Restrictions and Limitations - Parallel Transporter

Restrictions and Limitations

This section describes the restrictions and limitations when using the Export operator.

Select Statements

Only the Teradata SQL SELECT statements are supported in the Export operator's SelectStmt attribute.

The SELECT statements in the Export operator's SelectStmt attribute cannot have any of the following characteristics:

Contain a USING modifier

Access nondata tables, such as SELECT DATE or SELECT USER

All SELECT statements in the Export operator's SelectStmt attribute are treated as a single multi-statement request to be sent to the Teradata Database.

Data Types

The job cannot export these data types:

LOB

JSON

XML

ST_Geometry

If the ST_Geometry data type is casted as VARCHAR/VARBYTE, then the data can be exported.

UDT data can be exported in its external type format.

Notes

The Export operator can export rows from multiple tables and views as long as the result sets adhere to the same schema.

For more information about restrictions on using the NoSpool mode, see “Limitations and Functionality.”

The Export operator is not restartable if the data export has started and the data export has not completed.

The Export operator requires one Teradata Database load slot.