DDL statements that differ for ColumnStore
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.
|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|