7.00.02 - Input - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Release Date
September 2017
Content Type
Programming Reference
User Guide
Publication ID
B700-1022-700K
Language
English (United States)

The function uses the input table columns time_column and value_column for saxification. They correspond to the time_column and value_column in input for SAX2.

Input time series data must be correctly formatted; otherwise, function behavior is undefined. In a correctly formatted time series, time intervals are evenly spaced and all time intervals have numeric values.

To calculate missing values in a time series, use the function Interpolator. If the input table’s time column is text-based, create a new input table with an integer-based time column. For example, suppose that the table time_series_text_time has the text-based columns idval, timeval, valueval, and catval. This statement creates a table that the function accepts as input:

CREATE TABLE time_series_numeric_time AS SELECT
  idval,
  RANK() OVER (PARTITION BY idval ORDER BY timeval) AS timeval,
  valueval,
  catval
  FROM time_series_text_time;
UnsupervisedShapelet Input Table Schema
Column Name Data Type Description
id Any Time series identifier.
time_column BYTEINT, SMALLINT, INTEGER, BIGINT, NUMERIC, or DOUBLE PRECISION Contains the time axis of the data.
value_column BYTEINT, SMALLINT, INTEGER, BIGINT, NUMERIC, or DOUBLE PRECISION Contains time series data to be transformed.