Restrictions and Limitations - Parallel Data Pump

Teradata Parallel Data Pump Reference

Product
Parallel Data Pump
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-22
dita:mapPath
tqa1488824663174.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-3021
lifecycle
previous
Product Category
Teradata Tools and Utilities

The following table describes Teradata TPump restrictions and limitations on operational features and functions.

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 'yyyy-mm-dd'));
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.