CREATE TABLE `t1` (
|
i int(11) NOT NULL,
|
c char(3) DEFAULT NULL
|
) ENGINE=Columnstore DEFAULT CHARSET=latin1 COMMENT='autoincrement=i' ;
|
|
|
# initial insert test
|
insert into t1 (c) values ('t11');
|
insert into t1 values (0, 't12');
|
insert into t1 values (50, 't13');
|
select * from t1;
|
+----+------+
|
| i | c |
|
+----+------+
|
| 1 | t11 |
|
| 2 | t12 |
|
| 50 | t13 |
|
+----+------+
|
|
select * from information_schema.columnstore_tables;
|
+--------------+------------+-----------+---------------+--------------+---------------+
|
| TABLE_SCHEMA | TABLE_NAME | OBJECT_ID | CREATION_DATE | COLUMN_COUNT | AUTOINCREMENT |
|
+--------------+------------+-----------+---------------+--------------+---------------+
|
| test | t1 | 3003 | 2017-01-22 | 2 | 1 |
|
+--------------+------------+-----------+---------------+--------------+---------------+
|
|
select * from calpontsys.systable;
|
+-----------+--------+----------+------------+------------+------+------+-----------+-----------+-------------+---------------+
|
| tablename | schema | objectid | createdate | lastupdate | init | next | numofrows | avgrowlen | numofblocks | autoincrement |
|
+-----------+--------+----------+------------+------------+------+------+-----------+-----------+-------------+---------------+
|
| t1 | test | 3003 | 2017-01-22 | NULL | NULL | NULL | NULL | NULL | NULL | 1 |
|
+-----------+--------+----------+------------+------------+------+------+-----------+-----------+-------------+---------------+
|
|