tencent cloud

Tencent Cloud TCHouse-C

문서Tencent Cloud TCHouse-C

Configuring DDL on Cluster Feature

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

다음 주제: 개인 정보 보호 정책

도움말 및 지원

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

피드백