Unloading a table from HeatWave may be necessary to replace an existing table, to reload a table, to free up memory, or simply to remove a table that is no longer used.
To unload a table from HeatWave, specify the
SECONDARY_UNLOAD clause in an
ALTER TABLE statement:
mysql> ALTER TABLE orders SECONDARY_UNLOAD;
Data is removed from HeatWave only. The table contents on the MySQL DB System are not affected.