16.20 - MAPS Architecture - Teradata Vantage NewSQL Engine

Teradata Vantage™ NewSQL Engine Release Summary

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
created_date
March 2019
category
Release Notes
featnum
B035-1098-162K

This feature allows Teradata Database to use multiple maps for table and join index data distribution. A map can include all AMPs in the system or a subset of AMPs to which the table and join index rows will be distributed. Every table and join index is assigned to use a map, either explicitly in a CREATE/ALTER statement, or by default by Teradata Database.

The MAPS Manager portlet in Teradata Viewpoint can facilitate analyzing map use and moving database objects among maps.

Benefits

  • Provides high data availability across the analytical ecosystem. Dramatically reduces the required maintenance window for system reconfiguration and data redistribution after a system expansion.
  • More efficient distribution of data, and optimal use of resources by associating small tables with small (one-AMP or few-AMP) “sparse” maps.
  • Teradata Database includes two sparse maps, and users with appropriate privileges can create additional sparse maps if needed.
  • New tables, views, and procedures are provided to aid in managing multiple maps and migrate tables to new maps after system expansion with minimal impact on system availability.
  • More consistent tactical query performance with higher query concurrency.
  • You can associate maps with table operators and foreign servers to ensure the operator function code is stored and run only on AMPs that store data for tables on which the operators run.

Considerations

  • The Teradata MAPS feature introduces a new database, TDMaps, installed by DIP, that owns new tables, views, and procedures that aid in the management of maps.
  • Privileges on TDMaps must be granted to map administrators.
  • MAPS is disabled by default on systems that are upgraded from pre-16.10 versions of Teradata Database. After MAPS has been enabled, the system cannot be backed down to an earlier release. MAPS is enabled by default on systems that have been sysinited on or migrated to Teradata Database 16.10.
  • The Teradata MAPS feature introduces a new dedicated fallback scheme, used for all tables that use maps created on Teradata Database 16.10.
  • The Teradata MAPS Architecture feature is not compatible with the ARC (arcmain) archive/recovery utility. If MAPS is enabled, you should use Teradata Data Stream Architecture (DSA) for archive/recovery operations. For more information on DSA, see Teradata® DSA User Guide, B035-3150.

SQL Changes

New SQL statements:
  • CREATE MAP, DROP MAP, SHOW MAP
  • GRANT MAP, REVOKE MAP
Changed SQL statements, that now accept a MAP option:
  • CREATE TABLE, CREATE TABLE AS, ALTER TABLE
  • CREATE JOIN INDEX, ALTER JOIN INDEX
  • CREATE HASH INDEX, ALTER HASH INDEX
  • CREATE DATABASE, CREATE USER, MODIFY DATABASE, MODIFY USER
  • CREATE PROFILE, MODIFY PROFILE
  • CREATE FUNCTION, REPLACE FUNCTION
  • CREATE FOREIGN SERVER, MODIFY FOREIGN SERVER
SQL statements that now show map information:
  • EXPLAIN [IN XML]
  • HELP SESSION
  • SHOW [IN XML] TABLE
  • SHOW [IN XML] JOIN INDEX
New functions:
  • SYSLIB.ContiguousMapAMPs
  • SYSLIB.SparseMapAMPs
  • SYSLIB.SparseTableAMPs
Changed functions:
  • HASHAMP, HASHBACKAMP
New SQL procedures:
  • AnalyzeSP
  • CreateMapListSP, AddMapListEntrySP, and AddMapListEntrySPX
  • CreateObjectListSP, AddObjectListEntrySP, and AddObjectListEntrySPX
  • CreateExclusionListSP, AddExclusionListEntrySP, and AddExclusionListEntrySPX
  • MonitorAnalyzeSP
  • CleanUpAnalyzerSP
  • ManageMoveTablesSP
  • MoveTablesSP
  • MonitorMoveTablesSP
  • StopMoveTablesSP
  • CleanUpMoveTablesSP
  • MoveTDMapsTablesSP
  • TruncateHistorySP
  • AdjustSpace

Additional Information

Topic Document
Maps Teradata Vantage™ - Database Design, B035-1094
Creating maps and associating maps with tables Teradata Vantage™ SQL Data Definition Language Syntax and Examples, B035-1144
Associating maps with table operators and foreign servers The EXECUTE MAP clause in Teradata Vantage™ SQL Data Definition Language Syntax and Examples, B035-1144
Managing maps Teradata Vantage™ - Database Administration, B035-1093
MAPS Manager portlet in Teradata Viewpoint Teradata® Viewpoint User Guide, B035-2206
Syntax for new SQL procedures and macros Teradata Vantage™ SQL Operators and User-Defined Functions, B035-1210
Configuration and Reconfiguration utilities Support Utilities , B035-1180