Skip to main content
These settings are available in system.settings and are autogenerated from source.

​
deduplicate_insert

Enables or disables block deduplication of INSERT INTO (for Replicated* tables). The setting overrides insert_deduplicate and async_insert_deduplicate settings. That setting has three possible values:
  • disable — Deduplication is disabled for INSERT INTO query.
  • enable — Deduplication is enabled for INSERT INTO query.
  • backward_compatible_choice — Deduplication is enabled if insert_deduplicate or async_insert_deduplicate are enabled for specific insert type.

​
deduplicate_insert_select

Enables or disables block deduplication of INSERT SELECT (for Replicated* tables). The setting overrids insert_deduplicate and deduplicate_insert for INSERT SELECT queries. That setting has four possible values:
  • disable — Deduplication is disabled for INSERT SELECT query.
  • force_enable — Deduplication is enabled for INSERT SELECT query. If select result is not stable, exception is thrown.
  • enable_when_possible — Deduplication is enabled if insert_deduplicate is enable and select result is stable, otherwise disabled.
  • enable_even_for_bad_queries - Deduplication is enabled if insert_deduplicate is enable. If select result is not stable, warning is logged, but query is executed with deduplication. This option is for backward compatibility. Consider to use other options instead as it may lead to unexpected results.
Last modified on July 23, 2026