TD_SINFO Function Example | Teradata Vantage - TD_SINFO Example - Teradata Vantage

TD_SINFO Call

EXECUTE FUNCTION INTO VOLATILE ART(TSINFO_RESULTS)
TD_SINFO(
   SERIES_SPEC (
      TABLE_NAME(OCEAN_BUOYS),
      ROW_AXIS(TIMECODE(TD_TIMECODE)),
      SERIES_ID(Ocean_Name, BuoyID),
      PAYLOAD(FIELDS(JsonCol.Measure.Salinity),CONTENT(REAL))
   )
);

TD_SINFO Output

SELECT * FROM TSINFO_RESULTS;

BUOYID 33
ROW_I 0
INDEX_DT TIMESTAMP(6)
INDEX_BEGIN '2017-05-08 00:00:00'
INDEX_END '2017-05-20 13:10:00'
NUM_ENTRIES 500
DISCRETE 1
SAMPLE_INTERVAL MINUTES(15)
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
RMS_MAG_salinity 33.8
BUOYID 34
INDEX_DT REAL
INDEX_BEGIN 0
INDEX_END 100
NUM_ENTRIES 1000
DISCRETE 0
SAMPLE_INTERVAL 0.1
CONTENT REAL
MIN_MAG_temperature 22.2
MAX_MAG_temperature 39.6
AVG_MAG_temperature 24.2
MIN_MAG_salinity 30.8
MAX_MAG_salinity 43.2
AVG_MAG_salinity 33.1
RMS_MAG_salinity 33.0