3.9 Forecasting

3.9.1 Training a Forecasting Model

3.9.2 Using a Forecasting Model

To generate a forecast, run ML_TRAIN and specify a forecasting task as a JSON object. ML_PREDICT_TABLE can then predict the values for the selected column. Use ML_SCORE to score the model quality.

Create a timeseries forecast for a single column with a numeric data type. In forecasting terms, this is a univariate endogenous variable.

MySQL 8.0.32 adds support for multivariate endogenous forecasting models, and exogenous forecasting models.