Release Notes for MariaDB Enterprise ColumnStore 22.08.1
This page is part of MariaDB's Documentation.
The parent of this page is: Release Notes for MariaDB Enterprise ColumnStore 22.08
Topics on this page:
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 complex JOINs in views. (MCOL-5061, MCOL-4902)
Support has been added for combining outer JOINs and
IS NULL
filters. (MCOL-4715)
Query Performance
Functions
Support for
CHAR
andVARCHAR
have been added for theMODA()
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
, orJSON_TABLE
.
ColumnStore's functions that use the
cal
prefix have been changed to use themcs
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)
The ExeMgr process has been merged with the PrimProc process. (MCOL-5001, MCOL-5109)
Platforms
In alignment to 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)