Documentation Home
MySQL HeatWave User Guide
Related Documentation Download this Manual
PDF (US Ltr) - 1.6Mb
PDF (A4) - 1.6Mb


MySQL HeatWave User Guide  /  ...  /  Bulk Ingest Data to MySQL Server Limitations

2.17.7 Bulk Ingest Data to MySQL Server Limitations

  • MySQL HeatWave on OCI does not support LOAD DATA with ALGORITHM=BULK.

  • MySQL HeatWave on AWS does support LOAD DATA with ALGORITHM=BULK, but does not support the INFILE and URL clauses.

  • The target table for LOAD DATA with ALGORITHM=BULK must be empty. The state of the table should be as though it has been freshly created. If the table has instantly added/dropped column, call TRUNCATE before calling LOAD DATA with ALGORITHM=BULK.

  • The target table for LOAD DATA with ALGORITHM=BULK must not be partitioned.

  • The target table for LOAD DATA with ALGORITHM=BULK must not contain secondary indexes.

  • The target table for LOAD DATA with ALGORITHM=BULK must be in a file_per_tablespace. The table must not be in a shared tablespace.

  • The target table for LOAD DATA with ALGORITHM=BULK must have the default row format, ROW_FORMAT=DYNAMIC. Use ALTER TABLE to make any changes to the table after LOAD DATA with ALGORITHM=BULK.

  • The target table for LOAD DATA with ALGORITHM=BULK must contain a primary key.

  • LOAD DATA with ALGORITHM=BULK does not support a prefix index for the primary key.

  • The target table for LOAD DATA with ALGORITHM=BULK must not contain virtual or stored generated columns.

  • The target table for LOAD DATA with ALGORITHM=BULK must not contain foreign keys.

  • The target table for LOAD DATA with ALGORITHM=BULK must not contain CHECK constraints.

  • The target table for LOAD DATA with ALGORITHM=BULK must not contain triggers.

  • The target table for LOAD DATA with ALGORITHM=BULK is not replicated to other nodes.

  • The target table for LOAD DATA with ALGORITHM=BULK must not use a secondary engine. Set the secondary engine after the after LOAD DATA with ALGORITHM=BULK. See: Section 2.2.2.2, “Defining the Secondary Engine”.

  • LOAD DATA with ALGORITHM=BULK locks the target table exclusively and does not allow other operations on the table.

  • LOAD DATA with ALGORITHM=BULK does not support automatic rounding or truncation of the input data. LOAD DATA with ALGORITHM=BULK will fail if the input data requires rounding or truncation in order to be loaded.

  • LOAD DATA with ALGORITHM=BULK does not support temporary tables.

  • LOAD DATA with ALGORITHM=BULK is atomic but not transactional. LOAD DATA with ALGORITHM=BULK commits any transaction that is already running. On failure the LOAD DATA statement is completely rolled back.

  • LOAD DATA with ALGORITHM=BULK cannot execute when the target table is explicitly locked by a LOCK TABLES statement.