TD_SAX Output - Teradata Vantage

Database Unbounded Array Framework Time Series Functions

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2025-04-04
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.