MySQL HeatWave User Guide
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.