Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-debugging-queries.html
For MySQL HeatWave on AWS, see Estimating Cluster Size with MySQL HeatWave Autopilot in the MySQL HeatWave on AWS Service Guide. After running queries, consider using MySQL HeatWave Autopilot Advisor for encoding and data placement recommendations.
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-byo-embedding-tables.html
It uses techniques such as algorithm selection, hyperparameter tuning, and model ensembling to automatically generate high-performing models with minimal human intervention. It involves using algorithms and techniques to automatically identify the ... As of MySQL 9.2.1, MySQL HeatWave GenAI lets you use tables containing your own vector embedding to run retrieval-augemented generation (RAG) with vector ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-run-chat.html
When you run MySQL HeatWave Chat, it automatically loads the default LLM. By default, MySQL HeatWave Chat searches for an answer to a query across all ingested documents by automatically discovering available vector stores, and returns the answer ...You can limit the scope of search to specific document collections available in certain vector stores or specify documents to include in the ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-troubleshoot.html
If you are still not able to ingest files using VECTOR_STORE_LOAD routine, then try Ingest Files Using Auto Parallel Load. This section describes some commonly encountered issues and errors for MySQL HeatWave GenAI and their workarounds. The folder ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-create-table-manually-task.html
If you choose not to Create an External Table Using Lakehouse Auto Parallel Load, you can create the table manually. As of MySQL 9.2.0, MySQL HeatWave Lakehouse can automatically detect these values. Where: The CREATE EXTERNAL TABLE statement ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-result-outputfile.html
The names for the output files are auto-generated and based on the following format: file_prefix/universal unique number/nnode_ID-tthread_ID-cChunk_ID.compression.file_format File Name Parameters File_prefix: The user-provided prefix for the file ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-delta.html
When loading tables with Auto Parallel Load, these columns are inferred as NOT SECONDARY. MySQL HeatWave Lakehouse has the following limitations for delta lake tables. Loading delta lake tables is only supported in MySQL HeatWave on OCI. Support ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-partitions.html
As of MySQL 9.1.0, MySQL HeatWave supports InnoDB partitions with the following limitations: MySQL HeatWave cannot load partitions with Auto Parallel Load. Before MySQL 9.1.0, MySQL HeatWave does not support explicit partition selection. MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-query-history.html
To view the MySQL HeatWave query history including query start time, end time, and wait time in the scheduling queue, as discussed in Section 5.4.11, “Auto Scheduling”. CONNECTION_ID The connection ID of the client that issued the query.
https://dev.mysql.com/doc/heatwave/en/mys-hw-metadata-queries-secondary-engine.html
To identify tables in the DB System that are defined with a secondary engine, query the CREATE_OPTIONS column in the INFORMATION_SCHEMA.TABLES table. If the CREATE_OPTIONS column contains both SECONDARY_ENGINE=RAPID and SECONDARY_LOAD=1, the table ...