CREATE MAP Syntax Elements - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
Unless otherwise noted, every syntax element that is a name must follow the rules for naming database objects. See Object Names.
sparse_map_name
Name of the sparse map.
You cannot specify a name of an existing map or a name that begins with TD_.
For best practice, include "map" in the name, for example OneAMPMap or SmallTable_Map.
FROM contiguous_map_name
Name of the parent contiguous map for the sparse map. You must specify the name of an existing contiguous map.
You cannot specify TD_DataDictonaryMap or TD_GlobalMap.
SPARSE
Required keyword to indicate that the map is a sparse map.
AMPCOUNT = n
Specifies the number of AMPs for the map, where n is a value from 1 to the number of AMPs in the parent contiguous map, up to 1024.