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_cleanup_old_data_files_compaction
Allow to clean up old data files during Iceberg compaction.allow_experimental_database_hms_catalog
Allow experimental database engine DataLakeCatalog with catalog_type = ‘hms’allow_experimental_database_materialized_postgresql
Allow to create database with Engine=MaterializedPostgreSQL(…).allow_experimental_database_paimon_rest_catalog
Allow experimental database engine DataLakeCatalog with catalog_type = ‘paimon_rest’allow_experimental_eval_table_function
Enable experimental table functioneval.
allow_experimental_expire_snapshots
Allow to execute experimental Iceberg commandALTER TABLE ... EXECUTE expire_snapshots.
allow_experimental_hash_functions
Enable experimental hash functionsallow_experimental_iceberg_compaction
Allow to explicitly use ‘OPTIMIZE’ for iceberg tables.allow_experimental_kusto_dialect
Enable the Kusto Query Language (KQL) dialect - an alternative to SQL.allow_experimental_lateral_join
Allow LATERAL JOIN syntax. When enabled, subqueries in the right side of a JOIN can reference columns from the left side, enabling correlated subqueries in the FROM clause (SQL standard LATERAL JOIN).allow_experimental_nlp_functions
Enable experimental functions for natural language processing.allow_experimental_object_storage_queue_hive_partitioning
Allow to use hive partitioning with S3Queue/AzureQueue enginesallow_experimental_paimon_storage_engine
Allow to create tables with Paimon* table engines.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