doris
doris copied to clipboard
apache
[release](version) change branch-2.0 version to 2.0.10
Proposed changes
Issue Number: close #xxx
Further comments
If this is a relatively large or complex change, kick off the discussion at [email protected] by explaining why you chose the solution you did and what alternatives you considered, etc...
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.
TPC-H: Total hot run time: 49656 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 55dfc770f753534cf50d59f5a6b814c42176453f, data reload: false
------ Round 1 ----------------------------------
q1 17649 4338 4376 4338
q2 2048 147 140 140
q3 10438 1892 1911 1892
q4 10325 1221 1299 1221
q5 8417 3892 4008 3892
q6 226 123 125 123
q7 2023 1607 1576 1576
q8 9318 2711 2700 2700
q9 11013 10563 10455 10455
q10 8623 3484 3469 3469
q11 425 240 248 240
q12 463 298 302 298
q13 18344 3919 4034 3919
q14 365 329 341 329
q15 497 467 460 460
q16 666 563 568 563
q17 1135 977 948 948
q18 7288 6840 6913 6840
q19 1704 1582 1495 1495
q20 521 324 297 297
q21 4417 4151 4077 4077
q22 491 384 389 384
Total cold run time: 116396 ms
Total hot run time: 49656 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4324 4292 4278 4278
q2 325 222 224 222
q3 4143 4138 4131 4131
q4 2737 2724 2729 2724
q5 7180 7090 7108 7090
q6 230 119 117 117
q7 3222 2811 2851 2811
q8 4372 4446 4462 4446
q9 17365 17101 17147 17101
q10 4226 4267 4261 4261
q11 756 667 760 667
q12 1027 841 865 841
q13 7056 3739 3720 3720
q14 437 424 429 424
q15 494 459 455 455
q16 729 673 684 673
q17 3875 3869 3880 3869
q18 8848 8593 8815 8593
q19 1709 1696 1669 1669
q20 2384 2154 2134 2134
q21 8458 8399 8448 8399
q22 1041 919 925 919
Total cold run time: 84938 ms
Total hot run time: 79544 ms
TPC-DS: Total hot run time: 203280 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 55dfc770f753534cf50d59f5a6b814c42176453f, data reload: false
query1 907 383 381 381
query2 6517 2857 2724 2724
query3 6919 201 195 195
query4 20837 17987 18032 17987
query5 19722 6561 6457 6457
query6 278 213 225 213
query7 4149 300 312 300
query8 276 225 245 225
query9 3195 2741 2664 2664
query10 414 285 283 283
query11 11338 10673 10669 10669
query12 119 75 75 75
query13 5619 723 736 723
query14 17898 13234 13188 13188
query15 364 215 222 215
query16 6456 267 252 252
query17 1731 1462 878 878
query18 2317 408 408 408
query19 202 155 155 155
query20 77 77 74 74
query21 200 91 96 91
query22 5180 4966 4938 4938
query23 32668 31975 32150 31975
query24 6926 6539 6453 6453
query25 500 432 424 424
query26 531 162 160 160
query27 1876 297 298 297
query28 6165 2405 2358 2358
query29 2932 2708 2707 2707
query30 244 159 158 158
query31 907 706 732 706
query32 71 58 58 58
query33 397 251 260 251
query34 833 479 496 479
query35 1164 911 953 911
query36 1182 1126 1280 1126
query37 90 63 64 63
query38 3055 2951 2904 2904
query39 1367 1303 1328 1303
query40 202 93 102 93
query41 38 36 33 33
query42 87 81 87 81
query43 790 710 762 710
query44 1149 725 729 725
query45 241 224 225 224
query46 1219 963 969 963
query47 1885 1637 1799 1637
query48 1047 736 703 703
query49 621 364 375 364
query50 873 612 602 602
query51 4750 4599 4656 4599
query52 86 75 73 73
query53 448 320 313 313
query54 2698 2479 2451 2451
query55 91 84 77 77
query56 216 205 210 205
query57 1178 1148 1084 1084
query58 217 197 203 197
query59 4035 3744 3835 3744
query60 202 200 200 200
query61 93 86 89 86
query62 881 438 472 438
query63 473 332 337 332
query64 2486 1633 1494 1494
query65 3628 3530 3578 3530
query66 777 378 387 378
query67 17590 15431 15789 15431
query68 8812 674 677 674
query69 575 353 345 345
query70 1534 1515 1516 1515
query71 410 296 309 296
query72 6554 3437 3439 3437
query73 729 322 323 322
query74 6346 5891 5865 5865
query75 5382 3677 3744 3677
query76 5341 1184 1202 1184
query77 884 267 251 251
query78 12809 11752 12847 11752
query79 8493 654 690 654
query80 1356 398 393 393
query81 497 231 234 231
query82 595 97 101 97
query83 175 136 128 128
query84 251 70 70 70
query85 862 305 298 298
query86 330 297 302 297
query87 3208 3026 2978 2978
query88 4613 2326 2346 2326
query89 401 290 277 277
query90 1927 213 198 198
query91 183 131 132 131
query92 58 51 58 51
query93 4633 609 575 575
query94 711 203 205 203
query95 1108 1070 1054 1054
query96 665 330 327 327
query97 6578 6441 6512 6441
query98 192 180 165 165
query99 3046 990 873 873
Total cold run time: 312882 ms
Total hot run time: 203280 ms
ClickBench: Total hot run time: 30.88 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 55dfc770f753534cf50d59f5a6b814c42176453f, data reload: false
query1 0.02 0.03 0.03
query2 0.07 0.02 0.02
query3 0.24 0.04 0.05
query4 1.80 0.06 0.06
query5 0.53 0.52 0.52
query6 1.24 0.62 0.62
query7 0.01 0.01 0.01
query8 0.03 0.02 0.02
query9 0.53 0.48 0.49
query10 0.55 0.52 0.53
query11 0.12 0.09 0.08
query12 0.12 0.09 0.09
query13 0.62 0.62 0.60
query14 0.78 0.79 0.81
query15 0.77 0.76 0.76
query16 0.36 0.40 0.36
query17 1.00 1.02 1.01
query18 0.23 0.25 0.25
query19 1.96 1.81 1.83
query20 0.02 0.02 0.01
query21 15.45 0.55 0.56
query22 1.97 2.05 1.62
query23 17.17 1.12 0.99
query24 4.50 1.03 2.29
query25 0.34 0.06 0.09
query26 0.68 0.16 0.15
query27 0.04 0.05 0.03
query28 7.94 0.72 0.74
query29 12.64 2.30 2.27
query30 0.60 0.51 0.51
query31 2.81 0.39 0.38
query32 3.38 0.50 0.49
query33 3.10 3.08 3.08
query34 15.25 4.83 4.81
query35 4.84 4.88 4.87
query36 1.07 1.02 1.01
query37 0.06 0.05 0.04
query38 0.03 0.02 0.03
query39 0.02 0.01 0.02
query40 0.16 0.14 0.13
query41 0.06 0.01 0.01
query42 0.02 0.01 0.01
query43 0.02 0.01 0.02
Total cold run time: 103.15 s
Total hot run time: 30.88 s
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
Load test result on commit 55dfc770f753534cf50d59f5a6b814c42176453f with default session variables
Stream load json: 20 seconds loaded 2358488459 Bytes, about 112 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 21.9 seconds inserted 10000000 Rows, about 456K ops/s