2024-07-04 17:55:15 --- /usr/share/clickhouse-test/queries/0_stateless/01275_parallel_mv.reference 2024-07-04 16:57:58.069466103 -0300
2024-07-04 17:55:15 +++ /tmp/clickhouse-test/0_stateless/01275_parallel_mv.gen.stdout 2024-07-04 17:55:15.777387568 -0300
2024-07-04 17:55:15 @@ -137,7 +137,7 @@
2024-07-04 17:55:15 Settings['parallel_view_processing'] = '1' and
2024-07-04 17:55:15 Settings['optimize_trivial_insert_select'] = '0' and
2024-07-04 17:55:15 Settings['max_insert_threads'] = '16';
2024-07-04 17:55:15 -18
2024-07-04 17:55:15 +10
2024-07-04 17:55:15 select count() from testX;
2024-07-04 17:55:15 60
2024-07-04 17:55:15 select count() from testXA;
2024-07-04 17:55:15
2024-07-04 17:55:15
2024-07-04 17:55:15 Settings used in the test: --max_insert_threads 16 --group_by_two_level_threshold 1 --group_by_two_level_threshold_bytes 48267495 --distributed_aggregation_memory_efficient 0 --fsync_metadata 0 --output_format_parallel_formatting 1 --input_format_parallel_parsing 0 --min_chunk_bytes_for_parallel_parsing 5854325 --max_read_buffer_size 927084 --prefer_localhost_replica 1 --max_block_size 27066 --max_joined_block_size_rows 72193 --max_threads 9 --optimize_append_index 0 --optimize_if_chain_to_multiif 0 --optimize_if_transform_strings_to_enum 0 --optimize_read_in_order 1 --optimize_or_like_chain 1 --optimize_substitute_columns 1 --enable_multiple_prewhere_read_steps 0 --read_in_order_two_level_merge_threshold 65 --optimize_aggregation_in_order 0 --aggregation_in_order_max_block_bytes 34059687 --use_uncompressed_cache 0 --min_bytes_to_use_direct_io 10737418240 --min_bytes_to_use_mmap_io 3012744388 --local_filesystem_read_method pread_threadpool --remote_filesystem_read_method read --local_filesystem_read_prefetch 1 --filesystem_cache_segments_batch_size 3 --read_from_filesystem_cache_if_exists_otherwise_bypass_cache 0 --throw_on_error_from_cache_on_write_operations 0 --remote_filesystem_read_prefetch 1 --allow_prefetched_read_pool_for_remote_filesystem 1 --filesystem_prefetch_max_memory_usage 32Mi --filesystem_prefetches_limit 0 --filesystem_prefetch_min_bytes_for_single_read_task 8Mi --filesystem_prefetch_step_marks 50 --filesystem_prefetch_step_bytes 100Mi --compile_aggregate_expressions 1 --compile_sort_description 0 --merge_tree_coarse_index_granularity 7 --optimize_distinct_in_order 1 --max_bytes_before_external_sort 10737418240 --max_bytes_before_external_group_by 10737418240 --max_bytes_before_remerge_sort 2240349947 --min_compress_block_size 1818230 --max_compress_block_size 1513298 --merge_tree_compact_parts_min_granules_to_multibuffer_read 113 --optimize_sorting_by_input_stream_properties 1 --http_response_buffer_size 1617984 --http_wait_end_of_query False --enable_memory_bound_merging_of_aggregation_results 1 --min_count_to_compile_expression 3 --min_count_to_compile_aggregate_expression 3 --min_count_to_compile_sort_description 0 --session_timezone America/Mazatlan --prefer_warmed_unmerged_parts_seconds 3 --use_page_cache_for_disks_without_file_cache True --page_cache_inject_eviction True --merge_tree_read_split_ranges_into_intersecting_and_non_intersecting_injection_probability 0.81 --prefer_external_sort_block_bytes 1 --cross_join_min_rows_to_compress 1 --cross_join_min_bytes_to_compress 100000000 --min_external_table_block_size_bytes 1 --max_parsing_threads 1
2024-07-04 17:55:15
2024-07-04 17:55:15 MergeTree settings used in test: --ratio_of_defaults_for_sparse_serialization 0.0 --prefer_fetch_merged_part_size_threshold 8755514578 --vertical_merge_algorithm_min_rows_to_activate 1000000 --vertical_merge_algorithm_min_columns_to_activate 1 --allow_vertical_merges_from_compact_to_wide_parts 1 --min_merge_bytes_to_use_direct_io 668520075 --index_granularity_bytes 12693347 --merge_max_block_size 13065 --index_granularity 3514 --min_bytes_for_wide_part 232735480 --marks_compress_block_size 25279 --primary_key_compress_block_size 67609 --replace_long_file_name_to_hash 0 --max_file_name_length 0 --min_bytes_for_full_part_storage 45635382 --compact_parts_max_bytes_to_buffer 83520586 --compac