1.1 - 8.10 - TimeSeriesOrders Example: No PartitionColumns - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.1
8.10
Published
October 2019
Content Type
Programming Reference
Publication ID
B700-4003-079K
Language
English (United States)
Last Update
2019-12-31

Input

SQL Call

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

Output

No partition column appears in the output table.

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

Download a zip file of all examples and a SQL script file that creates their input tables from the attachment in the left sidebar.