2.2.2.4 Loading Partitions

As of MySQL 8.4.0, HeatWave supports InnoDB partitions, see Partition Selection. To load partitions into HeatWave, specify the SECONDARY_LOAD clause in an ALTER TABLE statement.

mysql> ALTER TABLE tbl_name SECONDARY_LOAD PARTITION (p0, p1, ..., pn);

The SECONDARY_LOAD PARTITION clause is valid if the table has been loaded to HeatWave or not. For example:

mysql> ALTER TABLE t1 SECONDARY_LOAD;
mysql> ALTER TABLE t1 ADD PARTITION (PARTITION p4 VALUES LESS THAN (2002));
mysql> ALTER TABLE t1 SECONDARY_LOAD PARTITION (p4);

The SECONDARY_LOAD clause has these properties:

• Data is read using the READ COMMITTED isolation level.

See: Section 2.18.6, “Partition Selection Limitations”.