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 |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/ddl-statements-that-differ-for-columnstore/