MariaDB [tt]> create table lu1 (id int) engine=columnstore;
|
Query OK, 0 rows affected (4.591 sec)
|
|
MariaDB [tt]> insert into lu1 (id) values(1);
|
Query OK, 1 row affected (0.662 sec)
|
|
MariaDB [tt]> select * from calpontsys.systable where tablename = 'lu1';
|
+-----------+--------+----------+------------+------------+------+------+-----------+-----------+-------------+---------------+
|
| tablename | schema | objectid | createdate | lastupdate | init | next | numofrows | avgrowlen | numofblocks | autoincrement |
|
+-----------+--------+----------+------------+------------+------+------+-----------+-----------+-------------+---------------+
|
| lu1 | tt | 3022 | 2019-06-07 | NULL | NULL | NULL | NULL | NULL | NULL | 0 |
|
+-----------+--------+----------+------------+------------+------+------+-----------+-----------+-------------+---------------+
|
1 row in set (0.092 sec)
|