7.00.02 - Output - 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 output table format depends on the values of the Output and WindowType arguments.

For 'string' or 'bytes' output, the output table has only one row for a 'global' window, but multiple rows for a 'sliding' window. The following table describes the output table columns. In the column names, n varies from 1 to N.

SAX2 'string' or 'bytes' Output Table Schema
Column Name Data Type Description
accumulate_column Any A column to be included in the output table, specified with the Accumulate argument.
time_column_start Numeric or time SQL data type The point on the time axis where the window starts.
time_column_end Numeric or time SQL data type The point on the time axis where the window ends.
value_column_n_saxcode VARCHAR for 'string', BYTE for 'bytes' The SAX code for the nth window; a string for 'string', a byte array for 'bytes'.
value_column_n_mean DOUBLE PRECISION The mean value used to calculate the SAX value for the nth window. This column appears only if the value of the PrintCodeStats argument is 'true', 'yes', 't', 'y', or '1'.
value_column_n_stdev DOUBLE PRECISION The standard deviation value used to calculate the SAX value for the nth window. This column appears only if the value of the PrintCodeStats argument is 'true', 'yes', 't', 'y', or '1'.

For 'bitmap' output, the output table has only one row, whose columns are described in the following table. In column names, n varies from 1 to N.

SAX2 'bitmap' Output Table Schema
Column Name Data Type Description
accumulate_column Any A column to be included in the output table, specified with the Accumulate argument.
time_columnstart Numeric or time SQL data type The point on the time axis where the window starts.
time_column_end Numeric or time SQL data type The point on the time axis where the window ends.
value_column_n_bitmap VARCHAR The bitmap value for the nth window; a JSON string containing key-value pairs of the form "xx":d, where "xx" is a SAX code and d is a value between 0.00 and 1.00.

For 'characters' output, each SAX symbol has its own row in the output table. You can input this output table to the function HMMUnsupervisedLearner.

SAX2 'characters' Output Table Schema
Column Name Data Type Description
accumulate_column Any A column to be included in the output table, specified with the Accumulate argument.
key VARCHAR The column on which the input table is partitioned.
time_column_start Numeric or time SQL data type The point on the time axis where the window starts.
time_columnend Numeric or time SQL data type The point on the time axis where the window ends.
saxchar_n CHAR(1) The character value for the nth window.
value_column_n_mean DOUBLE PRECISION The mean value used to calculate the SAX value for the nth window. This column appears only if the value of the PrintCodeStats argument is 'true', 'yes', 't', 'y', or '1'.
value_column_n_stdev DOUBLE PRECISION The standard deviation value used to calculate the SAX value for the nth window. This column appears only if the value of the PrintCodeStats argument is 'true', 'yes', 't', 'y', or '1'.