LOAD DATA INFILE for MariaDB Xpand
For compatibility purposes, Xpand supports
LOAD DATA INFILE to load data. However, this is the least performant way to load data onto Xpand. Using
clx_import is the recommended method for loading data.
Caveats for LOAD DATA INFILE
LOAD DATA INFILE does not take advantage of any parallelism for performing the import.
Xpand requires that
TERMINATED BYbe specified before
Unsupported for LOAD DATA INFILE
Xpand does not support empty string for
FIELDS TERMINATED BYor
FIELDS ENCLOSED BY(or fixed row formats).