1.0 - 8.00 - SAX Output - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
Language
English (United States)

The output table format depends on the OutputType argument. For OutputType ('string') or OutputType ('bytes'), the format also depends on the WindowType argument.

Output Table Schema, OutputType ('string') or OutputType ('bytes')

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

Column Data Type Description
accumulate_column Any Column copied from input table.
time_column_start Numeric or time SQL data type Point on time axis where window starts.
time_column_end Numeric or time SQL data type Point on time axis where window ends.
target_column_n_saxcode CLOB SAX code for nth window.
target_column_n_mean DOUBLE PRECISION [Appears only with OutputStats value of 'true', 'yes', 't', 'y', or '1'.] Mean value used to calculate SAX value for nth window.
target_column_n_stdev DOUBLE PRECISION [Appears only with OutputStats value of 'true', 'yes', 't', 'y', or '1'.] Standard deviation value used to calculate SAX value for nth window.

Output Table Schema, OutputType ('bitmap')

The table has only one row. In the following column names, n varies from 1 to N.

Column Data Type Description
accumulate_column Any Column copied from input table.
time_columnstart Numeric or time SQL data type Contains point on time axis where window starts.
time_column_end Numeric or time SQL data type Contains point on time axis where window ends.
target_column_n_bitmap VARCHAR Contains bitmap value for nth window, a JSON string containing key-value pairs of form "xx":d, where "xx" is a SAX code and d is a value between 0.00 and 1.00.

Output Table Schema, OutputType ('characters')

The table has one row for each SAX symbol. You can input this output table to the function HMMUnsupervised.

Column Data Type Description
accumulate_column Any Column copied from input table.
key VARCHAR Column by which input table is partitioned.
time_column_start Numeric or time SQL data type Contains point on time axis where window starts.
time_columnend Numeric or time SQL data type Contains point on time axis where window ends.
saxchar_n CHARACTER(1) Contains character value for nth window.
target_column_n_mean DOUBLE PRECISION [Appears only with OutputStats value of 'true', 'yes', 't', 'y', or '1'.] Contains mean value used to calculate SAX value for nth window.
target_column_n_stdev DOUBLE PRECISION [Appears only with OutputStats value of 'true', 'yes', 't', 'y', or '1'.] Contains standard deviation value used to calculate SAX value for nth window.