Overview

MariaDB ColumnStore is a columnar storage engine included with MariaDB Enterprise Server. This is the third release in the ColumnStore 5 series.

This release of MariaDB ColumnStore is included with MariaDB Enterprise Server 10.5.8-5.

This release is of General Availability (GA) maturity.

MariaDB ColumnStore 5.5.1 was released on 2020-12-14.

• Documentation

Notable Changes

• ColumnStore VARCHAR was sized in bytes, which required customers with multi-byte data to account for the byte variance within their capacity calculations and column definitions. VARCHAR is now sized by characters (which may be multi-byte) in alignment to the behavior of InnoDB and as required by SQL standard (ISO/IEC 9075:2016 feature E021 - Character string types). ()

• Non-equality comparison operators previously produced storage engine-specific results with NOPAD collations. This behavior now aligns to the behavior of InnoDB. ()

• Added ENCODE() and DECODE() function support. ()

• ColumnStore now respects case-insensitive comparison during JOIN when called for by the specified collation. (, )

• Enhanced performance of multi-node ColumnStore startup. ()

• Possible crash in mariadbd when calling stored procedures in the columnstore_info database. ()

• INSERT .. SELECT hangs on cpimport when MariaDB ColumnStore is installed in a non-default path. ()

• Incorrect error message shown when using unsupported JSON functions. ()

• Equality does not respect the NOPAD collation attribute. ()

• ROUND() function returns incorrect answer for DATE data type. (, )

• mcs-loadbrm and mcs-savebrm have hard coded paths to load_brm and save_brm ()

• In-place upgrade from 1.5 to 5.5 failed due to DEB package conflicts. ()

• A configuration file x-columnstore.cnf previously existed during Beta and Gamma releases of ColumnStore. This file has been removed as it is no longer required. ()

In alignment with the , MariaDB ColumnStore 5.5.1 is provided for:

• CentOS 8

• CentOS 7

• Debian 10

• Debian 9

_{This page is: Copyright © 2026 MariaDB. All rights reserved.}

Overview

MariaDB ColumnStore is a columnar storage engine that is included with the MariaDB Enterprise Server. This is the fourth release in the 5 series.

This release of MariaDB ColumnStore is included with MariaDB Enterprise Server 10.5.9-6.

This release is of General Availability (GA) maturity.

MariaDB ColumnStore 5.5.2 was released on 2021-03-15.

Notable Changes

• Added the ec2_iam_mode=enabled option to storagemanager.cnf, which enables an EC2 instance to authenticate with S3 using its IAM role. (MCOL-4386)

• Added support for CREATE TABLE AS SELECT .. COUNT() .. FROM .. GROUP BY .. ()

• Removed legacy OAM scripts. ()

• Consolidated ColumnStore log files in the /var/log/mariadb/columnstore/ directory. ()

• Moved CMAPI log files to the /var/log/mariadb/columnstore/cmapi/ directory. ()

• Added more logs to /etc/logrotate.d/columnstore configuration. ()

• Refactor ColumnStore systemd services to ensure startup waits for network connectivity. ()

• Results from SELECT .. ORDER BY BINARY(col) now match InnoDB. ()

• Results from FLOOR() function now match InnoDB for DATETIME, TIMESTAMP, and TIME columns. ()

• Extent map can become corrupted during startup under 5.5.1 with a large extent map and shared storage. ()

• A join with different collations crashes the ExeMgr process. ()

• A time zone conversion results in a hang due to a deadlock in the thread pool. ()

• When replication is used, INSERT INTO .. SELECT .. FROM ... results in a hang in the SQL thread. ()

• Error message from LOAD DATA INFILE statement mentions wrong path for .err and .bad files. ()

• Table remains locked when ColumnStore is forced to restart. ()

• CREATE TABLE AS SELECT .. LIMIT 0 writes a row to the table. ()

• Configuration files not moved back into place after in-place upgrade. ()

In alignment with the , MariaDB ColumnStore 5.5.2 is provided for:

• CentOS 8

• CentOS 7

• Debian 10

• Debian 9

_{This page is: Copyright © 2026 MariaDB. All rights reserved.}