The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

MariaDB ColumnStore 1.1.1 Release Candidate Release Notes

Release date: 3rd November 2017

MariaDB ColumnStore 1.1.1 is a Release Candidate release of MariaDB ColumnStore. This is the second release of the MariaDB ColumnStore 1.1 series. The MariaDB ColumnStore 1.1 series provides several new features and improvements over the MariaDB ColumnStore 1.0 release.

MariaDB ColumnStore 1.1.1 is a Release Candidate release.

Do not use Release Candidate 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

  1. MariaDB ColumnStore 1.1.1 is based on MariaDB Server 10.2.10
  2. Java and Python bindings are available for the Write Data API

Bugs and issues fixed

  • MCOL-662 - Unexpected results in cross engine join
  • MCOL-667 - Installation of MCS updates the root .bashrc file
  • MCOL-750 - make the remote server install scripts run faster by checking for ssh/scp return codes
  • MCOL-783 - Recursive Common Table Expressions caused mysqld to crash
  • MCOL-786 - redistribute remove moved data from removed node to one node
  • MCOL-859 - Running TRUNCATE on many tables in parallel seems to eventually deadlock
  • MCOL-877 - Not all data escaped when inserting with select statement from innodb table into columnstore
  • MCOL-895 - INSERT after ALTER TABLE can corrupt HWM
  • MCOL-898 - NULL operand ignored in vtable mode when querying view
  • MCOL-911 - exemgr crashes with a nested aggregate multiplication query
  • MCOL-913 - DistributeConfigFile Failed messages after adding modules
  • MCOL-914 - Warning messages for the RemoveModule command should be improved
  • MCOL-915 - Improve the output from the RemoveModule command
  • MCOL-916 - Gluster failover: Stack did not recover completely after PM1 reboot
  • MCOL-926 - UDAF returns null for 2nd or more applications against same column
  • MCOL-928 - postConfigure is not detecting glusterfs on Debian9.1 for non-root user
  • MCOL-929 - switchparentoammodule cores when pm2 is active on a 1um/2pm Data Redundancy system
  • MCOL-938 - columnstore replication failover from master updates server-id
  • MCOL-943 - multi-node postConfigure fails when mysql password is set.
  • MCOL-944 - coalesce with count(distinct) can lead to incorrect results
  • MCOL-945 - MariaDBReplication slave messages is incorrectly sending updates to PM nodes
  • MCOL-946 - migrate to swig for mcsapi python binding
  • MCOL-951 - tpcds query 17 fails with invalid colum width
  • MCOL-959 - invalid LD_LIBRARY_PATH for non root install
  • MCOL-963 - self join cte queries from tpcds alternately fail with parsing error and succeed but with incorrect results
  • MCOL-965 - group_contact with order by on joined table causes error
  • MCOL-971 - 1.0 to 1.1 non-root upgrade issue - problem shows after a reboot, still using 1.0 ENV variables
  • MCOL-972 - PmMaxMemorySmallSide configuration value not carried forward in upgrade
  • MCOL-973 - ArithmaticColumn parsing can cause crash
  • MCOL-979 - Crash with LEAD function in ColumnStore with 'char' field type
  • MCOL-982 - Merge MariaDB 10.2.9 into ColumnStore
  • MCOL-984 - Error 1815 after several executions of example/basic_bulk_insert having SMALLINT in t1
  • MCOL-988 - 1um/2pm DataRep system starting up without a ProcessManager in HOT_STANDBY state
  • MCOL-990 - provide a resetRow method
  • MCOL-992 - java binding for mcsapi
  • MCOL-1000 - Merge MariaDB 10.2.10

In addition, all bugs fixed in MariaDB ColumnStore 1.0.11 and earlier are implicitly included in this release.

Upgrade

Multi version upgrades are not supported, please upgrade versions prior to 1.1.0 before upgrading to 1.1.1:

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-271 empty string values are treated as NULL. This means you cannot insert empty values into a NOT NULL string column.
  • MCOL-365: Log files created by load data infile remain in the bulk/data/log and /tmp directories. If storage is a concern these can safely be removed.
  • MCOL-540 : In a non root Ubuntu install with local query enabled, the PM servers crash and restart on table creation.
  • MCOL-624 :MariaDB 10.2 WF create MEDIAN, PERCENTILE_CONT and PERCENTILE_DISC Window functions. MariaDB ColumnStore 1.1 was rewritten to use the MariaDB 10.2 server parser code which does not support the percentile window functions. This will be added in a later release. A median function has been provided instead as part of the User Defined Aggregate Function framework that provides similar functionality or can be adapted to support percentiles other than 0.5.
  • MCOL-631 :Create table caused primproc crashed for a specific configuration
  • MCOL-643 :Implement ha_calpont_impl_rnd_pos. Sorting of long text columns may fail.
  • MCOL-695 :Implement joins between CHAR/VARCHAR and INT columns. ColumnStore now fails more consistently on incompatible join types. Explicit type casts must be used if this error is hit.
  • MCOL-713 : Some functions return "The maximum row size" error when TEXT/LONGTEXT is used in a table
  • MCOL-912 : fter adding two PMs with gluster, cpimport failed on newly added PMs. The system must be restarted after adding PM modules with data redundancy / gluster storage.
  • The current logging default generates full verbose debug logs. This can be controlled by making logging configuration changes as described here.
  • While Millisecond and Microsecond storage is supported for datetime, time and timestamp columns, at this time the query results cannot return millisecond and microseconds.
  • UTF-8 Limitation
    • UTF-8 must be declared at the table level if the instance has been set up with a UTF-8 profile. Tables created with a non-matching character set will yield indeterminate results.
    • Viewing SQL output should be done using client software that supports UTF-8 character sets.
    • UTF-8 characters are not supported in object names.
  • Known security issues and fixes are documented here.

Documentation

MariaDB ColumnStore Documentation

Packaging

RPM, Debian, and binary packages are provided for the Linux distributions supported by MariaDB ColumnStore 1.1.1 RC version.

  • The supported OS for the GA version are CentOS 6, CentOS 7, Debian 8.6, Debian 9.1, RedHat 6, RedHat 7, SUSE 12, and Ubuntu 16.0.4.
  • Packages can be downloaded here
  • An Amazon AWS AMI Image is available for this release, please search for AMI name "MariaDB-ColumnStore-1.1.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

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.