TD_DTW Output - Teradata Vantage

Database Unbounded Array Framework Time Series Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-12-08
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743

The TD_DTW function outputs a result series. This function only outputs a primary layer (ARTPRIMARY) no other auxiliary layers are produced by this function.

RETURNS TABLE Schema

The columns corresponding to the ARTPRIMARY layer are described in the table. The result series can be retrieved using a SELECT statement or a TD_EXTRACT_RESULTS statement with LAYER (ARTPRIMARY).

Name Data Type Description
derived-series-identifier VARCHAR The resultant series identifier inherited from the SERIES_ID.
ROW_I BIGINT An integer index used to indicate the generated warp path index.
WarpDistance FLOAT The calculated value of the warp distance at the current ROW_I. If no warp path is generated, then the value is the overall warp distance.
WarpX BIGINT This column is only generated if the WARPPATH option is either 1 or 3. It is the index value of the first specified series starting from 0.
WarpY BIGINT This column is only generated if the WARPPATH option is either 1 or 3. It is the index value of the second specified series starting from 0.
WarpX_I Same as series 1 row axis type This column is only generated if the WARPPATH option is either 2 or 3. It matches the first specified series input row axis type. Its value matches the first specified series row axis value at the path index.
WarpY_I Same as series 2 row axis type This column is only generated if the WARPPATH option is either 2 or 3. It matches the second specified input row axis type. Its value matches the second specified row axis value at the path index.