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) ) 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.