Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-group-by-modifiers.html
In the MySQL HeatWave secondary engine, the GROUP BY clause permits the following modifiers: A ROLLUP modifier. ROLLUP and CUBE Modifiers The ROLLUP modifier generates aggregated results that follow the hierarchy for the selected columns. The CUBE ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-insert-select.html
Setting use_secondary_engine=FORCED does not cause the statement to fail with an error. If you set use_secondary_engine=FORCED, the operation fails and generates an offload error. This topic describes how to run a SELECT query and insert the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-create-table-manually-metadata.html
Specifying an invalid data type for a metadata column generates an error if STRICT_LOAD or is_strict_mode is enabled, or a warning message if STRICT_LOAD or is_strict_mode is disabled. Specifying a generated column as a metadata column generates an ... As of MySQL 9.6.1, MySQL HeatWave Lakehouse supports the _metadata_filename column, which is a reserved column name that stores file name information for each row of ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-query-prerequisites.html
If MySQL HeatWave execution is not possible for a query due to unsupported syntax or any other reason as mentioned in Diagnose Query Offload, the query is executed by the "DB System", and no errors are generated. If the query is not supported by ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-run-query.html
To determine why a query is not offload, refer to Diagnose Query Offload Errors or MySQL HeatWave Issues to diagnose and resolve the offloading error. This topic describes how to use the EXPLAIN statement to analyze query execution and verify ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-lakehouse.html
| | | | Warning: Executing the generated script may alter column definitions and secondary engine flags in the schema | | | | Using SQL_MODE: ... If you have external data that you want to use with MySQL HeatWave AutoML, you can load it directly ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-nl-sql.html
The routine automatically detects these errors, and retries the SQL generation until a syntactically valid SQL statement is generated, with a maximum of 3 generation attempts. The routine also runs the generated SQL statement and displays the result ...
https://dev.mysql.com/doc/heatwave/en/mys-hwgenai-vector-store-load.html
If set to false, disables truncation and instead throw an error when a text segment that is too large for the embeeding model is found. In this case, the entire load fails and exits with an error. The VECTOR_STORE_LOAD routine generates vector ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-31.html
If an error occurs during training or you cancel the training operation, MySQL HeatWave AutoML records the error status in this column. MySQL HeatWave AutoML Functionality Added or Changed MySQL HeatWave AutoML MySQL HeatWave AutoML queries are now ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-9-2-2.html
You must reload tables in this state by running SECONDARY_UNLOAD followed by SECONDARY_LOAD, which lets you identify errors and take corrective action. Note These release notes were created with the assistance of MySQL HeatWave GenAI. Important ...