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

• Define the secondary engine.

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

• Learn about change propagation.