ARIMAPredict Example - Teradata Vantage

Teradata® Vantage Machine Learning Engine Analytic Function Reference

Product
Teradata Vantage
Release Number
1.0
8.00
Published
May 2019
Language
English (United States)
Last Update
2019-11-22
dita:mapPath
blj1506016597986.ditamap
dita:ditavalPath
blj1506016597986.ditaval
dita:id
lmf1502735330121
Product Category
Teradata Vantage

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