HeatWave User Guide  /  ...  /  Partition Selection Limitations

11.2.1.7 Partition Selection Limitations

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

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

  • MySQL HeatWave cannot load partitions with Auto Parallel Load.

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

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

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

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