tencent cloud

TDSQL Boundless

DocumentaçãoTDSQL BoundlessGeneral ReferenceSQL ReferenceData DictionaryINFORMATION_SCHEMAMETA_CLUSTER_DPS

META_CLUSTER_DPS

PDF
Modo Foco
Tamanho da Fonte
Última atualização: 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.
Anterior: META_CLUSTER_DATA_OBJECTSPróximo: META_CLUSTER_HOT_DATA_OBJECTS

Ajuda e Suporte

Esta página foi útil?

comentários