MariaDB ColumnStore 5.4.1 Release Notes

Overview

MariaDB Enterprise ColumnStore is a columnar storage engine included with MariaDB Enterprise Server. This is the first release in the Enterprise ColumnStore 5 series, which succeeds Enterprise ColumnStore 1.5.3.

This release is focused on architectural change, product quality, and improved alignment to MariaDB Enterprise Server.

This release of MariaDB Enterprise ColumnStore is included with MariaDB Enterprise Server 10.5.6-4.

This release is of General Availability (GA) maturity.

MariaDB Enterprise ColumnStore 5.4.1 was released on 2020-10-20.

• Documentation

Notable Changes

Multi-Node Changes

• Multi-node Enterprise ColumnStore 5.4.1 requires MaxScale 2.5.
• Multi-node Enterprise ColumnStore 5.4.1 requires shared storage, such as GlusterFS, EFS, and NFS. It also optionally supports S3-compatible storage for data, but it still requires shared storage for metadata.
• The CMAPI (Cluster Management API) has been updated. Multi-node Enterprise ColumnStore 5.4.1 uses CMAPI 1.1, which still uses version 0.4.0 of the REST API. (MCOL-3909)

Security Changes

• Support for IAM roles for Amazon S3. (MCOL-3976)
• Support for ColumnStore running as non-root user. (MCOL-4012)

Client Changes

• Support for Power BI Direct Query Adapter. (MCOL-3935)

Issues Fixed

• Changed default configuration for memory usage, blocks, and set table names. (MCOL-4252)
• Prepared Statements causing Signal 11. (MCOL-4282)
• Running COUNT() when the sql_select_limit system variable is set may leave the table badly (MCOL-4278)
• New segments files created during bulk insertion with cpimport belong to root (MCOL-4328)
• Join operations return errors when using upper-case table names. (MCOL-4290)
• Permissions issue in /tmp/columnstore_tmp_files (MCOL-4265)
• RENAME TABLE leaving table unusable. (MCOL-3701)
• Errors returned when using upper-case database names. (MCOL-4144)
• Server crashing when running queries where no default schema was provided. (MCOL-3464)
• Regression in subqueries. (MCOL-4179)
• CMAPI issues configuring multi-node ColumnStore deployment. (MCOL-4226)
• Changed default common_prefix_depth for S3 to accommodate new paths. (MCOL-3651)
• Join operations failing on views. (MCOL-3814)
• Crash/assertion failure after "RWLock failed to attach to the InfiniDB-shm-00020000 shared mem segment, got Permission denied" (MCOL-4283)
• SUM() and AVG() functions in subqueries returning 0. (MCOL-4247)
• CEILING() function returning wrong answer for datetimes. (MCOL-4236)
• CMAPI Server not gracefully handling first nodes with unresolved names in /etc/hostname (MCOL-4223)
• Case sensitivity in LOCATE(), INSTR(), and FIND_IN_SET() functions. (MCOL-4100)
• INSERT() function not inserting. (MCOL-4099)
• SQL syntax error when uninstalling Columnstore plugin package. (MCOL-4087)
• Replication of InnoDB into ColumnStore ends in SEGV in plugin. (MCOL-4181)
• Unclear error message when postConfigure fails to access online S3 storage. (MCOL-3494)
• Integrate with the cluster management code. (MCOL-4055)
• Column not found in info map when querying views. (MCOL-3827)
• Query failures on UPDATE statements to InnoDB tables when WHERE clause includes a sub-query on a ColumnStore table. (MCOL-4264)
• UPDATE... SET statements not updating when using another table. (MCOL-4303)
• Multi-node not working after executing stop and start commands. (MCOL-4227)
• Custom cross-engine join user unable to connect. (MCOL-4322)
• Hangs when requesting data from ColumnStore extents or files. (MCOL-4330)
• columnstore-post-install and mariadb-columnstore-start.sh fixed to use absolute paths. (MCOL-4335)
• Procedures hanging when using ColumnStore tables. (MCOL-4334)
• CMAPI returning error messages when using custom replication user credentials. (MCOL-4289)
• CMAP incorrectly sed parsing & character for CMAPI key. (MCOL-4297)
• Database user access unrestricted by IP addresses. (MCOL-4293)
• Stored procedures failing for Information Schema tables. (MCOL-4332)

Interface Changes

• columnstore_cache_flush_threshold system variable added
• columnstore_cache_inserts system variable added
• columnstore_select_handler_in_stored_procedures system variable added
• mariadbd --columnstore-cache-flush-threshold command-line option added
• mariadbd --columnstore-cache-inserts command-line option added
• mariadbd --columnstore-select-handler-in-stored-procedures command-line option added

Platforms

In alignment to the enterprise lifecycle, MariaDB Enterprise ColumnStore 5.4.1 is provided for:

• CentOS 8
• CentOS 7
• Debian 10
• Debian 9
• Red Hat Enterprise Linux 8
• Red Hat Enterprise Linux 7
• SUSE Linux Enterprise Server 15
• SUSE Linux Enterprise Server 12
• Ubuntu 20.04
• Ubuntu 18.04
• Ubuntu 16.04

Installation Instructions

• ColumnStore Object Storage Topology with MariaDB Enterprise Server 10.5 and MariaDB Enterprise ColumnStore 5.
• ColumnStore Shared Local Storage Topology with MariaDB Enterprise Server 10.5 and MariaDB Enterprise ColumnStore 5.
• HTAP Topology with MariaDB Enterprise Server 10.5 and MariaDB Enterprise ColumnStore 5.
• Single-Node Enterprise ColumnStore 5 with MariaDB Enterprise Server 10.5 and Object Storage.
• Single-Node Enterprise ColumnStore 5 with MariaDB Enterprise Server 10.5.

Upgrade Instructions

• Major Release Upgrades for MariaDB Enterprise ColumnStore.