Input - 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

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.