17.10 - Journal Tables and the Default Map - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)

If CREATE USER statement specifies a journal table and a default map, the journal table is created using this default map. The journal table map must be a contiguous map that has the same AMPs as TD_GlobalMap.

If CREATE USER statement specifies a journal table and without specifying a default map, the system determines the map for the journal table in the following order of precedence:
  • Default map for the profile of the user creator, if defined.
  • Default map for the user creator, if defined.
  • System-default map.