Beta and experimental features

Because ClickHouse is open-source, it receives many contributions not only from ClickHouse employees but also from the community. These contributions are often developed at different speeds; certain features may require a lengthy prototyping phase or more time for sufficient community feedback and iteration to be considered generally available (GA). Due to the uncertainty of when features are classified as generally available, we delineate features into four categories: Beta, Public preview, Experimental, and Private preview. Beta features are officially supported by the ClickHouse team. Public preview features are largely complete and on a clear path to general availability (GA). Experimental features are early prototypes driven by either the ClickHouse team or the community and aren’t officially supported. Private preview features are on a clear path to general availability but still have limited applicability and are not recommended for production use. The sections below explicitly describe the properties of Beta, Public preview, Experimental, and Private preview features:

Beta features

Under active development to make them generally available (GA)
Main known issues can be tracked on GitHub
Functionality may change in the future
Possibly enabled in ClickHouse Cloud
The ClickHouse team supports beta features

You can find below the features considered Beta in ClickHouse Cloud and are available for use in your ClickHouse Cloud Services. Note: please be sure to be using a current version of the ClickHouse compatibility setting to be using a recently introduced feature.

Public preview features

Largely complete and on a clear path to general availability (GA)
Ready for customer feedback, but not yet beta
Not recommended for production use
Functionality may change in the future
Need to be deliberately enabled, and eligible customers can do this themselves in ClickHouse Cloud
Availability may depend on plan or region

Experimental features

May never become GA
May be removed
Can introduce breaking changes
Functionality may change in the feature
Need to be deliberately enabled
The ClickHouse team doesn’t support experimental features
May lack important functionality and documentation
Can’t be enabled in the cloud

Please note: no additional experimental features are allowed to be enabled in ClickHouse Cloud other than those listed above as Beta.

Private preview features

On a clear path to general availability (GA)
Applicability is still limited
Not recommended for production use
Functionality may change in the future
Need to be deliberately enabled

Beta settings

Name	Default
adaptive_codec_selection_period	`8`
compute_exact_num_defaults_for_sparse_columns	`1`
enable_adaptive_codec_selection	`0`
packed_skip_index_max_bytes	`1048576`
enable_reads_from_columns_cache	`1`
enable_writes_to_columns_cache	`1`
columns_cache_max_estimated_bytes_to_write_to_cache	`0`
columns_cache_max_bytes_to_write_to_cache	`0`
framing_output_format	`None`
enable_join_transitive_predicates	`1`
geotoh3_argument_order	`lat_lon`
optimize_trivial_count_with_sparsity_filter	`1`
allow_correlated_subqueries	`1`
allow_delta_lake_writes	`0`
parallel_replicas_count	`0`
parallel_replica_offset	`0`
parallel_replicas_custom_key	“
parallel_replicas_custom_key_range_lower	`0`
parallel_replicas_custom_key_range_upper	`0`
parallel_replicas_for_queries_with_multiple_tables	`1`
parallel_replicas_allow_view_over_mergetree	`0`
distributed_index_analysis	`0`
allow_database_iceberg	`0`
allow_database_unity_catalog	`0`
allow_database_glue_catalog	`0`
session_timezone	“
low_priority_query_wait_time_ms	`1000`
ai_function_request_timeout_sec	`60`
ai_function_max_retries	`3`
ai_function_retry_initial_delay_ms	`1000`
ai_function_throw_on_error	`1`
ai_function_max_input_tokens_per_query	`0`
ai_function_max_output_tokens_per_query	`0`
ai_function_max_api_calls_per_query	`0`
ai_function_throw_on_quota_exceeded	`1`
ai_function_embedding_max_batch_size	`100`
ai_function_max_concurrent_requests_per_thread	`8`
ai_function_text_default_credentials	“
ai_function_embedding_default_credentials	“
ai_function_allow_insecure_endpoint	`0`
enable_pco_codec	`0`
enable_kusto_dialect	`0`
enable_trino_dialect	`0`
allow_insert_into_iceberg	`0`
distributed_plan_partial_aggregation_before_shuffle	`1`
cascades_aggregation_pushdown	`1`
query_plan_optimize_join_order_algorithm	`dpsub,greedy`
query_plan_optimize_join_order_conflict_detector	`c`
query_plan_join_order_use_interesting_orders	`1`

Experimental settings

Name	Default
allow_commit_order_projection	`0`
allow_experimental_replacing_merge_with_cleanup	`0`
allow_experimental_text_index_phrase_search	`0`
allow_remote_fs_zero_copy_replication	`0`
distributed_index_analysis_min_indexes_bytes_to_activate	`1073741824`
distributed_index_analysis_min_parts_to_activate	`10`
enable_merge_checkpoints	`0`
enable_replacing_merge_with_cleanup_for_min_age_to_force_merge	`0`
force_read_through_cache_for_merges	`0`
merge_checkpoints_min_bytes	`10737418240`
merge_checkpoints_min_interval_seconds	`60`
merge_selector_algorithm	`Simple`
merge_selector_heuristic_to_lower_max_parts_to_merge_at_once_exponent	`5`
notify_newest_block_number	`0`
part_moves_between_shards_delay_seconds	`30`
part_moves_between_shards_enable	`0`
remote_fs_zero_copy_path_compatible_mode	`0`
remote_fs_zero_copy_zookeeper_path	`/clickhouse/zero_copy`
remove_rolled_back_parts_immediately	`1`
unique_key_conflict_action	`overwrite`
use_reader_executor	`0`
reader_executor_use_long_connections	`0`
reader_executor_min_bytes_for_seek	`2097152`
reader_executor_max_tail_for_drain	`1048576`
reader_executor_window_size	`8388608`
reader_executor_block_size	`1048576`
reader_executor_plan_look_ahead	`16777216`
use_columns_cache	`0`
group_by_top_k_optimization_observation_rows	`65536`
query_plan_optimize_join_order_max_searched_plans	`100000`
query_plan_optimize_join_order_randomize	`0`
ast_fuzzer_runs	`0`
ast_fuzzer_any_query	`0`
ast_fuzzer_oracle	`0`
allow_fuzz_query_functions	`0`
reserve_memory	`0`
min_bytes_to_spill	`67108864`
resumable_backup_from_snapshot	`0`
allow_url_wildcard_from_index_pages	`0`
enable_materialized_cte	`0`
analyzer_inline_views	`0`
enable_join_seal_gated_reading	`0`
use_query_condition_cache_for_time_conditions	`0`
query_condition_cache_time_condition_grid_factor	`1`
allow_kafka_offsets_storage_in_keeper	`0`
enable_lateral_join	`0`
parallel_replicas_plan_based	`0`
parallel_replicas_allow_merge_tables	`0`
enable_subcolumn_codecs	`0`
enable_materialized_postgresql_table	`0`
enable_funnel_functions	`0`
allow_experimental_nlp_functions	`0`
allow_experimental_hash_functions	`0`
enable_ipcrypt	`0`
enable_xgboost	`0`
enable_elasticsearch	`0`
unique_key_max_encoded_size	`256`
unique_key_probe_implementation	`auto`
enable_unique_key	`0`
enable_quantized_codec	`0`
enable_sz3_codec	`0`
enable_gdeflate_codec	`0`
enable_zxc_codec	`0`
throw_on_unsupported_query_inside_transaction	`1`
wait_changes_become_visible_after_commit_mode	`wait_unknown`
wait_changes_become_visible_timeout_ms	`10000`
implicit_transaction	`0`
join_to_sort_minimum_perkey_rows	`40`
join_to_sort_maximum_table_rows	`10000`
allow_join_right_table_sorting	`0`
allow_experimental_shuffle_query	`0`
enable_streaming_queries	`0`
stop_refreshable_materialized_views_on_startup	`0`
enable_database_materialized_postgresql	`0`
enable_database_hms_catalog	`0`
enable_prql_dialect	`0`
enable_polyglot_dialect	`0`
enable_json_ast_dialect	`0`
polyglot_dialect	“
enable_logsql_dialect	`0`
logsql_database	“
logsql_table	“
logsql_time_column	`_time`
logsql_message_column	`_msg`
enable_adaptive_memory_spill_scheduler	`0`
allow_delta_lake_create_table	`0`
enable_cleanup_old_data_files_compaction	`0`
allow_experimental_iceberg_compaction	`0`
iceberg_manifest_min_count_to_compact	`100`
allow_iceberg_remove_orphan_files	`0`
iceberg_orphan_files_older_than_seconds	`259200`
iceberg_orphan_files_min_retention_seconds	`86400`
allow_expire_snapshots	`0`
write_full_path_in_iceberg_metadata	`0`
iceberg_metadata_compression_method	“
distributed_plan_execute_locally	`0`
distributed_plan_default_shuffle_join_bucket_count	`8`
distributed_plan_default_reader_bucket_count	`0`
distributed_plan_min_rows_per_reader	`1000000`
distributed_plan_force_exchange_kind	“
distributed_plan_exchange_compression_method	`LZ4`
distributed_plan_exchange_zstd_compression_level	`1`
distributed_plan_max_rows_to_broadcast	`20000`
distributed_plan_read_in_order	`0`
distributed_plan_join_runtime_filters	`0`
distributed_plan_max_buffered_log_rows	`100000`
enable_ytsaurus_table_engine	`0`
enable_ytsaurus_table_function	`0`
enable_ytsaurus_dictionary_source	`0`
distributed_plan_force_shuffle_aggregation	`0`
enable_cascades_optimizer	`0`
rewrite_in_to_join	`0`
enable_paimon_storage_engine	`0`
paimon_target_snapshot_id	`-1`
max_consume_snapshots	`0`
use_paimon_partition_pruning	`0`
enable_object_storage_queue_hive_partitioning	`0`
enable_database_paimon_rest_catalog	`0`
webassembly_udf_max_fuel	`100000`
webassembly_udf_max_memory	`134217728`
webassembly_udf_max_input_block_size	`0`
webassembly_udf_input_split_memory_ratio	`0.5`
webassembly_udf_max_instances	`32`
enable_eval_table_function	`0`

Private preview settings

Name	Default
enable_time_series_table	`0`
time_series_prefer_recent_samples_table	`1`
make_distributed_plan	`0`
distributed_plan_workers_num	`0`
distributed_plan_workers_provisioning_timeout_ms	`10000`
distributed_plan_prefer_replicas_over_workers	`0`
distributed_plan_worker_cluster	“
enable_time_series_aggregate_functions	`0`
promql_database	“
promql_table	“
promql_evaluation_time	`auto`
promql_max_points_per_series	`11000`
promql_push_down_label_matchers	`1`

SQL Reference

Data Types

Engines

Functions

Formats

Settings

System Tables

Data Lakes