MariaDB ColumnStore 22.08.1 Release Notes
Overview
MariaDB Enterprise ColumnStore 22.08.1 is a maintenance release of MariaDB Enterprise ColumnStore . MariaDB Enterprise ColumnStore is a columnar storage engine included with MariaDB Enterprise Server. This is the first release in the Enterprise ColumnStore 22.08 series.
MariaDB Enterprise ColumnStore 22.08.1 was released on 2022-09-12. This release is of General Availability (GA) maturity.
MariaDB Enterprise ColumnStore 22.08 replaces MariaDB Enterprise ColumnStore 6 in MariaDB Enterprise Server 10.6.
This release of MariaDB Enterprise ColumnStore is included with MariaDB Enterprise Server 10.6.9-5.
This release has been withdrawn. Users of MariaDB Enterprise ColumnStore 22.08.1 should upgrade to MariaDB Enterprise ColumnStore 22.08.3.
Notable Changes
JOINs
Support has been added for JOINs with an ON clause that reference tables that are not involved in the join. (MCOL-5167)
Support has been added for circular outer JOINs. (MCOL-4699)
Support has been added for combining outer JOINs and IS NULL filters. (MCOL-4715)
Query Performance
In single-node ColumnStore, query performance has been improved by removing a network hop. (MCOL-5166)
Performance has been enhanced for DELETE queries. (MCOL-5021)
Functions
Support for CHAR and VARCHAR have been added for the MODA() function. (MCOL-5161)
Distributed implementations of most JSON functions have been added to ColumnStore. (MCOL-785)
This feature does not include JSON_ARRAYAGG, JSON_OBJECTAGG, or JSON_TABLE.
ColumnStore's functions that use the cal prefix have been changed to use the mcs prefix. (MCOL-4984)
Tooling
ColumnStore now includes Cluster Management API (CMAPI) 22.08.1.
Some internal improvements have been made to the mcsRebuildEM utility. (MCOL-5172)
Operating Systems
Operating system compatibility has changed, as designated in MariaDB Engineering Policy, including:
Support for Debian 11, Red Hat Enterprise Linux 9, Rocky Linux 9, and Ubuntu 22.04 have been added.
Support for Debian 9, Debian 10, and Ubuntu 18.04 have been removed.
CPU Compatibility
When ColumnStore is installed and started, ColumnStore's binaries check the system's CPU to confirm that the CPU supports the SIMD instructions required by ColumnStore. (MCOL-5180)
On x86_64, ColumnStore requires SSE4.2.
On ARM64, ColumnStore requires NEON.
If the ColumnStore installation scripts determine that the required SIMD instructions are not supported, the following error is raised:
error: this machine CPU lacks of support for Intel SSE4.2 or ARM Advanced SIMD instructions. Columnstore requires one of this instruction sets, installation aborted
If the ColumnStore binaries are started and determine that the required SIMD instructions are not supported, the following error is raised:
Unsupported CPU architecture. ARM Advanced SIMD or x86_64 SSE4.2 required; aborting.
Internal Processes
Internal stability improvements have been made to the processes that write data. (MCOL-5163)
The WriteEngineServer, DMLProc, and DDLProc processes have been improved.
PrimProc thread pool has been changed to use a fair scheduler. (MCOL-5044)
Platforms
In alignment with the enterprise lifecycle, MariaDB Enterprise ColumnStore 22.08.1 is provided for:
CentOS 7 (x86_64)
Debian 11 (x86_64, ARM64)
Red Hat Enterprise Linux 7 (x86_64)
Red Hat Enterprise Linux 8 (x86_64, ARM64)
Red Hat Enterprise Linux 9 (x86_64, ARM64)
Rocky Linux 8 (x86_64, ARM64)
Rocky Linux 9 (x86_64, ARM64)
Ubuntu 20.04 (x86_64, ARM64)
Ubuntu 22.04 (x86_64, ARM64)
Installation Instructions
Upgrade Instructions
Upgrade Multi-Node MariaDB Enterprise ColumnStore from 6 to 23.10
This page is: Copyright © 2025 MariaDB. All rights reserved.
Last updated
Was this helpful?