MATRIX_SPEC Syntax Elements - Teradata Vantage
Database Unbounded Array Framework Time Series Functions
- Deployment
- VantageCloud
- VantageCore
- Edition
- Enterprise
- IntelliFlex
- VMware
- Product
- Teradata Vantage
- Release Number
- 17.20
- Published
- June 2022
- Language
- English (United States)
- Last Update
- 2023-12-08
- dita:mapPath
- ncd1634149624743.ditamap
- dita:ditavalPath
- ruu1634160136230.ditaval
- dita:id
- ncd1634149624743
- TABLE_NAME
- The source of the matrix data. It is a single table. The source can reference any Teradata accessible table or a view, or a derived-table, or an ART.
- ROW_AXIS
- The style of indexing, which is TIMECODE or SEQUENCE, and the field which contains the indexing values. TIMECODE is an index based on date or timestamp and SEQUENCE is an index based on integer or float.
- You do not have to identify the indexing data type.
- COLUMN_AXIS
- The style of indexing, which is TIMECODE or SEQUENCE, and the field which contains the indexing values. TIMECODE is an index based on date or timestamp and SEQUENCE is an index based on integer or float.
- You do not have to identify the indexing data type.
- MATRIX_ID
- The field references in the database table which serve the role of the identifier.
- ID_SEQUENCE
- [Dependencies: This parameter is only used with the TD_PLOT function.] A sequence of matrixes to plot. The ID_SEQUENCE contains a JSON object with name-value pairs. Each name corresponds to a MATRIX_ID field with its associated value indicating the desired values.
- PAYLOAD
- The fields comprising the elements of the matrix, and descriptions of their contents. A matrix can have individual elements classified as real numbers, complex numbers, or multivariate real numbers (a vector of real numbers). See SERIES_SPEC Syntax Elements for field descriptions.
- LAYER
- [[Dependencies: This parameter is only used when the MATRIX_SPEC is used to reference a particular layer in an ART.] The layer of the analytical result table (ART) that is passed to the function. An ART can have primary, secondary, tertiary, and quaternary layers. Each layer of an ART has an associated mnemonic name. The names of the ART layers output by a particular function are provided in each function description. See TD_EXTRACT_RESULTS to see which layers are available for which functions.