Skip to main content
Skip to main content
Edit this page

Experimental settings

The following settings are currently experimental.

NameDefault
allow_archive_path_syntax1
allow_experimental_codecs0
allow_experimental_database_glue_catalog0
allow_experimental_database_iceberg0
allow_experimental_database_materialized_postgresql0
allow_experimental_database_unity_catalog0
allow_experimental_full_text_index0
allow_experimental_funnel_functions0
allow_experimental_hash_functions0
allow_experimental_inverted_index0
allow_experimental_join_condition0
allow_experimental_join_right_table_sorting0
allow_experimental_kafka_offsets_storage_in_keeper0
allow_experimental_kusto_dialect0
allow_experimental_live_view0
allow_experimental_materialized_postgresql_table0
allow_experimental_nlp_functions0
allow_experimental_object_type0
allow_experimental_prql_dialect0
allow_experimental_query_deduplication0
allow_experimental_replacing_merge_with_cleanup0
allow_experimental_reverse_key0
allow_experimental_shared_set_join1
allow_experimental_statistic0
allow_experimental_statistics0
allow_experimental_time_series_table0
allow_experimental_ts_to_grid_aggregate_function0
allow_experimental_vector_similarity_index0
allow_experimental_window_view0
allow_statistic_optimize0
allow_statistics_optimize0
enable_adaptive_memory_spill_scheduler0
enable_replacing_merge_with_cleanup_for_min_age_to_force_merge0
force_read_through_cache_for_merges0
grace_hash_join_initial_buckets1
grace_hash_join_max_buckets1024
hnsw_candidate_list_size_for_search256
implicit_transaction0
join_to_sort_maximum_table_rows10000
join_to_sort_minimum_perkey_rows40
live_view_heartbeat_interval15
max_limit_for_ann_queries1000000
max_live_view_insert_blocks_before_refresh64
merge_selector_algorithmSimple
notify_newest_block_number0
part_moves_between_shards_delay_seconds30
part_moves_between_shards_enable0
remote_fs_zero_copy_path_compatible_mode0
remote_fs_zero_copy_zookeeper_path/clickhouse/zero_copy
remove_rolled_back_parts_immediately1
shared_merge_tree_enable_keeper_parts_extra_data0
stop_refreshable_materialized_views_on_startup0
throw_on_unsupported_query_inside_transaction1
wait_changes_become_visible_after_commit_modewait_unknown
wait_for_window_view_fire_signal_timeout10
window_view_clean_interval60
window_view_heartbeat_interval15