The TD_SINFO function returns a result set with metadata about the series. There is one output row for each series. In addition, each input payload produces the output variables for MIN, MAX, AVG and RMS. The output 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 SERIES_SPEC or SERIES_ID. |
| ROW_I | BIGINT | The row axis value. Only one row is returned, so the value is 1. |
| INDEX_DT | VARCHAR(20) | The data type associated with the one-dimensional series. Options are TIMESTAMP, DATE, INTEGER, and FLOAT. |
| INDEX_BEGIN | Varies | The index value associated with the first sample point of the series. |
| INDEX_END | Varies | The index value associated with the last sample point of the series. |
| NUM_ENTRIES | INTEGER | Total number of entries in the series. |
| DISCRETE | SMALLINT | Indicator that the series is regular (discrete) or irregular. A value of 1 indicates a regular series. A value of 0 indicates an irregular series. |
| SAMPLE_INTERVAL | VARCHAR(30) | The sampling interval. If series is discrete, then this is the associated sampling interval size. If series is irregular, then this is the calculated average of all encountered sampling intervals. |
| CONTENT | VARCHAR(20) | The series content type. |
| MIN_MAG_payload_field | FLOAT | The minimum sample magnitude associated with the field. |
| MAX_MAG_payload_field | FLOAT | The maximum sample magnitude associated with the field. |
| AVG_MAG_payload_field | FLOAT | The average of all sample magnitudes associated with the field. |
| RMS_MAG_payload_field | FLOAT | The Root Mean Square (RMS) of all sample magnitudes associated with the field. |
| HAS_NULL_NAN_INF | VARCHAR(5) | The indicator that the series has null, non-numbers (NAN) or infinite entries. |