Set up docs MCPThese settings are available in system.settings and are autogenerated from source.
dictionary_lazy_load
Type
BoolAuto
Default
auto
Version history
| Version | Default value | Comment |
|---|---|---|
| 26.7 | auto | New setting overriding the server setting `dictionaries_lazy_load` for an individual dictionary. |
Controls loading of a dictionary when specified in the SETTINGS clause of CREATE DICTIONARY: 1 defers loading until first use, 0 loads the dictionary at creation, 'auto' follows the server setting dictionaries_lazy_load. Has no effect when set on a session or query level.
dictionary_use_async_executor
Type
Bool
Default
0
Execute a pipeline for reading dictionary source in several threads. It’s supported only by dictionaries with local CLICKHOUSE source.
dictionary_validate_primary_key_type
Type
Bool
Default
0
Version history
| Version | Default value | Comment |
|---|---|---|
| 24.7 | 0 | Validate primary key type for dictionaries. By default id type for simple layouts will be implicitly converted to UInt64. |
Validate primary key type for dictionaries. By default id type for simple layouts will be implicitly converted to UInt64.