Related Documentation Download this Manual
PDF (US Ltr) - 1.7Mb
PDF (A4) - 1.7Mb

HeatWave User Guide  /  ...  /  Loading Models

3.13.3 Loading Models

A model must be loaded from the model catalog into HeatWave before running HeatWave AutoML routines other than ML_TRAIN. A model remains loaded and can be called repetitively by HeatWave AutoML routines until it is unloaded using the ML_MODEL_UNLOAD routine or until the HeatWave Cluster is restarted.

A model can only be loaded by the MySQL user that created the model. For more information, see Section 3.13.10, “Sharing Models”.

HeatWave can load multiple models but to avoid taking up too much space in memory, limit the number of loaded models to three.

For ML_MODEL_LOAD parameter descriptions, see Section 3.15.9, “ML_MODEL_LOAD”.

The following example loads a HeatWave AutoML model from the model catalog:

mysql> CALL sys.ML_MODEL_LOAD(@census_model, NULL);


  • @census_model is the session variable that contains the model handle.

  • NULL is specified in place of the user name of the model owner.

A fully qualified ML_MODEL_LOAD call that specifies the model handle and user name of the owner is as follows:

mysql> CALL sys.ML_MODEL_LOAD('heatwaveml_bench.census_train_user1_1636729526', user1);

To look up a model handle, see Section 3.13.8, “Model Handles”.

As of MySQL 8.1.0, the user parameter is ignored. It can be set to NULL.