Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-viewing.html
To view the details for the models in your model catalog, query the MODEL_CATALOG table. Before You Begin Review the following: Create a Machine Learning Model The Model Catalog View Details for Your Models The following example queries model_id, ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-predictions-ml-predict-row.html
mysql> SELECT sys.ML_PREDICT_ROW(@variable, ...), model_handle, options); Replace variable, model_handle, and options with your own values. ML_PREDICT_ROW generates predictions for one or more rows of data specified in JSON format. The following ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-predictions-ml-predict-table.html
mysql> SELECT * FROM table_name LIMIT N; Replace table_name with your own table name, and N with the number of rows from the table you want to view. ML_PREDICT_TABLE generates predictions for an entire table of trained data. Depending on your MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-prepare-data-split.html
mysql> CALL sys.TRAIN_TEST_SPLIT('table_name', 'target_column_name', options); Replace table_name, target_column_name, and options with your own values. As of MySQL 9.4.1, you can automatically create training and testing datasets with the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-regression-explanations.html
mysql> CALL sys.ML_EXPLAIN_TABLE(table_name, model_handle, output_table_name, [options]); Replace table_name, model_handle, and output_table_name with your own values. After training a regression model, you can query the default model explanation ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-regression-predictions.html
mysql> CALL sys.ML_PREDICT_TABLE(table_name, model_handle, output_table_name), [options]); Replace table_name, model_handle, and output_table_name with your own values. To generate predictions, use the sample data from the house_price_testing ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-scoring-a-forecasting-model.html
mysql> CALL sys.ML_SCORE(table_name, target_column_name, model_handle, metric, score, [options]); Replace table_name, target_column_name, model_handle, metric, score with your own values. After generating predictions, you can score the model to ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-scoring-a-recommendation-model.html
mysql> CALL sys.ML_SCORE(table_name, target_column_name, model_handle, metric, score, [options]); Replace table_name, target_column_name, model_handle, metric, score with your own values. After generating predicted ratings/rankings and ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-topic-modeling-prediction.html
mysql> CALL sys.ML_PREDICT_TABLE(table_name, model_handle, output_table_name), [options]); Replace table_name, model_handle, and output_table_name with your own values. After training the model, you can run topic modeling on the trained text. To ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-using-a-forecasting-model.html
mysql> CALL sys.ML_PREDICT_TABLE(table_name, model_handle, output_table_name), [options]); Replace table_name, model_handle, and output_table_name with your own values. To generate predictions, use the sample data from the electricity_demand_test ...