Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-error-handling.html
See MySQL 9.5 Error Message Reference for Lakehouse error messages. As of MySQL 9.2.2, a detailed summary of warnings is available when loading data to Lakehouse. This includes warnings related to the schema inference stage of loading data. The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-csv.html
For example, if col_1 in table_1 is a VECTOR column that you want to convert to JSON, you can do the following: SELECT CAST(VECTOR_TO_STRING(col_1) as JSON) FROM table_1; To convert JSON to VECTOR, first convert JSON to a STRING data type, and then ... MySQL HeatWave Lakehouse has the following limitations for CSV ...
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-secondary-load-partitions.html
As of MySQL 9.1.0, MySQL HeatWave supports partitions for DB System tables. Loading Partitions using Secxondary _Load Clause To load partitions into MySQL HeatWave, specify the SECONDARY_LOAD clause in an ALTER TABLE statement with the PARTITION ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-using-views.html
mysql> CREATE VIEW airport_US AS SELECT airport.* FROM airport JOIN airport_geo ON airport.airport_id = airport_geo.airport_id WHERE airport_geo.country = 'UNITED STATES'; To determine if a query run on a view can be offloaded to MySQL HeatWave for ... This topic describes how to run queries on views using MySQL HeatWave and verify if those queries are offloaded to the MySQL HeatWave secondary engine for accelerated ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-anomaly-detection-logs.html
You have the option to select the keyword model and any embedding model supported by MySQL HeatWave with the training options keyword_model and embedding_model. To review supported embedding models, run the following query: SELECT ... MySQL 9.2.2 ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-classification-generate-prediction.html
If needed, you can also query all the columns from the table (SELECT * FROM classification_predictions) to review all the data at once. To generate predictions, use the sample data from the testing_data dataset. Even though the table has labels for ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-classification-score.html
mysql> SELECT @classification_score; +-----------------------+ | @classification_score | +-----------------------+ | 0.800000011920929 | +-----------------------+ 1 row in set (0.0431 sec) If done working with the model, unload it with the ... After ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-error-messages.html
Grant user with correct privileges (SELECT, DROP, CREATE, INSERT, ALTER) on input schema. Grant user with correct privileges (SELECT, DROP, CREATE, INSERT, ALTER) on input schema. Each error message includes an error number, SQLSTATE value, and ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-forecasting-model-types.html
Selecting Forecasting Models To specify which models that are considered for training, use the model_list option and enter the appropriate model names. If the model_list option is not set, then ML_TRAIN considers all supported models during the ...