Tables on a MySQL DB System are defined with
InnoDB as the primary storage engine. For
each table that you want to load into HeatWave, you must define
the HeatWave query processing engine (
as the secondary engine.
mysql> CREATE TABLE orders (id INT) SECONDARY_ENGINE = RAPID;
mysql> ALTER TABLE orders SECONDARY_ENGINE = RAPID;
Instead of defining the secondary storage engine for each table manually, consider using the Auto Parallel Load utility to prepare and load tables. For more information, see Section 4.1, “Auto Parallel Load”.