7.1.11 ML_MODEL_UNLOAD

ML_MODEL_UNLOAD unloads a model from MySQL HeatWave AutoML.

Note

ML_MODEL_UNLOAD does not check whether the model specified is in the model catalog. If it is not, ML_MODEL_UNLOAD will succeed, but will not unload any model. Use ML_MODEL_ACTIVE to check which models are active and owned by the user.

ML_MODEL_UNLOAD Syntax

mysql> CALL sys.ML_MODEL_UNLOAD(model_handle);

To run ML_MODEL_UNLOAD, define the model_handle. To look up a model handle, see Query the Model Handle.

Syntax Examples

• An example that specifies the model handle.

  mysql> CALL sys.ML_MODEL_UNLOAD('ml_data.iris_train_user1_1636729526');

• An example that specifies a session variable containing the model handle.

  mysql> CALL sys.ML_MODEL_UNLOAD(@iris_model);