Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-generate-content.html
MySQL offers high performance, reliability, and scalability, making it a popular choice for developers worldwide.\n\n[DONE]", "error": null} *************************** 2. It's a rapidly evolving field with applications in various sectors including ... The following sections in this topic describe how to generate new text-based content using MySQL HeatWave GenAI: Before You Begin Generate Content Run Batch Queries What's Next Before You Begin Review the MySQL HeatWave GenAI requirements and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-create-table-auto-parallel-load-task.html
mysql> CALL sys.HEATWAVE_LOAD( '[{"db_name": "db_1", "tables": [{ "table_name": "table_1", "engine_attribute": { "file": [{"uri": "oci://bucket_1@tenant_1/data_file_1.csv"}] } }] }]', NULL); While you can specify all parameters in one command, it ...
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-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 ...