partitions
Overview
This table is solely used for compatibility with MySQL behavior. It is always empty.
Database
information_schema
Table Information
Column Name | Type | Description |
---|---|---|
TABLE_CATALOG | varchar(64) | Catalog name |
TABLE_SCHEMA | varchar(64) | Database name |
TABLE_NAME | varchar(64) | Table name |
PARTITION_NAME | varchar(64) | Partition name |
SUBPARTITION_NAME | varchar(64) | Always empty |
PARTITION_ORDINAL_POSITION | int | Ordinal position of the partition |
SUBPARTITION_ORDINAL_POSITION | int | Always empty |
PARTITION_METHOD | varchar(13) | Partition method |
SUBPARTITION_METHOD | varchar(13) | Always empty |
PARTITION_EXPRESSION | varchar(2048) | Partition expression |
SUBPARTITION_EXPRESSION | varchar(2048) | Always empty |
PARTITION_DESCRIPTION | text | Partition description |
TABLE_ROWS | bigint | |
AVG_ROW_LENGTH | bigint | |
DATA_LENGTH | bigint | |
MAX_DATA_LENGTH | bigint | |
INDEX_LENGTH | bigint | |
DATA_FREE | bigint | |
CREATE_TIME | bigint | |
UPDATE_TIME | datetime | |
CHECK_TIME | datetime | |
CHECKSUM | bigint | |
PARTITION_COMMENT | text | |
NODEGROUP | varchar(256) | |
TABLESPACE_NAME | varchar(268) |