Auto Parallel Load facilitates the process of loading data into HeatWave by automating many of the steps involved, including:
Excluding schemas, tables, and columns that cannot be loaded.
RAPIDas the secondary engine for tables that are to be loaded.
Verifying that there is sufficient memory available for the data.
Optimizing load parallelism based on machine-learning models.
Loading data into HeatWave.
Auto Parallel Load, which can be run from any MySQL client or
connector, is implemented as a stored procedure named
heatwave_load, which resides in the MySQL
sys schema. Running Auto
Parallel Load involves issuing a
CALL statement for the stored
procedure, which takes
options as arguments; for example,
this statement loads the
mysql> CALL sys.heatwave_load(JSON_ARRAY("tpch"),NULL);