Table | Description |
---|---|
input_table | Contains information for one or more time series. |
template_table | Defines correspondence between input_table and template_table rows. Columns by which these tables are ordered must agree in number and data type. That is, each i_order_column must have a corresponding t_order_column with the same data type. However, corresponding order columns can have different names. |
mapping_table | Defines correspondence between input_table and mapping_table rows. Columns by which these 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. |
input_table Schema
Each row contains information for one time series.
Column | Data Type | Description |
---|---|---|
timeseriesid | INTEGER | Time series identifier. |
timestamp | INTEGER, SMALLINT, BIGINT, NUMERIC, or DOUBLE PRECISION | Timestamp. |
value | DOUBLE PRECISION | Value. |
template_table Schema
Each row contains information for one time series.
Column | Data Type | Description |
---|---|---|
templateid | INTEGER | Time series identifier. |
timestamp | INTEGER, SMALLINT, BIGINT, NUMERIC, or DOUBLE PRECISION | Identifier of time series in input_table that corresponds to time series specified by timeseriesid in this table. |
value | DOUBLE PRECISION | Value. |
mapping_table Schema
Column | Data Type | Description |
---|---|---|
timeseriesid | INTEGER | Time series identifier. |
templateid | INTEGER | Identifier of time series in input_table that corresponds to time series specified by timeseriesid in this table. |
In mapping_table, DTW supports a single ID column in the input_table and template_table.