Input Table Rows Redistribution - Analytics Database

Database Analytic Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2024-04-06
dita:mapPath
gjn1627595495337.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
jmh1512506877710
Product Category
Teradata Vantage™

To redistribute input table rows to fewer AMPs, sparse map can be used. For example, to redistribute a table to four AMPs, first create a sparse map of four AMPs named sparse_map_4 using the following command:

CREATE MAP sparse_map_4 FROM td_map1 SPARSE ampcount=4;

Then, create a table using this sparse map, as follows.

CREATE TABLE Table1, MAP=sparse_map_4 (a1 INTEGER, b1 INTEGER) PRIMARY INDEX (a1);

All data inserted into this table is distributed to four AMPs only.

For more information about maps, see Teradata® Database SQL Data Definition Language - Syntax and Examples, Teradata® Database Design, and Teradata® Database Administration.