Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Release notes for MariaDB ColumnStore 6
MariaDB Enterprise ColumnStore 6.4.4 is a maintenance release of MariaDB Enterprise ColumnStore . MariaDB Enterprise ColumnStore is a columnar storage engine included with MariaDB Enterprise Server. This is the sixth release in the Enterprise ColumnStore 6 series.
MariaDB Enterprise ColumnStore 6.4.4 was released on 2022-08-09. This release is of General Availability (GA) maturity.
This release of MariaDB Enterprise ColumnStore is included with MariaDB Enterprise Server 10.6.8-4.
When disk-based aggregations are enabled, aggregations can fail with the ER_INTERNAL_ERROR error code. ()
The following error message could be raised to the client:
In alignment with the , MariaDB Enterprise ColumnStore 6.4.4 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)
This page is: Copyright © 2025 MariaDB. All rights reserved.
6.4.6 is a maintenance release of . MariaDB Enterprise ColumnStore is a columnar storage engine included with MariaDB Enterprise Server. This is the seventh release in the Enterprise ColumnStore 6 series.
MariaDB Enterprise ColumnStore 6.4.6 was released on 2022-09-30. This release is of General Availability (GA) maturity.
This release of MariaDB Enterprise ColumnStore is included with MariaDB Enterprise Server 10.6.8-4.
Ubuntu 18.04 (x86_64)
Ubuntu 20.04 (x86_64)
An error can be returned during disk aggregation. (MCOL-5213)
The following error message could be raised to the client:
GROUP BY can return duplicates. (MCOL-5213)
In alignment to the enterprise lifecycle, MariaDB Enterprise ColumnStore 6.4.6 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)
Rocky Linux 8 (x86_64)
Ubuntu 18.04 (x86_64)
Ubuntu 20.04 (x86_64)
This page is: Copyright © 2025 MariaDB. All rights reserved.
MariaDB Enterprise ColumnStore 6.4.2 is a maintenance release of MariaDB Enterprise ColumnStore . MariaDB Enterprise ColumnStore is a columnar storage engine included with MariaDB Enterprise Server. This is the sixth release in the Enterprise ColumnStore 6 series.
MariaDB Enterprise ColumnStore 6.4.2 was released on 2022-07-19. This release is of General Availability (GA) maturity.
This release of MariaDB Enterprise ColumnStore is included with MariaDB Enterprise Server 10.6.8-4.
When disk-based aggregations are enabled, aggregations can fail with the ER_INTERNAL_ERROR error code. ()
The following error message could be raised to the client:
This change was a speculative bug fix. Please use Enterprise ColumnStore 6.4.4 or later for the complete bug fix.
In alignment with the , MariaDB Enterprise ColumnStore 6.4.2 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)
This page is: Copyright © 2025 MariaDB. All rights reserved.
6.2.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 third release in the Enterprise ColumnStore 6 series.
MariaDB Enterprise ColumnStore 6.2.3 was released on 2022-02-23. This release is of General Availability (GA) maturity.
This release of MariaDB Enterprise ColumnStore is included with MariaDB Enterprise Server 10.6.5-2 and MariaDB Enterprise Server 10.6.7-3.
ERROR 1815 (HY000): Internal error: TupleAggregateStep::threadedAggregateRowGroups()[24] MCS-2054: Unknown error while aggregation.MCS-2056: There was an IO error during a disk-based aggregation: No such file or directoryUbuntu 18.04 (x86_64)
Ubuntu 20.04 (x86_64)
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".
Added encrypted password support for the cross engine join user. ()
UPDATE with cross engine IN subquery produced unexpected results. (MCOL-4868)
Error can arise with cross engine JOIN: Internal error: CrossEngineStep::execute() caught getSignedNullValue(): got bad column width (4) (MCOL-4874)
IN operation doesn't respect COLLATE (MCOL-4899)
Slower than expected bulk insertion. (MCOL-4912)
A ColumnStore process thread read call could last indefinitely. ()
With this release, if no data appears when a ColumnStore process thread makes a read call, the thread logs an error, closes the socket, and proceeds.
Prior to this release, a ColumnStore process thread would synchronously wait for data to appear in the socket.
QueryStats does not automatically log each query to calGetTrace() results. ()
With this release, when QueryStats is enabled, queries are automatically logged to infinidb_querystats.querystats
Prior to this release, it was necessary to execute SELECT calGetTrace(1) to log queries even with QueryStats enabled.
In alignment with the enterprise lifecycle, MariaDB Enterprise ColumnStore 6.2.3 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 18.04 (x86_64)
Ubuntu 20.04 (x86_64)
This page is: Copyright © 2025 MariaDB. All rights reserved.
MariaDB Enterprise ColumnStore 6.2.2 is a maintenance release of MariaDB Enterprise ColumnStore . MariaDB Enterprise ColumnStore is a columnar storage engine included with MariaDB Enterprise Server. This is the second release in the Enterprise ColumnStore 6 series.
MariaDB Enterprise ColumnStore 6.2.2 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.6.5-2.
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".
Performance improvements for query execution (, )
When columnstore_select_handler=ON is configured, the server can crash if a SELECT statement uses aggregate functions. ()
The ColumnStore storage engine sometimes attempts to connect to the ExeMgr process on the old primary ColumnStore node after failover. ()
cpimport writes output to standard error (stderr) when no error occurs. ()
SELECT and UPDATE statements fail when the statement uses the CONVERT_TZ() function. () The following error message would be raised to the client:
SELECT statements sometimes fail when the statement uses the RAND() function (, )
The following error message would be raised to the client:<<code>>
ERROR 1815 (HY000): Internal error: IDB-2045: At least one PrimProc closed the connection unexpectedly.
<.
SELECT statements could return wrong results on large tables if the WHERE condition contains varchar_col < char_col ()
In alignment with the , MariaDB Enterprise ColumnStore 6.2.2 is provided for:
CentOS 7 (x86_64)
Debian 9 (x86_64)
Debian 10 (x86_64)
Red Hat Enterprise Linux 7 (x86_64)
This page is: Copyright © 2025 MariaDB. All rights reserved.
ERROR 1815 (HY000): Internal error: TupleAggregateStep::threadedAggregateRowGroups()[24] MCS-2054:
Unknown error while aggregation.ColumnStore's ExeMgr process now performs fewer context switches.
ColumnStore's PrimProc process now uses less memory.
Some internal operations have been improved to use more parallelism.
JOIN support for columns using increased DECIMAL precision (MCOL-4173)
ColumnStore can now JOIN tables on DECIMAL(38) columns.
Utility to rebuild the Extent Map (MCOL-312)
The mcsRebuildEM utility is now installed by Enterprise ColumnStore.
Enterprise ColumnStore uses the Extent Map to store metadata about the data stored in each extent. There are certain situations when metadata in the Extent Map can become inconsistent with the extents. In these situations, the Extent Map should be rebuilt.
When no options are provided, the mcsRebuildEM utility rebuilds the Extent Map. It does not check whether the Extent Map is already consistent with the extents. It rebuilds the Extent Map even if the Extent Map is already consistent.
When the -d option is provided, the mcsRebuildEM utility displays what changes it would make to the Extent Map and exits. This option can be used to test the operation without writing changes to disk.
When the -s option is provided, the mcsRebuildEM utility displays the current contents of the Extent Map and exits.
When columnstore_select_handler=ON is configured, SELECT statements returns the wrong results if a predicate in the WHERE condition uses an alias that is dependent on the result of a window function. (MCOL-4719)
The columnstoreAlias.sh script raises an error upon login for single node ColumnStore (MCOL-4832)
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 Server. This is the first release in the Enterprise ColumnStore 6 series.
MariaDB Enterprise ColumnStore 6.1.1 was released on 2021-08-26. This release is of General Availability (GA) maturity.
This release of MariaDB Enterprise ColumnStore is included with MariaDB Enterprise Server 10.6.4-1.
There are no documented changes to CMAPI in this release.
Disk-based aggregation allows larger aggregated result sets than can fit in memory ()
Prior to this feature, all aggregation operations were performed in memory.
Disk-based aggregation is enabled through configuration.
Enterprise ColumnStore's mandatory utility user is used for Cross-Engine JOIN. The mandatory utility user requires the UPDATE privilege. Before this release, UPDATE to ColumnStore data from transactional data was supported, however UPDATE to transactional data from ColumnStore data (an operation that requires Cross-Engine JOIN) was unsupported.
LZ4 compression ()
With this release, MariaDB Enterprise ColumnStore supports LZ4 and Snappy compression. Configuration allows the user to choose the best compression algorithm for their data set.
Before this release, Snappy compression was supported.
OFFSET syntax ()
*** The following query demonstrates the syntax:**
Encrypted passwords for the mandatory utility user ()
This release adds the cskeys and cspasswd command-line utilities.
The cskeys command-line utility generates an encryption key file. The encryption key file is stored in the /var/lib/columnstore directory by default.
The cspasswd command-line utility uses the encryption key file generated by cskeys to encrypt the specified password.
Auto-switch mode for the ColumnStore Select Handler ()
The AUTO value for the columnstore_select_handler system variable enables the auto-switch mode.
As with prior releases, columnstore_select_handler=ON enables the custom select handler and columnstore_select_handler=OFF disables the custom select handler.
When columnstore_select_handler is set to AUTO, MariaDB Enterprise ColumnStore automatically chooses whether to use the custom select handler for each query.
For additional information, see "Optimizer Statistics".
Reduced resource usage for connection configuration ()
A format change to the Columnstore.xml configuration file has reduced resource overhead. Connection definitions (PMSn sections) have been simplified.
No manual action is required to change over to the new format. This configuration is handled by CMAPI.
In alignment with the , MariaDB Enterprise ColumnStore 6.1.1 is provided for:
CentOS 7
CentOS 8
Debian 9
Debian 10
MariaDB Enterprise ColumnStore 6.3.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 fourth release in the Enterprise ColumnStore 6 series.
MariaDB Enterprise ColumnStore 6.3.1 was released on 2022-04-25. This release is of General Availability (GA) maturity.
This release of MariaDB Enterprise ColumnStore is included with MariaDB Enterprise Server 10.6.7-3.
Deprecated and historical values have been removed from Columnstore.xml ()
Performance improvements. (, , , )
Segfault in Storage Manager due to thread limits. ()
Segfault when using distributed aggregate functions. ()
Segfault during cpimport to table with large column count. ()
ExeMgr crashes after a large join, resulting in client-side error ERROR 1815 (HY000): Internal error: IDB-2004: Cannot connect to ExeMgr. ()
ROUND() on DOUBLE in case statements in conjunction with subqueries can generate incorrect value. ()
CRC32(), when called with two arguments, against a ColumnStore table, returns the wrong value. ()
A query with filter condition on subquery with window function can return the wrong result. ()
Incorrect help text. ()
On Debian, non-interactive upgrade complains that /etc/columnstore/Columnstore.xml has been modified since installation. ()
Upgrade from ColumnStore 5 to ColumnStore 6 does not restore saved configuration files. ()
Prior to this release, configuration files were saved at uninstall but not restored upon upgrade.
With this release, ColumnStore configuration files are properly restored upon reinstall. New parameters, included in the configuration files packaged with the release, will not be merged and must be migrated manually.
In alignment with the , MariaDB Enterprise ColumnStore 6.3.1 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)
This page is: Copyright © 2025 MariaDB. All rights reserved.
6.4.1 is a maintenance release of . MariaDB Enterprise ColumnStore is a columnar storage engine included with MariaDB Enterprise Server. This is the fifth release in the Enterprise ColumnStore 6 series.
MariaDB Enterprise ColumnStore 6.4.1 was released on 2022-07-12. This release is of General Availability (GA) maturity.
This release of MariaDB Enterprise ColumnStore is included with MariaDB Enterprise Server 10.6.8-4.
ERROR 1178 (42000): The storage engine for the table doesn't support IDB-1001: Function 'convert_tz' isn't supported.With this release, when manually upgrading (uninstall and reinstall), the server.cnf is replaced with the packaged copy.
With this release, when upgrading by repository, the existing server.cnf is retained.
Ubuntu 20.04 (x86_64)
Increased DECIMAL precision (MCOL-641)
The maximum precision of DECIMAL (fixed-point numeric data type) is 38.
Prior to this release, the maximum precision of DECIMAL was 18.
The columnstore_decimal_overflow_check system variable allows Enterprise ColumnStore to check for decimal overflows when working with DECIMAL values of precision >= 18. For additional information, see "Enable Decimal Overflow Checks".
Increased DECIMAL precision used by the AVG() and SUM() aggregate functions when aggregating integer data types (MCOL-4603)
The AVG() and SUM() aggregate functions have a maximum precision of 38 digits. This enables AVG() and SUM() to work with larger integer values with less risk of overflow.
Prior to this release, the AVG() and SUM() aggregate functions had a maximum precision of 18 digits.
Transactional tables can be updated with data from ColumnStore tables (MCOL-1482)
Through enhancement to Cross-Engine JOIN capabilities, UPDATE statements can update transactional tables (such as InnoDB and MyRocks) with data from ColumnStore tables:
With this release, SELECT .. OFFSET .. FETCH syntax is available as an alternative to LIMIT .. OFFSET
The syntax is:
Example usage:
For additional information, see "Configure the Select Handler".
Optimizer statistics store NDV (Number of Distinct Values) for ColumnStore tables (MCOL-4713)
Optimizer statistics can be collected for ColumnStore tables by executing the ANALYZE TABLE statement.
ColumnStore uses the optimizer statistics to add support for queries that contain circular inner joins.
In previous releases, ColumnStore would raise the following error when a query containing a circular inner join was executed:
Red Hat Enterprise Linux 8
SUSE Linux Enterprise Server 12
SUSE Linux Enterprise Server 15
Ubuntu 18.04
Ubuntu 20.04
ColumnStore now includes Cluster Management API (CMAPI) 6.4.1.
ColumnStore has optimized the storage and usage of the Extent Map to improve scalability. (MCOL-4917)
The Extent Map is now stored as a red-black tree instead of a linear array.
The Extent Map's new data structure provides optimizations for many operations.
The mcsRebuildEM utility now supports both the ColumnStore Object Storage Topology and the ColumnStore Shared Local Storage Topology. ()
The mcsRebuildEM utility now calculates the high water mark for system catalog files. ()
ColumnStore's systemd unit files use startup and shutdown timeouts that are too low, which can lead to race conditions during startup and shutdown. (MCOL-4775, MCOL-4867, MCOL-5105)
The race conditions could cause the Extent Map to become corrupt.
The race conditions could also cause the DMLProc process to repeatedly try to rollback the same transactions in a crash loop.
When a recursive CTE is executed with a ColumnStore table, the server crashes. ()
Starting with this release, when a recursive CTE is executed with a ColumnStore table, the ER_CHECK_NOT_IMPLEMENTED error code is raised to the client with the following message:
<.
ERROR 1178 (42000): The storage engine for the table doesn't support Recursive CTE
<>
When a disk-based JOIN is executed, ExeMgr can crash. ()
Internal installation scripts refer to legacy OAM components and can break some installations. (MCOL-5060)
In alignment with the enterprise lifecycle, MariaDB Enterprise ColumnStore 6.4.1 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)
Rocky Linux 8 (x86_64)
Ubuntu 18.04 (x86_64)
Ubuntu 20.04 (x86_64)
This page is: Copyright © 2025 MariaDB. All rights reserved.
UPDATE innodb_tab i
JOIN columnstore_tab c
ON i.col1 = c.col1
SET i.col2 = c.col2;OFFSET start { ROW | ROWS }
FETCH { FIRST | NEXT } [ count ] { ROW | ROWS } ONLYSELECT username, purchase
FROM user_purchases
ORDER BY username, purchase
OFFSET 0 ROWS
FETCH NEXT 10 ROWS ONLY;$ cskeys
$ cspasswd '<plain_text_passwd>'
$ mcsSetConfig CrossEngineSupport Password '<encrypted_passwd>'ERROR 1815 (HY000): Internal error: IDB-1003: Circular joins are not supported.MariaDB Enterprise ColumnStore 6.4.8 is a maintenance release of MariaDB Enterprise ColumnStore . MariaDB ColumnStore is a columnar storage engine included with MariaDB Enterprise Server and MariaDB Community Server 10.6, 10.11, and 11.0. This is a release in the ColumnStore 6 series.
MariaDB Enterprise ColumnStore 6.4.8 was released on 2024-02-07. This release is of General Availability (GA) maturity.
This release of MariaDB ColumnStore is included with MariaDB Community Server 10.11.7 and MariaDB Community Server 10.6.17
Compile error under GCC-13.2.1 (fc39) ()
Fails to build against MariaDB Community -11.0 handler::scan_time() changed ()
In alignment with the , MariaDB ColumnStore 6.4.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)
This page is: Copyright © 2025 MariaDB. All rights reserved.
Ubuntu 18.04 (x86_64)
Ubuntu 20.04 (x86_64)
This page is: Copyright © 2025 MariaDB. All rights reserved.