Documentation Home
MySQL HeatWave User Guide
Related Documentation Download this Manual
PDF (US Ltr) - 1.6Mb
PDF (A4) - 1.6Mb


MySQL HeatWave User Guide  /  ...  /  Loading Data Manually

2.2.2 Loading Data Manually

As of MySQL 8.2.0, HeatWave Statically 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:

  1. Optionally, applying string column encoding and data placement workload optimizations. For more information, see Section 2.7, “Workload Optimization”.

  2. Loading tables using ALTER TABLE ... SECONDARY_LOAD statements. See Section 2.2.2.3, “Loading Tables”.

Before MySQL 8.2.0, loading data manually involves the following steps:

  1. Excluding columns with unsupported data types. See Section 2.2.2.1, “Excluding Table Columns”.

  2. Defining RAPID as the secondary engine for tables you want to load. See Section 2.2.2.2, “Defining the Secondary Engine”.

  3. Optionally, applying string column encoding and data placement workload optimizations. For more information, see Section 2.7, “Workload Optimization”.

  4. Loading tables using ALTER TABLE ... SECONDARY_LOAD statements. See Section 2.2.2.3, “Loading Tables”.