All pages
Powered by GitBook
1 of 3

Loading...

Loading...

Loading...

MariaDB ColumnStore 5.4 Release Notes

Release notes for MariaDB ColumnStore 5.4.

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.

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. ()

Security Changes

  • Support for IAM roles for Amazon S3. ()

  • Support for ColumnStore running as non-root user. ()

Client Changes

  • Support for Power BI Direct Query Adapter. ()

Issues Fixed

  • Changed default configuration for memory usage, blocks, and set table names. ()

  • Prepared Statements causing Signal 11. ()

  • Running COUNT() when the sql_select_limit system variable is set may leave the table badly ()

  • New segments files created during bulk insertion with cpimport belong to root ()

Interface Changes

  • system variable added

  • system variable added

  • system variable added

  • command-line option added

Platforms

In alignment with the , MariaDB Enterprise ColumnStore 5.4.1 is provided for:

  • CentOS 8

  • CentOS 7

  • Debian 10

  • Debian 9

Installation Instructions

Upgrade Instructions

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)

  • mariadbd --columnstore-cache-inserts command-line option added

  • mariadbd --columnstore-select-handler-in-stored-procedures command-line option added

  • 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

  • MCOL-3909
    MCOL-3976
    MCOL-4012
    MCOL-3935
    MCOL-4252
    MCOL-4282
    MCOL-4278
    MCOL-4328
    columnstore_cache_flush_threshold
    columnstore_cache_inserts
    columnstore_select_handler_in_stored_procedures
    mariadbd --columnstore-cache-flush-threshold
    enterprise lifecycle
    Major Release Upgrades for MariaDB Enterprise ColumnStore
    MariaDB Enterprise ColumnStore

    MariaDB ColumnStore 5.4.3 Release Notes

    Overview

    MariaDB Enterprise ColumnStore is a columnar storage engine included with MariaDB Enterprise Server. This is the second release in the Enterprise ColumnStore 5 series.

    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.3 was released on 2020-11-09.

    • Documentation

    Issues Fixed

    • statements crashing the Server. ()

    • statements not working when selecting from to ColumnStore tables. ()

    • statements crashing when is set to ON or ALWAYS ()

    Platforms

    In alignment with the , MariaDB Enterprise ColumnStore 5.4.3 is provided for:

    • CentOS 8

    • CentOS 7

    • Debian 10

    • Debian 9

    Installation Instructions

    Upgrade Instructions

    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

  • MCOL-4364
    MCOL-4320
    MCOL-4370
    enterprise lifecycle
    Major Release Upgrades for MariaDB Enterprise ColumnStore
    columnstore_use_import_for_batchinsert
    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 23.10 with MariaDB Enterprise Server 10.5
    and Object Storage
    Single-Node Enterprise ColumnStore 23.10 with MariaDB Enterprise Server 10.5
    LOAD DATA INFILE
    INSERT SELECT
    InnoDB
    LOAD DATA INFILE
    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 23.10 with MariaDB Enterprise Server 10.5
    and Object Storage
    Single-Node Enterprise ColumnStore 23.10 with MariaDB Enterprise Server 10.5

    This page is: Copyright © 2025 MariaDB. All rights reserved.

    This page is: Copyright © 2025 MariaDB. All rights reserved.