Related Documentation Download this Manual
PDF (US Ltr) - 0.6Mb
PDF (A4) - 0.6Mb


HeatWave User Guide  /  Preparing Data  /  Defining the Secondary Engine

3.5 Defining the Secondary Engine

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 (RAPID) as the secondary engine.

To define RAPID as the secondary engine for a table, specify the SECONDARY_ENGINE table option in a CREATE TABLE or ALTER TABLE statement:

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

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”.