TD_TRACKINGOP Function Examples | Teradata Vantage - TD_TRACKINGOP Examples - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

TD_TRACKINGOP Input Table myTrack

SeqNo TrainID Schedule_Date Source Next_Station Destination GeoTag ArrivalTime DepartureTime
1 210 2022-03-26 Wilmington Claymont Norristown POINT (-75.5536 39.7374) 2022-03-26 10:41:02 2022-03-26 10:4:01
2 210 2022-03-26 Wilmington Marcus Hook Norristown POINT (-75.45059 39.79994) 2022-03-26 10:46:06 2022-03-26 10:47:01
3 210 2022-03-26 Wilmington Highland Ave Norristown POINT (-75.4199 39.82172) 2022-03-26 10:52:05 2022-03-26 10:53:45
... ... ... ... ... ... ... ... ...
25 210 2022-03-26 Wilmington Norristown TC Norristown POINT (-75.30747 40.07137) 2022-03-26 12:28:06 2022-03-26 12:29:01
26 210 2022-03-26 Wilmington Main St Norristown POINT (-75.34562 40.11321) 2022-03-26 12:33:05 2022-03-26 12:34:11
27 210 2022-03-26 Wilmington Elm St Norristown POINT (-75.34864 40.11735) 2022-03-26 12:36:06 2022-03-26 12:37:45

Example: TD_TRACKINGOP Call for Kilometers

EXECUTE FUNCTION INTO VOLATILE ART(myTrack)
TD_TRACKINGOP( 
   SERIES_SPEC( TABLE_NAME(TrainTracking),ROW_AXIS(TIMECODE(ArrivalTime)),
      SERIES_ID(train_id, schedule_date), 
      PAYLOAD (FIELDS(ArrivalTime, DepartureTime, geoTag),
      CONTENT(MULTIVAR_ANYTYPE)) ),
   FUNC_PARAMS(DISTANCE(1), SPEED(1), TIME_SPENT(1), METRIC(1))
);

TD_TRACKINGOP Output in Kilometers

SELECT * FROM myTrack;
train_id 210
schedule_date 16/03/21
ROW_I 0
TRACK_DISTANCE 6.96537534248852E 001
TRACK_PATH LINESTRING (-75.5536 39.7374,-75.4506 39.7999,-75.4199 39.8217,-75.3932 39.8337,-75.3616 39.8489,-75.3317 39.8712,-75.3231
39.88,-75.3124 39.8865,-75.3036 39.8906,-75.29 39.8962,-75.2779 39.9014,-75.271 39.9043,-75.2664 39.9071,-75.2553 39.9127,-75.1912 39.9471,-
75.1837 39.9569,-75.1678 39.9539,-75.1536 39.9555,-75.1499 39.9806,-75.155 39.9934,-75.1933 40.0115,-7
MIN_SPEED 1.28285792249215E 001
AVG_SPEED 5.92746479561341E 001
MAX_SPEED 2.18532040984786E 002
RUN_TIME 7.72333333333333E 001
TRIP_TIME 1.16716666666667E 002

Example: TD_TRACKINGOP Call for Miles

EXECUTE FUNCTION INTO VOLATILE ART(myTrack)
TD_TrackingOp( 
   SERIES_SPEC( TABLE_NAME(TrainTracking),ROW_AXIS(TIMECODE(ArrivalTime)),
      SERIES_ID(train_id, schedule_date),
      PAYLOAD (FIELDS(ArrivalTime, DepartureTime, geoTag),
      CONTENT(MULTIVAR_ANYTYPE)) ),
   FUNC_PARAMS(DISTANCE(1), SPEED(1), TIME_SPENT(1), METRIC(0))
);

TD_TRACKINGOP Output in Miles

SELECT * FROM myTrack;
train_id 210
schedule_date 16/03/21
ROW_I 0
TRACK_DISTANCE 4.32807527656209E 001
TRACK_PATH LINESTRING (-75.5536 39.7374,-75.4506 39.7999,-75.4199 39.8217,-75.3932 39.8337,-75.3616 39.8489,-75.3317 39.8712,-75.3231
39.88,-75.3124 39.8865,-75.3036 39.8906,-75.29 39.8962,-75.2779 39.9014,-75.271 39.9043,-75.2664 39.9071,-75.2553 39.9127,-75.1912 39.9471,-
75.1837 39.9569,-75.1678 39.9539,-75.1536 39.9555,-75.1499 39.9806,-75.155 39.9934,-75.1933 40.0115,-7
MIN_SPEED 7.97129427298945E 000
AVG_SPEED 3.68314880005031E 001
MAX_SPEED 1.35789254306717E 002
RUN_TIME 7.72333333333333E 001
TRIP_TIME 1.16716666666667E 002