1.1 - 8.10 - VARMAX Input - 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)
Table Description
InputTable The alias, InputTable, is required only if you specify the optional Orders table.
Orders [Optional] TimeSeriesOrders Output table. If omitted, you must specify the PDQ syntax element.

InputTable Schema

Column Data Type Description
timestamp_column Any [Column appears once for each specified timestamp_column.] Sequence (time points) of input value.

If time points do not have uniform intervals, run Interpolator (ML Engine) function on them before running VARMAX function on input table.

partition_column Any [Column appears once for each specified partition_column.] Column by which input data is partitioned.
target_column Any numeric SQL data type [Column appears once for each specified target_column.] Value of response variable.
exogenous_column Any numeric SQL data type [Column appears once for each specified exogenous_column.] Value of exogenous variable.
Each input time series must:
  • Be an ordered sequence in a partition with uniform time intervals
  • Fit into memory
  • Not include NULL or numeric values, except as noted in the description of the ResponseColumns syntax element