tencent cloud

TDSQL Boundless

文档TDSQL BoundlessGeneral ReferenceSQL ReferenceData DictionaryINFORMATION_SCHEMAMETA_CLUSTER_DPS

META_CLUSTER_DPS

下载
聚焦模式
字号
最后更新时间： 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.
上一篇: META_CLUSTER_DATA_OBJECTS下一篇: META_CLUSTER_HOT_DATA_OBJECTS

帮助和支持

本页内容是否解决了您的问题？

填写满意度调查问卷，共创更好文档体验。

文档反馈