Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-summarize-docs.html
As of MySQL 9.4.1, MySQL HeatWave GenAI lets you generate text summaries for unstructured files available in Object Storage. You need to first ingest these documents into vector store tables using Auto Parallel Load. The generated table contains ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-store-overview.html
This section describes the Vector Store functionality available in MySQL HeatWave. About Vector Store MySQL HeatWave vector store is a relational database that lets you load unstructured data to MySQL HeatWave Lakehouse. It automatically parses ...
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-json-functions.html
Table 5.7 JSON Functions Name Description -> Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT(). ->> Return value from JSON column after evaluating path and unquoting the result; equivalent to ...
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-limitations-json.html
MySQL HeatWave Lakehouse has the following limitations for JSON files. As of MySQL 9.3.1, Lakehouse can load up to 4192192 bytes (~4MB) of data per line, and ignores any lines with more than this limit. Note The JSON size is measured after ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations.html
The following limitations apply to Lakehouse. For MySQL HeatWave limitations, see Section 11.2.1, “MySQL HeatWave Limitations”. ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-loading-data-manually.html
After creating an external table manaully and specifying the files to load into the table, you specify the SECONDARY_UNLOAD clause in an ALTER TABLE statement to load the data from the files into the table. This topic contains the following ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations.html
This section lists functionality that is not supported by MySQL HeatWave. It is not an exhaustive list with respect to data types, functions, operators, and SQL modes. For data types, functions, operators, and SQL modes that are supported by MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-memory-usage.html
To view the memory usage for each MySQL HeatWave node: mysql> SELECT ID, MEMORY_USAGE, MEMORY_TOTAL, BASEREL_MEMORY_USAGE FROM performance_schema.rpd_nodes; +----+--------------+--------------+----------------------+ | ID | MEMORY_USAGE | ...