1.1 - 8.10 - TimeSeriesOrders Syntax - Teradata Vantage

Teradata Vantage™ - Machine Learning Engine Analytic Function Reference

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

Version 1.3

SELECT * FROM TimeSeriesOrders (   
  ON { table | view | (query) } AS InputTable
    PARTITION BY { 1 | partition_column [,...] } ORDER BY time_column ASC [,...]
  USING      
  ResponseColumn ('response_column')
  [ PartitionColumns ('partition_column' [,...]) ]
  TimeColumns ('time_column' [,...])
) AS alias;

In the ORDER BY clause, put ASC after each time_column.