> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-fix-nav-issues.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.
# Бета- и экспериментальные возможности
> В ClickHouse есть бета- и экспериментальные возможности. На этой странице документации рассматриваются эти понятия.
Поскольку ClickHouse — проект с открытым исходным кодом, в его развитие вносят вклад не только сотрудники ClickHouse, но и сообщество. Эти изменения часто разрабатываются с разной скоростью; некоторым возможностям может потребоваться длительный этап прототипирования или больше времени на получение достаточной обратной связи от сообщества и доработку, прежде чем их можно будет считать общедоступными (GA).
Поскольку не всегда очевидно, когда возможность можно отнести к общедоступным, мы разделяем возможности на две категории: **бета** и **экспериментальные**.
Возможности **бета** официально поддерживаются командой ClickHouse. **Экспериментальные** возможности — это ранние прототипы, разрабатываемые либо командой ClickHouse, либо сообществом, и они официально не поддерживаются.
В разделах ниже подробно описаны свойства возможностей **бета** и **экспериментальных** возможностей:
## бета-функции
* Находятся в активной разработке и готовятся к выходу в GA
* Основные известные проблемы можно отслеживать на GitHub
* Функциональность может измениться в будущем
* Могут быть включены в ClickHouse Cloud
* Команда ClickHouse поддерживает бета-функции
Ниже перечислены возможности, которые считаются бета-функциями в ClickHouse Cloud и доступны для использования в ваших сервисах ClickHouse Cloud.
Примечание: убедитесь, что вы используете актуальную версию настройки ClickHouse [compatibility](/ru/reference/settings/session-settings#compatibility), чтобы иметь доступ к недавно появившейся возможности.
## Экспериментальные возможности
* Могут никогда не выйти в GA
* Могут быть удалены
* Могут вносить несовместимые изменения
* Функциональность может измениться
* Требуют явного включения
* Команда ClickHouse **не поддерживает** экспериментальные возможности
* Могут не иметь важных функций и документации
* Нельзя включить в ClickHouse Cloud
Обратите внимание: в ClickHouse Cloud нельзя включать никакие дополнительные экспериментальные возможности, кроме тех, что перечислены выше как бета.
{/*AUTOGENERATED_START*/}
## Бета-настройки
| Название | По умолчанию |
| --------------------------------------------------------------------------------------------------------------------------------------- | ------------ |
| [geotoh3\_argument\_order](/ru/reference/settings/session-settings#geotoh3_argument_order) | `lat_lon` |
| [enable\_lightweight\_update](/ru/reference/settings/session-settings#enable_lightweight_update) | `1` |
| [allow\_experimental\_correlated\_subqueries](/ru/reference/settings/session-settings#allow_experimental_correlated_subqueries) | `1` |
| [parallel\_replicas\_count](/ru/reference/settings/session-settings#parallel_replicas_count) | `0` |
| [parallel\_replica\_offset](/ru/reference/settings/session-settings#parallel_replica_offset) | `0` |
| [parallel\_replicas\_custom\_key](/ru/reference/settings/session-settings#parallel_replicas_custom_key) | \`\` |
| [parallel\_replicas\_custom\_key\_range\_lower](/ru/reference/settings/session-settings#parallel_replicas_custom_key_range_lower) | `0` |
| [parallel\_replicas\_custom\_key\_range\_upper](/ru/reference/settings/session-settings#parallel_replicas_custom_key_range_upper) | `0` |
| [parallel\_replicas\_filter\_pushdown](/ru/reference/settings/session-settings#parallel_replicas_filter_pushdown) | `0` |
| [parallel\_replicas\_allow\_view\_over\_mergetree](/ru/reference/settings/session-settings#parallel_replicas_allow_view_over_mergetree) | `0` |
| [allow\_experimental\_database\_iceberg](/ru/reference/settings/session-settings#allow_experimental_database_iceberg) | `0` |
| [allow\_experimental\_database\_unity\_catalog](/ru/reference/settings/session-settings#allow_experimental_database_unity_catalog) | `0` |
| [allow\_experimental\_database\_glue\_catalog](/ru/reference/settings/session-settings#allow_experimental_database_glue_catalog) | `0` |
| [session\_timezone](/ru/reference/settings/session-settings#session_timezone) | \`\` |
| [low\_priority\_query\_wait\_time\_ms](/ru/reference/settings/session-settings#low_priority_query_wait_time_ms) | `1000` |
| [allow\_experimental\_delta\_kernel\_rs](/ru/reference/settings/session-settings#allow_experimental_delta_kernel_rs) | `1` |
| [allow\_insert\_into\_iceberg](/ru/reference/settings/session-settings#allow_insert_into_iceberg) | `0` |
| [enable\_join\_runtime\_filters](/ru/reference/settings/session-settings#enable_join_runtime_filters) | `1` |
## Экспериментальные настройки
| Название | По умолчанию |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------------------- |
| [query\_plan\_optimize\_join\_order\_randomize](/ru/reference/settings/session-settings#query_plan_optimize_join_order_randomize) | `0` |
| [enable\_join\_transitive\_predicates](/ru/reference/settings/session-settings#enable_join_transitive_predicates) | `0` |
| [ast\_fuzzer\_runs](/ru/reference/settings/session-settings#ast_fuzzer_runs) | `0` |
| [ast\_fuzzer\_any\_query](/ru/reference/settings/session-settings#ast_fuzzer_any_query) | `0` |
| [allow\_fuzz\_query\_functions](/ru/reference/settings/session-settings#allow_fuzz_query_functions) | `0` |
| [enable\_materialized\_cte](/ru/reference/settings/session-settings#enable_materialized_cte) | `0` |
| [analyzer\_inline\_views](/ru/reference/settings/session-settings#analyzer_inline_views) | `0` |
| [allow\_experimental\_kafka\_offsets\_storage\_in\_keeper](/ru/reference/settings/session-settings#allow_experimental_kafka_offsets_storage_in_keeper) | `0` |
| [allow\_experimental\_delta\_lake\_writes](/ru/reference/settings/session-settings#allow_experimental_delta_lake_writes) | `0` |
| [automatic\_parallel\_replicas\_mode](/ru/reference/settings/session-settings#automatic_parallel_replicas_mode) | `0` |
| [automatic\_parallel\_replicas\_min\_bytes\_per\_replica](/ru/reference/settings/session-settings#automatic_parallel_replicas_min_bytes_per_replica) | `1048576` |
| [distributed\_index\_analysis](/ru/reference/settings/session-settings#distributed_index_analysis) | `0` |
| [allow\_experimental\_materialized\_postgresql\_table](/ru/reference/settings/session-settings#allow_experimental_materialized_postgresql_table) | `0` |
| [allow\_experimental\_funnel\_functions](/ru/reference/settings/session-settings#allow_experimental_funnel_functions) | `0` |
| [allow\_experimental\_nlp\_functions](/ru/reference/settings/session-settings#allow_experimental_nlp_functions) | `0` |
| [allow\_experimental\_hash\_functions](/ru/reference/settings/session-settings#allow_experimental_hash_functions) | `0` |
| [allow\_experimental\_time\_series\_table](/ru/reference/settings/session-settings#allow_experimental_time_series_table) | `0` |
| [allow\_experimental\_unique\_key](/ru/reference/settings/session-settings#allow_experimental_unique_key) | `0` |
| [allow\_experimental\_codecs](/ru/reference/settings/session-settings#allow_experimental_codecs) | `0` |
| [throw\_on\_unsupported\_query\_inside\_transaction](/ru/reference/settings/session-settings#throw_on_unsupported_query_inside_transaction) | `1` |
| [wait\_changes\_become\_visible\_after\_commit\_mode](/ru/reference/settings/session-settings#wait_changes_become_visible_after_commit_mode) | `wait_unknown` |
| [implicit\_transaction](/ru/reference/settings/session-settings#implicit_transaction) | `0` |
| [grace\_hash\_join\_initial\_buckets](/ru/reference/settings/session-settings#grace_hash_join_initial_buckets) | `1` |
| [grace\_hash\_join\_max\_buckets](/ru/reference/settings/session-settings#grace_hash_join_max_buckets) | `1024` |
| [join\_to\_sort\_minimum\_perkey\_rows](/ru/reference/settings/session-settings#join_to_sort_minimum_perkey_rows) | `40` |
| [join\_to\_sort\_maximum\_table\_rows](/ru/reference/settings/session-settings#join_to_sort_maximum_table_rows) | `10000` |
| [allow\_experimental\_join\_right\_table\_sorting](/ru/reference/settings/session-settings#allow_experimental_join_right_table_sorting) | `0` |
| [allow\_experimental\_json\_lazy\_type\_hints](/ru/reference/settings/session-settings#allow_experimental_json_lazy_type_hints) | `0` |
| [allow\_experimental\_window\_view](/ru/reference/settings/session-settings#allow_experimental_window_view) | `0` |
| [window\_view\_clean\_interval](/ru/reference/settings/session-settings#window_view_clean_interval) | `60` |
| [window\_view\_heartbeat\_interval](/ru/reference/settings/session-settings#window_view_heartbeat_interval) | `15` |
| [wait\_for\_window\_view\_fire\_signal\_timeout](/ru/reference/settings/session-settings#wait_for_window_view_fire_signal_timeout) | `10` |
| [stop\_refreshable\_materialized\_views\_on\_startup](/ru/reference/settings/session-settings#stop_refreshable_materialized_views_on_startup) | `0` |
| [allow\_experimental\_database\_materialized\_postgresql](/ru/reference/settings/session-settings#allow_experimental_database_materialized_postgresql) | `0` |
| [allow\_experimental\_nullable\_tuple\_type](/ru/reference/settings/session-settings#allow_experimental_nullable_tuple_type) | `0` |
| [allow\_experimental\_query\_deduplication](/ru/reference/settings/session-settings#allow_experimental_query_deduplication) | `0` |
| [allow\_experimental\_database\_hms\_catalog](/ru/reference/settings/session-settings#allow_experimental_database_hms_catalog) | `0` |
| [allow\_experimental\_kusto\_dialect](/ru/reference/settings/session-settings#allow_experimental_kusto_dialect) | `0` |
| [allow\_experimental\_prql\_dialect](/ru/reference/settings/session-settings#allow_experimental_prql_dialect) | `0` |
| [allow\_experimental\_polyglot\_dialect](/ru/reference/settings/session-settings#allow_experimental_polyglot_dialect) | `0` |
| [polyglot\_dialect](/ru/reference/settings/session-settings#polyglot_dialect) | \`\` |
| [enable\_adaptive\_memory\_spill\_scheduler](/ru/reference/settings/session-settings#enable_adaptive_memory_spill_scheduler) | `0` |
| [allow\_experimental\_cleanup\_old\_data\_files\_compaction](/ru/reference/settings/session-settings#allow_experimental_cleanup_old_data_files_compaction) | `0` |
| [allow\_experimental\_iceberg\_compaction](/ru/reference/settings/session-settings#allow_experimental_iceberg_compaction) | `0` |
| [allow\_iceberg\_remove\_orphan\_files](/ru/reference/settings/session-settings#allow_iceberg_remove_orphan_files) | `0` |
| [iceberg\_orphan\_files\_older\_than\_seconds](/ru/reference/settings/session-settings#iceberg_orphan_files_older_than_seconds) | `259200` |
| [allow\_experimental\_expire\_snapshots](/ru/reference/settings/session-settings#allow_experimental_expire_snapshots) | `0` |
| [write\_full\_path\_in\_iceberg\_metadata](/ru/reference/settings/session-settings#write_full_path_in_iceberg_metadata) | `0` |
| [iceberg\_metadata\_compression\_method](/ru/reference/settings/session-settings#iceberg_metadata_compression_method) | \`\` |
| [make\_distributed\_plan](/ru/reference/settings/session-settings#make_distributed_plan) | `0` |
| [distributed\_plan\_execute\_locally](/ru/reference/settings/session-settings#distributed_plan_execute_locally) | `0` |
| [distributed\_plan\_default\_shuffle\_join\_bucket\_count](/ru/reference/settings/session-settings#distributed_plan_default_shuffle_join_bucket_count) | `8` |
| [distributed\_plan\_default\_reader\_bucket\_count](/ru/reference/settings/session-settings#distributed_plan_default_reader_bucket_count) | `8` |
| [distributed\_plan\_force\_exchange\_kind](/ru/reference/settings/session-settings#distributed_plan_force_exchange_kind) | \`\` |
| [distributed\_plan\_max\_rows\_to\_broadcast](/ru/reference/settings/session-settings#distributed_plan_max_rows_to_broadcast) | `20000` |
| [distributed\_plan\_prefer\_replicas\_over\_workers](/ru/reference/settings/session-settings#distributed_plan_prefer_replicas_over_workers) | `0` |
| [allow\_experimental\_ytsaurus\_table\_engine](/ru/reference/settings/session-settings#allow_experimental_ytsaurus_table_engine) | `0` |
| [allow\_experimental\_ytsaurus\_table\_function](/ru/reference/settings/session-settings#allow_experimental_ytsaurus_table_function) | `0` |
| [allow\_experimental\_ytsaurus\_dictionary\_source](/ru/reference/settings/session-settings#allow_experimental_ytsaurus_dictionary_source) | `0` |
| [distributed\_plan\_force\_shuffle\_aggregation](/ru/reference/settings/session-settings#distributed_plan_force_shuffle_aggregation) | `0` |
| [join\_runtime\_filter\_exact\_values\_limit](/ru/reference/settings/session-settings#join_runtime_filter_exact_values_limit) | `10000` |
| [join\_runtime\_bloom\_filter\_bytes](/ru/reference/settings/session-settings#join_runtime_bloom_filter_bytes) | `524288` |
| [join\_runtime\_bloom\_filter\_hash\_functions](/ru/reference/settings/session-settings#join_runtime_bloom_filter_hash_functions) | `3` |
| [join\_runtime\_filter\_pass\_ratio\_threshold\_for\_disabling](/ru/reference/settings/session-settings#join_runtime_filter_pass_ratio_threshold_for_disabling) | `0.7` |
| [join\_runtime\_filter\_blocks\_to\_skip\_before\_reenabling](/ru/reference/settings/session-settings#join_runtime_filter_blocks_to_skip_before_reenabling) | `30` |
| [join\_runtime\_bloom\_filter\_max\_ratio\_of\_set\_bits](/ru/reference/settings/session-settings#join_runtime_bloom_filter_max_ratio_of_set_bits) | `0.7` |
| [rewrite\_in\_to\_join](/ru/reference/settings/session-settings#rewrite_in_to_join) | `0` |
| [allow\_experimental\_time\_series\_aggregate\_functions](/ru/reference/settings/session-settings#allow_experimental_time_series_aggregate_functions) | `0` |
| [promql\_database](/ru/reference/settings/session-settings#promql_database) | \`\` |
| [promql\_table](/ru/reference/settings/session-settings#promql_table) | \`\` |
| [promql\_evaluation\_time](/ru/reference/settings/session-settings#promql_evaluation_time) | `auto` |
| [allow\_experimental\_alias\_table\_engine](/ru/reference/settings/session-settings#allow_experimental_alias_table_engine) | `0` |
| [allow\_experimental\_paimon\_storage\_engine](/ru/reference/settings/session-settings) | `0` |
| [paimon\_target\_snapshot\_id](/ru/reference/settings/session-settings) | `-1` |
| [max\_consume\_snapshots](/ru/reference/settings/session-settings) | `0` |
| [use\_paimon\_partition\_pruning](/ru/reference/settings/session-settings#use_paimon_partition_pruning) | `0` |
| [allow\_experimental\_object\_storage\_queue\_hive\_partitioning](/ru/reference/settings/session-settings#allow_experimental_object_storage_queue_hive_partitioning) | `0` |
| [query\_plan\_optimize\_join\_order\_algorithm](/ru/reference/settings/session-settings#query_plan_optimize_join_order_algorithm) | `greedy` |
| [allow\_experimental\_database\_paimon\_rest\_catalog](/ru/reference/settings/session-settings#allow_experimental_database_paimon_rest_catalog) | `0` |
| [webassembly\_udf\_max\_fuel](/ru/reference/settings/session-settings#webassembly_udf_max_fuel) | `100000` |
| [webassembly\_udf\_max\_memory](/ru/reference/settings/session-settings#webassembly_udf_max_memory) | `134217728` |
| [webassembly\_udf\_max\_input\_block\_size](/ru/reference/settings/session-settings#webassembly_udf_max_input_block_size) | `0` |
| [webassembly\_udf\_max\_instances](/ru/reference/settings/session-settings#webassembly_udf_max_instances) | `32` |
| [allow\_experimental\_ai\_functions](/ru/reference/settings/session-settings#allow_experimental_ai_functions) | `0` |
| [ai\_function\_request\_timeout\_sec](/ru/reference/settings/session-settings#ai_function_request_timeout_sec) | `60` |
| [ai\_function\_max\_retries](/ru/reference/settings/session-settings#ai_function_max_retries) | `0` |
| [ai\_function\_retry\_initial\_delay\_ms](/ru/reference/settings/session-settings#ai_function_retry_initial_delay_ms) | `1000` |
| [ai\_function\_throw\_on\_error](/ru/reference/settings/session-settings#ai_function_throw_on_error) | `1` |
| [ai\_function\_max\_input\_tokens\_per\_query](/ru/reference/settings/session-settings#ai_function_max_input_tokens_per_query) | `1000000` |
| [ai\_function\_max\_output\_tokens\_per\_query](/ru/reference/settings/session-settings#ai_function_max_output_tokens_per_query) | `500000` |
| [ai\_function\_max\_api\_calls\_per\_query](/ru/reference/settings/session-settings#ai_function_max_api_calls_per_query) | `0` |
| [ai\_function\_throw\_on\_quota\_exceeded](/ru/reference/settings/session-settings#ai_function_throw_on_quota_exceeded) | `1` |
| [allow\_commit\_order\_projection](/ru/reference/settings/merge-tree-settings#allow_commit_order_projection) | `0` |
| [allow\_experimental\_replacing\_merge\_with\_cleanup](/ru/reference/settings/merge-tree-settings#allow_experimental_replacing_merge_with_cleanup) | `0` |
| [allow\_experimental\_reverse\_key](/ru/reference/settings/merge-tree-settings#allow_experimental_reverse_key) | `0` |
| [allow\_remote\_fs\_zero\_copy\_replication](/ru/reference/settings/merge-tree-settings#allow_remote_fs_zero_copy_replication) | `0` |
| [distributed\_index\_analysis\_min\_indexes\_bytes\_to\_activate](/ru/reference/settings/merge-tree-settings#distributed_index_analysis_min_indexes_bytes_to_activate) | `1073741824` |
| [distributed\_index\_analysis\_min\_parts\_to\_activate](/ru/reference/settings/merge-tree-settings#distributed_index_analysis_min_parts_to_activate) | `10` |
| [enable\_replacing\_merge\_with\_cleanup\_for\_min\_age\_to\_force\_merge](/ru/reference/settings/merge-tree-settings#enable_replacing_merge_with_cleanup_for_min_age_to_force_merge) | `0` |
| [force\_read\_through\_cache\_for\_merges](/ru/reference/settings/merge-tree-settings#force_read_through_cache_for_merges) | `0` |
| [merge\_selector\_algorithm](/ru/reference/settings/merge-tree-settings#merge_selector_algorithm) | `Simple` |
| [merge\_selector\_enable\_heuristic\_to\_lower\_max\_parts\_to\_merge\_at\_once](/ru/reference/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](/ru/reference/settings/merge-tree-settings#merge_selector_heuristic_to_lower_max_parts_to_merge_at_once_exponent) | `5` |
| [notify\_newest\_block\_number](/ru/reference/settings/merge-tree-settings#notify_newest_block_number) | `0` |
| [part\_moves\_between\_shards\_delay\_seconds](/ru/reference/settings/merge-tree-settings#part_moves_between_shards_delay_seconds) | `30` |
| [part\_moves\_between\_shards\_enable](/ru/reference/settings/merge-tree-settings#part_moves_between_shards_enable) | `0` |
| [remote\_fs\_zero\_copy\_path\_compatible\_mode](/ru/reference/settings/merge-tree-settings#remote_fs_zero_copy_path_compatible_mode) | `0` |
| [remote\_fs\_zero\_copy\_zookeeper\_path](/ru/reference/settings/merge-tree-settings#remote_fs_zero_copy_zookeeper_path) | `/clickhouse/zero_copy` |
| [remove\_rolled\_back\_parts\_immediately](/ru/reference/settings/merge-tree-settings#remove_rolled_back_parts_immediately) | `1` |
| [shared\_merge\_tree\_virtual\_parts\_discovery\_batch](/ru/reference/settings/merge-tree-settings#shared_merge_tree_virtual_parts_discovery_batch) | `1` |