Search



Search Results
Displaying 1121 to 1130 of 1136 total results
MySQL AI 9.5 :: 4.5.5 Generating Model Explanations
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-explainers.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. After the ML_TRAIN routine, use the ML_EXPLAIN routine to train model explainers for AutoML. By default, ...
MySQL AI 9.5 :: 4.5.6.1 Generating Prediction Explanations for a Row of Data
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-explanations-ml-explain-row.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. ML_EXPLAIN_ROW explains predictions for one or more rows of unlabeled data. The following example trains ...
MySQL AI 9.5 :: 4.5.6.2 Generating Prediction Explanations for a Table
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-explanations-ml-explain-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. ML_EXPLAIN_TABLE explains predictions for an entire table of unlabeled data. We recommend limiting the ...
MySQL AI 9.5 :: 4.9 AutoML Limitations
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-limitations.html
MySQL HeatWave AutoML does not support TEXT columns with NULL values. Text Handling Limitations AutoML only supports datasets in the English language. MySQL HeatWave AutoML does not support target columns (a column with ground truth values) with a ...
MySQL AI 9.5 :: 4.7.1.1 The Model Catalog Table
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-model-catalog-table.html
The MODEL_CATALOG table (ML_SCHEMA_user_name.MODEL_CATALOG) has the following columns: model_id A primary key, and a unique auto-incrementing numeric identifier for the model. The model handle is generated or set by the user when the ML_TRAIN ...
MySQL AI 9.5 :: 4.7.2 Work with Model Handles
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-model-handles.html
mysql> SELECT sys.ML_PREDICT_ROW(@row_input, 'census_classification_model', NULL); Defining Model Handle Before training a model, it is good practice to define your own model handle instead of automatically generating one. When ML_TRAIN trains a ...
MySQL AI 9.5 :: 4.2 Additional AutoML Requirements
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-prereqs.html
NaN (Not a Number) values are not recognized by MySQL and should be replaced by NULL. Before You Begin Model and Table Sizes The table used to train a model cannot exceed 10 GB, 100 million rows, or 1017 columns. Data Requirements Each dataset must ...
MySQL AI 9.5 :: 4.4 Supported Data Types for AutoML
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-supported-data-types.html
AutoML has the following limitations for text usage: The ML_PREDICT_TABLE ml_results column contains the prediction results and the data. What's Next Learn more about the following: Additional AutoML Requirements AutoML Privileges Learn how to ...
MySQL AI 9.5 :: 4.6.5.3 Training a Recommendation Model
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-training-a-recommendation-model.html
If the users or items column contains NULL values, the corresponding rows are dropped and are not be considered during training. After preparing the data for a recommendation model, you can train the model. Requirements for Recommendation Training ...
MySQL AI 9.5 :: 4.6.5.4 Generating Predictions for a Recommendation Model
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-ai-aml-using-a-recommendation-model.html
NULL values for any row in the users or items columns generates an error. To generate predictions, use the sample data from the testing_dataset dataset. Before You Begin Complete the following tasks: Prepare Data for a Recommendation Model Train a ...
Displaying 1121 to 1130 of 1136 total results