2.6.2 Unloading Partitions

As of MySQL 9.1.0, HeatWave MySQL supports InnoDB partitions. INFORMATION_SCHEMA.PARTITIONS includes a SECONDARY_LOAD column that indicates whether a partition has been loaded. See: Section 2.2.2.4, “Loading Partitions”.

As of MySQL 9.1.0, when an unload operation successfully unloads the last partition, it will unload the whole table.

To unload partitions from HeatWave, specify the SECONDARY_UNLOAD clause in an ALTER TABLE statement.

Press CTRL+C to copy
 
mysql>ALTER TABLE tbl_name SECONDARY_UNLOAD PARTITION (p0, p1, ..., pn);

If a partition unload fails, the table becomes stale.

See: Section 2.19.6, “Partition Selection Limitations”.