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

SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
September 2020
English (United States)
Last Update
Product Category
Teradata Vantage™

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.

Usage Notes

A sparse map is specific to the secure zone of the creator.

You cannot use the CREATE MAP statement to create a contiguous map.