16.20 - SYSLIB.SparseMapAMPs - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Administration
Programming Reference
Publication ID
B035-1210-162K
Language
English (United States)

Purpose

SYSLIB.SparseMapAMPs is a table function that returns the AMPs with a sparse map defined for a table, join index, or hash index.

The view DBC.SparseMapAMPsV is an alternative to using the table function SYSLIB.SparseMapAMPs. The underlying system view, DBC.ObjectsInSparseMapsV, prepares all arguments for the table function. See Teradata Vantage™ - Data Dictionary, B035-1092 for more details about views DBC.SparseMapAMPsV and DBC.ObjectsInSparseMapsV.

Syntax



SYSLIB.
Name of the database where the function is located.
'DatabaseName'
The database in which the object is defined.
'ObjectName'
Name of the table, join index, or hash index defined in 'DatabaseName'. It cannot be NULL.
'ObjectKind'
The kind of objects, such as a table, join index or hash index, defined in the sparse map.
'MapSlot'
The map slot of the sparse map.
If the map containing the map slot does not exist, or is not a sparse map, an error is returned.
'NumberOfPrimaryAMPs'
The number of primary AMPs defined in the sparse map.
'ColocationName'
The colocation name string for the table.