Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-syntax.html
memory_gain_ascending: Whether to rank the unload table suggestions in ascending or descending order based on the table size. limit_tables: A limit to the number of unload table suggestions, based on the order imposed by memory_gain_ascending.
https://dev.mysql.com/doc/heatwave/en/mys-hw-advisor-unload.html
Set memory_gain_ascending to true to rank the unload table suggestions in ascending order based on the table size. Use the limit_tables option to limit the number of unload table suggestions, based on the order imposed by memory_gain_ascending.
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-parallel-load-syntax.html
mysql> CALL sys.heatwave_load(JSON_ARRAY("tpch","airportdb","employees","sakila"), JSON_OBJECT("policy","not_disable_unsupported_columns")); Load multiple schemas, excluding specified tables and a particular column: mysql> CALL ... MySQL 9.0.0 adds ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-autopilot-index-advisor-report-table.html
When Autopilot Indexing runs, it sends detailed output to the autopilot_index_advisor_report table in the sys schema. The autopilot_index_advisor_report table is a temporary table that contains data from the last execution of Autopilot Indexing.
https://dev.mysql.com/doc/heatwave/en/mys-hw-create-temp-table.html
As of MySQL 9.3.0, you can create temporary tables that are stored in the MySQL HeatWave Cluster. A temporary table is visible only within the current session, and is dropped automatically when you close the session. Once created, you can use a ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-encoding-string-columns.html
Columns with a high number of distinct values MySQL HeatWave nodes Dictionary (SORTED) Supports GROUP BY and ORDER BY operations on string columns Columns with a low number of distinct values DB System node For additional information about string ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-error-handling.html
See MySQL 9.5 Error Message Reference for Lakehouse error messages. As of MySQL 9.2.2, a detailed summary of warnings is available when loading data to Lakehouse. This includes warnings related to the schema inference stage of loading data. The ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-export-query-results-csv-non-json.html
This topic shows the different ways to export query results as a CSV file with SQL syntax. INTO OUTFILE {URL | URI} 'uri' [FORMAT csv] [CHARACTER SET 'charset_name'] [HEADER {ON | OFF}] [{FIELDS | COLUMNS} [NULL AS 'null_char'] [TERMINATED BY ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-selective-load.html
Available as of MySQL 9.1.2, you can update external tables using Selective Load, which lets you edit the list of files that comprise an external table without altering the directories in the Object Storage bucket. This topic contains the following ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-limitations-functions.html
For example: mysql> SELECT CONVERT_TZ(O_ORDERDATE, 'UTC','EST') FROM tpch.orders; Rewrite as: mysql> SELECT CONVERT_TZ(O_ORDERDATE, '+00:00','-05:00') FROM tpch.orders; Only UNIX_TIMESTAMP() and FROM_UNIXTIME() functions support a timezone value ...