MariaDB ColumnStore 1.2.5 is a GA release of MariaDB ColumnStore. The MariaDB ColumnStore 1.2 series provides several new features and improvements over the MariaDB ColumnStore 1.1 release.
Please provide feedback in JIRA for anything that is not working as expected so that we can fix it before we make the release available for the larger community.
For general "how to questions" ask questions here or subscribe to mariadb-columnstore@googlegroups.com
Notable changes
MCOL-3398 - The base MariaDB server version is now 10.3.16 which include several maintenance and security fixes.
- Critical regression in the dictionary storage of 1.2.4 fixed.
- Assertion failure when using HAVING with constant values
- Fix up regr functions in regrmysql.cpp so regr_* funtions work correcly for InnoDB tables
- cross engine join with space in column names in on condition cause fatal error
In addition, all bugs fixed in MariaDB ColumnStore 1.2.4 and earlier are implicitly included in this release.
The following procedure outlines upgrading a 1.1.7 ColumnStore install to 1.2.5:
The following procedure outlines upgrading a 1.2.x ColumnStore install to 1.2.5:
Multi version upgrades generally will work using the same procedure however we can't test every possible permutation so you should test your specific scenario outside of production first if you wish to try this (and this is good practice regardless).
There are a number bugs and known limitations within this version of MariaDB ColumnStore, the most serious of these are listed below.
- localquery mode tries to turn on replication and fails.
RPM, Debian, and binary packages are provided for the Linux distributions supported by MariaDB ColumnStore 1.2.5 GA version.
The supported OS for the GA version are CentOS 6, CentOS 7, Debian 8, Debian 9, RedHat 6, RedHat 7, SUSE 12, Ubuntu 16.04 and Ubuntu 18.04.
Packages can be downloaded or can be installed from the .
An Amazon AWS AMI Image is available for this release, please search for AMI name "MariaDB-ColumnStore-1.2.5". AMI specific installation instructions can be found .
The source code of MariaDB ColumnStore is tagged at GitHub with a tag, which is identical with the version of MariaDB ColumnStore. For instance, the tag of version X.Y.Z of MariaDB ColumnStore is columnstore-X.Y.Z. Further, master always refers to the latest released non-beta version.
MariaDB ColumnStore 1.2.3 is a GA release of MariaDB ColumnStore. The MariaDB ColumnStore 1.2 series provides several new features and improvements over the MariaDB ColumnStore 1.1 release.
Please provide feedback in JIRA for anything that is not working as expected so that we can fix it before we make the release available for the larger community.
For general "how to questions" ask questions here or subscribe to mariadb-columnstore@googlegroups.com
Notable changes
MCOL-2218 - The base MariaDB server version is now 10.3.13 which include several maintenance and security fixes.
- Jemalloc is a new dependency for MariaDB ColumnStore.
- The maximum possible value for AVG() and SUM() has significantly increased due to the usage of long double.
- group_concat() consumes a great amount of memory
- Query doesn't try REDO_PHASE1
- Regression on working_tpch1/misc/bug3669 string pad compare not correct
In addition, all bugs fixed in MariaDB ColumnStore 1.2.2 and earlier are implicitly included in this release.
The following procedure outlines upgrading a 1.1.7 ColumnStore install to 1.2.3:
Multi version upgrades generally will work using the same procedure however we can't test every possible permutation so you should test your specific scenario outside of production first if you wish to try this (and this is good practice regardless).
There are a number bugs and known limitations within this version of MariaDB ColumnStore, the most serious of these are listed below.
- localquery mode tries to turn on replication and fails.
- Running TRUNCATE on a table that has been upgraded from 1.1 -> 1.2 can cause MariaDB server to crash. As a workaround you can DROP and recreate the table.
RPM, Debian, and binary packages are provided for the Linux distributions supported by MariaDB ColumnStore 1.2.3 GA version.
The supported OS for the GA version are CentOS 6, CentOS 7, Debian 8, Debian 9, RedHat 6, RedHat 7, SUSE 12, Ubuntu 16.04 and Ubuntu 18.04.
Packages can be downloaded or can be installed from the .
An Amazon AWS AMI Image is available for this release, please search for AMI name "MariaDB-ColumnStore-1.2.3". AMI specific installation instructions can be found .
The source code of MariaDB ColumnStore is tagged at GitHub with a tag, which is identical with the version of MariaDB ColumnStore. For instance, the tag of version X.Y.Z of MariaDB ColumnStore is columnstore-X.Y.Z. Further, master always refers to the latest released non-beta version.
MariaDB ColumnStore 1.2.2 is a GA release of MariaDB ColumnStore. The MariaDB ColumnStore 1.2 series provides several new features and improvements over the MariaDB ColumnStore 1.1 release.
Please provide feedback in JIRA for anything that is not working as expected so that we can fix it before we make the release available for the larger community.
For general "how to questions" ask questions here or subscribe to mariadb-columnstore@googlegroups.com
Notable changes
MCOL-1952 - The base MariaDB server version is now 10.3.11 which include several maintenance and security fixes.
- NumBlocksPct and TotalUmMemory can take fixed memory sizes instead of percentages
- mcsapi has been split into separate packages for every programming language
- The kafka package has been renamed
- Query doesn't process certain JOIN types with GROUP BY handler.
In addition, all bugs fixed in MariaDB ColumnStore 1.2.1 and earlier are implicitly included in this release.
The following procedure outlines upgrading a 1.1.6 ColumnStore install to 1.2.2:
Multi version upgrades generally will work using the same procedure however we can't test every possible permutation so you should test your specific scenario outside of production first if you wish to try this (and this is good practice regardless).
There are a number bugs and known limitations within this version of MariaDB ColumnStore, the most serious of these are listed below.
- INSERT...SELECT and LOAD DATA INFILE when used in a transaction as well as mcsapi can cause dictionary columns to be badly cached
- resumeDatabaseWrites can cause DML/DDL to go active all on UMs simultaneously
- localquery mode tries to turn on replication and fails.
RPM, Debian, and binary packages are provided for the Linux distributions supported by MariaDB ColumnStore 1.2.2 GA version.
The supported OS for the GA version are CentOS 6, CentOS 7, Debian 8, Debian 9, RedHat 6, RedHat 7, SUSE 12, Ubuntu 16.04 and Ubuntu 18.04.
Packages can be downloaded or can be installed from the .
An Amazon AWS AMI Image is available for this release, please search for AMI name "MariaDB-ColumnStore-1.2.2". AMI specific installation instructions can be found .
The source code of MariaDB ColumnStore is tagged at GitHub with a tag, which is identical with the version of MariaDB ColumnStore. For instance, the tag of version X.Y.Z of MariaDB ColumnStore is columnstore-X.Y.Z. Further, master always refers to the latest released non-beta version.
- regr tests depend on table that doesn't exist yet
- WF regression tests need fixing
- tablemode test failing in develop
- regr_slope() and regr_r2() produce incorrect result when used as window functions
- test022 regression
- need to be able to specify NumBlocksPct and TotalUmMemory explicitly
- ColumnStore table whose name contains $ cannot be renamed
- func_concat_ws type
- getsystemcpu & related commands always return 0 cpu usage
- getactivesqlstatements returns 'file open error'
- csv text "true" is mapped to 0 during import but should be parsed to 1
- Cross engine / Query stats doesn't show specific query errors
- PDI Plugin unresponsive if CS is not available
- mxs_adapter throws malloc error
- Our aliases break BASH
- vTpch10.sql and vTpch21.sql regression
- columnstoreClusterTester.sh script fails
- mxs_adapter assertion crash on multi table stream
- mcsapi should have view/clear table lock features
- Add a export function that utilizes (sequential) write from Spark workers
- Split mcsapi installation into different packages for C++, Java and Python
- mcsimport - depend on mcsapi only
- Allow prior/custom changes made to myCnf-include-args.text be added to new myCnf-include-args.text after upgrading
- Implement new CASE item type detection
- Change logo in mcsapi, PDI and mcsimport
- /var/log/mariadb/columnstore ownership set to 777 recursive
- Rebase develop 10.3.11
- Running TRUNCATE on a table that has been upgraded from 1.1 -> 1.2 can cause MariaDB server to crash. As a workaround you can DROP and recreate the table.
Certified to run in Google Cloud Environment in the GA OSs.
MariaDB ColumnStore 1.2.1 is an Beta release of MariaDB ColumnStore. This is the first release of the MariaDB ColumnStore 1.2 series. The MariaDB ColumnStore 1.2 series provides several new features and improvements over the MariaDB ColumnStore 1.1 release.
Please provide feedback in JIRA for anything that is not working as expected so that we can fix it before we make the release available for the larger community.
For general "how to questions" ask questions here or subscribe to mariadb-columnstore@googlegroups.com
Notable changes
- The base MariaDB server version is now which include several maintenance and security fixes.
- Non-root install now does not require sudo for the installation tools
- Amazon AMI support for Instances with ENA drivers
- Adapter can't recognize database schema written with backtick
- PDI CS not work in the Pentaho Sever repository
- Test failing in develop
In addition, all bugs fixed in MariaDB ColumnStore 1.2.0 and earlier are implicitly included in this release.
The following procedure outlines upgrading a 1.2.0 ColumnStore install to 1.2.1:
Multi version upgrades generally will work using the same procedure however we can't test every possible permutation so you should test your specific scenario outside of production first if you wish to try this (and this is good practice regardless).
There are a number bugs and known limitations within this version of MariaDB ColumnStore, the most serious of these are listed below.
- mcimport can show a warning about column sizes during import
- regr_slope() and regr_r2() produce incorrect result when used as window functions
RPM, Debian, and binary packages are provided for the Linux distributions supported by MariaDB ColumnStore 1.2.0 Alpha version.
The supported OS for the Alpha version are CentOS 6, CentOS 7, Debian 8, Debian 9, RedHat 6, RedHat 7, SUSE 12, Ubuntu 16.04 and Ubuntu 18.04.
Packages can be downloaded or can be installed from the .
An Amazon AWS AMI Image is available for this release, please search for AMI name "MariaDB-ColumnStore-1.2.0". AMI specific installation instructions can be found .
The source code of MariaDB ColumnStore is tagged at GitHub with a tag, which is identical with the version of MariaDB ColumnStore. For instance, the tag of version X.Y.Z of MariaDB ColumnStore is columnstore-X.Y.Z. Further, master always refers to the latest released non-beta version.
MariaDB ColumnStore 1.2.4 GA Release Notes (Release removed)
Release date: 29th May 2019
This version has been removed from production due to having the potential to corrupt databases.
is a GA release of MariaDB ColumnStore. The MariaDB ColumnStore 1.2 series provides several new features and improvements over the MariaDB ColumnStore 1.1 release.
For an overview of see
Please provide feedback in for anything that is not working as expected so that we can fix it before we make the release available for the larger community.
For general "how to questions" ask questions or subscribe to mariadb-columnstore@googlegroups.com
MCOL-1782 - UPDATE and DELETE reported incorrect affected row count
MCOL-1786 - Handle "true" keyword for numeric data types in cpimport - with thanks to community contributor "tntnatbry"
MCOL-1792 - Timestamp --> Datetime insert: milliseconds are wrongly inserted in CS
MCOL-3315 - The base MariaDB server version is now 10.3.15 which include several maintenance and security fixes.
MCOL-3270 - cpimport performance for dictionary data is up to 2x faster.
MCOL-2061 - If you are performing a major version upgrade or have in the past there is a new stored procedure called columnstore_info.columnstore_upgrade() should be executed.
Multi version upgrades generally will work using the same procedure however we can't test every possible permutation so you should test your specific scenario outside of production first if you wish to try this (and this is good practice regardless).
There are a number bugs and known limitations within this version of MariaDB ColumnStore, the most serious of these are listed below.
MCOL-1990 - localquery mode tries to turn on replication and fails.
RPM, Debian, and binary packages are provided for the Linux distributions supported by MariaDB ColumnStore 1.2.4 GA version.
The supported OS for the GA version are CentOS 6, CentOS 7, Debian 8, Debian 9, RedHat 6, RedHat 7, SUSE 12, Ubuntu 16.04 and Ubuntu 18.04.
Packages can be downloaded here or can be installed from the repositories.
An Amazon AWS AMI Image is available for this release, please search for AMI name "MariaDB-ColumnStore-1.2.4". AMI specific installation instructions can be found here.
Certified to run in Google Cloud Environment in the GA OSs.
The source code of MariaDB ColumnStore is tagged at GitHub with a tag, which is identical with the version of MariaDB ColumnStore. For instance, the tag of version X.Y.Z of MariaDB ColumnStore is columnstore-X.Y.Z. Further, master always refers to the latest released non-beta version.
MariaDB ColumnStore 1.2.0 is an Alpha release of MariaDB ColumnStore. This is the first release of the MariaDB ColumnStore 1.2 series. The MariaDB ColumnStore 1.2 series provides several new features and improvements over the MariaDB ColumnStore 1.1 release.
Please provide feedback in JIRA for anything that is not working as expected so that we can fix it before we make the release available for the larger community.
For general "how to questions" ask questions here or subscribe to mariadb-columnstore@googlegroups.com
Notable changes
- The base MariaDB server version is now which include several maintenance and security fixes.
- TIME data type is
- TIME and DATETIME data types
- data corruption when setting NUMERIC columns to NULL through the python and C++ API
- OAM Process failover logic for DDLproc is incorrect - causing DDL to stop working
- PDI 8 - variable substitution doesn't work
In addition, all bugs fixed in MariaDB ColumnStore 1.1.6 and earlier are implicitly included in this release.
The following procedure outlines upgrading a 1.1.6 ColumnStore install to 1.2.0:
Multi version upgrades generally will work using the same procedure however we can't test every possible permutation so you should test your specific scenario outside of production first if you wish to try this (and this is good practice regardless).
There are a number bugs and known limitations within this version of MariaDB ColumnStore, the most serious of these are listed below.
- mcsapi regression
- regression of , trailing space string matching in VARCHAR
- UPDATE and DELETE reported incorrect affected row count
RPM, Debian, and binary packages are provided for the Linux distributions supported by MariaDB ColumnStore 1.2.0 Alpha version.
The supported OS for the Alpha version are CentOS 6, CentOS 7, Debian 8, Debian 9, RedHat 6, RedHat 7, SUSE 12, Ubuntu 16.04 and Ubuntu 18.04.
Packages can be downloaded or can be installed from the .
An Amazon AWS AMI Image is available for this release, please search for AMI name "MariaDB-ColumnStore-1.2.0". AMI specific installation instructions can be found .
The source code of MariaDB ColumnStore is tagged at GitHub with a tag, which is identical with the version of MariaDB ColumnStore. For instance, the tag of version X.Y.Z of MariaDB ColumnStore is columnstore-X.Y.Z. Further, master always refers to the latest released non-beta version.
MCOL-1242 - A remote bulk data import tool is now available which allows loading data directly from any server. This tool is included in the MariaDB ColumnStore Tools package