tencent cloud

TDSQL Boundless

DocumentationTDSQL BoundlessGeneral ReferenceSQL ReferenceData DictionaryINFORMATION_SCHEMAMETA_CLUSTER_DPS

META_CLUSTER_DPS

PDF
Focus Mode
Font Size
Last updated: 2026-03-06 18:48:08

Function

INFORMATION_SCHEMA.META_CLUSTER_DPS is used to display the data distribution policy.

Field Description

Field Name
Type
Description
distribution_policy_id
int unsigned
The unique identifier ID for the data distribution policy.
distribution_policy_name
varchar(64)
The name of the data distribution policy.
distribution_policy_desc
longtext
The detailed description of the data distribution policy.

Examples

tdsql > SELECT * FROM INFORMATION_SCHEMA.META_CLUSTER_DPS;
+------------------------+--------------------------+-----------------------------------------------------------------------------------+
| distribution_policy_id | distribution_policy_name | distribution_policy_desc                                                          |
+------------------------+--------------------------+-----------------------------------------------------------------------------------+
|                    101 | **_2                  | {"constraints":[{"key":"tdsql-storage-type","op":"in","values":["ssd1","ssd2"]}]} |
+------------------------+--------------------------+-----------------------------------------------------------------------------------+
This result displays the data distribution policy with ID 101, whose description defines storage constraints (requiring storage types to be ssd1 or ssd2) in JSON format. This view is primarily used for monitoring cluster data distribution policy configurations and troubleshooting data distribution-related issues.
Previous Topic: META_CLUSTER_DATA_OBJECTSNext Topic: META_CLUSTER_HOT_DATA_OBJECTS

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback