Restrictions and Limitations
This section describes the restrictions and limitations when using the Stream operator.
Data Types
The job cannot load these data types:
LOB
JSON
XML
ST_Geometry
UDT data can be loaded in its external type format.
Error Table
Two jobs loading different tables with different table definition cannot use the same
error table.
Other Notes
One Stream operator job can load up to 127 Teradata tables or views.
Only the Teradata SQL INSERT, UPDATE, DELETE, UPSERT, MERGE, and EXECUTE statements
are supported. Any other Teradata SQL statements are not supported.
Data can be loaded into empty or populated Teradata tables.
By default, duplicate rows are not discarded by the Stream operator for SET tables.
Duplicate rows are inserted into the error table. Use the DML option, "IGNORE DUPLICATE
ROWS," to override the default if you do not want the duplicate rows to be inserted
into the error table.
Duplicate rows are not discarded by the Stream operator for MULTISET tables; they
are inserted into the target tables. The DML options, "MARK DUPLICATE ROWS" and "IGNORE
DUPLICATE ROWS" cannot override this behavior. Duplicate rows are allowed for MULTISET
tables.
Row hash level locking is used during the job. The job does not lock the target tables.
For updates, a record cannot change the value of the primary index of a row, but reflexive
updates of other columns are allowed. A reflexive update of a column computes the
new value as the result of an expression that involves the current value of one or
more columns.
The atomic UPSERT feature cannot have any of the following syntax or characteristics:
INSERT-SELECT
UPDATE-WHERE-CURRENT
UPDATE-FROM
UPDATE-WHERE SUBQUERIES
UPDATE-PRIMARY INDEX
UPDATE or INSERT that could cause a trigger to be fired
UPDATE or INSERT that could cause a join or hash index to be updated
The target tables cannot be rolled back after the job is complete.
A DML group cannot use the Array Support feature if the DML group has multiple DML
statements. The exception is atomic UPSERT statement. Atomic UPSERT statement can
use the Array Support feature.
A job with multiple DML groups and serialize on cannot use the Array Support feature.
A job with a single DML group and serialize on can use the Array Support feature if
the DML group contains a single DML statement or an atomic UPSERT statement.
The Stream operator does not support the TPump's Wildcard INSERT feature.
The Stream operator does not require a Teradata Database load slot.