MariaDB Enterprise ColumnStore 5.6.5 is a maintenance release of MariaDB Enterprise ColumnStore. MariaDB Enterprise ColumnStore is a columnar storage engine included with MariaDB Enterprise Server. This is the eighth release in the Enterprise ColumnStore 5 series.
MariaDB Enterprise ColumnStore 5.6.5 was released on 2022-02-14. This release is of General Availability (GA) maturity.
This release of MariaDB Enterprise ColumnStore is included with MariaDB Enterprise Server 10.5.13-9 and MariaDB Enterprise Server 10.5.15-10.
CMAPI 1.6.2 was originally included
CMAPI 1.6.3 is now included
CMAPI is a REST API for administering MariaDB Enterprise ColumnStore in multi-node topologies.
For additional information, see "Release Notes for CMAPI 1.6.2" and "Release Notes for CMAPI 1.6.3".
Related to performance
When performing a bulk data load, performance can be negatively impacted by slow extent map lookups. ()
In alignment with the , MariaDB Enterprise ColumnStore 5.6.5 is provided for:
CentOS 7 (x86_64)
Debian 10 (x86_64)
Red Hat Enterprise Linux 7 (x86_64)
Red Hat Enterprise Linux 8 (x86_64)
Major Release Upgrades for MariaDB Enterprise ColumnStore.
Ubuntu 20.04 (x86_64)
Release notes for MariaDB ColumnStore 5.6
MariaDB Enterprise ColumnStore 5.6.7 is a maintenance release of MariaDB Enterprise ColumnStore. MariaDB Enterprise ColumnStore is a columnar storage engine included with MariaDB Enterprise Server.
MariaDB Enterprise ColumnStore 5.6.7 was released on 2022-09-12. This release is of General Availability (GA) maturity.
This release of MariaDB Enterprise ColumnStore is included with MariaDB Enterprise Server 10.5.17-12.
Miscellaneous minor build and bug fixes
In alignment with the , MariaDB Enterprise ColumnStore 5.6.7 is provided for:
CentOS 7 (x86_64)
Debian 10 (x86_64)
Red Hat Enterprise Linux 7 (x86_64)
Red Hat Enterprise Linux 8 (x86_64)
Major Release Upgrades for MariaDB Enterprise ColumnStore.
Ubuntu 20.04 (x86_64)
MariaDB Enterprise ColumnStore 5.6.8 is a maintenance release of MariaDB Enterprise ColumnStore . MariaDB Enterprise ColumnStore is a columnar storage engine included with MariaDB Enterprise Server.
MariaDB Enterprise ColumnStore 5.6.8 was released on 2022-12-21. This release is of General Availability (GA) maturity.
This release of MariaDB Enterprise ColumnStore is included starting with MariaDB Enterprise Server 10.5.18-13.
Miscellaneous minor build and bug fixes
In alignment with the , MariaDB Enterprise ColumnStore 5.6.8 is provided for:
CentOS 7 (x86_64)
Debian 10 (x86_64)
Red Hat Enterprise Linux 7 (x86_64)
Red Hat Enterprise Linux 8 (x86_64)
Ubuntu 20.04 (x86_64)
MariaDB Enterprise ColumnStore 5.6.3 is a maintenance release of MariaDB Enterprise ColumnStore. MariaDB Enterprise ColumnStore is a columnar storage engine included with MariaDB Enterprise Server. This is the seventh release in the Enterprise ColumnStore 5 series.
MariaDB Enterprise ColumnStore 5.6.3 was released on 2021-12-13. This release is of General Availability (GA) maturity.
This release of MariaDB Enterprise ColumnStore is included with MariaDB Enterprise Server 10.5.13-9.
CMAPI 1.6 is now included
CMAPI is a REST API for administering MariaDB Enterprise ColumnStore in multi-node topologies.
For additional information, see "Release Notes for CMAPI 1.6".
ColumnStore now supports compression for temporary files used for disk-based aggregations ()
Replica nodes crash and cannot restart after cpimport is executed. ()
Server crashes when a NOT IN(..) subquery contains an IS NULL comparison in an OR predicate. ()
The CMAPI shell aliases fail when the API key contains a = character. ()
In alignment with the , MariaDB Enterprise ColumnStore 5.6.3 is provided for:
CentOS 7 (x86_64)
Debian 9 (x86_64)
Debian 10 (x86_64)
Red Hat Enterprise Linux 7 (x86_64)
Major Release Upgrades for MariaDB Enterprise ColumnStore.
When disk-based aggregations are enabled, the temporary files use snappy compression by default.
SUSE Linux Enterprise Server 12 (x86_64)
SUSE Linux Enterprise Server 15 (x86_64)
Ubuntu 18.04 (x86_64)
Ubuntu 20.04 (x86_64)
MariaDB Enterprise ColumnStore is a columnar storage engine included with MariaDB Enterprise ColumnStore. This is the sixth 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.2 was released on 2021-06-30.
Possible segfault with disk-based aggregation. (, )
In alignment with the , MariaDB Enterprise ColumnStore 5.6.2 is provided for:
CentOS 7
CentOS 8
Debian 9
Debian 10
Major Release Upgrades for MariaDB Enterprise ColumnStore.
Red Hat Enterprise Linux 8
SUSE Linux Enterprise Server 12
SUSE Linux Enterprise Server 15
Ubuntu 18.04
Ubuntu 20.04
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.
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.
This page is: Copyright © 2025 MariaDB. All rights reserved.