1.1 - 8.10 - SAX Output - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Release Date
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)

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

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

For WindowType ('global'), the table has one row for each partition. For WindowType ('sliding'), the table has multiple rows for each partition.

Column Data Type Description
accumulate_column Any Column copied from InputTable.
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_saxcode CLOB SAX code for target_column for window.
target_column_mean DOUBLE PRECISION [Column appears only with OutputStats value of 'true', 'yes', 't', 'y', or '1'.] Mean value used to calculate SAX value for window.
target_column_stdev DOUBLE PRECISION [Column appears only with OutputStats value of 'true', 'yes', 't', 'y', or '1'.] Standard deviation value used to calculate SAX value for window.

Output Table Schema, OutputType ('bitmap')

The table has one row for each partition.

Column Data Type Description
accumulate_column Any Column copied from InputTable.
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_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 (ML Engine).

Column Data Type Description
accumulate_column Any Column copied from InputTable.
value_column VARCHAR Column name from InputTable.
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.
saxchar CHARACTER(1) Character value for window.