TD_SAX Output - Teradata Vantage

Database Unbounded Array Framework Time Series Functions

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-12-08
dita:mapPath
ncd1634149624743.ditamap
dita:ditavalPath
ruu1634160136230.ditaval
dita:id
ncd1634149624743

A primary result set containing the transformed time series.

Display the RETURNS TABLE with a SELECT statement.

RETURNS TABLE Schema
Name Data Type Description
derived_series_identifier VARCHAR The resultant series identifier inherited from the SERIES_ID.
ROW_I Varies Row identifier of the ordered result sets.
output_type_Payload Depends on OUTPUT parameter type Transformed value can be the following:
  • SAX_Code for STRING varchar(64000)
  • SAX_BITMAP for BITMAP varchar(64000)
  • SAX_SYMBOL for CHARACTER char(2)
  • CHARSET UNICODE

Need to use ‘POINTS_PER_SYMBOL’ to get the maximum SAX code based on the input data for the GLOBAL window. For SLIDING window, the maximum WINDOW_SIZE is 64000.

Mean_Payload FLOAT The mean value used to calculate the SAX value for the nth window.
Std_dev_Payload FLOAT The standard deviation value used to calculate the SAX value for the nth window.