DTW (version 1.0) - Aster Analytics

Teradata Aster Analytics Foundation User Guide

Product
Aster Analytics
Release Number
6.21
Published
November 2016
Language
English (United States)
Last Update
2018-04-14
dita:mapPath
kiu1466024880662.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1021
lifecycle
previous
Product Category
Software
SELECT * FROM DTW (
  ON input_table  AS input_table
    PARTITION BY i_partition_column [,...] 
    ORDER BY i_ordering_column [,...] 
  ON template_table  AS template_table DIMENSION
    ORDER BY t_ordering_column [,...] 
  ON mapping_table  AS mapping_table
    PARTITION BY m_partition_column [,...] 
  InputColumns ('i_value', 'i_timestamp')
  TemplateColumns ('t_value', 't_timestamp')
  TimeseriesID ('timeseriesid' [,...])
  TemplateID ('templateid' [,...])
  [ Radius ('radius') ]
  [ DistMethod ('distance_metric') ]
  [ WarpPath ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'})]
);