Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-unload-syntax.html
This adds an include list to exactly specify the tables to unload, which eliminates the need to include a database and exclude unnecessary tables. mysql> CALL sys.HEATWAVE_UNLOAD_all ([options]); options: { JSON_OBJECT("key","value"[,"key","value"] ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-quickstart.html
Start a Chat Session Clear the previous chat history and states: mysql> SET @chat_options=NULL; Ask your question using MySQL HeatWave Chat: mysql> CALL sys.HEATWAVE_CHAT("What is HeatWave AutoML?"); The HEATWAVE_CHAT routine automatically loads the ... This quickstart shows how to set up a GenAI-powered Help Chat that uses the information available in MySQL HeatWave User Guide to provide answers to MySQL HeatWave-related ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-run-chat.html
Run the Chat To run MySQL HeatWave Chat, perform the following steps: To delete previous chat output and state, if any, reset the @chat_options variable: mysql> SET @chat_options=NULL; Note Ensure that you use the name @chat_options for the variable. When you run MySQL HeatWave Chat, it automatically loads the default ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-summarize-docs.html
The document concludes by inviting readers to try MySQL HeatWave on AWS for free.", "error": null} *************************** 2. As of MySQL 9.4.1, MySQL HeatWave GenAI lets you generate text summaries for unstructured files available in Object ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-result-par-redact.html
The pre-authenticated request (PAR) URL is hidden in the log file for security reasons. The following example exports the query results as a CSV file to the object storge location represented as a PAR URL. It also displays the latest query results ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-limitations-avro.html
Lakehouse only supports an Avro union between one supported data type and NULL. MySQL HeatWave Lakehouse has the following limitations for Avro files. The data in an Avro block must be no larger than 64MiB before applying any compression. Lakehouse ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-table-syntax-json.html
External tables use table-level and column-level ENGINE_ATTRIBUTE options of the CREATE TABLE statement to specify the parameters needed to process data stored externally in Object Storage. CREATE EXTERNAL TABLE table_name (col_name data_type ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-data-types.html
CAST() COALESCE() CASE IF() NULLIF() ABS() CEILING() FLOOR() ROUND() TRUNCATE() GREATEST() LEAST() The following ENUM type columns are unsupported: ENUM type columns as part of a UNION, EXCEPT, EXCEPT ALL, INTERSECT, or INTERSECT ALL SELECT list or ...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 the exception of the following: Arithmetic operators, see: Section 5.3.2, “Arithmetic ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-functions.html
COUNT(NULL) in cases where it is used as an input argument for non-aggregate operators. As of MySQL 9.2.2, the maximum output width of the following functions is 65,332 bytes: JSON_ARRAYAGG() JSON_OBJECTAGG() JSON_ARRAY() JSON_OBJECT() ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-other.html
For example, the following query is not offloaded: mysql> SELECT AVG(c1) AS value FROM t1 WHERE c1 IS NULL; Primary keys with column prefixes. For a list of supported SQL modes, see Section 5.2, “Supported SQL Modes”. The WITH ROLLUP modifier in ...