Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-privileges.html
mysql> GRANT SELECT, INSERT, CREATE, DROP, ALTER, UPDATE ON output_schema.* TO 'user_name'@'%'; For more information, see Privileges Provided by MySQL and Default MySQL Privileges. What's Next Learn about the available LLMs, embedding Models, and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-troubleshoot.html
This section describes some commonly encountered issues and errors for MySQL HeatWave GenAI and their workarounds. The folder you are trying to load might contain unsupported format files or the file that you are trying to load might be of an ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-vector-store.html
Using the inbuilt vector store and retrieval-augmented generation (RAG), you can load and query unstructured documents stored in Object Storage using natural language within the MySQL HeatWave ecosystem. The sections in this topic describe how to ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-group-by-modifiers.html
In the MySQL HeatWave secondary engine, the GROUP BY clause permits the following modifiers: A CUBE modifier in addition to the WITH ROLLUP modifier. (Available in MySQL HeatWave only.) A ROLLUP modifier as a preferred alternative to the WITH ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-json-functions.html
What's Next Learn how to perform the following tasks: Run queries Modify tables Retrieve MySQL HeatWave Metadata Optimize workloads for OLAP and OLTP Monitor MySQL HeatWave processes . Table 5.7 JSON Functions Name Description -> Return value from ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-load-event-based.html
As of MySQL 9.4.1, you can load data from Object Storage by using event-based incremental load. Once an event for an external file location is emitted due to a change to an object, Lakehouse automatically refreshes the data into the external table.
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-data-types.html
You cannot run queries for materialized views that project ENUM type columns. The following string and text data types are unsupported: BINARY VARBINARY Decimal values with a precision greater than 18 in expression operators are unsupported, with ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-variables.html
time_zone and timestamp variable settings are not passed to MySQL HeatWave when queries are offloaded.
https://dev.mysql.com/doc/heatwave/en/mys-hw-loading-data-manually.html
Perform the following steps sequentially for each table that you want to load: Exclude table columns with unsupported data types or columns not used in queries Define a secondary engine on the table. You can manually load data from InnoDB tables in ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-loading-data.html
Concurrent DML operations and queries on the MySQL node are supported while a data load operation is in progress; however, concurrent operations on the MySQL node can affect load performance and vice versa. MySQL HeatWave provides the following ...