What's New in MariaDB ColumnStore 1.5?

MariaDB ColumnStore 1.5 introduces the following new features:

MariaDB Server Convergence

MariaDB ColumnStore 1.5 converges with MariaDB Server even further:

  • It uses a simplified installation procedure, which is similar to other MariaDB Server storage engines.

  • It supports even more queries and other features that are supported by MariaDB Server.

Enterprise

MariaDB ColumnStore 1.5 is included with MariaDB Enterprise Server 10.5:

Community

MariaDB ColumnStore 1.5 is included with MariaDB Community Server 10.5:

Simplified Installation

MariaDB ColumnStore 1.5 simplifies the installation process:

OAM Replacement

MariaDB ColumnStore 1.5 replaces the OAM with a new REST API:

  • It provides simplified administration for multi-node ColumnStore deployments.

  • It removes the need to configure SSH between nodes in a multi-node ColumnStore deployment.

  • It uses systemd to manage its processes.

Character Sets and Collations

MariaDB ColumnStore 1.5 adds support for more character sets and collations in more scenarios:

  • It uses a column's defined collation to sort the column for ORDER BY operations, rather than always sorting with latin1_general_cs.

  • It adds support for the COLLATE clause in CREATE TABLE and ALTER TABLE statements.

  • It adds support for the COLLATE clause in ORDER BY clauses.

S3-Compatible Object Storage

MariaDB ColumnStore 1.5 adds further enhancements to its capabilities with S3-compatible object storage:

  • It ensures that Storage Manager shuts down properly when a fatal error occurs.

  • It adds support to cpimport for multi-node ColumnStore deployments that use S3-compatible object storage.

Query Compatibility

Improved Support for DDL

MariaDB ColumnStore 1.5 adds support for additional Data Definition Language (DDL) statements:

Improved Support for DML

MariaDB ColumnStore 1.5 adds support for additional Data Manipulation Language (DML) statements:

  • It improves support for using the LOAD DATA INFILE statement within a transaction.

  • It adds support for microseconds to the FROM_UNIXTIME() function.

  • It improves support for the EXPLAIN statement.

Improved Support for Window Functions

MariaDB ColumnStore 1.5 adds support for additional queries that use window functions:

  • It adds support for using an IN() in a WHERE clause when the query uses a window function.

  • It adds support for COUNT(NULL) OVER().

For a complete list of changes, see MariaDB ColumnStore 1.5.2 release notes.