MySQL HeatWave User Guide

4.2.6.4 Load Partitions

As of MySQL 9.1.0, MySQL HeatWave supports partitions for DB System tables. See Partition Selection.

Before You Begin
Loading Partitions using Secxondary _Load Clause

To load partitions into MySQL HeatWave, specify the SECONDARY_LOAD clause in an ALTER TABLE statement with the PARTITION clause. 

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

The SECONDARY_LOAD clause can load a subset of partitions: 

mysql> ALTER TABLE tbl_name SECONDARY_LOAD PARTITION (p4, p5, p10);

To load a new partition in MySQL HeatWave after adding it to a previously loaded table: 

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.

    With the guided load feature, the SECONDARY_LOAD clause also define the SECONDARY_ENGINE of the table to rapid and marked all columns with unsupported data types with the NOT SECONDARY attribute.

See: Section 11.2.1.7, “Partition Selection Limitations”.

What's Next
MySQL Documentation Library