DDL Statements Different in ColumnStore

DDL statements that behave differently on MariaDB ColumnStore: DROP TABLE RESTRICT, RENAME TABLE cross-database limits, CREATE TABLE engine syntax, and CREATE INDEX restrictions.

In most cases, a ColumnStore table works just as any other MariaDB table. There are, however, a few differences.

The following table lists the data definition statements (DDL) that differ from normal MariaDB DDL when used on ColumnStore tables.

DDL	Difference
DROP TABLE	ColumnStore supports DROP TABLE ...RESTRICT which only drops the table in the front end.
RENAME TABLE	ColumnStore doesn't allow one to rename a table between databases.
CREATE TABLE	ColumnStore doesn't need indexes, partitions and many other table and column options. See here for ColumnStore Specific Syntax
CREATE INDEX	ColumnStore doesn't need indexes. Hence an index many not be created on a table that is defined with engine=columnstore

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}