DTW.sql

--Syntax (version 1.0)

SELECT * FROM DTW(
  ON input_timeseries_table
  PARTITION BY partition_columns
  ORDER BY ordering_columns
  ON template_timiseries_table AS template_table
  DIMENSION
  ORDER BY ordering_columns
  ON mapping_table AS mapping_table
  PARTITION BY partition_columns
  INPUT_TABLE_VALUE_COLUMN_NAMES('value_column','timestamp_column')
  TEMPLATE_TABLE_VALUE_COLUMN_NAMES('value_column','timestamp_column')
  TIMESERIESID('timeseriesid_columns')
  TEMPLATEID('templateid_columns')
   [RADIUS('Integer')]
   [METRIC('distance_metric')]
   [WARPPATH('true'|'false')]
);