Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-defining-secondary-engine.html
Defining Secondary Engine For each table that you want to load into MySQL HeatWave Cluster, you must define the MySQL HeatWave query processing engine (RAPID) as the secondary engine for the table. Then, the MySQL HeatWave query processing engine ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-excluded-columns.html
These columns are typically not needed for analytic queries and are therefore omitted to optimize memory usage and performance. In MySQL HeatWave, you can explicitly exclude certain table columns from being loaded into the MySQL HeatWave Cluster, ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-index-creation.html
As of MySQL 9.5.0, MySQL HeatWave GenAI automatically creates vector indexes for frequenctly queried VECTOR columns in vector store and embedding tables using advanced index structures such as Hierarchical Navigable Small World (HNSW). Information ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-search.html
When you enter a query, MySQL HeatWave GenAI performs a vector-based similarity search to retrieve similar content from the vector store and embedding tables available in the DB system. This helps the LLM to produce more relevant and accurate ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-store-load.html
This section describes how to generate vector embeddings for files or folders stored in Object Storage, and load the embeddings into a vector store table. If not already done, create an Oracle Cloud Infrastructure (OCI) bucket for storing files ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-store-overview.html
MySQL HeatWave GenAI encodes your queries using the same embedding model that is used to encode the ingested data to create the vector store. This helps improves the document parsing quality by extracting complex structures like tables, and enhances ... This section describes the Vector Store functionality available in MySQL ...
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-all.html
MySQL HeatWave Lakehouse has the following limitations for all file formats. Unsupported Items MySQL HeatWave Lakehouse does not support the following: DML statements: INSERT UPDATE DELETE REPLACE The CREATE TABLESPACE statement. The following ...
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-rpd-nodes-table.html
The rpd_nodes read-only table provides information about MySQL HeatWave nodes. The table may not show the current status for a new node or newly configured node immediately. The rpd_nodes table is updated after the node has successfully joined the ...