Rules for Using Client Load Utilities With A Column-Partitioned Table - Teradata Vantage - Analytics Database

SQL Data Definition Language Detailed Topics
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2024-12-13
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
jbg1472252759029
lifecycle
latest
Product Category
Teradata Vantage™
  • You cannot load rows into a column-partitioned table using the MultiLoad or FastLoad utilities.
  • You can load rows into a column-partitioned table using Teradata Parallel Data Pump array INSERT operations.

    You can also use INSERT … SELECT statements to load rows from a source table into a column-partitioned target table. The source can be a primary-indexed table, a column-partitioned table, or an nonpartitioned NoPI table.

    For more information about using the Teradata Parallel Data Pump utility to load rows into a column-partitioned table, see Teradata® Parallel Data Pump Reference, B035-3021 and Teradata Vantage™ - Database Design, B035-1094.