MariaDB Enterprise ColumnStore is a columnar storage engine included with MariaDB Enterprise ColumnStore. This is the fifth release in the Enterprise ColumnStore 5 series.
This release of MariaDB Enterprise ColumnStore is included with MariaDB Enterprise Server 10.5.10-7.
This release is of General Availability (GA) maturity.
MariaDB Enterprise ColumnStore 5.6.1 was released on 2021-06-14.
LOOR() now returns a fully-formatted DATETIME in alignment to CEIL() behavior. ()
MariaDB Enterprise ColumnStore now supports disk-based aggregation. Prior to this release, all aggregation could occur only in memory. With disk-based aggregation, larger aggregated result sets can be handled than would fit in memory. ()
To enable disk-based aggregation, edit Columnstore.xmland within the RowAggregation section configure:
AllowDiskBasedAggregation=Y to enable the feature. The default is N
To disable SSL certificate verification, edit storagemanager.cnf and configure:ssl_verify = disabled to disable SSL certificate verification. The default is ssl_verify = enabled, which enables SSL certificate verification when connecting by HTTPS to S3-compatible storage.
HTTP connections can now be made to S3-compatible storage. We recommend using HTTPS connections, and to use HTTP connections only when necessary and where appropriate compensatory controls exist. ()
To enable HTTP connections, edit storagemanager.cnf and configure:use_http = enabled to enable HTTP connections to S3-compatible storage. The default is use_http = disabled, which uses HTTPS connections to S3-compatible storage.
TCP port number for S3-compatible storage connections can now be specified by setting port_number in storagemanager.cnf ()
CMAPI now pushes storagemanager.cnf changes to newly-added nodes. Prior to this release, storagemanager.cnf to nodes before they were added. ()
Performance enhancements for general query execution, LIKE, and for subqueries containing a UNION (, , )
TRIM(), CONCAT(), REPLACE(), ENCODE(), and DECODE()
New:
Update to CMAPI REST API for node removal:
Old:
New:
CMAPI shutdown of cluster is abrupt, and may occur in the middle of transaction execution or rollback. ()
Crash with JOIN when using certain collations. ()
Crash or performance impact due to SELECT bypassing select handler when @variables are involved in the query projection list. ()
Assert in COUNT(DISTINCT) in a JOIN on Ubuntu 20.04. ()
Assert when a function is used in an aggregation on Ubuntu 20.04. ()
Incorrect result from UNION of a huge narrow DECIMAL (such as 17,1) and BIGINT ()
UDAF can return a bad value instead of expected value NULL ()
DISTINCT is case sensitive even when using case insensitive collation. ()
WHERE is not collation aware on CHAR(1) and CHAR(2) ()
.DEB packages missing /usr/bin/testS3Connection ()
In alignment with the , MariaDB Enterprise ColumnStore 5.5.2 is provided for:
CentOS 7
CentOS 8
Debian 9
Debian 10
Major Release Upgrades for MariaDB Enterprise ColumnStore.
TempDirto the directory path for storing temporary files. The default is /tmp/columnstore_tmp_files/aggregates
SSL certificate verification can now be disabled for S3-compatible storage. We recommend that SSL certificate verification be disabled only when necessary, and where appropriate compensatory controls exist. (MCOL-3542)
sql_mode=ORACLEUpdate to CMAPI REST API for node add:
Old:
Delay in execution of first query after ColumnStore restart. (MCOL-4071)
Long command strings cause crash of cpimport (MCOL-3394)
Failover hangs with multi-node ColumnStore 5.4 when using S3 storage, requiring an API call to restart cluster. (MCOL-4440)
Crash with concurrent Pentaho ETL and queries. (MCOL-4555)
GROUP and DISTINCT are not collation aware on CHAR(1) (MCOL-4721)
LIKE is not collation-aware. (MCOL-4498)
Performance impacted on nested queries with aggregates. (MCOL-4543)
INSERT .. SELECT * FROM (subselect) throws is not in GROUP BY clause even when it is part of the GROUP BY clause. (MCOL-3890)
ERROR 1815 (HY000): Internal error: IDB-1000 on FROM subquery containing nested JOINs. (MCOL-4680)
INSERT from VIEW generates error IDB-1011: Insert on VIEW is currently not supported. (MCOL-4687)
Red Hat Enterprise Linux 8
SUSE Linux Enterprise Server 12
SUSE Linux Enterprise Server 15
Ubuntu 18.04
Ubuntu 20.04
curl -X PUT https://127.0.0.1:8640/cmapi/0.4.0/cluster/add-node --header 'Content-Type:application/json' --header 'x-api-key:somekey123' --data '{"timeout":20, "node": "172.31.2.106"}' -kcurl -X PUT https://127.0.0.1:8640/cmapi/0.4.0/cluster/node --header 'Content-Type:application/json' --header 'x-api-key:somekey123' --data '{"timeout":20, "node": "172.31.3.254"}' -k | jq .curl -X PUT https://127.0.0.1:8640/cmapi/0.4.0/cluster/remove-node --header 'Content-Type:application/json' --header 'x-api-key:somekey123' --data '{"timeout":20, "node": "172.31.2.106"}' -kcurl -X DELETE https://127.0.0.1:8640/cmapi/0.4.0/cluster/node --header 'Content-Type:application/json' --header 'x-api-key:somekey123' --data '{"timeout":20, "node": "172.31.11.19"}' -k | jq .This page is: Copyright © 2025 MariaDB. All rights reserved.