2.18.6 Partition Selection Limitations

Before MySQL 9.1.0, HeatWave MySQL does not support explicit partition selection.

As of MySQL 9.1.0, HeatWave MySQL supports InnoDB partitions with the following limitations:

• HeatWave MySQL cannot load partitions with Auto Parallel Load.

• HeatWave MySQL cannot load partitions from a snapshot of the database.

• HeatWave MySQL cannot load partitions from a table that contains dictionary-encoded columns.

• HeatWave MySQL can unload up to 1,000 partitions in a single statement. Use additional statements to unload more than 1,000 partitions.

• HeatWave MySQL cannot load or unload partitions during the recovery process.