Skip to main content
Version: Latest-3.5

partitions_meta

partitions_meta provides information about partitions of tables.

The following fields are provided in partitions_meta:

FieldDescription
DB_NAMEName of the database to which the partition belongs.
TABLE_NAMEName of the table to which the partition belongs.
PARTITION_NAMEName of the partition.
PARTITION_IDID of the partition.
COMPACT_VERSIONCompact version of the partition.
VISIBLE_VERSIONVisible version of the partition.
VISIBLE_VERSION_TIMEVisible version time of the partition.
NEXT_VERSIONNext version of the partition.
DATA_VERSIONData version of the partition.
VERSION_EPOCHVersion epoch of the partition.
VERSION_TXN_TYPEVersion transaction type of the partition.
PARTITION_KEYPartition key of the partition.
PARTITION_VALUEPartition value of the partition (e.g., Range or List).
DISTRIBUTION_KEYDistribution key of the partition.
BUCKETSNumber of buckets in the partition.
REPLICATION_NUMReplication number of the partition.
STORAGE_MEDIUMStorage medium of the partition.
COOLDOWN_TIMECooldown time of the partition.
LAST_CONSISTENCY_CHECK_TIMELast consistency check time of the partition.
IS_IN_MEMORYIndicates whether the partition is in memory (true) or not (false).
IS_TEMPIndicates whether the partition is temporary (true) or not (false).
DATA_SIZEData size of the partition.
ROW_COUNTNumber of rows in the partition.
ENABLE_DATACACHEIndicates whether data cache is enabled for the partition (true) or not (false).
AVG_CSAverage compaction score of the partition.
P50_CS50th percentile compaction score of the partition.
MAX_CSMaximum compaction score of the partition.
STORAGE_PATHStorage path of the partition.
STORAGE_SIZEStorage size of the partition.
METADATA_SWITCH_VERSIONMetadata switch version of the partition.
TABLET_BALANCEDWhether the tablet distribution is balanced in the partition.