General - Analytics Database - Teradata Vantage

ANSI Temporal Table Support

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2023-10-30
dita:mapPath
jqu1628112571823.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
esa1472244798285
lifecycle
latest
Product Category
Teradata Vantage™
  • Valid time is the Teradata implementation of what ANSI calls “application time.”
  • The valid_start and valid_end columns must be defined as NOT NULL.
  • The data types of the valid_start and valid_end columns must match.
  • To function as a temporal table, the valid-time table must be defined AS VALIDTIME. System-time tables do not have valid time.
  • A table can have only one valid-time period definition.
  • A valid-time table cannot be a queue, error, or global temporary trace table.
  • Statistics cannot be collected on the valid-time derived period column, but they can be collected on the component start and end time columns.
  • Algorithmic compression (ALC) is not allowed on DateTime columns that act as the beginning and ending bound values of a temporal derived period column.