SELECT * FROM DTW (
ON timeseriesdata AS input_table
PARTITION BY timeseriesid
ORDER BY timestamp1 ON templatedata AS template_table DIMENSION
ORDER BY timestamp2 ON mappingdata AS mapping_table
PARTITION BY timeseriesid
InputColumns ('stockprice', 'timestamp1')
TemplateColumns ('indexprice', 'timestamp2')
TimeSeriesID ('timeseriesid')
TemplateID ('templateid')
) ORDER BY "timeseriesID";