2.2.2.2 Defining the Secondary Engine

For each table that you want to load into HeatWave, you must define the HeatWave query processing engine (RAPID) as the secondary engine for the table. To define RAPID as the secondary engine, specify the SECONDARY_ENGINE table option in an ALTER TABLE or CREATE TABLE statement:

mysql> ALTER TABLE orders SECONDARY_ENGINE = RAPID;

mysql> CREATE TABLE orders (id INT) SECONDARY_ENGINE = RAPID;