from .types import ( SettingUInt64, SettingBool, SettingFloat, SettingString, SettingMaxThreads, SettingChar ) 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, }