HeatWave Release Notes
Auto Unload facilitates the process of unloading data from HeatWave by automating many of the steps involved, including:
Excluding schemas and tables that cannot be unloaded.
Removes the secondary engine flag for tables that are to be unloaded.
Unloading data from HeatWave.
Unloading of automatically loaded tables if there is not enough memory to load a manually loaded table. See Section 2.2.4.7, “Automatic Loading and Unloading of DB System Tables and Partitions”.
Auto Unload, which can be run from any MySQL client or connector, is
implemented as a stored procedure named
heatwave_unload, which resides in the MySQL
sys schema. Running Auto Unload
involves issuing a CALL
statement for the stored procedure, which takes
schemas and
options as arguments; for example,
this statement unloads the tpch schema:
mysql>CALL sys.heatwave_unload(JSON_ARRAY("tpch"), NULL);