MAP - Teradata Vantage - Analytics Database

You can specify an existing contiguous or sparse map for the table.

You must have been granted the specified map, except when you specify the same map determined to be the default map.

See GRANT MAP in Teradata Vantage™ - SQL Data Control Language, B035-1149. Also, see the CREATE PROFILE DEFAULT MAP option and the CREATE USER DEFAULT MAP option.

map_name

Name of an existing contiguous or sparse map.

You cannot specify TD_DataDictonaryMap or TD_GlobalMap.

COLOCATE USING colocation_name

Optionally, you can specify a colocation name so that the tables reside on the same AMPs to avoid a redistribution of the rows when the tables are joined on a primary index or primary AMP index. For example, you can colocate two tables, then join the tables on the primary index or primary AMP index columns.

You can only specify this option for a sparse map. For a contiguous map, the colocation_name is not needed for colocation and is set to NULL.

If you do not specify a colocation name, the name defaults to database_table, where database is the name of the database followed by an underscore (_) and table is the name of the table. If database exceeds 63 characters, database is truncated to 63 characters. If table exceeds 64 characters, table is truncated to 64 characters.

For a CREATE TABLE … AS source_table statement, where the map for the created table defaults to the sparse map of the source table, colocation_name defaults to the colocation name of the source table.