What's New in MariaDB Enterprise ColumnStore 6?
MariaDB Enterprise ColumnStore 6 is included with MariaDB Enterprise Server 10.6.
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.
Increased DECIMAL Precision
The maximum precision of DECIMAL (fixed-point numeric data type) is
38. Prior to this release, the maximum precision of
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".
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. Prior to this release, Snappy compression was supported.
Update Transactional Data from ColumnStore Data
Through enhancement to Cross-Engine JOIN capabilities, UPDATE statements can update transactional tables (such as InnoDB and MyRocks) with data from ColumnStore tables:
UPDATE innodb_tab i JOIN columnstore_tab c ON i.col1 = c.col1 SET i.col2 = c.col2;
Enterprise ColumnStore's mandatory utility user is used for Cross-Engine JOIN. The mandatory utility user requires the UPDATE privilege.
Prior to 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.