15.00 - Restrictions and Limitations for Load Utilities and Partitioned Tables - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

Restrictions and Limitations for Load Utilities and Partitioned Tables

Load utilities are supported on partitioned tables with the following restrictions and advisories.

  • MultiLoad does not support loads into target tables having USIs. Many partitioned tables have USIs.
  • An alternative is to FastLoad rows into an unpopulated staging table, then use either INSERT … SELECT or MERGE with error logging to move the rows into the target table. See “CREATE ERROR TABLE” on page 228 and SQL Data Manipulation Language for details.

    You cannot use FastLoad to load rows into a column‑partitioned table.

  • MultiLoad IMPORT tasks require you to supply all values of the primary index column set and all values of the partitioning column set for deletes and updates.
  • MultiLoad IMPORT tasks do not support updates of the partitioning column set.
  • MultiLoad IMPORT tasks do not support primary index updates.
  • FastLoad does not support loads into target tables having either USIs or NUSIs.
  • FastLoad does not support loads into primary‑indexed normalized target tables when a primary index column is also part of the ignore list for the NORMALIZE specification.
  • Neither MultiLoad nor FastLoad supports loading into target tables that are defined with either hash and join indexes.
  • You should specify values for the partitioning column set when performing Teradata Parallel Data Pump deletes and updates to avoid lock contention problems that can degrade performance (see Teradata Parallel Data Pump Reference for details).
  • You should avoid updating primary index and partitioning columns with Teradata Parallel Data Pump to minimize performance degradation (see Teradata Parallel Data Pump Reference for details).