cpimport options in 1.4¶

MariaDB ColumnStore provides cpimport for bulk loading data into ColumnStore tables.

long_opt

short_opt

descr

-B

I/O library read buffer size (in bytes)

-b

Number of read buffers

-C

Escape character used in conjunction with 'enclosed by'

-c

Application read buffer size(in bytes)

-d

Print different level(1-3) debug message

-E

Enclosed by character if field values are enclosed.

-e

Max number of allowable error per table per PM

-f

Data file directory path.

-g

S3 Region (for S3 imports)

-H

S3 Hostname (for S3 imports, Amazon's S3 default)

-h

Print this message.

-I

Import binary data; how to treat NULL values:

-i

Print extended info to console in Mode 3.

-j

Job ID. In simple usage, default is the table OID.

-K

S3 Authentication Secret (for S3 imports)

-l

Name of import file to be loaded, relative to -f path,

-m

mode

-n

NullOption (0-treat the string NULL as data (default);

-P

List of PMs ex: -P 1,2,3. Default is all PMs.

-p

Path for XML job description file.

-q

Batch Quantity, Number of rows distributed per batch in Mode 1

-r

Number of readers.

-S

Treat string truncations as errors.

-s

'c' is the delimiter between column values.

-T

Timezone used for TIMESTAMP datatype.

-t

S3 Bucket (for S3 imports)

-w

Number of parsers.

-y

S3 Authentication Key (for S3 imports)