7.00.02 - Input - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)
Last Update
2018-04-17

The DTW function requires three input tables:

Input Table Description
input_table Each row contains information for one time series.
template_table Each row contains information for one time series.
mapping_table Defines the mapping between input_table rows and template_table rows.

The columns by which input_table and mapping_table are partitioned must agree in number and data type. That is, each i_partition_column must have a corresponding m_partition_column with the same data type. However, corresponding partition columns can have different names.

The columns by which input_table and template_table are ordered must agree in number and data type. That is, each i_ordering_column must have a corresponding t_ordering_column with the same data type. However, corresponding ordering columns can have different names.

DTW input_table Schema
Column Name Data Type Description
timeseriesid INTEGER Unique identifier for a time series.
timestamp INTEGER, SMALLINT, BIGINT, NUMERIC, or DOUBLE PRECISION Timestamp for the time series.
value DOUBLE PRECISION Value for the timestamp.
DTW template_table Schema
Column Name Data Type Description
templateid INTEGER Unique identifier for a time series.
timestamp INTEGER, SMALLINT, BIGINT, NUMERIC, or DOUBLE PRECISION Timestamp for the time series.
value DOUBLE PRECISION Value for the timestamp.
DTW mapping_table Schema
Column Name Data Type Description
timeseriesid INTEGER Unique identifier for a time series in input_table.
templateid INTEGER Unique identifier for the time series in template_table that corresponds to the time series specified by timeseriesid.
In mapping_table, DTW supports a single ID column in the input_table and template_table.