columnstore_import_for_batchinsert_enclosed_by

ASCII value of the quote symbol used by batch data ingestion

See also: System Variables for MariaDB Enterprise Server 10.6, in 10.5 ES, and in 10.4 ES

DETAILS

The columnstore_import_for_batchinsert_enclosed_by system variable configures the quote character that is used for bulk data load statements that are internally performed by cpimport. This only occurs when columnstore_use_import_for_batchinsert is enabled.

PARAMETERS

Dynamic

Yes

Scope

Global, Session

Data Type

BIGINT UNSIGNED

Minimum Value

17

Maximum Value

127

Default Value

17

SKYSQL

Cloud

SkySQL Topology

ES Ver

Default

AWS

HA (Primary/Replica)

10.4

Not present

AWS

HA (Primary/Replica)

10.5

Not present

AWS

Transactional Standalone

10.4

Not present

AWS

Transactional Standalone

10.5

Not present

AWS

Distributed Transactions

10.5

Not present

GCP

ColumnStore

10.5

17

GCP

ColumnStore Multi

10.5

17

GCP

Galera

10.4

Not present

GCP

Galera

10.5

Not present

GCP

HA (Primary/Replica)

10.4

Not present

GCP

HA (Primary/Replica)

10.5

Not present

GCP

HTAP

10.5

17

GCP

Transactional Standalone

10.4

Not present

GCP

Transactional Standalone

10.5

Not present

GCP

Distributed Transactions

10.5

Not present

CHANGE HISTORY

Release Series

History

10.6 Enterprise

  • Present starting in MariaDB Enterprise Server 10.6.4-1.

10.5 Enterprise

  • Removed in MariaDB Enterprise Server 10.5.3-1.

  • Added in MariaDB Enterprise Server 10.5.4-2.

10.4 Enterprise

  • Added in MariaDB Enterprise Server 10.4.11-5.

EXTERNAL REFERENCES