Beta 和 Experimental 功能

由于 ClickHouse 是开源项目，除了 ClickHouse 员工之外，社区也会贡献大量内容。这些贡献的开发进度往往不尽相同；某些功能可能需要较长的原型验证阶段，或需要更多时间来获得充分的社区反馈并持续迭代，之后才能被视为正式可用 (GA) 。由于功能在何时会被归类为正式可用并不总是明确，我们将其分为三类：Beta、Experimental 和 私有预览。 Beta 功能由 ClickHouse 团队正式支持。Experimental 功能则是由 ClickHouse 团队或社区推动的早期原型，不提供正式支持。私有预览功能已明确朝着正式可用推进，但适用范围仍然有限，不建议在生产环境中使用。下文将明确说明 Beta、Experimental 和私有预览功能的特性：

Beta 功能

仍在积极开发中，目标是达到正式发布 (GA) 状态
可在 GitHub 上跟踪主要已知问题
功能后续可能会发生变化
可能已在 ClickHouse Cloud 中启用
ClickHouse 团队为 Beta 功能提供支持

以下是在 ClickHouse Cloud 中被视为 Beta，且可在您的 ClickHouse Cloud 服务中使用的功能。注意：请务必使用当前版本的 ClickHouse compatibility 设置，以便使用最近引入的功能。

Experimental 功能

可能永远不会 GA
可能会被移除
可能会引入破坏性变更
功能行为可能会发生变化
需要显式启用
ClickHouse 团队不支持Experimental 功能
可能缺少重要功能和文档
无法在 Cloud 中启用

请注意：除上文列为 Beta 的功能外，ClickHouse Cloud 不允许启用任何其他 Experimental 功能。

私有预览功能

有明确的正式可用 (GA) 路线
适用范围仍然有限
不建议用于生产环境
功能行为可能会发生变化
需要显式启用

Beta 设置

名称	默认值
compute_exact_num_defaults_for_sparse_columns	`1`
packed_skip_index_max_bytes	`1048576`
framing_output_format	`None`
enable_join_transitive_predicates	`1`
geotoh3_argument_order	`lat_lon`
optimize_trivial_count_with_sparsity_filter	`1`
enable_lightweight_update	`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_filter_pushdown	`0`
parallel_replicas_allow_view_over_mergetree	`0`
allow_database_iceberg	`0`
allow_database_unity_catalog	`0`
allow_database_glue_catalog	`0`
session_timezone	“
low_priority_query_wait_time_ms	`1000`
enable_json_lazy_type_hints	`0`
ai_function_request_timeout_sec	`60`
ai_function_max_retries	`1`
ai_function_retry_initial_delay_ms	`1000`
ai_function_throw_on_error	`1`
ai_function_max_input_tokens_per_query	`1000000`
ai_function_max_output_tokens_per_query	`500000`
ai_function_max_api_calls_per_query	`1000`
ai_function_throw_on_quota_exceeded	`1`
ai_function_embedding_max_batch_size	`100`
ai_function_text_default_credentials	“
ai_function_embedding_default_credentials	“
ai_function_allow_insecure_endpoint	`0`
enable_alp_codec	`0`
allow_delta_kernel_rs	`1`
allow_insert_into_iceberg	`0`
cascades_aggregation_pushdown	`1`

Experimental 设置

名称	默认值
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_adaptive_codec_selection	`0`
enable_replacing_merge_with_cleanup_for_min_age_to_force_merge	`0`
force_read_through_cache_for_merges	`0`
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`
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`
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`
resumable_backup_from_snapshot	`0`
allow_url_wildcard_from_index_pages	`0`
enable_materialized_cte	`0`
analyzer_inline_views	`0`
allow_kafka_offsets_storage_in_keeper	`0`
automatic_parallel_replicas_mode	`0`
automatic_parallel_replicas_min_bytes_per_replica	`1048576`
parallel_replicas_plan_based	`0`
parallel_replicas_allow_merge_tables	`0`
distributed_index_analysis	`0`
enable_materialized_postgresql_table	`0`
enable_funnel_functions	`0`
allow_experimental_nlp_functions	`0`
allow_experimental_hash_functions	`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_zxc_codec	`0`
throw_on_unsupported_query_inside_transaction	`1`
wait_changes_become_visible_after_commit_mode	`wait_unknown`
implicit_transaction	`0`
grace_hash_join_initial_buckets	`1`
grace_hash_join_max_buckets	`1024`
join_to_sort_minimum_perkey_rows	`40`
join_to_sort_maximum_table_rows	`10000`
allow_join_right_table_sorting	`0`
enable_streaming_queries	`0`
stop_refreshable_materialized_views_on_startup	`0`
allow_experimental_database_materialized_postgresql	`0`
allow_experimental_database_hms_catalog	`0`
allow_experimental_kusto_dialect	`0`
allow_experimental_prql_dialect	`0`
allow_experimental_polyglot_dialect	`0`
enable_json_ast_dialect	`0`
polyglot_dialect	“
enable_trino_dialect	`0`
enable_adaptive_memory_spill_scheduler	`0`
allow_delta_lake_create_table	`0`
allow_experimental_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`
allow_experimental_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	`8`
distributed_plan_force_exchange_kind	“
distributed_plan_max_rows_to_broadcast	`20000`
distributed_plan_read_in_order	`0`
allow_experimental_ytsaurus_table_engine	`0`
allow_experimental_ytsaurus_table_function	`0`
allow_experimental_ytsaurus_dictionary_source	`0`
distributed_plan_force_shuffle_aggregation	`0`
enable_cascades_optimizer	`0`
rewrite_in_to_join	`0`
allow_experimental_paimon_storage_engine	`0`
paimon_target_snapshot_id	`-1`
max_consume_snapshots	`0`
use_paimon_partition_pruning	`0`
allow_experimental_object_storage_queue_hive_partitioning	`0`
query_plan_optimize_join_order_algorithm	`greedy`
query_plan_optimize_join_order_conflict_detector	“
allow_experimental_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`
allow_experimental_eval_table_function	`0`

私有预览设置

名称	默认值
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`
enable_time_series_aggregate_functions	`0`
promql_database	“
promql_table	“
promql_evaluation_time	`auto`

SQL 参考文档

数据类型

引擎

函数

格式

设置

系统表

数据湖

Beta 功能

Experimental 功能

私有预览功能

Beta 设置

Experimental 设置

私有预览设置

​Beta 功能

​Experimental 功能

​私有预览功能

​Beta 设置

​Experimental 设置

​私有预览设置

Beta 功能

Experimental 功能

私有预览功能

Beta 设置

Experimental 设置

私有预览设置