Beta and Experimental Features

| Name Default|  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | | [allow\_commit\_order\_projection](/docs/operations/settings/merge-tree-settings#allow_commit_order_projection) `0`| [allow\_experimental\_replacing\_merge\_with\_cleanup](/docs/operations/settings/merge-tree-settings#allow_experimental_replacing_merge_with_cleanup) `0`| [allow\_experimental\_reverse\_key](/docs/operations/settings/merge-tree-settings#allow_experimental_reverse_key) `0`| [allow\_remote\_fs\_zero\_copy\_replication](/docs/operations/settings/merge-tree-settings#allow_remote_fs_zero_copy_replication) `0`| [distributed\_index\_analysis\_min\_indexes\_bytes\_to\_activate](/docs/operations/settings/merge-tree-settings#distributed_index_analysis_min_indexes_bytes_to_activate) `1073741824`| [distributed\_index\_analysis\_min\_parts\_to\_activate](/docs/operations/settings/merge-tree-settings#distributed_index_analysis_min_parts_to_activate) `10`| [enable\_replacing\_merge\_with\_cleanup\_for\_min\_age\_to\_force\_merge](/docs/operations/settings/merge-tree-settings#enable_replacing_merge_with_cleanup_for_min_age_to_force_merge) `0`| [force\_read\_through\_cache\_for\_merges](/docs/operations/settings/merge-tree-settings#force_read_through_cache_for_merges) `0`| [merge\_selector\_algorithm](/docs/operations/settings/merge-tree-settings#merge_selector_algorithm) `Simple`| [merge\_selector\_enable\_heuristic\_to\_lower\_max\_parts\_to\_merge\_at\_once](/docs/operations/settings/merge-tree-settings#merge_selector_enable_heuristic_to_lower_max_parts_to_merge_at_once) `0`| [merge\_selector\_heuristic\_to\_lower\_max\_parts\_to\_merge\_at\_once\_exponent](/docs/operations/settings/merge-tree-settings#merge_selector_heuristic_to_lower_max_parts_to_merge_at_once_exponent) `5`| [notify\_newest\_block\_number](/docs/operations/settings/merge-tree-settings#notify_newest_block_number) `0`| [part\_moves\_between\_shards\_delay\_seconds](/docs/operations/settings/merge-tree-settings#part_moves_between_shards_delay_seconds) `30`| [part\_moves\_between\_shards\_enable](/docs/operations/settings/merge-tree-settings#part_moves_between_shards_enable) `0`| [remote\_fs\_zero\_copy\_path\_compatible\_mode](/docs/operations/settings/merge-tree-settings#remote_fs_zero_copy_path_compatible_mode) `0`| [remote\_fs\_zero\_copy\_zookeeper\_path](/docs/operations/settings/merge-tree-settings#remote_fs_zero_copy_zookeeper_path) `/clickhouse/zero_copy`| [remove\_rolled\_back\_parts\_immediately](/docs/operations/settings/merge-tree-settings#remove_rolled_back_parts_immediately) `1`| [shared\_merge\_tree\_virtual\_parts\_discovery\_batch](/docs/operations/settings/merge-tree-settings#shared_merge_tree_virtual_parts_discovery_batch) `1`| [query\_plan\_optimize\_join\_order\_randomize](/docs/operations/settings/settings#query_plan_optimize_join_order_randomize) `0`| [enable\_join\_transitive\_predicates](/docs/operations/settings/settings#enable_join_transitive_predicates) `0`| [ast\_fuzzer\_runs](/docs/operations/settings/settings#ast_fuzzer_runs) `0`| [ast\_fuzzer\_any\_query](/docs/operations/settings/settings#ast_fuzzer_any_query) `0`| [allow\_fuzz\_query\_functions](/docs/operations/settings/settings#allow_fuzz_query_functions) `0`| [enable\_materialized\_cte](/docs/operations/settings/settings#enable_materialized_cte) `0`| [analyzer\_inline\_views](/docs/operations/settings/settings#analyzer_inline_views) `0`| [allow\_experimental\_kafka\_offsets\_storage\_in\_keeper](/docs/operations/settings/settings#allow_experimental_kafka_offsets_storage_in_keeper) `0`| [allow\_experimental\_delta\_lake\_writes](/docs/operations/settings/settings#allow_experimental_delta_lake_writes) `0`| [automatic\_parallel\_replicas\_mode](/docs/operations/settings/settings#automatic_parallel_replicas_mode) `0`| [automatic\_parallel\_replicas\_min\_bytes\_per\_replica](/docs/operations/settings/settings#automatic_parallel_replicas_min_bytes_per_replica) `1048576`| [distributed\_index\_analysis](/docs/operations/settings/settings#distributed_index_analysis) `0`| [allow\_experimental\_materialized\_postgresql\_table](/docs/operations/settings/settings#allow_experimental_materialized_postgresql_table) `0`| [allow\_experimental\_funnel\_functions](/docs/operations/settings/settings#allow_experimental_funnel_functions) `0`| [allow\_experimental\_nlp\_functions](/docs/operations/settings/settings#allow_experimental_nlp_functions) `0`| [allow\_experimental\_hash\_functions](/docs/operations/settings/settings#allow_experimental_hash_functions) `0`| [allow\_experimental\_time\_series\_table](/docs/operations/settings/settings#allow_experimental_time_series_table) `0`| [allow\_experimental\_codecs](/docs/operations/settings/settings#allow_experimental_codecs) `0`| [throw\_on\_unsupported\_query\_inside\_transaction](/docs/operations/settings/settings#throw_on_unsupported_query_inside_transaction) `1`| [wait\_changes\_become\_visible\_after\_commit\_mode](/docs/operations/settings/settings#wait_changes_become_visible_after_commit_mode) `wait_unknown`| [implicit\_transaction](/docs/operations/settings/settings#implicit_transaction) `0`| [grace\_hash\_join\_initial\_buckets](/docs/operations/settings/settings#grace_hash_join_initial_buckets) `1`| [grace\_hash\_join\_max\_buckets](/docs/operations/settings/settings#grace_hash_join_max_buckets) `1024`| [join\_to\_sort\_minimum\_perkey\_rows](/docs/operations/settings/settings#join_to_sort_minimum_perkey_rows) `40`| [join\_to\_sort\_maximum\_table\_rows](/docs/operations/settings/settings#join_to_sort_maximum_table_rows) `10000`| [allow\_experimental\_join\_right\_table\_sorting](/docs/operations/settings/settings#allow_experimental_join_right_table_sorting) `0`| [allow\_experimental\_json\_lazy\_type\_hints](/docs/operations/settings/settings#allow_experimental_json_lazy_type_hints) `0`| [allow\_experimental\_window\_view](/docs/operations/settings/settings#allow_experimental_window_view) `0`| [window\_view\_clean\_interval](/docs/operations/settings/settings#window_view_clean_interval) `60`| [window\_view\_heartbeat\_interval](/docs/operations/settings/settings#window_view_heartbeat_interval) `15`| [wait\_for\_window\_view\_fire\_signal\_timeout](/docs/operations/settings/settings#wait_for_window_view_fire_signal_timeout) `10`| [stop\_refreshable\_materialized\_views\_on\_startup](/docs/operations/settings/settings#stop_refreshable_materialized_views_on_startup) `0`|