TD_MINFO Function Example | Teradata Vantage - TD_MINFO Example - Teradata Vantage

TD_MINFO Call

EXECUTE FUNCTION INTO VOLATILE ART(TMINFO_RESULTS)
TD_MINFO(
   MATRIX_SPEC (
      TABLE_NAME(OCEAN_BUOYS),
      ROW_AXIS(TIMECODE(TD_TIMECODE)),
      COLUMN_AXIS(SEQUENCE(SPACE)),
      MATRIX_ID(Ocean_Name, BuoyID),
      PAYLOAD(FIELDS(JsonCol.Measure.Salinity),CONTENT(REAL))
   )
);

TD_MINFO Output

SELECT * FROM TMINFO_RESULTS;

BUOYID 33
ROW_I 0
COLUMN_I 1
ROW_INDEX_DT TIMESTAMP(6)
ROW_INDEX_BEGIN '2017-05-08 00:00:00'
ROW_INDEX_END '2017-05-20 13:10:00'
ROW_INDEX_NUM_ENTRIES 5.00000000000000E 002
ROW_INDEX_DISCRETE 1
ROW_INDEX_SAMPLE_INTERVAL MINUTES(15)
COLUMN_INDEX_DT REAL
COLUMN_INDEX_BEGIN 0
COLUMN_INDEX_END 100
COLUMN_INDEX_NUM_ENTRIES 1000
COLUMN_INDEX_DISCRETE 0
COLUMN_INDEX_SAMPLE_INTERVAL 0.1
CONTENT REAL
MIN_MAG_temperature 22.9
MAX_MAG_temperature 39.5
AVG_MAG_temperature 24.6
MIN_MAG_salinity 30.1
MAX_MAG_salinity 43.6
AVG_MAG_salinity 33.9
TOTAL_NUM_OF_NULL_MAG 0
MAL_FORM_MATRIX MAL_FORM