1.0 - 8.00 - ARIMAPredict Example - 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)

Input

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

  • ModelTable: arimaex1_model
  • ResidualTable: arimaex1_residual

SQL Call

SELECT * FROM ARIMAPredict (
  ON arimaex1_model AS ModelTable PARTITION BY id_partition
  ON arimaex1_residual AS ResidualTable PARTITION BY id_partition ORDER BY period
  USING
  StepAhead (10)
  PartitionColumns ('id_partition')
 ) AS dt;

Output

id_partition stepahead predict
1 1 632.629551066825
1 2 635.765309354513
1 3 636.842359032732
1 4 637.21229698806
1 5 637.339360849236
1 6 637.383003910415
1 7 637.397994142661
1 8 637.403142889259
1 9 637.404911346952
1 10 637.405518765195
1 1 814.345681937634
2 2 819.493209938129
2 3 819.493209938129
2 4 819.493209938129
2 5 819.493209938129
2 6 819.493209938129
2 7 819.493209938129
2 8 819.493209938129
2 9 819.493209938129
2 10 819.493209938129