Verifying that MariaDB ColumnStore is correctly installed

To verify that MariaDB ColumnStore is correctly installed, connect to MariaDB and ask for ColumnStore version:

  SHOW STATUS LIKE 'columnstore_version';

If this query does not return any result, ColumnStore is not installed. Otherwise, it will return ColumnStore version.

Now you can verify that ColumnStore is able to accept writes:

  CREATE SCHEMA IF NOT EXISTS cs_test;
  USE cs_test;
  CREATE TABLE cst (i INT) ENGINE ColumnStore;
  INSERT INTO cst VALUES (1);

If the last statement does not return any error, ColumnStore is able to accept writes.