Skip to main content
Skip to main content

partitions

Overview

This table is solely used for compatibility with MySQL behavior. It is always empty.

Database

information_schema

Table Information

Column NameTypeDescription
TABLE_CATALOGvarchar(64)Catalog name
TABLE_SCHEMAvarchar(64)Database name
TABLE_NAMEvarchar(64)Table name
PARTITION_NAMEvarchar(64)Partition name
SUBPARTITION_NAMEvarchar(64)Always empty
PARTITION_ORDINAL_POSITIONintOrdinal position of the partition
SUBPARTITION_ORDINAL_POSITIONintAlways empty
PARTITION_METHODvarchar(13)Partition method
SUBPARTITION_METHODvarchar(13)Always empty
PARTITION_EXPRESSIONvarchar(2048)Partition expression
SUBPARTITION_EXPRESSIONvarchar(2048)Always empty
PARTITION_DESCRIPTIONtextPartition description
TABLE_ROWSbigint
AVG_ROW_LENGTHbigint
DATA_LENGTHbigint
MAX_DATA_LENGTHbigint
INDEX_LENGTHbigint
DATA_FREEbigint
CREATE_TIMEbigint
UPDATE_TIMEdatetime
CHECK_TIMEdatetime
CHECKSUMbigint
PARTITION_COMMENTtext
NODEGROUPvarchar(256)
TABLESPACE_NAMEvarchar(268)