v.21.9Improvement

Add Distributed Directory Monitor Settings via CREATE TABLE

Official CH changelog text
Add ability to set Distributed directory monitor settings via CREATE TABLE (i.e. CREATE TABLE dist (key Int) Engine=Distributed(cluster, db, table) SETTINGS monitor_batch_inserts=1 and similar). #26336 (Azat Khuzhin).
Enable setting Distributed engine directory monitor options directly in CREATE TABLE statements. Users can now specify parameters like monitor_batch_inserts as table settings for Distributed tables.

Why it matters

This feature allows users to configure directory monitoring behavior for Distributed tables directly within table definitions. It improves usability by consolidating configuration into CREATE TABLE commands, eliminating the need for external configuration changes and enabling more flexible and fine-grained control over directory monitoring parameters.

How to use it

When creating a Distributed table, include the desired directory monitor settings using the SETTINGS clause in the CREATE TABLE statement. For example:

CREATE TABLE dist (key Int) ENGINE = Distributed(cluster, db, table) SETTINGS monitor_batch_inserts = 1

Related resources

PreviousNext