As of MySQL 8.4.0, HeatWave supports InnoDB partitions. Selectively loading and unloading partitions will reduce memory requirements. The use of partition information can allow data-skipping and accelerate query processing.
As of MySQL 8.2.0, HeatWave Guided Load uses MySQL Autopilot to exclude
schemas, tables, and columns that cannot be loaded, and define
RAPID
as the secondary engine. To load data
manually, follow these steps:
Optionally, applying string column encoding and data placement workload optimizations. For more information, see Section 2.7, “Workload Optimization”.
Loading tables or partitions using
ALTER TABLE ... SECONDARY_LOAD
statements. See Section 2.2.2.3, “Loading Tables” and Section 2.2.2.4, “Loading Partitions”.
Before MySQL 8.2.0, to load data manually, follow these steps:
Excluding columns with unsupported data types. See Section 2.2.2.1, “Excluding Table Columns”.
Defining
RAPID
as the secondary engine for tables you want to load. See Section 2.2.2.2, “Defining the Secondary Engine”.Optionally, applying string column encoding and data placement workload optimizations. For more information, see Section 2.7, “Workload Optimization”.
Loading tables using
ALTER TABLE ... SECONDARY_LOAD
statements. See Section 2.2.2.3, “Loading Tables”.