Search Results
https://dev.mysql.com/doc/heatwave/en/heatwave-errors.html
Error number: 1142; Symbol: HW_ER_AUTOCOMMIT_TURNED_OFF Message: You cannot be offload queries to HeatWave secondary engine because autocommit is disabled. Description: HeatWave secondary storage engine execution is not supported, if autocommit ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-data-scanned.html
Features like Auto Zonemap and MySQL table partitions also impact the base relation data scanned by a query. MySQL HeatWave tracks the amount of base relation data scanned by all queries collectively and by individual queries. Base relation data ...
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-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-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.10, “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 ...