1.0 - 8.00 - TimeSeriesOrders Example 1: PartitionColumns - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Release Date
May 2019
Content Type
Programming Reference
Publication ID
B700-4003-098K
Language
English (United States)

SQL Call

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

Output

The specified partition column, id_partition, appears in the output table.

id_partition p d q include_drift include_mean
1 0 2 0 0 0
2 0 1 2 0 0