Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-aggregate-functions.html
Table 5.1 Aggregate (GROUP BY) Functions Name VARLEN Support Description AVG() Return the average value of the argument COUNT() Yes Return a count of the number of rows returned COUNT(DISTINCT) Return the count of a number of different values ...The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-dictionary-encoding.html
Dictionary encoding (SORTED) has the following characteristics: Best suited to string columns with a low number of distinct values relative to the cardinality of the table. Load operations for tables with dictionary-encoded string columns that have ...Dictionary encoding reduces the space required for column values on the MySQL HeatWave nodes but requires space on the DB System node for ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-chat-details.html
View Details To view the chat session details, inspect the @chat_options variable: mysql>SELECT JSON_PRETTY(@chat_options); The output includes the following details about a chat session: Vector store tables: in the database which were referenced by ... This topic describes how to view a chat session ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results.html
As of MySQL 9.1.1-u1, you can export your query results on DB System tables and external Lakehouse tables to Object Storage. This feature is available for MySQL HeatWave on OCI and MySQL HeatWave on AWS. The capability to convert the output into ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-joins.html
The plan evaluation count is reset to zero after each derived table, after an outer query, and after each subquery. Outer join queries without an equality condition defined for the two tables. Antijoins, with the exception of supported IN and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-workload-optimization-olap.html
Unload Advisor Recommends tables to unload, reducing MySQL HeatWave memory usage. The recommendations are based upon when the tables were last queried. Workload optimization for online analytical processing, OLAP, includes using dictionary encoding ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-automl-workflow.html
The data can originate from either DB System tables or external Lakehouse tables. A typical MySQL HeatWave AutoML workflow is described below: When you run the ML_TRAIN routine, MySQL HeatWave AutoML retrieves the data to use for training. The ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-classification-train.html
Train Model Train the model with the ML_TRAIN routine and use the training_data table previously created. mysql> CALL sys.ML_TRAIN('table_name', 'target_column_name', JSON_OBJECT('task', 'task_name'), model_handle); Replace table_name, ... After ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-quality.html
After training and loading the model, prepare a table of labeled data to score that has a different set of data from the trained model. mysql> CALL sys.ML_SCORE(table_name, target_column_name, model_handle, metric, score, [options]); The following ... ML_SCORE scores a model by generating predictions using the feature columns in a labeled dataset as input and comparing the predictions to ground truth values in the target column of the labeled ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-regression-train.html
Train Model Train the model with the ML_TRAIN routine and use the house_price_training table previously created. mysql> CALL sys.ML_TRAIN('table_name', 'target_column_name', JSON_OBJECT('task', 'task_name'), @variable); Replace table_name, ... After ...