from asynch.proto.settings.types import ( SettingBool, SettingChar, SettingFloat, SettingMaxThreads, SettingString, SettingUInt64, ) SettingInt64 = SettingUInt64 # Seconds and milliseconds should be set as ints. SettingSeconds = SettingMilliseconds = SettingUInt64 # Server cares about possible choices validation. # See https://github.com/yandex/ClickHouse/blob/master/dbms/src/ # Interpreters/Settings.h for all choices. SettingLoadBalancing = SettingTotalsMode = SettingCompressionMethod = ( SettingDistributedProductMode ) = SettingGlobalSubqueriesMethod = SettingDateTimeInputFormat = SettingURI = ( SettingJoinAlgorithm ) = SettingSpecialSort = SettingLogQueriesType = SettingDefaultDatabaseEngine = SettingString settings = { # Settings "min_compress_block_size": SettingUInt64, "max_compress_block_size": SettingUInt64, "max_block_size": SettingUInt64, "max_insert_block_size": SettingUInt64, "min_insert_block_size_rows": SettingUInt64, "min_insert_block_size_bytes": SettingUInt64, "max_partitions_per_insert_block": SettingUInt64, "max_threads": SettingMaxThreads, "max_alter_threads": SettingMaxThreads, "max_read_buffer_size": SettingUInt64, "max_distributed_connections": SettingUInt64, "max_query_size": SettingUInt64, "interactive_delay": SettingUInt64, "connect_timeout": SettingSeconds, "connect_timeout_with_failover_ms": SettingMilliseconds, "receive_timeout": SettingSeconds, "send_timeout": SettingSeconds, "queue_max_wait_ms": SettingMilliseconds, "poll_interval": SettingUInt64, "distributed_connections_pool_size": SettingUInt64, "connections_with_failover_max_tries": SettingUInt64, "extremes": SettingBool, "use_uncompressed_cache": SettingBool, "replace_running_query": SettingBool, "background_pool_size": SettingUInt64, "background_schedule_pool_size": SettingUInt64, "distributed_directory_monitor_sleep_time_ms": SettingMilliseconds, "distributed_directory_monitor_batch_inserts": SettingBool, "distributed_directory_monitor_max_sleep_time_ms": SettingMilliseconds, "optimize_move_to_prewhere": SettingBool, "optimize_skip_unused_shards": SettingBool, "optimize_read_in_order": SettingBool, "optimize_min_equality_disjunction_chain_length": SettingUInt64, "enable_optimize_predicate_expression": SettingBool, "replication_alter_partitions_sync": SettingUInt64, "replication_alter_columns_timeout": SettingUInt64, "load_balancing": SettingLoadBalancing, "totals_mode": SettingTotalsMode, "totals_auto_threshold": SettingFloat, "compile": SettingBool, "compile_expressions": SettingBool, "min_count_to_compile": SettingUInt64, "group_by_two_level_threshold": SettingUInt64, "group_by_two_level_threshold_bytes": SettingUInt64, "distributed_aggregation_memory_efficient": SettingBool, "aggregation_memory_efficient_merge_threads": SettingUInt64, "max_parallel_replicas": SettingUInt64, "parallel_replicas_count": SettingUInt64, "parallel_replica_offset": SettingUInt64, "skip_unavailable_shards": SettingBool, "distributed_group_by_no_merge": SettingBool, "merge_tree_min_rows_for_concurrent_read": SettingUInt64, "merge_tree_min_rows_for_seek": SettingUInt64, "merge_tree_coarse_index_granularity": SettingUInt64, "merge_tree_max_rows_to_use_cache": SettingUInt64, "merge_tree_min_bytes_for_concurrent_read": SettingUInt64, "merge_tree_min_bytes_for_seek": SettingUInt64, "merge_tree_max_bytes_to_use_cache": SettingUInt64, "merge_tree_uniform_read_distribution": SettingBool, "mysql_max_rows_to_insert": SettingUInt64, "min_bytes_to_use_direct_io": SettingUInt64, "force_index_by_date": SettingBool, "force_primary_key": SettingBool, "mark_cache_min_lifetime": SettingUInt64, "max_streams_to_max_threads_ratio": SettingFloat, "network_compression_method": SettingCompressionMethod, "network_zstd_compression_level": SettingInt64, "priority": SettingUInt64, "log_queries": SettingBool, "log_queries_cut_to_length": SettingUInt64, "query_profiler_real_time_period_ns": SettingUInt64, "query_profiler_cpu_time_period_ns": SettingUInt64, "enable_debug_queries": SettingBool, "distributed_product_mode": SettingDistributedProductMode, "max_concurrent_queries_for_user": SettingUInt64, "insert_deduplicate": SettingBool, "insert_quorum": SettingUInt64, "insert_quorum_timeout": SettingMilliseconds, "select_sequential_consistency": SettingUInt64, "table_function_remote_max_addresses": SettingUInt64, "read_backoff_min_latency_ms": SettingMilliseconds, "read_backoff_max_throughput": SettingUInt64, "read_backoff_min_interval_between_events_ms": SettingMilliseconds, "read_backoff_min_events": SettingUInt64, "memory_tracker_fault_probability": SettingFloat, "enable_http_compression": SettingBool, "http_zlib_compression_level": SettingInt64, "http_native_compression_disable_checksumming_on_decompress": SettingBool, "count_distinct_implementation": SettingString, "add_http_cors_header": SettingBool, "input_format_skip_unknown_fields": SettingBool, "input_format_import_nested_json": SettingBool, "input_format_values_interpret_expressions": SettingBool, "input_format_with_names_use_header": SettingBool, "input_format_defaults_for_omitted_fields": SettingBool, "input_format_null_as_default": SettingBool, "input_format_values_deduce_templates_of_expressions": SettingBool, "input_format_values_accurate_types_of_literals": SettingBool, "input_format_allow_errors_num": SettingUInt64, "input_format_allow_errors_ratio": SettingFloat, "input_format_csv_unquoted_null_literal_as_null": SettingBool, "output_format_write_statistics": SettingBool, "output_format_json_quote_64bit_integers": SettingBool, "output_format_json_quote_denormals": SettingBool, "output_format_json_escape_forward_slashes": SettingBool, "output_format_pretty_max_rows": SettingUInt64, "output_format_pretty_max_column_pad_width": SettingUInt64, "output_format_pretty_color": SettingBool, "output_format_parquet_row_group_size": SettingUInt64, "use_client_time_zone": SettingBool, "send_progress_in_http_headers": SettingBool, "http_headers_progress_interval_ms": SettingUInt64, "fsync_metadata": SettingBool, "join_use_nulls": SettingBool, "join_default_strictness": SettingString, "preferred_block_size_bytes": SettingUInt64, "max_replica_delay_for_distributed_queries": SettingUInt64, "fallback_to_stale_replicas_for_distributed_queries": SettingBool, "preferred_max_column_in_block_size_bytes": SettingUInt64, "insert_distributed_sync": SettingBool, "insert_distributed_timeout": SettingUInt64, "distributed_ddl_task_timeout": SettingInt64, "stream_flush_interval_ms": SettingMilliseconds, "format_schema": SettingString, "insert_allow_materialized_columns": SettingBool, "http_connection_timeout": SettingSeconds, "http_send_timeout": SettingSeconds, "http_receive_timeout": SettingSeconds, "optimize_throw_if_noop": SettingBool, "use_index_for_in_with_subqueries": SettingBool, "empty_result_for_aggregation_by_empty_set": SettingBool, "allow_distributed_ddl": SettingBool, "odbc_max_field_size": SettingUInt64, # Limits "max_rows_to_read": SettingUInt64, "max_bytes_to_read": SettingUInt64, "read_overflow_mode": SettingString, "max_rows_to_group_by": SettingUInt64, "group_by_overflow_mode": SettingString, "max_bytes_before_external_group_by": SettingUInt64, "max_rows_to_sort": SettingUInt64, "max_bytes_to_sort": SettingUInt64, "sort_overflow_mode": SettingString, "max_bytes_before_external_sort": SettingUInt64, "max_bytes_before_remerge_sort": SettingUInt64, "max_result_rows": SettingUInt64, "max_result_bytes": SettingUInt64, "result_overflow_mode": SettingString, "max_execution_time": SettingSeconds, "timeout_overflow_mode": SettingString, "min_execution_speed": SettingUInt64, "timeout_before_checking_execution_speed": SettingSeconds, "max_columns_to_read": SettingUInt64, "max_temporary_columns": SettingUInt64, "max_temporary_non_const_columns": SettingUInt64, "max_subquery_depth": SettingUInt64, "max_pipeline_depth": SettingUInt64, "max_ast_depth": SettingUInt64, "max_ast_elements": SettingUInt64, "max_expanded_ast_elements": SettingUInt64, "readonly": SettingUInt64, "max_rows_in_set": SettingUInt64, "max_bytes_in_set": SettingUInt64, "set_overflow_mode": SettingString, "max_rows_in_join": SettingUInt64, "max_bytes_in_join": SettingUInt64, "join_overflow_mode": SettingString, "max_rows_to_transfer": SettingUInt64, "max_bytes_to_transfer": SettingUInt64, "transfer_overflow_mode": SettingString, "max_rows_in_distinct": SettingUInt64, "max_bytes_in_distinct": SettingUInt64, "distinct_overflow_mode": SettingString, "max_memory_usage": SettingUInt64, "max_memory_usage_for_user": SettingUInt64, "max_memory_usage_for_all_queries": SettingUInt64, "max_network_bandwidth": SettingUInt64, "max_network_bytes": SettingUInt64, "max_network_bandwidth_for_user": SettingUInt64, "max_network_bandwidth_for_all_users": SettingUInt64, "max_streams_multiplier_for_merge_tables": SettingFloat, "max_http_get_redirects": SettingUInt64, "max_execution_speed": SettingUInt64, "max_execution_speed_bytes": SettingUInt64, "format_csv_delimiter": SettingChar, "format_csv_allow_single_quotes": SettingBool, "format_csv_allow_double_quotes": SettingBool, "format_template_resultset": SettingString, "format_template_row": SettingString, "format_template_rows_between_delimiter": SettingString, "format_custom_escaping_rule": SettingString, "format_custom_field_delimiter": SettingString, "format_custom_row_before_delimiter": SettingString, "format_custom_row_after_delimiter": SettingString, "format_custom_row_between_delimiter": SettingString, "format_custom_result_before_delimiter": SettingString, "format_custom_result_after_delimiter": SettingString, "enable_conditional_computation": SettingUInt64, "date_time_input_format": SettingDateTimeInputFormat, "log_profile_events": SettingBool, "log_query_settings": SettingBool, "log_query_threads": SettingBool, "send_logs_level": SettingString, "low_cardinality_max_dictionary_size": SettingUInt64, "low_cardinality_use_single_dictionary_for_part": SettingBool, "decimal_check_overflow": SettingBool, "prefer_localhost_replica": SettingBool, "max_fetch_partition_retries_count": SettingUInt64, "asterisk_left_columns_only": SettingBool, "http_max_multipart_form_data_size": SettingUInt64, "calculate_text_stack_trace": SettingBool, "parallel_view_processing": SettingBool, "allow_experimental_low_cardinality_type": SettingBool, "allow_experimental_decimal_type": SettingBool, "allow_suspicious_low_cardinality_types": SettingBool, "allow_experimental_multiple_joins_emulation": SettingBool, "allow_experimental_cross_to_join_conversion": SettingBool, "allow_experimental_data_skipping_indices": SettingBool, "allow_hyperscan": SettingBool, "allow_simdjson": SettingBool, "allow_introspection_functions": SettingBool, "allow_drop_detached": SettingBool, "allow_experimental_live_view": SettingBool, "allow_ddl": SettingBool, "partial_merge_join": SettingBool, "partial_merge_join_optimizations": SettingBool, "partial_merge_join_rows_in_right_blocks": SettingUInt64, "partial_merge_join_rows_in_left_blocks": SettingFloat, "distributed_replica_error_half_life": SettingSeconds, "distributed_replica_error_cap": SettingUInt64, "min_free_disk_space_for_temporary_data": SettingUInt64, "tcp_keep_alive_timeout": SettingSeconds, "connection_pool_max_wait_ms": SettingMilliseconds, "kafka_max_wait_ms": SettingMilliseconds, "idle_connection_timeout": SettingUInt64, "s3_min_upload_part_size": SettingUInt64, "any_join_distinct_right_table_keys": SettingBool, "join_any_take_last_row": SettingBool, "stream_poll_timeout_ms": SettingMilliseconds, "joined_subquery_requires_alias": SettingBool, "enable_unaligned_array_join": SettingBool, "low_cardinality_allow_in_native_format": SettingBool, "external_table_functions_use_nulls": SettingBool, "experimental_use_processors": SettingBool, "check_query_single_value_result": SettingBool, "live_view_heartbeat_interval": SettingSeconds, "temporary_live_view_timeout": SettingSeconds, "max_live_view_insert_blocks_before_refresh": SettingUInt64, "max_insert_threads": SettingUInt64, "replace_running_query_max_wait_ms": SettingMilliseconds, "background_move_pool_size": SettingUInt64, "min_count_to_compile_expression": SettingUInt64, "force_optimize_skip_unused_shards": SettingUInt64, "input_format_parallel_parsing": SettingBool, "min_chunk_bytes_for_parallel_parsing": SettingUInt64, "min_bytes_to_use_mmap_io": SettingUInt64, "os_thread_priority": SettingInt64, "input_format_tsv_empty_as_default": SettingBool, "input_format_avro_schema_registry_url": SettingString, "output_format_avro_codec": SettingString, "output_format_avro_sync_interval": SettingUInt64, "min_execution_speed_bytes": SettingUInt64, "default_max_bytes_in_join": SettingUInt64, "enable_optimize_predicate_expression_to_final_subquery": SettingBool, "cancel_http_readonly_queries_on_client_close": SettingBool, "enable_scalar_subquery_optimization": SettingBool, "optimize_trivial_count_query": SettingBool, "mutations_sync": SettingUInt64, "optimize_if_chain_to_miltiif": SettingBool, "max_parser_depth": SettingUInt64, "max_joined_block_size_rows": SettingUInt64, "connect_timeout_with_failover_secure_ms": SettingMilliseconds, "parallel_distributed_insert_select": SettingBool, "force_optimize_skip_unused_shards_no_nested": SettingBool, "format_avro_schema_registry_url": SettingURI, "output_format_tsv_crlf_end_of_line": SettingBool, "join_algorithm": SettingJoinAlgorithm, "memory_profiler_step": SettingUInt64, "output_format_csv_crlf_end_of_line": SettingBool, "allow_experimental_alter_materialized_view_structure": SettingBool, "enable_early_constant_folding": SettingBool, "deduplicate_blocks_in_dependent_materialized_views": SettingBool, "use_compact_format_in_distributed_parts_names": SettingBool, "multiple_joins_rewriter_version": SettingUInt64, "min_insert_block_size_rows_for_materialized_views": SettingUInt64, "min_insert_block_size_bytes_for_materialized_views": SettingUInt64, "max_final_threads": SettingUInt64, "background_buffer_flush_schedule_pool_size": SettingUInt64, "background_distributed_schedule_pool_size": SettingUInt64, "special_sort": SettingSpecialSort, "optimize_distributed_group_by_sharding_key": SettingBool, "log_queries_min_type": SettingLogQueriesType, "allow_suspicious_codecs": SettingBool, "metrics_perf_events_enabled": SettingBool, "metrics_perf_events_list": SettingString, "join_on_disk_max_files_to_merge": SettingUInt64, "temporary_files_codec": SettingString, "max_untracked_memory": SettingUInt64, "memory_profiler_sample_probability": SettingFloat, "optimize_aggregation_in_order": SettingBool, "default_database_engine": SettingDefaultDatabaseEngine, "allow_experimental_database_atomic": SettingBool, "show_table_uuid_in_table_create_query_if_not_nil": SettingBool, "optimize_arithmetic_operations_in_aggregate_functions": SettingBool, "validate_polygons": SettingBool, "transform_null_in": SettingBool, "allow_nondeterministic_mutations": SettingBool, "lock_acquire_timeout": SettingSeconds, "materialize_ttl_after_modify": SettingBool, "allow_experimental_geo_types": SettingBool, "output_format_pretty_max_value_width": SettingUInt64, "format_regexp": SettingString, "format_regexp_escaping_rule": SettingString, "format_regexp_skip_unmatched": SettingBool, "output_format_enable_streaming": SettingBool, }