MariaDB ColumnStore 1.2.0 Alpha Release Notes
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 MariaDB ColumnStore Architectural Overview
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-392 - TIME data type is now supported
MCOL-320 - TIME and DATETIME data types now support microseconds
MCOL-497 - Cross Engine Joins now support SSL connections
Improved DDL syntax support
MCOL-497 - BOOL / BOOLEAN alias for TINYINT now supported - with thanks to community contributor "tntnatbry"
MCOL-573 - Backticks & reserved words now supported
MCOL-716 - Non-alphanumeric table/column names now supported
MCOL-1201 - User Defined Aggregate / Window Functions now support multiple parameters.
MCOL-521 - Regression aggregate and windows functions are now supported.
MCOL-1577 - CREATE TABLE...LIKE now supported
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
Bugs and issues fixed
MCOL-1322 - data corruption when setting NUMERIC columns to NULL through the python and C++ API
MCOL-1523 - OAM Process failover logic for DDLproc is incorrect - causing DDL to stop working
MCOL-1606 - PDI 8 - variable substitution doesn't work
MCOL-1648 - pymcsapi3 on Windows depends on the Python 3 release DLL it was compiled with
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
In addition, all bugs fixed in MariaDB ColumnStore 1.1.6 and earlier are implicitly included in this release.
Upgrade
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).
Known issues and limitations
There are a number bugs and known limitations within this version of MariaDB ColumnStore, the most serious of these are listed below.
MCOL-1782 - UPDATE and DELETE reported incorrect affected row count
MCOL-1792 - mcsapi can incorrectly insert milliseconds
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
Documentation
MariaDB ColumnStore Documentation
Packaging
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 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.0". AMI specific installation instructions can be found here.
Certified to run in Google Cloud Environment in the GA OSs.
Source code
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 - Source code for engine specific processes on UM and PM node
Write Data API - Source code for Write Data API /SDK
MaxScale CDC and Kafka Data Adapters - Source Code for data adapters
This page is: Copyright © 2025 MariaDB. All rights reserved.
Last updated
Was this helpful?