Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-privileges.html
mysql>GRANT SELECT, INSERT, CREATE, DROP, ALTER, UPDATE ON output_schema.* TO 'user_name'@'%'; For more information, see Privileges Provided by MySQL and Default MySQL Privileges. What's Next Learn about the available LLMs, embedding Models, and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-json-functions.html
Table 5.7 JSON Functions Name Description -> Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT(). JSON_TABLE() Return data from a JSON expression as a relational table. What's Next Learn how to perform the following ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-change-propagation.html
As of MySQL 9.2.1, TRANSACTIONAL indicates that change propagation is enabled for the table. In previous versions of MySQL, RAPID_LOAD_POOL_TRANSACTIONAL indicates that change propagation is enabled for the table.
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-query-history.html
The rpd_query_stats table stores query compilation and execution statistics (the query history) for the last 1000 successfully executed queries. To view the MySQL HeatWave query history including query start time, end time, and wait time in the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-string-functions-operators.html
With the exception of the FORMAT() function, string functions and operators described in the following table are supported with variable-length encoded columns. FIELD() Index (position) of first argument in subsequent arguments FIND_IN_SET() Index ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-anomaly-detection-logs.html
The input table can only have the following columns: The column containing the logs. As of MySQL 9.4.1, at least one column must act as the primary key to establish the temporal order of logs. If the input table has additional columns to the ones ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-explanations-ml-explain-row.html
The column names must match the feature column names in the trained table. mysql> CALL sys.ML_EXPLAIN ('table_name', 'target_column_name', model_handle, [options]); The following example runs the shap explainer. mysql> CALL ... ML_EXPLAIN_ROW ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-explanations.html
Prediction explanations are generated by running ML_EXPLAIN_ROW or ML_EXPLAIN_TABLE on unlabeled data. You can train the following prediction explainers: The Permutation Importance prediction explainer, specified as permutation_importance, is the ...The data must have the same feature columns as the data used to train the ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-explain.html
To run ML_EXPLAIN_ROW and ML_EXPLAIN_TABLE with a different explainer, you must first run ML_EXPLAIN with the same explainer. Required ML_EXPLAIN Parameters Set the following required parameters: table_name: You must define the table that you ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-handles.html
If you do not specify a model handle name, a model handle is automatically generated that is based on the database name, input table name, the user name training the table, and a unique numerical identifier. The following example queries the model ... When ML_TRAIN trains a model, you have the option to specify a name for the model, which is the model ...