TD_MINFO Output - 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
2024-10-04
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743
lifecycle
latest

A result set containing metadata about each matrix. The function returns one row per matrix instance. In addition, each input payload produces the output variables for MIN_MAG, MAX_MAG and AVG_MAG. The number of output columns varies depending on the number of input payloads.

RETURNS TABLE Schema

Name Data Type Description
derived-series-identifier Varies The resultant series identifier inherited from MATRIX_ID.
ROW_I BIGINT The row axis value. Only one row is returned, so the value is 1.
COLUMN_I BIGINT The column axis value. Only one row is returned, so the value is 1.
ROW_INDEX_DT VARCHAR(50) The data type associated with the two-dimensional array. Options are TIMESTAMP, TIMESTAMP WITH TIME ZONE, DATE, INTEGER, and FLOAT.
ROW_INDEX_BEGIN Varies The index value associated with the first row sample point of the matrix.
ROW_INDEX_END Varies The index value associated with the last row sample point of the matrix.
ROW_INDEX_NUM_ENTRIES FLOAT Total number of entries along the row index.

If the input matrix is malformed, then this is the average number of entries along the row index among all column index values.

ROW_INDEX_DISCRETE SMALLINT Indicator that the row index is regular (discrete) or irregular. A value of 1 indicates a regular row index. A value of 0 indicates an irregular row index.
ROW_INDEX_SAMPLE_INTERVAL VARCHAR(30) The row index sample interval. If row index is discrete, then this is the associated sampling interval size. If row index is irregular, then this is the calculated average of all encountered sampling intervals
COLUMN_INDEX_DT CHAR(40) The data type associated with the two-dimensional array. Options are TIMESTAMP, TIMESTAMP WITH TIME ZONE, DATE, INTEGER, and FLOAT.
COLUMN_INDEX_BEGIN Varies The index value associated with the first column sample point of the matrix.
COLUMN_INDEX_END Varies The index value associated with the last column sample point of the matrix.
COLUMN_INDEX_NUM_ENTRIES INTEGER Total number of entries along the column index.
COLUMN_INDEX_DISCRETE SMALLINT Indicator that the column index is regular (discrete) or irregular. A value of 1 indicates a regular column index. A value of 0 indicates an irregular column index.
COLUMN_INDEX_SAMPLE_INTERVAL VARCHAR(30) The column index sample interval. If column index is discrete, then this is the associated sampling interval size. If column index is irregular, then this is the calculated average of all encountered sampling intervals
CONTENT VARCHAR(20) Content type of the fields.
MIN_MAG_payload_field FLOAT The minimum encountered sample magnitude associated with the payload fields in the matrix.
MAX_MAG_payload_field FLOAT The maximum encountered sample magnitude associated with the payload fields in the matrix.
AVG_MAG_payload_field FLOAT The average of all sample magnitudes associated with the payload fields in the matrix.
RMS_MAG_payload_field FLOAT The computed root mean square (RMS) value of all sample magnitudes associated with the payload fields in the matrix.
HAS_NULL_NAN_INF VARCHAR(5) The indicator that the matrix has null, non-numbers (NAN) or infinite entries.
MAL_FORM_MATRIX VARCHAR(25) Output showing if matrix is malformed. If the matrix is missing or containing extra data that makes the axis indiscreet, then this field output is MAL_FORM. Otherwise, the field output is WELL_FORM.