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

CHARACTER SET problem in ColumnStore?

I'm trying to create this table:

CREATE TABLE `table1` ( `name` char(3) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL DEFAULT '') ENGINE=Columnstore;

ERROR 1178 (42000): The storage engine for the table doesn't support The syntax or the data type(s) is not supported by Columnstore. Please check the Columnstore syntax guide for supported syntax or data types.

Any idea why this is not working?

BR, Daniel

Answer Answered by David Thompson in this comment.

Column level character set settings and the collate option are not currently supported. Instance level (see UTF8 section https://mariadb.com/kb/en/mariadb/mariadb-columnstore-system-usage/) or table level, for example:

CREATE TABLE table1 ( name char(3) NOT NULL DEFAULT '')default CHARACTER SET latin1 engine=columnstore;

An improvement has been filed: https://jira.mariadb.org/browse/MCOL-337

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.