Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-auto-indexing-examples.html
To evaluate all user defined schemas: mysql> CALL sys.autopilot_index_advisor(NULL); To evaluate selected schemas: mysql> CALL sys.autopilot_index_advisor(JSON_OBJECT('target_schema',JSON_ARRAY('schema1','schema2', ...))); An example of the output ...The reason, expected storage footprint, and performance impact of each ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-syntax.html
Produces summarized output and sends it to stdout and to the heatwave_autopilot_report table. The silent output type is useful if human-readable output is not required; when the output is consumed by a script, for example. If a target schema is not ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-add-task-log.html
The add_task_log routine add a log entry for the task with the specified ID. You can use this routine with an application-level task as well and it does not require an application-managed user ID. Syntax mysql> CALL mysql_tasks.add_task_log( IN ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-task-status-list.html
If the value is NULL, tasks of all types are included. The task_status_list routine returns a paginated list of task statuses. This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT ...
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-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-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-modifying-tables.html
When an InnoDB table is loaded into MySQL HeatWave Cluster, DDL operations such as ALTER TABLE, RENAME TABLE, TRUNCATE TABLE, and DROP TABLE are permitted. While any of these operations are being executed, queries involving the modified table are ...