TimeSeriesOrders Example 2: No PartitionColumns - Teradata Vantage

Input

• milk_timeseries, as in VARMAX Example 5: Orders Table with One Time Series

SQL Call

SELECT * FROM TimeSeriesOrders (   
  ON milk_timeseries AS "data" PARTITION BY 1 ORDER BY period ASC
  USING
  TimeColumns ('period')
  ResponseColumn ('milkpound')
) AS dt;

Output

No partition column appears in the output table.