SAX Example 2: Sliding Window, Default Output - Teradata Vantage

Input

• input: financial_data3, as in VARMAX Example 1: No Exogenous Model

SQL Call

SELECT
    id,
    period_start,
    period_end,
    cast (expenditure_saxcode AS VARBYTE(50)) AS expenditure_saxcode,
    expenditure_mean,
    expenditure_stdev
FROM SAX (
  ON finance_data3 AS "input" PARTITION BY id ORDER BY period
  USING
    TargetColumns ('expenditure')
    TimeColumn ('period')
    WindowType ('sliding')
    WindowSize (20)
    OutputStats ('true')
    Accumulate ('id')
) AS dt ORDER BY 1;

Output