Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-anomaly-detection-model-types.html
When training the model, the target_column_name parameter must be set to NULL. The target_column_name parameter must specify a column whose only allowed values are 0 (normal), 1 (anomalous), and NULL (unlabeled). All rows are used to train the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-classification-generate-explanation.html
For the option to set the user name, you can set it to NULL. mysql> CALL sys.ML_MODEL_LOAD(@model, NULL); The following example uses the model handle. mysql> CALL sys.ML_MODEL_LOAD('classification_use_case', NULL); Use the ML_EXPLAIN_TABLE routine ... After training a classification model, you can query the default model explanation or query new model ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-score.html
mysql> CALL sys.ML_SCORE('census_data.census_train', 'revenue', 'census_data.census_train_admin_1745439945171', 'balanced_accuracy', @score, NULL); Query OK, 0 rows affected (3.0536 sec) mysql> SELECT @score; +--------------------+ | @score | ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-quality.html
mysql> CALL sys.ML_MODEL_LOAD(@census_model, NULL); For more information about training and loading models, see Train a Model and Load a Model. mysql> CALL sys.ML_SCORE(table_name, target_column_name, model_handle, metric, score, [options]); The ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-predictions-ml-predict-table.html
mysql> CALL sys.ML_MODEL_LOAD(@census_model, NULL); For more information about training and loading models, see Train a Model and Load a Model. mysql> CALL sys.ML_PREDICT_TABLE('census_data.census_train', @census_model, ... ML_PREDICT_TABLE ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prepare-data-split.html
If a target column is not required, you can set this parameter to NULL. If this is set to NULL, then the default value of false is selected. As of MySQL 9.4.1, you can automatically create training and testing datasets with the TRAIN_TEST_SPLIT ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-regression-explanations.html
For the option to set the user name, you can set it to NULL. mysql> CALL sys.ML_MODEL_LOAD(@model, NULL); The following example uses the model handle. mysql> CALL sys.ML_MODEL_LOAD('regression_use_case', NULL); Use the ML_EXPLAIN_TABLE routine to ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-using-a-recommendation-model-ratings-rankings.html
For the option to set the user name, you can set it to NULL. mysql> CALL sys.ML_MODEL_LOAD(@model, NULL); The following example uses the model handle. mysql> CALL sys.ML_MODEL_LOAD('recommendation_use_case', NULL); Make predictions for the test ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-using-a-recommendation-model-similar-items.html
For the option to set the user name, you can set it to NULL. mysql> CALL sys.ML_MODEL_LOAD(@model, NULL); The following example uses the model handle. mysql> CALL sys.ML_MODEL_LOAD('recommendation_use_case', NULL); Make predictions for the test ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-using-a-recommendation-model-similar-users.html
For the option to set the user name, you can set it to NULL. mysql> CALL sys.ML_MODEL_LOAD(@model, NULL); The following example uses the model handle. mysql> CALL sys.ML_MODEL_LOAD('recommendation_use_case', NULL); Make predictions for the test ...