tencent cloud

Tencent Cloud TCHouse-C

Release Notes
Product Introduction
Overview
Basic Concepts
Cluster Architecture
Strengths
Use Cases
Purchase Guide
Billing Overview
Expiration and Payment Overdue
Refund
Configuration Adjustment Billing
Getting Started
Operation Guide
Cluster Management
Parameter Configuration
Monitoring and Alarming
Hot/Cold Data Tiering
Account and Authorization
Query Management
Log Search
Data Dictionary
Backup and Restore
Multi-ZooKeeper Cluster
External Data Import
Configuring DDL on Cluster Feature
Data Redistribution
Scale-in and Migration
Development Guide
Database Engine
Table Engines
ClickHouse SQL Syntax Reference
ClickHouse Client Overview
Self-Built ClickHouse Migration Solution
Service Level Agreement
CDWCH Policy
Privacy Policy
Data Privacy and Security Agreement
FAQs
Contact Us
Glossary
DocumentationTencent Cloud TCHouse-COperation GuideConfiguring DDL on Cluster Feature

Configuring DDL on Cluster Feature

PDF
Focus Mode
Font Size
Last updated: 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;

Previous Topic: Local File importNext Topic: Data Redistribution

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback