CREATE MAP SQL Statement | Teradata Vantage - 17.05 - CREATE MAP - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
English (United States)

Creates a sparse map.

Sparse maps are intended for small tables, join indexes, and hash indexes. You can colocate tables, join indexes, or hash indexes on the same AMPs. Tables that have the same sparse map and colocation name can be joined using the same primary index or primary AMP index columns without redistributing or duplicating rows. For example, you can colocate two tables, then join the tables on the primary index or primary AMP index columns. See the CREATE TABLE MAP option, ALTER TABLE (Map and Colocation Form), the CREATE JOIN INDEX MAP option, and the CREATE HASH INDEX MAP option.

You can also specify a sparse map for a table operator when a table operator is included in the FROM clause of a SELECT statement. See "Table Operator" in Teradata Vantage™ - SQL Data Manipulation Language, B035-1146.

Required Privileges

You must have the CREATE MAP privilege. You must have been granted the contiguous map that you specify in this statement. See "GRANT MAP" in Teradata Vantage™ - SQL Data Control Language, B035-1149.

Privileges Automatically Granted

The map creator is granted the map WITH GRANT OPTION that allows the creator to grant or revoke the created sparse map to users, PUBLIC, and roles.