Restrictions and Limitations - Parallel Data Pump

Teradata Parallel Data Pump Reference

Product
Parallel Data Pump
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-3021
lifecycle
previous
Product Category
Teradata Tools and Utilities

Restrictions and Limitations

Table 20 describes Teradata TPump restrictions and limitations on operational features and functions.

 

Table 20: Restrictions and Limitations on Operational Features and Functions 

Operational Feature/Function

Restriction/Limitation

Maximum row size

The maximum row size for a Teradata TPump job, data plus indicators, is approximately 64,000 bytes. This limit is a function of the row size limit of Teradata Database.

  • Aggregate operators
  • Concatenation of data files
  • Data retrieval from Teradata Database via SELECT statements
  • Not allowed

    Expressions

    Evaluated from left to right, using the Teradata Database order of preference, but can be overridden by parentheses.

    IMPORT commands

    Limit of 100 IMPORT commands within a single TPump load task.

    Date specification

    For dates before 1900 or after 1999, the year portion of the date must be represented by four numerals (yyyy). The default of two numerals (yy) to represent the year is interpreted to be the 20th century, and must be overridden to avoid spurious year information. If the table column defined as type DATE does not have the proper format, the dates may not process properly. The correct date format must be specified at the time of table creation, for example:

    CREATE TABLE tab (ADATE DATE*);
    DEFINE a (char(10))
    INSERT tab (ADATE = :a(DATE, FORMAT 'yyyymmdd'));

    Access logging

    Unlike the MultiLoad and FastLoad utilities, access logging can cause a severe performance penalty in Teradata TPump. This is because Teradata TPump uses normal SQL operations rather than a proprietary protocol, and if all successful table updates are logged, a log entry is made for each operation. The primary index of the access logging table may then create the possibility of row hash conflicts.

    Primary Indexes and Partitioning Column Sets

    Specify values for the partitioning column set when performing Teradata TPump deletes and updates to avoid lock contention problems that can degrade performance. Avoid updating primary index and partitioning columns with Teradata TPump to minimize performance degradation.