MariaDB [testdatabase]> CREATE TABLE rename_able (test INT(11)) ENGINE=Columnstore;

Query OK, 0 rows affected (0.15 sec)

MariaDB [testdatabase]> RENAME TABLE rename_able TO yes_renamed;

Query OK, 0 rows affected (0.08 sec)

MariaDB [testdatabase]> DROP TABLE yes_renamed;

Query OK, 0 rows affected (1.22 sec)

MariaDB [testdatabase]> CREATE TABLE dollar$_table (test INT(11)) ENGINE=Columnstore;

Query OK, 0 rows affected (0.19 sec)

MariaDB [testdatabase]> RENAME TABLE dollar$_table TO dollar$_also_renamed;

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.

MariaDB [testdatabase]> DROP TABLE dollar$_table;

Query OK, 0 rows affected (1.66 sec)

MariaDB [testdatabase]> CREATE TABLE rename_able (test INT(11)) ENGINE=Columnstore;

Query OK, 0 rows affected (0.17 sec)

MariaDB [testdatabase]> RENAME TABLE rename_able TO dollar$;

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.

MariaDB [testdatabase]> DROP TABLE rename_able;

Query OK, 0 rows affected (1.35 sec)

MariaDB [testdatabase]> status;

--------------

/usr/local/mariadb/columnstore/mysql/bin/mysql  Ver 15.1 Distrib 10.2.17-MariaDB, for Linux (x86_64) using readline 5.1

Connection id:		2607

Current database:	testdatabase

Current user:		testdatabaseadmin@localhost

SSL:			Not in use

Current pager:		stdout

Using outfile:		''

Using delimiter:	;

Server:			MariaDB

Server version:		10.2.17-MariaDB-log Columnstore 1.1.6-1

Protocol version:	10

Connection:		Localhost via UNIX socket

Server characterset:	latin1

Db     characterset:	latin1

Client characterset:	utf8

Conn.  characterset:	utf8

UNIX socket:		/usr/local/mariadb/columnstore/mysql/lib/mysql/mysql.sock

Uptime:			17 days 40 min 19 sec

Threads: 10  Questions: 22504  Slow queries: 0  Opens: 5984  Flush tables: 1  Open tables: 52  Queries per second avg: 0.015

--------------

MariaDB [testdatabase]>