> ## 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) と見なされるまでに、長期のプロトタイピング段階や、コミュニティからの十分なフィードバックと改善のための時間を要する場合があります。
機能がいつ一般提供として分類されるかは一律ではないため、機能を **ベータ** と **実験的** の 2 つのカテゴリに分けています。
**ベータ** 機能は ClickHouse チームによって公式にサポートされています。**実験的** 機能は、ClickHouse チームまたはコミュニティ主導で開発されている初期段階のプロトタイプであり、公式にはサポートされていません。
以下のセクションでは、**ベータ** 機能と **実験的** 機能の特性を明確に説明します。
## ベータ機能
* 一般提供 (GA) に向けて現在も活発に開発が進められています
* 主な既知の問題は GitHub で追跡できます
* 今後、機能が変更される可能性があります
* ClickHouse Cloud で有効になる場合があります
* ClickHouse チームはベータ機能をサポートしています
以下に、ClickHouse Cloud でベータと見なされ、ClickHouse Cloud サービスで利用可能な機能を示します。
注: 最近導入された機能を利用するには、ClickHouse の [compatibility](/ja/reference/settings/session-settings#compatibility) 設定で最新バージョンを使用していることを必ず確認してください。
## 実験的機能
* GA になるとは限りません
* 削除される可能性があります
* 互換性を損なう変更が入る可能性があります
* 機能の動作が変更される可能性があります
* 明示的に有効化する必要があります
* ClickHouse チームは**実験的機能をサポートしていません**
* 重要な機能やドキュメントが不足している場合があります
* Cloud では有効化できません
ご注意ください: 上記でベータとして記載されているものを除き、ClickHouse Cloud では追加の実験的機能は有効化できません。
{/*AUTOGENERATED_START*/}
## ベータ設定
| 名前 | デフォルト |
| --------------------------------------------------------------------------------------------------------------------------------------- | --------- |
| [geotoh3\_argument\_order](/ja/reference/settings/session-settings#geotoh3_argument_order) | `lat_lon` |
| [enable\_lightweight\_update](/ja/reference/settings/session-settings#enable_lightweight_update) | `1` |
| [allow\_experimental\_correlated\_subqueries](/ja/reference/settings/session-settings#allow_experimental_correlated_subqueries) | `1` |
| [parallel\_replicas\_count](/ja/reference/settings/session-settings#parallel_replicas_count) | `0` |
| [parallel\_replica\_offset](/ja/reference/settings/session-settings#parallel_replica_offset) | `0` |
| [parallel\_replicas\_custom\_key](/ja/reference/settings/session-settings#parallel_replicas_custom_key) | \`\` |
| [parallel\_replicas\_custom\_key\_range\_lower](/ja/reference/settings/session-settings#parallel_replicas_custom_key_range_lower) | `0` |
| [parallel\_replicas\_custom\_key\_range\_upper](/ja/reference/settings/session-settings#parallel_replicas_custom_key_range_upper) | `0` |
| [parallel\_replicas\_filter\_pushdown](/ja/reference/settings/session-settings#parallel_replicas_filter_pushdown) | `0` |
| [parallel\_replicas\_allow\_view\_over\_mergetree](/ja/reference/settings/session-settings#parallel_replicas_allow_view_over_mergetree) | `0` |
| [allow\_experimental\_database\_iceberg](/ja/reference/settings/session-settings#allow_experimental_database_iceberg) | `0` |
| [allow\_experimental\_database\_unity\_catalog](/ja/reference/settings/session-settings#allow_experimental_database_unity_catalog) | `0` |
| [allow\_experimental\_database\_glue\_catalog](/ja/reference/settings/session-settings#allow_experimental_database_glue_catalog) | `0` |
| [session\_timezone](/ja/reference/settings/session-settings#session_timezone) | \`\` |
| [low\_priority\_query\_wait\_time\_ms](/ja/reference/settings/session-settings#low_priority_query_wait_time_ms) | `1000` |
| [allow\_experimental\_delta\_kernel\_rs](/ja/reference/settings/session-settings#allow_experimental_delta_kernel_rs) | `1` |
| [allow\_insert\_into\_iceberg](/ja/reference/settings/session-settings#allow_insert_into_iceberg) | `0` |
| [enable\_join\_runtime\_filters](/ja/reference/settings/session-settings#enable_join_runtime_filters) | `1` |
## 実験的な設定
| 名前 | 既定値 |
| ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | ----------------------- |
| [query\_plan\_optimize\_join\_order\_randomize](/ja/reference/settings/session-settings#query_plan_optimize_join_order_randomize) | `0` |
| [enable\_join\_transitive\_predicates](/ja/reference/settings/session-settings#enable_join_transitive_predicates) | `0` |
| [ast\_fuzzer\_runs](/ja/reference/settings/session-settings#ast_fuzzer_runs) | `0` |
| [ast\_fuzzer\_any\_query](/ja/reference/settings/session-settings#ast_fuzzer_any_query) | `0` |
| [allow\_fuzz\_query\_functions](/ja/reference/settings/session-settings#allow_fuzz_query_functions) | `0` |
| [enable\_materialized\_cte](/ja/reference/settings/session-settings#enable_materialized_cte) | `0` |
| [analyzer\_inline\_views](/ja/reference/settings/session-settings#analyzer_inline_views) | `0` |
| [allow\_experimental\_kafka\_offsets\_storage\_in\_keeper](/ja/reference/settings/session-settings#allow_experimental_kafka_offsets_storage_in_keeper) | `0` |
| [allow\_experimental\_delta\_lake\_writes](/ja/reference/settings/session-settings#allow_experimental_delta_lake_writes) | `0` |
| [automatic\_parallel\_replicas\_mode](/ja/reference/settings/session-settings#automatic_parallel_replicas_mode) | `0` |
| [automatic\_parallel\_replicas\_min\_bytes\_per\_replica](/ja/reference/settings/session-settings#automatic_parallel_replicas_min_bytes_per_replica) | `1048576` |
| [distributed\_index\_analysis](/ja/reference/settings/session-settings#distributed_index_analysis) | `0` |
| [allow\_experimental\_materialized\_postgresql\_table](/ja/reference/settings/session-settings#allow_experimental_materialized_postgresql_table) | `0` |
| [allow\_experimental\_funnel\_functions](/ja/reference/settings/session-settings#allow_experimental_funnel_functions) | `0` |
| [allow\_experimental\_nlp\_functions](/ja/reference/settings/session-settings#allow_experimental_nlp_functions) | `0` |
| [allow\_experimental\_hash\_functions](/ja/reference/settings/session-settings#allow_experimental_hash_functions) | `0` |
| [allow\_experimental\_time\_series\_table](/ja/reference/settings/session-settings#allow_experimental_time_series_table) | `0` |
| [allow\_experimental\_unique\_key](/ja/reference/settings/session-settings#allow_experimental_unique_key) | `0` |
| [allow\_experimental\_codecs](/ja/reference/settings/session-settings#allow_experimental_codecs) | `0` |
| [throw\_on\_unsupported\_query\_inside\_transaction](/ja/reference/settings/session-settings#throw_on_unsupported_query_inside_transaction) | `1` |
| [wait\_changes\_become\_visible\_after\_commit\_mode](/ja/reference/settings/session-settings#wait_changes_become_visible_after_commit_mode) | `wait_unknown` |
| [implicit\_transaction](/ja/reference/settings/session-settings#implicit_transaction) | `0` |
| [grace\_hash\_join\_initial\_buckets](/ja/reference/settings/session-settings#grace_hash_join_initial_buckets) | `1` |
| [grace\_hash\_join\_max\_buckets](/ja/reference/settings/session-settings#grace_hash_join_max_buckets) | `1024` |
| [join\_to\_sort\_minimum\_perkey\_rows](/ja/reference/settings/session-settings#join_to_sort_minimum_perkey_rows) | `40` |
| [join\_to\_sort\_maximum\_table\_rows](/ja/reference/settings/session-settings#join_to_sort_maximum_table_rows) | `10000` |
| [allow\_experimental\_join\_right\_table\_sorting](/ja/reference/settings/session-settings#allow_experimental_join_right_table_sorting) | `0` |
| [allow\_experimental\_json\_lazy\_type\_hints](/ja/reference/settings/session-settings#allow_experimental_json_lazy_type_hints) | `0` |
| [allow\_experimental\_window\_view](/ja/reference/settings/session-settings#allow_experimental_window_view) | `0` |
| [window\_view\_clean\_interval](/ja/reference/settings/session-settings#window_view_clean_interval) | `60` |
| [window\_view\_heartbeat\_interval](/ja/reference/settings/session-settings#window_view_heartbeat_interval) | `15` |
| [wait\_for\_window\_view\_fire\_signal\_timeout](/ja/reference/settings/session-settings#wait_for_window_view_fire_signal_timeout) | `10` |
| [stop\_refreshable\_materialized\_views\_on\_startup](/ja/reference/settings/session-settings#stop_refreshable_materialized_views_on_startup) | `0` |
| [allow\_experimental\_database\_materialized\_postgresql](/ja/reference/settings/session-settings#allow_experimental_database_materialized_postgresql) | `0` |
| [allow\_experimental\_nullable\_tuple\_type](/ja/reference/settings/session-settings#allow_experimental_nullable_tuple_type) | `0` |
| [allow\_experimental\_query\_deduplication](/ja/reference/settings/session-settings#allow_experimental_query_deduplication) | `0` |
| [allow\_experimental\_database\_hms\_catalog](/ja/reference/settings/session-settings#allow_experimental_database_hms_catalog) | `0` |
| [allow\_experimental\_kusto\_dialect](/ja/reference/settings/session-settings#allow_experimental_kusto_dialect) | `0` |
| [allow\_experimental\_prql\_dialect](/ja/reference/settings/session-settings#allow_experimental_prql_dialect) | `0` |
| [allow\_experimental\_polyglot\_dialect](/ja/reference/settings/session-settings#allow_experimental_polyglot_dialect) | `0` |
| [polyglot\_dialect](/ja/reference/settings/session-settings#polyglot_dialect) | \`\` |
| [enable\_adaptive\_memory\_spill\_scheduler](/ja/reference/settings/session-settings#enable_adaptive_memory_spill_scheduler) | `0` |
| [allow\_experimental\_cleanup\_old\_data\_files\_compaction](/ja/reference/settings/session-settings#allow_experimental_cleanup_old_data_files_compaction) | `0` |
| [allow\_experimental\_iceberg\_compaction](/ja/reference/settings/session-settings#allow_experimental_iceberg_compaction) | `0` |
| [allow\_iceberg\_remove\_orphan\_files](/ja/reference/settings/session-settings#allow_iceberg_remove_orphan_files) | `0` |
| [iceberg\_orphan\_files\_older\_than\_seconds](/ja/reference/settings/session-settings#iceberg_orphan_files_older_than_seconds) | `259200` |
| [allow\_experimental\_expire\_snapshots](/ja/reference/settings/session-settings#allow_experimental_expire_snapshots) | `0` |
| [write\_full\_path\_in\_iceberg\_metadata](/ja/reference/settings/session-settings#write_full_path_in_iceberg_metadata) | `0` |
| [iceberg\_metadata\_compression\_method](/ja/reference/settings/session-settings#iceberg_metadata_compression_method) | \`\` |
| [make\_distributed\_plan](/ja/reference/settings/session-settings#make_distributed_plan) | `0` |
| [distributed\_plan\_execute\_locally](/ja/reference/settings/session-settings#distributed_plan_execute_locally) | `0` |
| [distributed\_plan\_default\_shuffle\_join\_bucket\_count](/ja/reference/settings/session-settings#distributed_plan_default_shuffle_join_bucket_count) | `8` |
| [distributed\_plan\_default\_reader\_bucket\_count](/ja/reference/settings/session-settings#distributed_plan_default_reader_bucket_count) | `8` |
| [distributed\_plan\_force\_exchange\_kind](/ja/reference/settings/session-settings#distributed_plan_force_exchange_kind) | \`\` |
| [distributed\_plan\_max\_rows\_to\_broadcast](/ja/reference/settings/session-settings#distributed_plan_max_rows_to_broadcast) | `20000` |
| [distributed\_plan\_prefer\_replicas\_over\_workers](/ja/reference/settings/session-settings#distributed_plan_prefer_replicas_over_workers) | `0` |
| [allow\_experimental\_ytsaurus\_table\_engine](/ja/reference/settings/session-settings#allow_experimental_ytsaurus_table_engine) | `0` |
| [allow\_experimental\_ytsaurus\_table\_function](/ja/reference/settings/session-settings#allow_experimental_ytsaurus_table_function) | `0` |
| [allow\_experimental\_ytsaurus\_dictionary\_source](/ja/reference/settings/session-settings#allow_experimental_ytsaurus_dictionary_source) | `0` |
| [distributed\_plan\_force\_shuffle\_aggregation](/ja/reference/settings/session-settings#distributed_plan_force_shuffle_aggregation) | `0` |
| [join\_runtime\_filter\_exact\_values\_limit](/ja/reference/settings/session-settings#join_runtime_filter_exact_values_limit) | `10000` |
| [join\_runtime\_bloom\_filter\_bytes](/ja/reference/settings/session-settings#join_runtime_bloom_filter_bytes) | `524288` |
| [join\_runtime\_bloom\_filter\_hash\_functions](/ja/reference/settings/session-settings#join_runtime_bloom_filter_hash_functions) | `3` |
| [join\_runtime\_filter\_pass\_ratio\_threshold\_for\_disabling](/ja/reference/settings/session-settings#join_runtime_filter_pass_ratio_threshold_for_disabling) | `0.7` |
| [join\_runtime\_filter\_blocks\_to\_skip\_before\_reenabling](/ja/reference/settings/session-settings#join_runtime_filter_blocks_to_skip_before_reenabling) | `30` |
| [join\_runtime\_bloom\_filter\_max\_ratio\_of\_set\_bits](/ja/reference/settings/session-settings#join_runtime_bloom_filter_max_ratio_of_set_bits) | `0.7` |
| [rewrite\_in\_to\_join](/ja/reference/settings/session-settings#rewrite_in_to_join) | `0` |
| [allow\_experimental\_time\_series\_aggregate\_functions](/ja/reference/settings/session-settings#allow_experimental_time_series_aggregate_functions) | `0` |
| [promql\_database](/ja/reference/settings/session-settings#promql_database) | \`\` |
| [promql\_table](/ja/reference/settings/session-settings#promql_table) | \`\` |
| [promql\_evaluation\_time](/ja/reference/settings/session-settings#promql_evaluation_time) | `auto` |
| [allow\_experimental\_alias\_table\_engine](/ja/reference/settings/session-settings#allow_experimental_alias_table_engine) | `0` |
| [allow\_experimental\_paimon\_storage\_engine](/ja/reference/settings/session-settings) | `0` |
| [paimon\_target\_snapshot\_id](/ja/reference/settings/session-settings) | `-1` |
| [max\_consume\_snapshots](/ja/reference/settings/session-settings) | `0` |
| [use\_paimon\_partition\_pruning](/ja/reference/settings/session-settings#use_paimon_partition_pruning) | `0` |
| [allow\_experimental\_object\_storage\_queue\_hive\_partitioning](/ja/reference/settings/session-settings#allow_experimental_object_storage_queue_hive_partitioning) | `0` |
| [query\_plan\_optimize\_join\_order\_algorithm](/ja/reference/settings/session-settings#query_plan_optimize_join_order_algorithm) | `greedy` |
| [allow\_experimental\_database\_paimon\_rest\_catalog](/ja/reference/settings/session-settings#allow_experimental_database_paimon_rest_catalog) | `0` |
| [webassembly\_udf\_max\_fuel](/ja/reference/settings/session-settings#webassembly_udf_max_fuel) | `100000` |
| [webassembly\_udf\_max\_memory](/ja/reference/settings/session-settings#webassembly_udf_max_memory) | `134217728` |
| [webassembly\_udf\_max\_input\_block\_size](/ja/reference/settings/session-settings#webassembly_udf_max_input_block_size) | `0` |
| [webassembly\_udf\_max\_instances](/ja/reference/settings/session-settings#webassembly_udf_max_instances) | `32` |
| [allow\_experimental\_ai\_functions](/ja/reference/settings/session-settings#allow_experimental_ai_functions) | `0` |
| [ai\_function\_request\_timeout\_sec](/ja/reference/settings/session-settings#ai_function_request_timeout_sec) | `60` |
| [ai\_function\_max\_retries](/ja/reference/settings/session-settings#ai_function_max_retries) | `0` |
| [ai\_function\_retry\_initial\_delay\_ms](/ja/reference/settings/session-settings#ai_function_retry_initial_delay_ms) | `1000` |
| [ai\_function\_throw\_on\_error](/ja/reference/settings/session-settings#ai_function_throw_on_error) | `1` |
| [ai\_function\_max\_input\_tokens\_per\_query](/ja/reference/settings/session-settings#ai_function_max_input_tokens_per_query) | `1000000` |
| [ai\_function\_max\_output\_tokens\_per\_query](/ja/reference/settings/session-settings#ai_function_max_output_tokens_per_query) | `500000` |
| [ai\_function\_max\_api\_calls\_per\_query](/ja/reference/settings/session-settings#ai_function_max_api_calls_per_query) | `0` |
| [ai\_function\_throw\_on\_quota\_exceeded](/ja/reference/settings/session-settings#ai_function_throw_on_quota_exceeded) | `1` |
| [allow\_commit\_order\_projection](/ja/reference/settings/merge-tree-settings#allow_commit_order_projection) | `0` |
| [allow\_experimental\_replacing\_merge\_with\_cleanup](/ja/reference/settings/merge-tree-settings#allow_experimental_replacing_merge_with_cleanup) | `0` |
| [allow\_experimental\_reverse\_key](/ja/reference/settings/merge-tree-settings#allow_experimental_reverse_key) | `0` |
| [allow\_remote\_fs\_zero\_copy\_replication](/ja/reference/settings/merge-tree-settings#allow_remote_fs_zero_copy_replication) | `0` |
| [distributed\_index\_analysis\_min\_indexes\_bytes\_to\_activate](/ja/reference/settings/merge-tree-settings#distributed_index_analysis_min_indexes_bytes_to_activate) | `1073741824` |
| [distributed\_index\_analysis\_min\_parts\_to\_activate](/ja/reference/settings/merge-tree-settings#distributed_index_analysis_min_parts_to_activate) | `10` |
| [enable\_replacing\_merge\_with\_cleanup\_for\_min\_age\_to\_force\_merge](/ja/reference/settings/merge-tree-settings#enable_replacing_merge_with_cleanup_for_min_age_to_force_merge) | `0` |
| [force\_read\_through\_cache\_for\_merges](/ja/reference/settings/merge-tree-settings#force_read_through_cache_for_merges) | `0` |
| [merge\_selector\_algorithm](/ja/reference/settings/merge-tree-settings#merge_selector_algorithm) | `Simple` |
| [merge\_selector\_enable\_heuristic\_to\_lower\_max\_parts\_to\_merge\_at\_once](/ja/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](/ja/reference/settings/merge-tree-settings#merge_selector_heuristic_to_lower_max_parts_to_merge_at_once_exponent) | `5` |
| [notify\_newest\_block\_number](/ja/reference/settings/merge-tree-settings#notify_newest_block_number) | `0` |
| [part\_moves\_between\_shards\_delay\_seconds](/ja/reference/settings/merge-tree-settings#part_moves_between_shards_delay_seconds) | `30` |
| [part\_moves\_between\_shards\_enable](/ja/reference/settings/merge-tree-settings#part_moves_between_shards_enable) | `0` |
| [remote\_fs\_zero\_copy\_path\_compatible\_mode](/ja/reference/settings/merge-tree-settings#remote_fs_zero_copy_path_compatible_mode) | `0` |
| [remote\_fs\_zero\_copy\_zookeeper\_path](/ja/reference/settings/merge-tree-settings#remote_fs_zero_copy_zookeeper_path) | `/clickhouse/zero_copy` |
| [remove\_rolled\_back\_parts\_immediately](/ja/reference/settings/merge-tree-settings#remove_rolled_back_parts_immediately) | `1` |
| [shared\_merge\_tree\_virtual\_parts\_discovery\_batch](/ja/reference/settings/merge-tree-settings#shared_merge_tree_virtual_parts_discovery_batch) | `1` |