MATRIX_SPEC Element Syntax | Teradata Vantage - MATRIX_SPEC Syntax - Teradata Vantage

Database Unbounded Array Framework Time Series Functions

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2026-03-23
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743
MATRIX_SPEC(
   TABLE_NAME( [ database-name . ] table name ),
   ROW_AXIS ( { TIMECODE | SEQUENCE } ( field ) ) ,
   COLUMN_AXIS ( { TIMECODE | SEQUENCE } ( field ) ) ,
   MATRIX_ID ( field-list ) ,
      [ID_SEQUENCE ( instance-identifier-list-json-string ) ,]
   PAYLOAD (
      FIELDS ( field-list ) ,
      CONTENT ( { REAL | COMPLEX | AMPL_PHASE | AMPL_PHASE_RADIANS |
          AMPL_PHASE_DEGREES | MULTIVAR_REAL | MULTIVAR_COMPLEX |
          MULTIVAR_ANYTYPE   MULTIVAR_AMPL_PHASE |
          MULTIVAR_AMPL_PHASE_RADIANS | MULTIVAR_AMPL_PHASE_DEGREES } )
      ) ,
   [LAYER ( layer-name ) ]
)