Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-iris-quickstart.html
This quickstart illustrates an end-to-end example of creating and using a predictive machine learning model using MySQL HeatWave AutoML. It steps through preparing data, using the ML_TRAIN routine to train a model, and using ML_PREDICT_* and ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-metrics.html
The ML_TRAIN routine includes the optimization_metric option, and the ML_SCORE routine includes the metric option. Both of these options define a metric that must be compatible with the task type and the target data. precision_k: An Oracle ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-model-unload.html
As of MySQL 9.0.0, 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 ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-predictions-ml-predict-row.html
ML_PREDICT_ROW generates predictions for one or more rows of data specified in JSON format. The following example trains a dataset with the classification machine learning task. mysql> CALL sys.ML_TRAIN('census_data.census_train', 'revenue', ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-recommendation-model-types.html
You can create recommendation models based on either explicit or implicit feedback. See Recommendation Models to review models that support either implicit or explicit feedback. Recommendation Models with Explicit Feedback Recommendation models ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-regression-predictions.html
To generate predictions, use the sample data from the house_price_testing dataset. Even though the table has labels for the price target column, the column is not considered when generating predictions. This allows you to compare the predictions to ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-regression-train.html
After preparing the data for a regression model, you can train the model. Before You Begin Review and complete all the tasks to Prepare Data for a Regression Model. Train Model Train the model with the ML_TRAIN routine and use the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-topic-modeling-prediction.html
After training the model, you can run topic modeling on the trained text. To run topic modeling, use the sample data from the movies dataset. When the output table generates, you can review the generated word groups and expressions for the trained ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-topic-modeling-train.html
After preparing the data for topic modeling, you can train the model. Before You Begin Review and complete all the tasks to Prepare Data for Topic Modeling. Requirements for Topic Modeling Training Define the following required parameters for topic ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-using-a-forecasting-model.html
To generate predictions, use the sample data from the electricity_demand_test dataset. Even though the table has labels for the demand target column, the column is not considered when generating predictions. This allows you to compare the ...