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. |