doris
doris copied to clipboard
apache
[fix](uncaught exception) Fix uncaught exception from load_index
*** Query id: 0-0 ***
*** is nereids: 0 ***
*** tablet id: 178416 ***
*** Aborted at 1718361232 (unix time) try "date -d @1718361232" if you are using GNU date ***
*** Current BE git commitID: bdf24c4dee ***
*** SIGABRT unknown detail explain (@0x48700397832) received by PID 3766322 (TID 3770295 OR 0x7f28678f2700) from PID 3766322; stack trace: ***
0# doris::signal::(anonymous namespace)::FailureSignalHandler(int, siginfo_t*, void*) at /mnt/disk1/hezhiqiang/doris/be/src/common/signal_handler.h:421
1# 0x00007F313DD94B50 in /lib64/libc.so.6
2# gsignal in /lib64/libc.so.6
3# __GI_abort in /lib64/libc.so.6
4# __gnu_cxx::__verbose_terminate_handler() [clone .cold] at ../../../../libstdc++-v3/libsupc++/vterminate.cc:75
5# __cxxabiv1::__terminate(void (*)()) at ../../../../libstdc++-v3/libsupc++/eh_terminate.cc:48
6# 0x000056127FD0D0B1 in /mnt/disk1/hezhiqiang/workspace/ASAN/be_1/lib/doris_be
7# __cxxabiv1::__terminate(void (*)()) [clone .cold] in /mnt/disk1/hezhiqiang/workspace/ASAN/be_1/lib/doris_be
8# doris::Status doris::DorisCallOnce<doris::Status>::call<doris::segment_v2::Segment::_load_index_impl()::$_0>(doris::segment_v2::Segment::_load_index_impl()::$_0) at /mnt/disk1/hezhiqiang/doris/be/src/util/once.h:79
9# doris::segment_v2::Segment::_load_index_impl() at /mnt/disk1/hezhiqiang/doris/be/src/olap/rowset/segment_v2/segment.cpp:352
10# doris::segment_v2::Segment::load_index()::$_0::operator()() const at /mnt/disk1/hezhiqiang/doris/be/src/olap/rowset/segment_v2/segment.cpp:344
11# doris::segment_v2::Segment::load_index() at /mnt/disk1/hezhiqiang/doris/be/src/olap/rowset/segment_v2/segment.cpp:344
12# doris::segment_v2::Segment::new_iterator(std::shared_ptr<doris::Schema const>, doris::StorageReadOptions const&, std::unique_ptr<doris::RowwiseIterator, std::default_delete<doris::RowwiseIterator> >*) at /mnt/disk1/hezhiqiang/doris/be/src/olap/rowset/segment_v2/segmen
t.cpp:210
13# doris::BetaRowsetReader::get_segment_iterators(doris::RowsetReaderContext*, std::vector<std::unique_ptr<doris::RowwiseIterator, std::default_delete<doris::RowwiseIterator> >, std::allocator<std::unique_ptr<doris::RowwiseIterator, std::default_delete<doris::RowwiseIter
ator> > > >*, bool) at /mnt/disk1/hezhiqiang/doris/be/src/olap/rowset/beta_rowset_reader.cpp:298
14# doris::vectorized::VerticalBlockReader::_get_segment_iterators(doris::TabletReader::ReaderParams const&, std::vector<std::unique_ptr<doris::RowwiseIterator, std::default_delete<doris::RowwiseIterator> >, std::allocator<std::unique_ptr<doris::RowwiseIterator, std::defa
ult_delete<doris::RowwiseIterator> > > >*, std::vector<bool, std::allocator<bool> >*, std::vector<doris::RowsetId, std::allocator<doris::RowsetId> >*) at /mnt/disk1/hezhiqiang/doris/be/src/vec/olap/vertical_block_reader.cpp:83
15# doris::vectorized::VerticalBlockReader::_init_collect_iter(doris::TabletReader::ReaderParams const&) at /mnt/disk1/hezhiqiang/doris/be/src/vec/olap/vertical_block_reader.cpp:118
16# doris::vectorized::VerticalBlockReader::init(doris::TabletReader::ReaderParams const&) at /mnt/disk1/hezhiqiang/doris/be/src/vec/olap/vertical_block_reader.cpp:213
17# doris::Merger::vertical_compact_one_group(std::shared_ptr<doris::BaseTablet>, doris::ReaderType, doris::TabletSchema const&, bool, std::vector<unsigned int, std::allocator<unsigned int> > const&, doris::vectorized::RowSourcesBuffer*, std::vector<std::shared_ptr<doris:
:RowsetReader>, std::allocator<std::shared_ptr<doris::RowsetReader> > > const&, doris::RowsetWriter*, long, doris::Merger::Statistics*, std::vector<unsigned int, std::allocator<unsigned int> >) at /mnt/disk1/hezhiqiang/doris/be/src/olap/merger.cpp:282
18# doris::Merger::vertical_merge_rowsets(std::shared_ptr<doris::BaseTablet>, doris::ReaderType, doris::TabletSchema const&, std::vector<std::shared_ptr<doris::RowsetReader>, std::allocator<std::shared_ptr<doris::RowsetReader> > > const&, doris::RowsetWriter*, long, doris
::Merger::Statistics*) at /mnt/disk1/hezhiqiang/doris/be/src/olap/merger.cpp:412
19# doris::Compaction::merge_input_rowsets() at /mnt/disk1/hezhiqiang/doris/be/src/olap/compaction.cpp:177
20# doris::CompactionMixin::execute_compact_impl(long) at /mnt/disk1/hezhiqiang/doris/be/src/olap/compaction.cpp:438
21# doris::CompactionMixin::execute_compact() at /mnt/disk1/hezhiqiang/doris/be/src/olap/compaction.cpp:390
22# doris::CumulativeCompaction::execute_compact() at /mnt/disk1/hezhiqiang/doris/be/src/olap/cumulative_compaction.cpp:101
23# doris::Tablet::execute_compaction(doris::CompactionMixin&) at /mnt/disk1/hezhiqiang/doris/be/src/olap/tablet.cpp:1761
24# doris::StorageEngine::_submit_compaction_task(std::shared_ptr<doris::Tablet>, doris::CompactionType, bool)::$_1::operator()() const at /mnt/disk1/hezhiqiang/doris/be/src/olap/olap_server.cpp:1037
25# void std::__invoke_impl<void, doris::StorageEngine::_submit_compaction_task(std::shared_ptr<doris::Tablet>, doris::CompactionType, bool)::$_1&>(std::__invoke_other, doris::StorageEngine::_submit_compaction_task(std::shared_ptr<doris::Tablet>, doris::CompactionType, bo
ol)::$_1&) at /mnt/disk1/hezhiqiang/toolchains/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/invoke.h:61
26# std::enable_if<is_invocable_r_v<void, doris::StorageEngine::_submit_compaction_task(std::shared_ptr<doris::Tablet>, doris::CompactionType, bool)::$_1&>, void>::type std::__invoke_r<void, doris::StorageEngine::_submit_compaction_task(std::shared_ptr<doris::Tablet>, dor
is::CompactionType, bool)::$_1&>(doris::StorageEngine::_submit_compaction_task(std::shared_ptr<doris::Tablet>, doris::CompactionType, bool)::$_1&) at /mnt/disk1/hezhiqiang/toolchains/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/invoke.h:117
27# std::_Function_handler<void (), doris::StorageEngine::_submit_compaction_task(std::shared_ptr<doris::Tablet>, doris::CompactionType, bool)::$_1>::_M_invoke(std::_Any_data const&) at /mnt/disk1/hezhiqiang/toolchains/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../includ
e/c++/11/bits/std_function.h:291
28# std::function<void ()>::operator()() const at /mnt/disk1/hezhiqiang/toolchains/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/std_function.h:560
29# doris::FunctionRunnable::run() at /mnt/disk1/hezhiqiang/doris/be/src/util/threadpool.cpp:48
30# doris::ThreadPool::dispatch_thread() at /mnt/disk1/hezhiqiang/doris/be/src/util/threadpool.cpp:543
31# void std::__invoke_impl<void, void (doris::ThreadPool::*&)(), doris::ThreadPool*&>(std::__invoke_memfun_deref, void (doris::ThreadPool::*&)(), doris::ThreadPool*&) at /mnt/disk1/hezhiqiang/toolchains/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/i
nvoke.h:74
32# std::__invoke_result<void (doris::ThreadPool::*&)(), doris::ThreadPool*&>::type std::__invoke<void (doris::ThreadPool::*&)(), doris::ThreadPool*&>(void (doris::ThreadPool::*&)(), doris::ThreadPool*&) at /mnt/disk1/hezhiqiang/toolchains/bin/../lib/gcc/x86_64-linux-gnu/
11/../../../../include/c++/11/bits/invoke.h:96
33# void std::_Bind<void (doris::ThreadPool::*(doris::ThreadPool*))()>::__call<void, , 0ul>(std::tuple<>&&, std::_Index_tuple<0ul>) at /mnt/disk1/hezhiqiang/toolchains/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/functional:420
34# void std::_Bind<void (doris::ThreadPool::*(doris::ThreadPool*))()>::operator()<, void>() at /mnt/disk1/hezhiqiang/toolchains/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/functional:503
35# void std::__invoke_impl<void, std::_Bind<void (doris::ThreadPool::*(doris::ThreadPool*))()>&>(std::__invoke_other, std::_Bind<void (doris::ThreadPool::*(doris::ThreadPool*))()>&) at /mnt/disk1/hezhiqiang/toolchains/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../includ
e/c++/11/bits/invoke.h:61
36# std::enable_if<is_invocable_r_v<void, std::_Bind<void (doris::ThreadPool::*(doris::ThreadPool*))()>&>, void>::type std::__invoke_r<void, std::_Bind<void (doris::ThreadPool::*(doris::ThreadPool*))()>&>(std::_Bind<void (doris::ThreadPool::*(doris::ThreadPool*))()>&) at
/mnt/disk1/hezhiqiang/toolchains/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/invoke.h:117
37# std::_Function_handler<void (), std::_Bind<void (doris::ThreadPool::*(doris::ThreadPool*))()> >::_M_invoke(std::_Any_data const&) at /mnt/disk1/hezhiqiang/toolchains/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/std_function.h:291
38# std::function<void ()>::operator()() const at /mnt/disk1/hezhiqiang/toolchains/bin/../lib/gcc/x86_64-linux-gnu/11/../../../../include/c++/11/bits/std_function.h:560
39# doris::Thread::supervise_thread(void*) at /mnt/disk1/hezhiqiang/doris/be/src/util/thread.cpp:498
40# start_thread in /lib64/libpthread.so.0
41# __clone in /lib64/libc.so.6
Thank you for your contribution to Apache Doris. Don't know what should be done next? See How to process your PR
Since 2024-03-18, the Document has been moved to doris-website. See Doris Document.
![github-actions[bot] avatar](https://avatars.githubusercontent.com/in/15368?v=4 "Published by a pub.dev verified publisher"){kind=small}
TeamCity be ut coverage result: Function Coverage: 36.48% (9001/24677) Line Coverage: 28.02% (73718/263120) Region Coverage: 27.49% (38300/139317) Branch Coverage: 24.19% (19520/80706) Coverage Report: http://coverage.selectdb-in.cc/coverage/a096156f7699b2c0774c19174ac54f14d05dd5a2_a096156f7699b2c0774c19174ac54f14d05dd5a2/report/index.html
TPC-H: Total hot run time: 39769 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit a096156f7699b2c0774c19174ac54f14d05dd5a2, data reload: false
------ Round 1 ----------------------------------
q1 17621 4378 4286 4286
q2 2014 186 189 186
q3 10466 1114 1106 1106
q4 10195 794 795 794
q5 7458 2638 2696 2638
q6 229 138 139 138
q7 991 603 599 599
q8 9228 2087 2055 2055
q9 8949 6520 6495 6495
q10 8856 3706 3725 3706
q11 454 237 232 232
q12 465 241 233 233
q13 17789 2968 2968 2968
q14 273 218 219 218
q15 519 466 467 466
q16 519 376 374 374
q17 950 683 748 683
q18 8024 7367 7522 7367
q19 5713 1482 1468 1468
q20 661 326 324 324
q21 4908 3100 3972 3100
q22 412 342 333 333
Total cold run time: 116694 ms
Total hot run time: 39769 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4423 4270 4278 4270
q2 368 270 256 256
q3 2947 2948 2824 2824
q4 1986 1746 1763 1746
q5 5606 5495 5442 5442
q6 224 138 132 132
q7 2166 1917 1848 1848
q8 3325 3437 3432 3432
q9 8710 8694 8842 8694
q10 4063 3888 3693 3693
q11 588 518 498 498
q12 808 639 623 623
q13 17241 3153 3197 3153
q14 297 272 284 272
q15 519 498 474 474
q16 525 443 448 443
q17 1851 1529 1502 1502
q18 8138 7898 7773 7773
q19 1858 1643 1581 1581
q20 3141 1923 1853 1853
q21 7826 4895 4845 4845
q22 604 557 525 525
Total cold run time: 77214 ms
Total hot run time: 55879 ms
TPC-DS: Total hot run time: 173509 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit a096156f7699b2c0774c19174ac54f14d05dd5a2, data reload: false
query1 941 374 370 370
query2 6491 2423 2278 2278
query3 6630 203 210 203
query4 19112 17271 17337 17271
query5 3664 479 477 477
query6 241 163 155 155
query7 4580 290 284 284
query8 331 288 281 281
query9 8547 2355 2350 2350
query10 598 295 271 271
query11 10560 9999 10041 9999
query12 117 86 90 86
query13 1629 362 368 362
query14 10177 7398 7154 7154
query15 233 194 187 187
query16 7009 264 261 261
query17 1445 531 509 509
query18 1131 270 264 264
query19 193 150 150 150
query20 90 85 82 82
query21 208 134 129 129
query22 4692 4040 3992 3992
query23 33769 33577 33562 33562
query24 11284 2834 2855 2834
query25 642 368 375 368
query26 1117 158 159 158
query27 2435 325 331 325
query28 6491 2090 2077 2077
query29 877 642 615 615
query30 261 158 160 158
query31 977 763 741 741
query32 101 52 54 52
query33 807 318 299 299
query34 1072 486 488 486
query35 784 636 635 635
query36 1107 973 971 971
query37 180 75 70 70
query38 2938 2807 2837 2807
query39 876 857 825 825
query40 206 132 128 128
query41 56 47 53 47
query42 109 103 104 103
query43 612 575 539 539
query44 1183 707 725 707
query45 197 162 163 162
query46 1078 724 720 720
query47 1851 1771 1807 1771
query48 365 297 290 290
query49 861 397 402 397
query50 755 387 399 387
query51 6823 6679 6632 6632
query52 100 96 87 87
query53 363 289 280 280
query54 933 449 433 433
query55 76 70 71 70
query56 270 256 267 256
query57 1123 1055 1033 1033
query58 244 243 236 236
query59 3376 3313 3158 3158
query60 286 265 270 265
query61 98 87 94 87
query62 602 462 465 462
query63 320 295 294 294
query64 9035 2229 1782 1782
query65 3241 3141 3117 3117
query66 873 333 329 329
query67 15457 14945 14970 14945
query68 6083 527 527 527
query69 623 444 412 412
query70 1202 1147 1123 1123
query71 443 270 268 268
query72 7262 5618 5363 5363
query73 791 329 325 325
query74 5946 5525 5464 5464
query75 3597 2689 2661 2661
query76 3305 929 966 929
query77 650 292 297 292
query78 10316 9833 9758 9758
query79 1910 503 506 503
query80 1288 483 449 449
query81 567 217 223 217
query82 740 101 98 98
query83 189 156 160 156
query84 269 87 86 86
query85 1272 286 270 270
query86 400 311 308 308
query87 3307 3104 3093 3093
query88 3741 2352 2359 2352
query89 467 376 394 376
query90 1771 189 185 185
query91 125 97 98 97
query92 58 47 48 47
query93 3730 501 498 498
query94 1047 198 202 198
query95 467 307 303 303
query96 594 266 261 261
query97 3235 3030 3076 3030
query98 214 194 191 191
query99 1239 854 870 854
Total cold run time: 271678 ms
Total hot run time: 173509 ms
ClickBench: Total hot run time: 30.36 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit a096156f7699b2c0774c19174ac54f14d05dd5a2, data reload: false
query1 0.03 0.03 0.04
query2 0.08 0.04 0.04
query3 0.23 0.05 0.05
query4 1.67 0.07 0.08
query5 0.49 0.47 0.50
query6 1.14 0.73 0.72
query7 0.02 0.02 0.01
query8 0.05 0.04 0.04
query9 0.52 0.47 0.48
query10 0.54 0.56 0.54
query11 0.16 0.11 0.11
query12 0.14 0.12 0.12
query13 0.59 0.59 0.59
query14 0.78 0.79 0.78
query15 0.85 0.80 0.80
query16 0.36 0.37 0.36
query17 1.05 1.04 1.05
query18 0.23 0.25 0.23
query19 1.91 1.72 1.74
query20 0.01 0.01 0.01
query21 15.43 0.66 0.64
query22 4.11 6.51 1.90
query23 18.30 1.45 1.22
query24 2.16 0.22 0.21
query25 0.13 0.08 0.09
query26 0.25 0.17 0.18
query27 0.07 0.07 0.08
query28 13.21 1.00 0.99
query29 12.61 3.23 3.21
query30 0.26 0.06 0.05
query31 2.88 0.39 0.39
query32 3.26 0.48 0.46
query33 2.92 2.89 2.84
query34 16.98 4.42 4.39
query35 4.46 4.53 4.49
query36 0.66 0.46 0.45
query37 0.18 0.15 0.16
query38 0.15 0.14 0.15
query39 0.04 0.03 0.03
query40 0.18 0.14 0.14
query41 0.10 0.05 0.05
query42 0.06 0.05 0.05
query43 0.04 0.04 0.04
Total cold run time: 109.29 s
Total hot run time: 30.36 s
TPC-H: Total hot run time: 40083 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 72400c322b8ca44221ae2004e5316fbb75e9227b, data reload: false
------ Round 1 ----------------------------------
q1 18354 4798 4450 4450
q2 2545 194 191 191
q3 11242 1097 1179 1097
q4 10468 786 825 786
q5 7596 2705 2631 2631
q6 225 142 137 137
q7 975 611 633 611
q8 9892 2094 2040 2040
q9 8969 6470 6466 6466
q10 8956 3747 3706 3706
q11 460 253 249 249
q12 396 231 230 230
q13 18903 2988 3031 2988
q14 259 229 221 221
q15 513 490 484 484
q16 483 391 385 385
q17 952 622 758 622
q18 8040 7570 7405 7405
q19 7348 1486 1470 1470
q20 649 327 334 327
q21 4960 3250 4090 3250
q22 399 337 350 337
Total cold run time: 122584 ms
Total hot run time: 40083 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4400 4204 4190 4190
q2 370 279 266 266
q3 3017 2734 2756 2734
q4 1866 1630 1592 1592
q5 5289 5271 5298 5271
q6 217 128 131 128
q7 2075 1771 1769 1769
q8 3192 3309 3310 3309
q9 8331 8357 8329 8329
q10 3872 3640 3735 3640
q11 582 496 487 487
q12 749 569 604 569
q13 17285 3006 3080 3006
q14 304 273 270 270
q15 533 471 484 471
q16 471 419 425 419
q17 1751 1466 1461 1461
q18 7523 7673 7618 7618
q19 1675 1544 1585 1544
q20 1986 1780 1787 1780
q21 4926 4820 4734 4734
q22 653 558 568 558
Total cold run time: 71067 ms
Total hot run time: 54145 ms
TPC-DS: Total hot run time: 170355 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 72400c322b8ca44221ae2004e5316fbb75e9227b, data reload: false
query1 910 373 394 373
query2 6447 2257 2235 2235
query3 6647 214 224 214
query4 19239 17241 17203 17203
query5 4182 473 479 473
query6 255 167 190 167
query7 4610 307 300 300
query8 320 306 300 300
query9 8526 2443 2426 2426
query10 622 286 265 265
query11 10474 10042 10157 10042
query12 132 87 79 79
query13 1631 369 367 367
query14 10080 7657 7017 7017
query15 289 192 186 186
query16 8156 274 269 269
query17 1907 551 529 529
query18 2135 275 280 275
query19 190 148 155 148
query20 90 82 83 82
query21 214 129 121 121
query22 4330 3986 4017 3986
query23 33737 33031 33092 33031
query24 11012 2881 2781 2781
query25 633 360 363 360
query26 1388 152 158 152
query27 2928 317 317 317
query28 7625 2104 2083 2083
query29 897 633 605 605
query30 282 147 149 147
query31 945 751 751 751
query32 100 63 55 55
query33 780 293 290 290
query34 949 472 473 472
query35 750 647 617 617
query36 1105 927 991 927
query37 158 69 70 69
query38 2872 2758 2725 2725
query39 854 821 819 819
query40 213 129 126 126
query41 58 56 53 53
query42 126 95 102 95
query43 575 527 546 527
query44 1277 737 745 737
query45 198 163 170 163
query46 1079 733 721 721
query47 1831 1778 1769 1769
query48 373 311 309 309
query49 1086 423 426 423
query50 777 388 388 388
query51 6862 6854 6834 6834
query52 108 94 92 92
query53 367 287 286 286
query54 855 457 443 443
query55 74 74 76 74
query56 292 261 306 261
query57 1159 1071 1088 1071
query58 250 243 269 243
query59 3328 3103 3132 3103
query60 296 275 276 275
query61 94 97 93 93
query62 654 449 444 444
query63 319 290 292 290
query64 8964 2233 1789 1789
query65 3171 3140 3117 3117
query66 943 333 341 333
query67 15345 15233 14847 14847
query68 4633 534 532 532
query69 571 425 352 352
query70 1184 1121 1128 1121
query71 431 285 274 274
query72 7125 5572 2756 2756
query73 742 345 329 329
query74 5949 5484 5532 5484
query75 3561 2638 2680 2638
query76 3110 917 879 879
query77 645 294 296 294
query78 10302 9952 9718 9718
query79 1270 513 517 513
query80 2156 474 473 473
query81 614 219 218 218
query82 436 107 102 102
query83 316 173 166 166
query84 271 88 84 84
query85 1261 293 285 285
query86 466 340 319 319
query87 3264 3119 3151 3119
query88 4143 2490 2493 2490
query89 492 389 390 389
query90 1918 193 194 193
query91 130 100 99 99
query92 67 51 50 50
query93 1915 502 502 502
query94 1363 193 193 193
query95 422 323 325 323
query96 595 270 276 270
query97 3241 3000 3061 3000
query98 216 209 188 188
query99 1139 838 841 838
Total cold run time: 273023 ms
Total hot run time: 170355 ms
ClickBench: Total hot run time: 30.52 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 72400c322b8ca44221ae2004e5316fbb75e9227b, data reload: false
query1 0.04 0.03 0.03
query2 0.08 0.04 0.05
query3 0.22 0.04 0.04
query4 1.68 0.06 0.07
query5 0.51 0.48 0.49
query6 1.13 0.72 0.72
query7 0.02 0.02 0.01
query8 0.04 0.04 0.04
query9 0.55 0.48 0.50
query10 0.55 0.54 0.55
query11 0.15 0.11 0.11
query12 0.14 0.12 0.12
query13 0.59 0.59 0.58
query14 0.75 0.77 0.81
query15 0.84 0.80 0.81
query16 0.38 0.37 0.36
query17 1.05 1.03 1.04
query18 0.20 0.24 0.23
query19 1.80 1.78 1.68
query20 0.01 0.01 0.01
query21 15.42 0.65 0.64
query22 4.50 6.90 1.92
query23 18.26 1.34 1.31
query24 2.08 0.23 0.22
query25 0.15 0.09 0.08
query26 0.27 0.17 0.17
query27 0.08 0.07 0.07
query28 13.20 1.00 1.00
query29 12.64 3.25 3.24
query30 0.25 0.08 0.05
query31 2.85 0.39 0.39
query32 3.27 0.47 0.47
query33 2.92 2.91 2.91
query34 17.13 4.42 4.41
query35 4.47 4.46 4.45
query36 0.65 0.47 0.48
query37 0.18 0.15 0.15
query38 0.16 0.15 0.14
query39 0.04 0.03 0.04
query40 0.18 0.14 0.16
query41 0.09 0.06 0.04
query42 0.05 0.05 0.05
query43 0.04 0.04 0.04
Total cold run time: 109.61 s
Total hot run time: 30.52 s
TPC-H: Total hot run time: 39672 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 3e3edb1597c352be6e6448454ff267a0cd74e498, data reload: false
------ Round 1 ----------------------------------
q1 17598 4368 4285 4285
q2 2022 195 196 195
q3 10458 1254 1120 1120
q4 10188 779 785 779
q5 7488 2683 2636 2636
q6 223 139 139 139
q7 956 613 594 594
q8 9238 2094 2054 2054
q9 8914 6473 6520 6473
q10 8920 3720 3702 3702
q11 457 240 234 234
q12 513 224 234 224
q13 18782 2980 2987 2980
q14 281 227 223 223
q15 534 475 482 475
q16 508 371 374 371
q17 985 613 663 613
q18 8011 7460 7415 7415
q19 7737 1450 1402 1402
q20 693 319 326 319
q21 5085 3097 3950 3097
q22 394 344 342 342
Total cold run time: 119985 ms
Total hot run time: 39672 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4391 4206 4215 4206
q2 369 275 264 264
q3 3068 2924 2958 2924
q4 1977 1759 1728 1728
q5 5526 5488 5391 5391
q6 256 136 133 133
q7 2266 1860 1873 1860
q8 3264 3434 3415 3415
q9 8757 8816 8778 8778
q10 4128 3749 3872 3749
q11 575 499 490 490
q12 808 657 652 652
q13 17235 3200 3124 3124
q14 306 284 271 271
q15 538 487 489 487
q16 498 425 418 418
q17 1803 1537 1523 1523
q18 8130 8083 7749 7749
q19 1776 1760 1718 1718
q20 2911 1841 1825 1825
q21 9420 4711 4938 4711
q22 643 533 541 533
Total cold run time: 78645 ms
Total hot run time: 55949 ms
TPC-DS: Total hot run time: 170976 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 3e3edb1597c352be6e6448454ff267a0cd74e498, data reload: false
query1 937 371 367 367
query2 6395 2646 2473 2473
query3 6645 203 215 203
query4 28412 17260 17268 17260
query5 3790 479 478 478
query6 263 175 168 168
query7 4599 305 310 305
query8 324 314 311 311
query9 8488 2466 2448 2448
query10 589 308 286 286
query11 11598 10136 9967 9967
query12 126 88 94 88
query13 1640 398 382 382
query14 10123 6909 7568 6909
query15 256 181 187 181
query16 7389 329 323 323
query17 1341 552 544 544
query18 1777 292 284 284
query19 205 155 156 155
query20 94 86 83 83
query21 220 139 124 124
query22 4328 4021 4013 4013
query23 34025 33740 33673 33673
query24 10908 2896 2977 2896
query25 627 426 407 407
query26 727 172 165 165
query27 2301 332 337 332
query28 5924 2210 2166 2166
query29 926 661 687 661
query30 255 154 159 154
query31 955 741 757 741
query32 108 58 67 58
query33 684 331 326 326
query34 918 512 498 498
query35 788 640 634 634
query36 1143 976 941 941
query37 141 81 84 81
query38 2943 2825 2884 2825
query39 874 818 795 795
query40 212 130 127 127
query41 58 54 53 53
query42 117 98 106 98
query43 602 569 561 561
query44 1062 735 726 726
query45 200 174 163 163
query46 1073 724 723 723
query47 1847 1754 1780 1754
query48 373 309 304 304
query49 938 411 417 411
query50 767 390 388 388
query51 6867 6869 6750 6750
query52 100 93 95 93
query53 365 295 300 295
query54 894 457 452 452
query55 72 72 73 72
query56 305 280 272 272
query57 1147 1047 1070 1047
query58 255 253 258 253
query59 3651 3323 3375 3323
query60 299 278 301 278
query61 94 94 93 93
query62 604 455 439 439
query63 326 293 292 292
query64 8591 2308 1805 1805
query65 3146 3134 3120 3120
query66 803 324 327 324
query67 15768 15007 14849 14849
query68 8626 555 564 555
query69 771 494 350 350
query70 1382 1052 1135 1052
query71 542 276 280 276
query72 9606 5086 2796 2796
query73 2240 327 329 327
query74 5847 5492 5448 5448
query75 5472 2642 2674 2642
query76 5214 1042 892 892
query77 800 359 311 311
query78 10572 8905 8808 8808
query79 8720 520 525 520
query80 1093 467 480 467
query81 585 223 217 217
query82 473 104 105 104
query83 341 168 162 162
query84 274 88 86 86
query85 981 304 304 304
query86 352 336 309 309
query87 3294 3093 3085 3085
query88 4373 2491 2454 2454
query89 531 383 381 381
query90 2087 195 195 195
query91 137 108 106 106
query92 63 51 52 51
query93 5941 515 502 502
query94 1362 220 215 215
query95 422 324 330 324
query96 631 275 271 271
query97 3212 2980 3007 2980
query98 219 195 198 195
query99 1132 844 821 821
Total cold run time: 301617 ms
Total hot run time: 170976 ms
ClickBench: Total hot run time: 31.04 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 3e3edb1597c352be6e6448454ff267a0cd74e498, data reload: false
query1 0.04 0.03 0.03
query2 0.07 0.04 0.04
query3 0.23 0.05 0.05
query4 1.67 0.08 0.08
query5 0.51 0.60 0.47
query6 1.14 0.72 0.73
query7 0.02 0.01 0.01
query8 0.05 0.04 0.05
query9 0.55 0.50 0.50
query10 0.54 0.54 0.55
query11 0.16 0.12 0.11
query12 0.15 0.12 0.12
query13 0.59 0.59 0.59
query14 0.75 0.78 0.76
query15 0.85 0.81 0.81
query16 0.34 0.37 0.36
query17 0.97 1.03 1.00
query18 0.24 0.23 0.23
query19 1.79 1.69 1.72
query20 0.01 0.01 0.01
query21 15.40 0.78 0.65
query22 4.47 6.65 2.26
query23 18.30 1.44 1.30
query24 2.44 0.22 0.21
query25 0.15 0.08 0.09
query26 0.31 0.21 0.21
query27 0.46 0.23 0.23
query28 13.33 1.01 0.99
query29 12.66 3.38 3.39
query30 0.26 0.06 0.06
query31 2.85 0.39 0.38
query32 3.28 0.49 0.47
query33 2.92 2.86 2.91
query34 17.09 4.42 4.38
query35 4.39 4.39 4.38
query36 0.67 0.45 0.48
query37 0.17 0.15 0.15
query38 0.16 0.15 0.15
query39 0.04 0.04 0.03
query40 0.16 0.12 0.12
query41 0.09 0.05 0.05
query42 0.06 0.06 0.05
query43 0.04 0.05 0.04
Total cold run time: 110.37 s
Total hot run time: 31.04 s
PR approved by at least one committer and no changes requested.
We're closing this PR because it hasn't been updated in a while. This isn't a judgement on the merit of the PR in any way. It's just a way of keeping the PR queue manageable. If you'd like to revive this PR, please reopen it and feel free a maintainer to remove the Stale tag!