Search Results
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. Support for delta lake tables is restricted to delta tables with features ...
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 ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-reload-mysql-tables.html
Before You Begin Complete the steps to load data using Auto Parallel Load or manually. As of MySQL 8.4.0, MySQL HeatWave lets you reload all tables using the HEATWAVE_RELOAD routine. Learn how to use the Machine Learning capabilities of MySQL ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-run-query.html
This topic describes how to use the EXPLAIN statement to analyze query execution and verify whether a query is offloaded to MySQL HeatWave for accelerated processing. To learn how to download the sample database, see AirportDB Analytics Quickstart.