MySQL HeatWave on OCI does not support
LOAD DATA
withALGORITHM=BULK
.MySQL HeatWave on AWS does support
LOAD DATA
withALGORITHM=BULK
, but does not support theINFILE
andURL
clauses.The target table for
LOAD DATA
withALGORITHM=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 callingLOAD DATA
withALGORITHM=BULK
.The target table for
LOAD DATA
withALGORITHM=BULK
must not be partitioned.The target table for
LOAD DATA
withALGORITHM=BULK
must not contain secondary indexes.The target table for
LOAD DATA
withALGORITHM=BULK
must be in a file_per_tablespace. The table must not be in a shared tablespace.The target table for
LOAD DATA
withALGORITHM=BULK
must have the default row format,ROW_FORMAT=DYNAMIC
. UseALTER TABLE
to make any changes to the table afterLOAD DATA
withALGORITHM=BULK
.The target table for
LOAD DATA
withALGORITHM=BULK
must contain a primary key.LOAD DATA
withALGORITHM=BULK
does not support a prefix index for the primary key.The target table for
LOAD DATA
withALGORITHM=BULK
must not contain virtual or stored generated columns.The target table for
LOAD DATA
withALGORITHM=BULK
must not contain foreign keys.The target table for
LOAD DATA
withALGORITHM=BULK
must not containCHECK
constraints.The target table for
LOAD DATA
withALGORITHM=BULK
must not contain triggers.The target table for
LOAD DATA
withALGORITHM=BULK
is not replicated to other nodes.The target table for
LOAD DATA
withALGORITHM=BULK
must not use a secondary engine. Set the secondary engine after the afterLOAD DATA
withALGORITHM=BULK
. See: Section 2.2.2.2, “Defining the Secondary Engine”.LOAD DATA
withALGORITHM=BULK
locks the target table exclusively and does not allow other operations on the table.LOAD DATA
withALGORITHM=BULK
does not support automatic rounding or truncation of the input data.LOAD DATA
withALGORITHM=BULK
will fail if the input data requires rounding or truncation in order to be loaded.LOAD DATA
withALGORITHM=BULK
does not support temporary tables.LOAD DATA
withALGORITHM=BULK
is atomic but not transactional.LOAD DATA
withALGORITHM=BULK
commits any transaction that is already running. On failure theLOAD DATA
statement is completely rolled back.LOAD DATA
withALGORITHM=BULK
cannot execute when the target table is explicitly locked by aLOCK TABLES
statement.