2.2.2.3 Loading Tables

To load a table into HeatWave, specify the SECONDARY_LOAD option in an ALTER TABLE statement.

mysql> ALTER TABLE orders SECONDARY_LOAD;

The SECONDARY_LOAD clause has these properties:

• Data is read using the READ COMMITTED isolation level.