Set up docs MCPThese settings are available in system.settings and are autogenerated from the ClickHouse snapshot.
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 function eval.
allow_experimental_expire_snapshots
Allow to execute experimental Iceberg command ALTER TABLE ... EXECUTE expire_snapshots.
allow_experimental_hash_functions
Enable experimental hash functions
allow_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_nlp_functions
Enable experimental functions for natural language processing.
allow_experimental_object_storage_queue_hive_partitioning
Allow to use hive partitioning with S3Queue/AzureQueue engines
allow_experimental_paimon_storage_engine
Allow to create tables with Paimon* table engines.
allow_experimental_parallel_reading_from_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_polyglot_dialect
Enable polyglot SQL transpiler - transpiles SQL from 30+ dialects (MySQL, PostgreSQL, SQLite, Snowflake, DuckDB, etc.) into ClickHouse SQL.
allow_experimental_prql_dialect
Enable PRQL - an alternative to SQL.
allow_experimental_ytsaurus_dictionary_source
Experimental dictionary source for integration with YTsaurus.
allow_experimental_ytsaurus_table_engine
Experimental table engine for integration with YTsaurus.
allow_experimental_ytsaurus_table_function
Experimental table engine for integration with YTsaurus.