Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec-prepared-stmt-app.html
The second statement SELECT JSON_OBJECT("Task result", "Finished...") into @task_result generates an output that is stored in the reserved session variable @task_result. The execute_prepared_stmt_from_app_async routine creates an asynchronous task ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec.html
The limits.maximumHeatwaveLoadingTasks key specifies the maximum number of VECTOR_STORE_LOAD tasks that can run concurrently for loading unstructured data into the MySQL HeatWave Cluster. For example: mysql> CALL ... As of MySQL 9.3.1, you can run ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-unload.html
mysql> SELECT JSON_ARRAYAGG(schema_name) FROM performance_schema.rpd_table_id WHERE table_name LIKE 'hw%' INTO @input_list; mysql> CALL sys.heatwave_unload(@input_list, NULL); Unload tables that begin with an “hw” prefix from a schema named db_1. mysql> SELECT JSON_ARRAY(JSON_OBJECT('db_name', 'db_1', 'tables', JSON_ARRAYAGG(table_name))) FROM performance_schema.rpd_table_id WHERE schema_name = 'db_1' AND table_name LIKE 'hw%' INTO @input_list; mysql> CALL sys.heatwave_unload(@input_list, NULL); Unload all user and system ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-debugging-queries.html
The following query example uses INTERVAL() function to calculate and display the time interval into which the departure hour falls, based on the specified thresholds (6, 12, 18, 24). This topic describes how to debug queries that fail to offload ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-defining-secondary-engine.html
Defining Secondary Engine For each table that you want to load into MySQL HeatWave Cluster, you must define the MySQL HeatWave query processing engine (RAPID) as the secondary engine for the table. With MySQL version 8.2.0 or higher, this step is ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-encoding-string-columns.html
Select the Encoding Type By default, when tables are loaded into MySQL HeatWave, CHAR, VARCHAR, and TEXT type columns are encoded using variable-length encoding. For example, it is permitted for a column description to be specified alongside a ...
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 ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-secondary-load.html
You can load tables into HeatWave using the SECONDARY_LOAD clause. Loading Tables Statement To load a table into MySQL HeatWave, specify the SECONDARY_LOAD clause in an ALTER TABLE statement and use the following syntax. ALTER TABLE table_name ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-26.html
(WL #14328, WL #14510, WL #14431, WL #14328, WL #14651) Auto Parallel Load The new MySQL HeatWave Auto Parallel Load utility automates the process of preparing and loading tables into MySQL HeatWave and loads data using an optimized number of ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-33-u3.html
MySQL HeatWave Lakehouse MySQL HeatWave expands to include MySQL HeatWave Lakehouse, letting organizations process and query hundreds of terabytes of data residing in Object Storage—in a variety of file formats, such as CSV and Parquet. The ...