Release date: 17th October 2018
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.
MariaDB ColumnStore 1.2.0 is a Alpha release.
Do not use alpha releases on production systems!
For an overview of MariaDB ColumnStore see
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
- The base MariaDB server version is now which include several maintenance and security fixes.
- TIME data type is
- TIME and DATETIME data types
- Cross Engine Joins now support SSL connections
- 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
- pymcsapi3 on Windows depends on the Python 3 release DLL it was compiled with
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
- mcsapi can incorrectly insert milliseconds
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 .
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.
The source code is available at these locations
Storage Engine -
MariaDB Server -
Tools -
Write Data API -
MCOL-1201 - User Defined Aggregate / Window Functions now support multiple parameters.
MCOL-521 - and are now supported.
MCOL-1577 - CREATE TABLE...LIKE
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
MCOL-1281 - Microsoft Windows 10 support for bulk write SDK
Pentaho data adapter is now also available for Windows 10
MCOL-1658 - support space names in columnstore table column names
MCOL-1701 - Change Windows mcsapi build to use libraries from external directory
MCOL-1644 - PDI plugin CI tests - add check with PDI 8
MCOL-1704 - javamcsapi - compatibility test fails if executed multiple times
MCOL-1761 - Test script for Win is searching for wrong named zip file
MCOL-1766 - Increase Gradle dependency resolution timeout to 5min
MCOL-1695 - Add OS information to Kettle zip file
MCOL-1713 - Add Windows suffix to kettle data adapter
MCOL-345 - Saturated time() func handling is different to MariaDB
MCOL-346 - Saturated addtime() func handling is different to MariaDB
MCOL-573 - CS does not support reserved words as column names
MCOL-807 - HOUR() function returns NULL when it should not
MCOL-876 - Renaming a table in non-current database fails
MCOL-1002 - cpimport with down system say InfiniDB
MCOL-1219 - Column name can not start with numeric value
MCOL-1322 - data corruption when setting NUMERIC columns to NULL through the python and C++ API
MCOL-1327 - CS objects' identifiers doesn't support U+0000..U+007f even when quoted
MCOL-1377 - ColumnStore system logging not working after 1.1.4 ubuntu-16 install
MCOL-1379 - Scala connector won't compile in Ubuntu 18.04
MCOL-1386 - Create table statement doesn't allow usage of C style comments in it
MCOL-1520 - Forked server crashes in Item_ident::print() for a Temptable_field.
MCOL-1684 - Performance Schema crashes prepared statement
MCOL-1701 - Change Windows mcsapi build to use libraries from external directory
MCOL-1766 - Increase Gradle dependency resolution timeout to 5min
MCOL-266 - BOOLEAN data type not supported
MCOL-320 - support query of milli and micro second time parts
MCOL-392 - TIME datatype is not supported
MCOL-497 - support ssl connection in cross engine joins
MCOL-521 - add distributed regression aggregate and window functions
MCOL-548 - clean up engine repo cmake warnings
MCOL-569 - CS does not support reserved words as table names
MCOL-716 - support non alphanumeric characters for table and column names
MCOL-978 - Disable Query Cache for ColumnStore
MCOL-1052 - Implement GROUP BY pushdown support
MCOL-1073 - DecomSvr should be removed
MCOL-1201 - Allow UDAnF to have multiple parameters defined.
MCOL-1242 - Remote CpImport
MCOL-1244 - make postConfigure default install non-distributed
MCOL-1281 - mcsapi Windows support
MCOL-1378 - Hardening Flags pt 2
MCOL-1385 - Merge MariaDB 10.3
MCOL-1392 - Add time field support for PDI plugin
MCOL-1424 - Make the default installation option to separate instead of combined.
MCOL-1577 - ColumnStore to allow CREATE TABLE table_name LIKE ... Syntax
MCOL-1633 - mcsapi Windows - add needed Windows Redistributables to installer
MCOL-1688 - Informatica PowerCenter Bulk Write Connector
MCOL-1759 - Implement regr_sxx, regr_syy, regr_sxy and corr functions as UDAF
MCOL-1773 - Add mcsimport to PATH
MCOL-1547 - Investigate renewed in 10.3 CASE implementation.
MCOL-1634 - Include Windows library build into mcsapi
MCOL-1417 - TIME: cpimort saturates reserved NULL and empty indicator values incorrectly
MCOL-1418 - TIME: LDI saturates out-of-range values incorrectly
MCOL-1419 - TIME: Update saturates out-of-range values incorrectly
MCOL-1427 - Microsecond values are stored left-justified with trailing 0 padding
MCOL-1428 - SUBTIME() as a WHERE condition on TIME data type caused primProc to hang
MCOL-1429 - DAYNAME() and MONTHNAME() on TIME data type columns caused primProc to restart
MCOL-1433 - Some functions return non-matching results after data type TIME was added to the functions test suite
MCOL-1496 - Joiner array boundary bug
MCOL-1799 - length() on BLOB data generates an error
MCOL-1786 - cpimport cannot handle "true" keyword for boolean/numeric data types in cpimport
MCOL-1805 - mcimport can show a warning about column sizes during import
MaxScale CDC and Kafka Data Adapters - Source Code for data adapters
This page is: Copyright © 2025 MariaDB. All rights reserved.