What are Maps? - Teradata Viewpoint

Teradata Viewpoint User Guide

Product
Teradata Viewpoint
Release Number
16.10
Published
June 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
hkd1478709580913.ditamap
dita:ditavalPath
2206_User_vp_1610.ditaval.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem

The Teradata Database is composed of parallel units known as “AMPs." Each node in the configuration has a predefined number of AMPs, and typically the rows of a table are spread across all AMPs in the system. Maps (Hash Maps) determine how to distribute data from individual table rows among the AMPs. Maps list one or more AMPs. Every table is associated with a map to distribute the table data (rows) among the AMPs in the map.

Other objects such as user defined functions (UDF) are also associated with maps. A UDF is placed on the AMP that stores the associated table's rows.

MAPS Manager uses two types of maps:
  • Contiguous maps include all AMPs within a specified range. Teradata Database creates contiguous maps during a system initialization or reconfiguration.
  • Sparse maps include a subset of AMPs from a contiguous map. Teradata Database provides two sparse maps: one sparse map for a subset of the AMPS and one sparse map for one AMP.
You can also create new sparse maps if you have appropriate database privileges. For more information on a creating a sparse map, see SQL Data Definition Language - Syntax and Examples.

MAPS Manager selects the optimal map for each object and provides the recommendation in System Monitoring or lists the target map in Object Workflows.

The order of map selection is first the system default map and its associated system created sparse maps, then any user created map that the user has been granted permissions to use. For System Monitoring, the credentials entered in the settings determine the maps for use. For Object Workflows, the credentials used during log on determine the maps that are selected or available. The user created maps must have a unique number of AMPs. If there are two user created maps with the same number of AMPs, MAPS Manager selects the map that alphabetically comes first. For example, the map TDAnn03 is selected instead of the map TDVin03.

You can change the target map after analysis using workflow options. For more information on maps, see Teradata Database Database Design.