ARIMA Example 1: OrdersTable, PartitionColumns, No Seasonality - Teradata Vantage

Input

The input table, milk_3, is partitioned into two time series.

SQL Call

SELECT * FROM ARIMA (
  ON milk_3 AS InputTable PARTITION BY id_partition
  ON arimaex1_orders AS OrdersTable PARTITION BY id_partition
  OUT TABLE ModelTable (arimaex1_model) 
  OUT TABLE ResidualTable (arimaex1_resid)
  USING
  TimeColumns ('period')
  TargetColumn ('milkpound')
  PartitionColumns ('id_partition')
) AS dt;

Output