MariaDB ColumnStore is a columnar storage engine for online analytical processing (OLAP), data warehousing, business intelligence, and hybrid transactional-analytical processing (HTAP). MariaDB ColumnStore is included with MariaDB Community Server.
Latest Software Releases
2021-05-07 MariaDB ColumnStore 5.5.2
Columnar storage engine that enables MariaDB Community Server to perform new workloads
Optimized for online analytical process (OLAP) workloads including data warehousing, decision support systems, and business intelligence
Single-stack solution for hybrid transactional-analytical workloads to eliminate barriers and prevent data silos
Implements cross-engine JOINs to join ColumnStore tables with tables using row-based storage engines, such as InnoDB
Smart storage engine that plans and optimizes its own queries using a custom select handler
S3-compatible object storage can be used for highly available, low-cost, multi-regional, resilient, scalable, secure, and virtually limitless data storage
Connectors for popular BI platforms such as Microsoft Power BI and Tableau
High-speed bulk data loading that bypasses the SQL layer and does not block concurrent read-only queries
Available in the cloud on MariaDB SkySQL DBaaS
Available for production on-premises deployments, with deployment instructions provided.
MariaDB ColumnStore supports multiple topologies. The options described on this page are representative of basic product capabilities.
MariaDB products can be deployed to form other topologies that leverage advanced product capabilities and combine the capabilities of multiple topologies.
The version of MariaDB ColumnStore depends on the version of MariaDB Community Server being used:
CS10.5.7 and later
CS10.5.6 and before
MariaDB ColumnStore is available on select platforms:
CentOS 7 (x86_64)
CentOS 8 (x86_64)
Debian 9 (x86_64)
Debian 10 (x86_64)
Debian 11 (x86_64)
Red Hat Enterprise Linux 7 (x86_64)
Red Hat Enterprise Linux 8 (x86_64)
SUSE Linux Enterprise Server 12 (x86_64)
SUSE Linux Enterprise Server 15 (x86_64)
Ubuntu 18.04 LTS (x86_64)
Ubuntu 20.04 LTS (x86_64)