Search Results
https://dev.mysql.com/doc/heatwave/en/import-data.html
This topic describes how to import data into the DB System. Import Data Use MySQL Shell Shell for importing data into a DB System. Its dump and load utilities are specifically built for this task and support all types of data exports and imports.
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-lakehouse-generated-columns.html
Stored generated columns are evaluated when loading data into external tables using the ALTER TABLE table_name SECONDARY_LOAD statement. As of MySQL 9.5.1, you have the option to include stored generated columns when creating external Lakehouse ...
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 ...