SAX Example 1: Global 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,
    cast (income_saxcode AS VARBYTE(50)) AS income_saxcode,
    income_mean,
    income_stdev,
    cast (investment_saxcode AS VARBYTE(50)) AS investment_saxcode,
    investment_mean,
    investment_stdev
FROM SAX (
  ON finance_data3 AS "input" PARTITION BY id ORDER BY period
  USING
    TargetColumns ('expenditure','income','investment')
    TimeColumn ('period')
    WindowType ('global')
    OutputStats ('true')
    Accumulate ('id')
) AS dt ORDER BY 1;

Output