tencent cloud

TDSQL Boundless

문서TDSQL BoundlessGeneral ReferenceSQL ReferenceData DictionaryINFORMATION_SCHEMAMETA_CLUSTER_DPS

META_CLUSTER_DPS

PDF
포커스 모드
폰트 크기
마지막 업데이트 시간: 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

도움말 및 지원

문제 해결에 도움이 되었나요?

피드백