tencent cloud

Tencent Cloud TCHouse-C

DokumentasiTencent Cloud TCHouse-C

Configuring DDL on Cluster Feature

Mode fokus
Ukuran font
Terakhir diperbarui: 2025-03-31 14:55:27
By default, you need to manually add the ON CLUSTER XXX syntax when performing DDL operations such as table creation at the cluster level. Tencent Cloud TCHouse-C 21.8.8.12 offers the new feature of DDL On Cluster, which can automatically add a cluster when performing DDL operations. This feature is disabled by default.
New ClickHouse parameters:
<!--`default_on_cluster` specifies the added cluster, which is "" by default.-->
<default_on_cluster>default_cluster</default_on_cluster>
<!--`enable_default_on_cluster` specifies whether to enable the DDL On Cluster feature, which is 0 by default.-->
<enable_default_on_cluster>1</enable_default_on_cluster>

Directions

1. Configure in the configuration file permanently

Add the following parameters to users.xml, with no restart required after the configuration:
<yandex>
    <!-- Profiles of settings. -->
    <profiles>
        <default_on_cluster>default_cluster</default_on_cluster>
        <enable_default_on_cluster>1</enable_default_on_cluster>
    </profiles>
</yandex>

2. Modify temporarily at the session level

set default_on_cluster='default_cluster';
set enable_default_on_cluster=1;

Topik selanjutnya: Kebijakan Privasi

Bantuan dan Dukungan

Apakah halaman ini membantu?

masukan