v.22.5New Feature

Allow Query-Level Override of Delay and Throw Settings in ClickHouse

Official CH changelog text
Allow to override parts_to_delay_insert and parts_to_throw_insert with query-level settings. If they are defined, they will override table-level settings. #36371 (Memo).
Enable overriding of parts_to_delay_insert and parts_to_throw_insert settings at the query level, superseding table-level configurations.

Why it matters

This feature allows users to customize the behavior of insert operations on a per-query basis by overriding the number of parts to delay or throw during an insert. It provides more granular control and flexibility without changing the table settings, facilitating better management of inserts under varying workload conditions.

How to use it

Set the parts_to_delay_insert and/or parts_to_throw_insert settings within the query context. For example:

SET parts_to_delay_insert = X;
SET parts_to_throw_insert = Y;

INSERT INTO ...

These query-level settings will override the corresponding table-level configurations for the duration of the query.

Related resources

PreviousNext