AUTOREGRESSOR
Creates and trains an autoregression (AR) or vector autoregression (VAR) model, depending on the number of provided value columns:
 One value column: the function executes autoregression and returns a trained AR model. AR is a univariate autoregressive time series algorithm that predicts a variable's future values based on its preceding values. The user specifies the number of lagged timesteps taken into account during computation, and the model then predicts future values as a linear combination of the values at each lag.
 Multiple value columns: the function executes vector autoregression and returns a trained VAR model. VAR is a multivariate autoregressive time series algorithm that captures the relationship between multiple time series variables over time. Unlike AR, which only considers a single variable, VAR models incorporate feedback between different variables in the model, enabling the model to analyze how variables interact across lagged time steps. For example, with two variables—atmospheric pressure and rain accumulation—a VAR model could determine whether a drop in pressure tends to result in rain at a future date.
To make predictions with a VAR or AR model, use the PREDICT_AUTOREGRESSOR function.
Because the input data must be sorted by timestamp, this function is singlethreaded.
This is a metafunction. You must call metafunctions in a toplevel SELECT statement.
Behavior type
VolatileSyntax
AUTOREGRESSOR ('modelname', 'inputrelation', 'valuecolumns', 'timestampcolumn'
[ USING PARAMETERS param=value[,...] ] )
Arguments
modelname
 Identifies the model to create, where
modelname
conforms to conventions described in Identifiers. It must also be unique among all names of sequences, tables, projections, views, and models within the same schema. inputrelation
 The table or view containing
timestampcolumn
andvaluecolumns
.This algorithm expects a stationary time series as input; using a time series with a mean that shifts over time may lead to weaker results.
valuecolumns
 Commaseparated list of one or more NUMERIC input columns that contain the dependent variables or outcomes.
The number of value columns determines whether the function performs the autoregression (AR) or vector autoregression (VAR) algorithm. If only one input column is provided, the function executes autoregression. For multiple input columns, the function performs the VAR algorithm.
timestampcolumn
 Name of an INTEGER, FLOAT, or TIMESTAMP column in
inputrelation
that represents the timestamp variable. The timestep between consecutive entries must be consistent throughout thetimestampcolumn
.Tip
If yourtimestampcolumn
has varying timesteps, consider standardizing the step size with the TIME_SLICE function.
Parameters
p
 INTEGER in the range [1, 1999], the number of lags to consider in the computation. Larger values for
p
weaken the correlation.Note
The AUTOREGRESSOR and ARIMA models use different training techniques that produce distinct models when trained with matching parameter values on the same data. For example, if you train an autoregressor model using the same data andp
value as an ARIMA model trained withd
andq
parameters set to zero, those two models will not be identical.Default: 3
method
 One of the following algorithms for training the model:

'OLS' (Ordinary Least Squares)

'YuleWalker'
Default: 'OLS'

missing
 One of the following methods for handling missing values:

'drop': Missing values are ignored.

'error': Missing values raise an error.

'zero': Missing values are replaced with 0.

'linear_interpolation': Missing values are replaced by linearlyinterpolated values based on the nearest valid entries before and after the missing value. This means that in cases where the first or last values in a dataset are missing, they will simply be dropped. The VAR algorithm does not support linear interpolation.
The default method depends on the model type:
 AR: 'linear_interpolation'
 VAR: 'error'

regularization
 For the OLS training method only, one of the following regularization methods used when fitting the data:

None

'L2': Weight regularization term which penalizes the squared weight value
Default: None

lambda
 For the OLS training method only, FLOAT in the range [0, 100000], the regularization value, lambda.
Default: 1.0
compute_mse
 BOOLEAN, whether to calculate and output the mean squared error (MSE).
Default: False
subtract_mean
 BOOLEAN, whether the mean of each column in
valuecolumns
is subtracted from its column values before calculating the model coefficients. This parameter only applies ifmethod
is set to 'YuleWalker'. If set to False, the model saves the column means as zero.Default: False
Examples
The following example creates and trains an autoregression model using the YuleWalker training algorithm and a lag of 3:
=> SELECT AUTOREGRESSOR('AR_temperature_yw', 'temp_data', 'Temperature', 'time' USING PARAMETERS p=3, method='yulewalker');
AUTOREGRESSOR

Finished. 3650 elements accepted, 0 elements rejected.
(1 row)
The following example creates and trains a VAR model with a lag of 2:
=> SELECT AUTOREGRESSOR('VAR_temperature', 'temp_data_VAR', 'temp_location1, temp_location2', 'time' USING PARAMETERS p=2);
WARNING 0: Only the Yule Walker method is currently supported for Vector Autoregression, setting method to Yule Walker
AUTOREGRESSOR

Finished. 3650 elements accepted, 0 elements rejected.
(1 row)
See Autoregressive model example and VAR model example for extended examples that train and make predictions with AR and VAR models.