Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-create-table-select.html
This topic describes how to create a new table and insert data using a SELECT query. When the query is offloaded to MySQL HeatWave, it is processed faster, improving the overall performance of the operation. SELECT statement is not permitted when ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-debugging-queries.html
This topic describes how to debug queries that fail to offload to MySQL HeatWave for execution. To learn how to download the sample database, see AirportDB Analytics Quickstart. Setting Secondary Engine Definition By default, SELECT queries are ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-encoding-string-columns.html
This topic describes how to encode string columns to improve the performance of queries that access them. This topic contains the following sections: Before You Begin Supported Encoding Types Select the Encoding Type Define String Column Encoding ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-byo-embedding-tables.html
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 search. The ML_RAG and ML_RAG_TABLE routines let you specify the table column names to use as ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-generate-content.html
The following sections in this topic describe how to generate new text-based content using MySQL HeatWave GenAI: Before You Begin Generate Content Run Batch Queries What's Next Before You Begin Review the MySQL HeatWave GenAI requirements and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-generate-embeddings.html
This section describes how to generate vector embeddings using the ML_EMBED_ROW MySQL HeatWave GenAI routine. Vector embeddings are a numerical representation of the text that capture the semantics of the data and relationships to other data. You ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-nl-sql.html
As of MySQL 9.4.1, MySQL HeatWave GenAI lets you generate SQL queries from natural-language statements, making it easier for you to interact with your databases. This feature collects information on the schemas, tables, and columns that you have ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-supported-models.html
This topic provides the list of languages that MySQL HeatWave GenAI supports and the embedding models as well as large language models (LLMs) that are available in MySQL HeatWave. This topic contains the following sections: Before You Begin View ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-troubleshoot.html
Workaround: Ensure that you use the --sqlc flag when you connect to your database system: mysqlsh -uAdmin -pPassword -hPrivateIP --sqlc Replace the following: Admin: the admin name. This section describes some commonly encountered issues and errors ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-get-privileges.html
What's Next Learn more about connecting to the MySQL HeatWave DB System. By default, the DB System provides only one user account for the DB System administrator. To use the additional features of MySQL HeatWave Cluster for different purposes, you ...