1.1 - 8.10 - ARIMAPredict Example - 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)

Input

Input tables are ARIMA Example: OrdersTable, PartitionColumns, No Seasonality output:

  • Model: arimaex1_model
  • ResidualTable: arimaex1_residual

SQL Call

SELECT * FROM ARIMAPredict (
  ON arimaex1_model AS Model PARTITION BY id_partition
  ON arimaex1_resid AS ResidualTable PARTITION BY id_partition ORDER BY period
  USING
  StepAhead (10)
  PartitionColumns ('id_partition')
 ) AS dt ORDER BY id_partition, stepahead;

Output

 id_partition stepahead predict           
 ------------ --------- ----------------- 
            1         1 632.6295188421049
            1         2 635.7652663835223
            1         3 636.8423124813031
            1         4 637.2122492448414
            1         5 637.3393127097191
            1         6  637.382955639263
            1         7 637.3979458278352
            1         8 637.4030945599616
            1         9 637.4048630128653
            1        10 637.4054704295256
            2         1  814.345648052931
            2         2 819.4931716185765
            2         3 819.4931716185765
            2         4 819.4931716185765
            2         5 819.4931716185765
            2         6 819.4931716185765
            2         7 819.4931716185765
            2         8 819.4931716185765
            2         9 819.4931716185765
            2        10 819.4931716185765

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