4.2.6.2 Define the Secondary Engine

Before You Begin

• Exclude table columns.

Defining Secondary Engine

For each table that you want to load into MySQL HeatWave Cluster, you must define the MySQL 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> CREATE TABLE customer(
 cust_id INTEGER primary key,
 total_items INTEGER NOT NULL,
 total_cost DECIMAL (4,2) NOT NULL,
 order_status CHAR(1) NOT NULL);

mysql> ALTER TABLE customer SECONDARY_ENGINE = RAPID;

This example creates a new table customer with the specified column names. Then, the MySQL HeatWave query processing engine (RAPID) is set as the secondary engine for the table, using ALTER TABLE statement.

With MySQL version 8.2.0 or higher, this step is not required as the guided load feature automatically define the secondary engine when you load a table into MySQL HeatWave cluster.

What's Next

• Learn how to load tables.

• Learn how to load partitions.