MariaDB [mytest]> create table t1 (c1 int) engine=columnstore;

Query OK, 0 rows affected (0.119 sec)

MariaDB [mytest]> insert into t1 values (1),(2);

Query OK, 2 rows affected (0.132 sec)

Records: 2  Duplicates: 0  Warnings: 0

MariaDB [mytest]> select * from t1;

+------+

| c1   |

+------+

|    1 |

|    2 |

+------+

2 rows in set (0.023 sec)

MariaDB [mytest]> create table t2 (c1 int) engine=columnstore;

Query OK, 0 rows affected (0.209 sec)

MariaDB [mytest]> start transaction;

Query OK, 0 rows affected (0.000 sec)

MariaDB [mytest]> insert into t2 select * from t1;

Query OK, 2 rows affected (1.125 sec)

Records: 2  Duplicates: 0  Warnings: 0

MariaDB [mytest]> select * from t2;

Empty set (0.022 sec)

MariaDB [mytest]> exit