allow_experimental_analyzer
Aliases:enable_analyzer
Obsolete since v26.9: the analyzer cannot be disabled anymore.
The analyzer is the query analysis and planning infrastructure that has been the default since v24.3. In v26.9 this setting was frozen at its only supported value, 1, and the compatibility setting no longer reverts it. In v26.10 the query analysis it used to switch to was removed. For backward compatibility, setting it to 0 is accepted and replaced with 1, so queries, session settings, settings profiles and client configurations that still set enable_analyzer = 0 keep working, with the analyzer. To compare the behaviour or the performance of a query with the old query analysis, use a ClickHouse version older than v26.9.
allow_experimental_hash_functions
Enable experimental hash functionsallow_experimental_iceberg_compaction
Allow to explicitly use ‘OPTIMIZE’ for iceberg tables.allow_experimental_nlp_functions
Enable experimental functions for natural language processing.allow_experimental_parallel_reading_from_replicas
Aliases:enable_parallel_replicas
Use up to max_parallel_replicas the number of replicas from each shard for SELECT query execution. Reading is parallelized and coordinated dynamically. 0 - disabled, 1 - enabled, silently disable them in case of failure, 2 - enabled, throw an exception in case of failure
allow_experimental_shuffle_query
Allow the experimentalSHUFFLE clause in SELECT queries. SHUFFLE is used in place of ORDER BY and returns the rows in a uniformly random order.