Alter Current Rowstore table into Columnstore table

Is there any way to alter table in rowstore into columnstore?

You can’t alter a rowstore to make it a columnstore directly, but you can do it like this:

memsql> create table rs(a int, b int);
Query OK, 0 rows affected (0.06 sec)

memsql> insert rs values(1,2);
Query OK, 1 row affected (0.08 sec)

memsql> create table cs(a int, b int, key(a) using clustered columnstore);
Query OK, 0 rows affected (0.11 sec)

memsql> insert into cs select a, b from rs;
Query OK, 1 row affected (0.15 sec)
Records: 1  Duplicates: 0  Warnings: 0

memsql> drop table rs;
Query OK, 0 rows affected (0.04 sec)

memsql> alter table cs rename rs;
Query OK, 0 rows affected (0.58 sec)
Records: 0  Duplicates: 0  Warnings: 0

memsql> select * from rs;
+------+------+
| a    | b    |
+------+------+
|    1 |    2 |
+------+------+

Thanks Hanson for your guidance.