Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-cast-functions-operators.html
What's Next Learn how to perform the following tasks: Run queries Modify tables Retrieve MySQL HeatWave Metadata Optimize workloads for OLAP and OLTP Monitor MySQL HeatWave processes . CAST() from and to all the MySQL HeatWave supported numeric, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-dynamic-query-offload.html
Before MySQL 9.0.0, MySQL HeatWave uses a query cost threshold to choose either INNODB or MySQL HeatWave as the execution engine for the query. As of MySQL 9.0.0, MySQL HeatWave uses dynamic query offload to choose the optimal execution engine for ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-store-overview.html
This helps improves the document parsing quality by extracting complex structures like tables, and enhances RAG as well as vector search queries. This section describes the Vector Store functionality available in MySQL HeatWave. About Vector Store ...
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 CUBE modifier in addition to the WITH ROLLUP modifier. (Available in MySQL HeatWave only.) A ROLLUP modifier as a preferred alternative to the WITH ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-data-recovery.html
In the event of a problem where query processing stops or the MySQL HeatWave Cluster stops, the external tables are recovered when the Cluster resumes and begins processing queries again using the MySQL HeatWave recovery process. See the following ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-result-par-redact.html
It also displays the latest query results from the query text from the performance_schema.rpd_query_stats table and retrieves all the MySQL statments currently being executed in all MySQL active connections on the network. The pre-authenticated ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-csv-json.html
These parameters are based on the dialect parameters required to create the external table. This topic shows the different ways to export query results as a CSV file with JSON syntax. INTO OUTFILE WITH PARAMETERS 'file_URI_JSON "file": begin-array ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-json.html
Tables created with json format must only have a single column that conforms to the JSON data type, see: The JSON Data Type. MySQL HeatWave Lakehouse has the following limitations for JSON files. As of MySQL 9.3.1, Lakehouse can load up to 4192192 ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-functions.html
The following JSON functions: JSON_TABLE() queries that include a LEFT JOIN clause require a primary key column specified for the base or intermediate table. As of MySQL 9.2.2, the maximum output width of the following functions is 65,332 bytes: ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-partitions.html
MySQL HeatWave cannot load partitions from a table that contains dictionary-encoded columns. Before MySQL 9.1.0, MySQL HeatWave does not support explicit partition selection. As of MySQL 9.1.0, MySQL HeatWave supports InnoDB partitions with the ...