GBase 8a数据库集群从V95版本开始支持分区,并在数据库的information_schema.partitions里记录了元数据信息。
其它分区表介绍,请参考:
GBase 8a集群支持分区表功能使用样例
GBase 8a 元数据表介绍
GBase 8a分区表指定特定分区的查询方法
目录导航
样例表
create table p1(id int)
partition by range(id)(
partition p1 values less than (10),
partition po values less than MAXVALUE
);
元数据查询结果
gbase> select * from information_schema.partitions where table_name='p1';
+---------------+--------------+------------+----------------+-------------------+----------------------------+-------------------------------+------------------+---------------------+----------------------+-------------------------+-----------------------+------------+----------------+-------------+-----------------+--------------+-----------+---------------------+---------------------+------------+----------+-------------------+-----------+-----------------+
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | PARTITION_NAME | SUBPARTITION_NAME | PARTITION_ORDINAL_POSITION | SUBPARTITION_ORDINAL_POSITION | PARTITION_METHOD | SUBPARTITION_METHOD | PARTITION_EXPRESSION | SUBPARTITION_EXPRESSION | PARTITION_DESCRIPTION | TABLE_ROWS | AVG_ROW_LENGTH | DATA_LENGTH | MAX_DATA_LENGTH | INDEX_LENGTH | DATA_FREE | CREATE_TIME | UPDATE_TIME | CHECK_TIME | CHECKSUM | PARTITION_COMMENT | NODEGROUP | TABLESPACE_NAME |
+---------------+--------------+------------+----------------+-------------------+----------------------------+-------------------------------+------------------+---------------------+----------------------+-------------------------+-----------------------+------------+----------------+-------------+-----------------+--------------+-----------+---------------------+---------------------+------------+----------+-------------------+-----------+-----------------+
| NULL | testdb | p1 | p1 | NULL | 1 | NULL | RANGE | NULL | id | NULL | 10 | 0 | 0 | 0 | NULL | 0 | 0 | 2020-09-05 02:50:09 | 2020-09-05 02:50:09 | NULL | NULL | | default | NULL |
| NULL | testdb | p1 | po | NULL | 2 | NULL | RANGE | NULL | id | NULL | MAXVALUE | 0 | 0 | 0 | NULL | 0 | 0 | 2020-09-05 02:50:09 | 2020-09-05 02:50:09 | NULL | NULL | | default | NULL |
+---------------+--------------+------------+----------------+-------------------+----------------------------+-------------------------------+------------------+---------------------+----------------------+-------------------------+-----------------------+------------+----------------+-------------+-----------------+--------------+-----------+---------------------+---------------------+------------+----------+-------------------+-----------+-----------------+
2 rows in set (Elapsed: 00:00:00.01)
gbase> select * from partitions where table_name='p1'\G
*************************** 1. row ***************************
TABLE_CATALOG: NULL
TABLE_SCHEMA: testdb
TABLE_NAME: p1
PARTITION_NAME: p1
SUBPARTITION_NAME: NULL
PARTITION_ORDINAL_POSITION: 1
SUBPARTITION_ORDINAL_POSITION: NULL
PARTITION_METHOD: RANGE
SUBPARTITION_METHOD: NULL
PARTITION_EXPRESSION: id
SUBPARTITION_EXPRESSION: NULL
PARTITION_DESCRIPTION: 10
TABLE_ROWS: 0
AVG_ROW_LENGTH: 0
DATA_LENGTH: 0
MAX_DATA_LENGTH: NULL
INDEX_LENGTH: 0
DATA_FREE: 0
CREATE_TIME: 2020-09-05 02:50:09
UPDATE_TIME: 2020-09-05 02:50:09
CHECK_TIME: NULL
CHECKSUM: NULL
PARTITION_COMMENT:
NODEGROUP: default
TABLESPACE_NAME: NULL
*************************** 2. row ***************************
TABLE_CATALOG: NULL
TABLE_SCHEMA: testdb
TABLE_NAME: p1
PARTITION_NAME: po
SUBPARTITION_NAME: NULL
PARTITION_ORDINAL_POSITION: 2
SUBPARTITION_ORDINAL_POSITION: NULL
PARTITION_METHOD: RANGE
SUBPARTITION_METHOD: NULL
PARTITION_EXPRESSION: id
SUBPARTITION_EXPRESSION: NULL
PARTITION_DESCRIPTION: MAXVALUE
TABLE_ROWS: 0
AVG_ROW_LENGTH: 0
DATA_LENGTH: 0
MAX_DATA_LENGTH: NULL
INDEX_LENGTH: 0
DATA_FREE: 0
CREATE_TIME: 2020-09-05 02:50:09
UPDATE_TIME: 2020-09-05 02:50:09
CHECK_TIME: NULL
CHECKSUM: NULL
PARTITION_COMMENT:
NODEGROUP: default
TABLESPACE_NAME: NULL
2 rows in set (Elapsed: 00:00:00.00)
表结构描述
列名 | 含义 |
---|---|
TABLE_CATALOG | |
TABLE_SCHEMA | 库名 |
TABLE_NAME | 表名 |
PARTITION_NAME | 分区名字 |
SUBPARTITION_NAME | |
PARTITION_ORDINAL_POSITION | 位置 |
SUBPARTITION_ORDINAL_POSITION | |
PARTITION_METHOD | 分区类型,比如RANGE |
SUBPARTITION_METHOD | |
PARTITION_EXPRESSION | 分区表达式或值 |
SUBPARTITION_EXPRESSION | |
PARTITION_DESCRIPTION | 描述 |
TABLE_ROWS | 分区里的行数(gnode分片才有) |
AVG_ROW_LENGTH | 平均行宽 |
DATA_LENGTH | 数据长度 |
MAX_DATA_LENGTH | |
INDEX_LENGTH | |
DATA_FREE | |
CREATE_TIME | 创建时间 |
UPDATE_TIME | 更新时间 |
CHECK_TIME | |
CHECKSUM | |
PARTITION_COMMENT | 备注 |
NODEGROUP | default |
TABLESPACE_NAME | 表空间名字 |