doris
doris copied to clipboard
apache
[refactor](predicate) Refactor predicates on external tables
What problem does this PR solve?
Issue Number: close #xxx
Related PR: #xxx
Problem Summary:
Release note
None
Check List (For Author)
-
Test
- [ ] Regression test
- [ ] Unit Test
- [ ] Manual test (add detailed scripts or steps below)
- [ ] No need to test or manual test. Explain why:
- [ ] This is a refactor/code format and no logic has been changed.
- [ ] Previous test can cover this change.
- [ ] No code files have been changed.
- [ ] Other reason
-
Behavior changed:
- [ ] No.
- [ ] Yes.
-
Does this need documentation?
- [ ] No.
- [ ] Yes.
Check List (For Reviewer who merge this PR)
- [ ] Confirm the release note
- [ ] Confirm test cases
- [ ] Confirm document
- [ ] Add branch pick label
Thank you for your contribution to Apache Doris. Don't know what should be done next? See How to process your PR.
Please clearly describe your PR:
- What problem was fixed (it's best to include specific error reporting information). How it was fixed.
- Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
- What features were added. Why was this function added?
- Which code was refactored and why was this part of the code refactored?
- Which functions were optimized and what is the difference before and after the optimization?
TPC-H: Total hot run time: 35501 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 8c2f563413411f0403fed2c9ebc84d847f6cf46c, data reload: false
------ Round 1 ----------------------------------
q1 17608 4199 4068 4068
q2 2031 365 245 245
q3 10163 1317 759 759
q4 10231 880 323 323
q5 7561 2176 1943 1943
q6 185 173 134 134
q7 1005 843 706 706
q8 9362 1483 1167 1167
q9 7122 5279 5339 5279
q10 6857 2387 1973 1973
q11 521 320 304 304
q12 664 740 589 589
q13 17819 3661 2997 2997
q14 298 303 274 274
q15 598 513 517 513
q16 934 899 891 891
q17 735 804 528 528
q18 8324 7171 7140 7140
q19 1088 975 612 612
q20 405 359 244 244
q21 4319 4060 3822 3822
q22 1049 995 990 990
Total cold run time: 108879 ms
Total hot run time: 35501 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4108 4073 4051 4051
q2 328 391 327 327
q3 2150 2654 2303 2303
q4 1336 1775 1299 1299
q5 4263 5115 4603 4603
q6 222 184 129 129
q7 2031 1973 1786 1786
q8 2699 2569 2523 2523
q9 7789 7543 7482 7482
q10 3095 3247 2829 2829
q11 581 509 489 489
q12 698 776 665 665
q13 3540 3932 3316 3316
q14 295 303 270 270
q15 560 522 510 510
q16 927 936 938 936
q17 1261 1485 1462 1462
q18 7831 7752 7493 7493
q19 865 832 889 832
q20 2025 2070 1946 1946
q21 4776 4319 4096 4096
q22 1085 1019 979 979
Total cold run time: 52465 ms
Total hot run time: 50326 ms
TPC-DS: Total hot run time: 181446 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 8c2f563413411f0403fed2c9ebc84d847f6cf46c, data reload: false
query5 5100 652 483 483
query6 334 230 237 230
query7 4231 470 279 279
query8 325 255 241 241
query9 8799 2566 2559 2559
query10 525 381 327 327
query11 15354 14977 15234 14977
query12 194 116 121 116
query13 1265 526 403 403
query14 6381 3256 2992 2992
query14_1 2945 2854 2890 2854
query15 209 196 185 185
query16 910 462 466 462
query17 1103 689 579 579
query18 2695 437 331 331
query19 235 224 200 200
query20 120 115 111 111
query21 222 140 115 115
query22 3964 3935 3879 3879
query23 16597 16120 15891 15891
query23_1 15949 16004 15836 15836
query24 7404 1657 1252 1252
query24_1 1225 1234 1215 1215
query25 552 463 455 455
query26 1264 275 186 186
query27 2725 480 312 312
query28 4444 2156 2138 2138
query29 840 589 472 472
query30 317 247 217 217
query31 814 688 627 627
query32 82 72 67 67
query33 553 345 301 301
query34 908 921 537 537
query35 785 819 717 717
query36 869 899 819 819
query37 143 100 84 84
query38 3834 3831 3909 3831
query39 765 750 726 726
query39_1 688 705 694 694
query40 226 144 126 126
query41 73 68 84 68
query42 112 106 108 106
query43 416 433 401 401
query44 1376 775 763 763
query45 193 193 185 185
query46 887 1002 618 618
query47 1662 1703 1625 1625
query48 322 338 254 254
query49 641 451 371 371
query50 656 309 223 223
query51 3879 3841 3806 3806
query52 108 110 107 107
query53 330 352 294 294
query54 311 277 275 275
query55 80 78 73 73
query56 315 316 311 311
query57 1175 1127 1078 1078
query58 270 267 260 260
query59 2356 2520 2358 2358
query60 341 336 333 333
query61 161 157 157 157
query62 689 688 629 629
query63 332 294 298 294
query64 4964 1309 1009 1009
query65 4038 3952 3946 3946
query66 1372 440 315 315
query67 15311 15139 14908 14908
query68 8331 1023 731 731
query69 493 351 298 298
query70 1073 1028 1005 1005
query71 388 315 282 282
query72 6325 4942 4802 4802
query73 676 580 306 306
query74 8923 8679 8588 8588
query75 3568 3530 3162 3162
query76 3910 1126 775 775
query77 524 394 291 291
query78 9572 9700 8836 8836
query79 1388 879 627 627
query80 712 644 566 566
query81 509 266 235 235
query82 221 132 111 111
query83 262 254 243 243
query84 255 124 103 103
query85 892 514 462 462
query86 391 281 281 281
query87 4016 4027 3975 3975
query88 3260 2305 2295 2295
query89 462 429 392 392
query90 2233 159 157 157
query91 176 169 140 140
query92 85 67 69 67
query93 2011 919 568 568
query94 471 300 284 284
query95 584 341 306 306
query96 594 474 205 205
query97 2546 2636 2585 2585
query98 222 192 195 192
query99 1284 1317 1222 1222
Total cold run time: 264596 ms
Total hot run time: 181446 ms
ClickBench: Total hot run time: 27.14 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 8c2f563413411f0403fed2c9ebc84d847f6cf46c, data reload: false
query1 0.05 0.05 0.04
query2 0.10 0.06 0.05
query3 0.25 0.08 0.08
query4 1.61 0.12 0.11
query5 0.28 0.26 0.25
query6 1.17 0.65 0.63
query7 0.03 0.03 0.02
query8 0.05 0.04 0.04
query9 0.57 0.52 0.50
query10 0.56 0.56 0.55
query11 0.16 0.11 0.11
query12 0.14 0.10 0.11
query13 0.63 0.60 0.60
query14 1.00 0.97 0.99
query15 0.81 0.81 0.80
query16 0.39 0.40 0.42
query17 1.03 0.98 1.06
query18 0.22 0.21 0.21
query19 1.90 1.82 1.81
query20 0.02 0.01 0.01
query21 15.41 0.27 0.14
query22 4.82 0.06 0.05
query23 16.20 0.29 0.10
query24 0.93 0.59 0.25
query25 0.07 0.05 0.06
query26 0.15 0.14 0.13
query27 0.06 0.06 0.06
query28 4.02 1.23 1.01
query29 12.60 3.94 3.25
query30 0.28 0.15 0.11
query31 2.82 0.61 0.39
query32 3.25 0.54 0.48
query33 3.04 2.96 3.06
query34 16.87 5.16 4.50
query35 4.53 4.55 4.57
query36 0.66 0.51 0.50
query37 0.11 0.07 0.07
query38 0.07 0.05 0.04
query39 0.05 0.03 0.03
query40 0.16 0.15 0.13
query41 0.09 0.03 0.03
query42 0.04 0.03 0.02
query43 0.05 0.03 0.03
Total cold run time: 97.25 s
Total hot run time: 27.14 s
BE UT Coverage Report
Increment line coverage 30.58% (137/448) :tada:
Increment coverage report Complete coverage report
| Category | Coverage |
|---|---|
| Function Coverage | 53.35% (18708/35065) |
| Line Coverage | 39.06% (173048/443042) |
| Region Coverage | 33.69% (134171/398239) |
| Branch Coverage | 34.58% (57735/166951) |
BE Regression && UT Coverage Report
Increment line coverage 59.82% (268/448) :tada:
Increment coverage report Complete coverage report
| Category | Coverage |
|---|---|
| Function Coverage | 72.21% (24817/34367) |
| Line Coverage | 58.91% (260733/442566) |
| Region Coverage | 53.78% (216722/402962) |
| Branch Coverage | 55.33% (92858/167826) |
TPC-H: Total hot run time: 35185 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 7c8bb4fe0d401b5b591fb80e06f48789e5715b1d, data reload: false
------ Round 1 ----------------------------------
q1 17640 4150 4035 4035
q2 2036 354 231 231
q3 10163 1328 732 732
q4 10223 902 316 316
q5 7546 2181 1930 1930
q6 181 167 135 135
q7 1012 863 708 708
q8 9348 1435 1158 1158
q9 7093 5342 5257 5257
q10 6824 2385 1932 1932
q11 526 354 286 286
q12 697 721 610 610
q13 17806 3648 3007 3007
q14 290 288 287 287
q15 622 514 518 514
q16 945 902 871 871
q17 709 827 480 480
q18 7575 7151 6968 6968
q19 1246 958 625 625
q20 408 366 258 258
q21 4223 3879 3880 3879
q22 1081 998 966 966
Total cold run time: 108194 ms
Total hot run time: 35185 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4098 4043 4017 4017
q2 329 396 315 315
q3 2126 2693 2322 2322
q4 1314 1759 1306 1306
q5 4259 4683 4829 4683
q6 224 173 136 136
q7 2039 1951 1888 1888
q8 2696 2576 2505 2505
q9 7692 7528 7548 7528
q10 3047 3271 2888 2888
q11 571 516 495 495
q12 860 834 631 631
q13 3642 3930 3432 3432
q14 311 295 294 294
q15 558 568 505 505
q16 890 914 888 888
q17 1179 1489 1424 1424
q18 8080 7730 7557 7557
q19 896 850 836 836
q20 1939 1959 1804 1804
q21 4676 4256 4064 4064
q22 1078 1039 984 984
Total cold run time: 52504 ms
Total hot run time: 50502 ms
TPC-DS: Total hot run time: 180781 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 7c8bb4fe0d401b5b591fb80e06f48789e5715b1d, data reload: false
query5 4606 647 468 468
query6 326 234 225 225
query7 4220 475 281 281
query8 316 262 235 235
query9 8770 2560 2532 2532
query10 525 377 313 313
query11 15276 14704 14744 14704
query12 179 116 117 116
query13 1264 506 400 400
query14 6139 3247 3014 3014
query14_1 2880 2861 2936 2861
query15 211 197 182 182
query16 887 490 463 463
query17 1143 712 611 611
query18 2594 441 353 353
query19 229 231 213 213
query20 121 115 112 112
query21 219 141 122 122
query22 4064 4006 3962 3962
query23 16589 16098 15897 15897
query23_1 15981 16001 15900 15900
query24 7352 1655 1250 1250
query24_1 1197 1255 1247 1247
query25 600 500 466 466
query26 1247 270 168 168
query27 2759 460 315 315
query28 4473 2160 2137 2137
query29 836 577 474 474
query30 319 244 217 217
query31 823 729 610 610
query32 77 80 69 69
query33 558 351 296 296
query34 911 923 537 537
query35 845 824 742 742
query36 859 891 817 817
query37 125 88 72 72
query38 3908 3770 3757 3757
query39 753 757 733 733
query39_1 691 716 699 699
query40 227 137 123 123
query41 68 63 63 63
query42 106 103 105 103
query43 441 431 395 395
query44 1336 753 739 739
query45 193 192 182 182
query46 861 985 610 610
query47 1663 1693 1633 1633
query48 316 329 249 249
query49 630 435 357 357
query50 659 278 220 220
query51 3786 3829 3764 3764
query52 101 107 107 107
query53 319 349 286 286
query54 306 266 247 247
query55 84 75 75 75
query56 304 289 336 289
query57 1134 1131 1086 1086
query58 268 249 250 249
query59 2390 2537 2429 2429
query60 320 318 298 298
query61 172 159 166 159
query62 685 683 624 624
query63 330 296 304 296
query64 5032 1300 1002 1002
query65 3999 3929 3948 3929
query66 1417 452 336 336
query67 15541 15207 14924 14924
query68 8384 1005 768 768
query69 501 349 312 312
query70 1042 995 959 959
query71 369 302 286 286
query72 6162 4863 4860 4860
query73 656 562 308 308
query74 8812 8713 8624 8624
query75 3595 3553 3142 3142
query76 4057 1129 753 753
query77 580 392 284 284
query78 9396 9601 8921 8921
query79 1789 868 614 614
query80 713 660 563 563
query81 526 272 232 232
query82 206 131 103 103
query83 265 254 245 245
query84 260 112 99 99
query85 906 502 462 462
query86 388 297 309 297
query87 4035 4054 3936 3936
query88 3804 2265 2287 2265
query89 472 421 395 395
query90 2208 152 143 143
query91 170 169 142 142
query92 86 64 66 64
query93 2328 920 566 566
query94 471 299 259 259
query95 567 325 355 325
query96 590 469 213 213
query97 2635 2651 2560 2560
query98 218 193 201 193
query99 1272 1301 1211 1211
Total cold run time: 264472 ms
Total hot run time: 180781 ms
ClickBench: Total hot run time: 27.13 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 7c8bb4fe0d401b5b591fb80e06f48789e5715b1d, data reload: false
query1 0.05 0.04 0.04
query2 0.09 0.04 0.04
query3 0.25 0.08 0.08
query4 1.60 0.11 0.11
query5 0.26 0.26 0.26
query6 1.16 0.65 0.63
query7 0.03 0.03 0.02
query8 0.06 0.04 0.05
query9 0.57 0.52 0.51
query10 0.56 0.56 0.55
query11 0.16 0.11 0.12
query12 0.15 0.11 0.12
query13 0.61 0.59 0.60
query14 0.98 0.98 0.98
query15 0.81 0.80 0.80
query16 0.39 0.42 0.43
query17 1.03 1.01 1.08
query18 0.22 0.22 0.21
query19 1.90 1.69 1.86
query20 0.02 0.02 0.01
query21 15.44 0.28 0.14
query22 4.68 0.05 0.04
query23 16.00 0.30 0.10
query24 1.30 0.45 0.28
query25 0.07 0.05 0.06
query26 0.15 0.13 0.14
query27 0.09 0.05 0.05
query28 4.43 1.22 1.03
query29 12.68 4.05 3.17
query30 0.28 0.15 0.12
query31 2.81 0.62 0.40
query32 3.24 0.56 0.46
query33 2.97 3.00 3.00
query34 17.02 5.25 4.57
query35 4.54 4.55 4.54
query36 0.66 0.51 0.48
query37 0.11 0.06 0.07
query38 0.07 0.04 0.04
query39 0.04 0.04 0.03
query40 0.18 0.14 0.14
query41 0.08 0.03 0.03
query42 0.04 0.03 0.03
query43 0.04 0.03 0.04
Total cold run time: 97.82 s
Total hot run time: 27.13 s
BE UT Coverage Report
Increment line coverage 30.58% (137/448) :tada:
Increment coverage report Complete coverage report
| Category | Coverage |
|---|---|
| Function Coverage | 53.38% (18725/35079) |
| Line Coverage | 39.10% (173282/443129) |
| Region Coverage | 33.76% (134448/398271) |
| Branch Coverage | 34.64% (57827/166941) |
BE Regression && UT Coverage Report
Increment line coverage 59.82% (268/448) :tada:
Increment coverage report Complete coverage report
| Category | Coverage |
|---|---|
| Function Coverage | 72.27% (24847/34381) |
| Line Coverage | 59.00% (261146/442653) |
| Region Coverage | 54.01% (217662/402994) |
| Branch Coverage | 55.47% (93080/167816) |
TPC-H: Total hot run time: 35194 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit e04ac300312a9cc2b308fa73f7f766db34afb485, data reload: false
------ Round 1 ----------------------------------
q1 17613 4322 4123 4123
q2 2032 355 233 233
q3 10182 1326 743 743
q4 10226 905 319 319
q5 7542 2208 1940 1940
q6 203 173 141 141
q7 1012 875 721 721
q8 9370 1491 1145 1145
q9 7207 5329 5341 5329
q10 6860 2384 1977 1977
q11 531 324 296 296
q12 696 744 586 586
q13 17829 3685 3090 3090
q14 301 295 269 269
q15 606 522 519 519
q16 689 670 634 634
q17 708 794 558 558
q18 8038 7089 7164 7089
q19 1093 968 602 602
q20 403 359 254 254
q21 4256 3958 3676 3676
q22 1083 1022 950 950
Total cold run time: 108480 ms
Total hot run time: 35194 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4117 4067 4086 4067
q2 343 395 308 308
q3 2205 2649 2310 2310
q4 1344 1758 1291 1291
q5 4272 4757 4657 4657
q6 226 180 132 132
q7 2216 2039 1844 1844
q8 2696 2547 2610 2547
q9 7549 7486 7539 7486
q10 3019 3254 2912 2912
q11 620 526 498 498
q12 779 772 614 614
q13 3738 3911 3278 3278
q14 317 313 293 293
q15 584 515 513 513
q16 660 704 668 668
q17 1245 1498 1433 1433
q18 7842 7778 7662 7662
q19 890 858 870 858
q20 2047 2066 1832 1832
q21 4707 4431 4151 4151
q22 1092 989 971 971
Total cold run time: 52508 ms
Total hot run time: 50325 ms
TPC-DS: Total hot run time: 178060 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 e04ac300312a9cc2b308fa73f7f766db34afb485, data reload: false
query5 4403 620 479 479
query6 327 224 222 222
query7 4222 476 285 285
query8 312 250 244 244
query9 8774 2564 2554 2554
query10 528 374 336 336
query11 15214 14715 14546 14546
query12 181 127 115 115
query13 1263 523 416 416
query14 5526 3219 2981 2981
query14_1 2825 2852 2927 2852
query15 218 202 180 180
query16 922 464 457 457
query17 1144 727 600 600
query18 2456 453 362 362
query19 240 233 211 211
query20 123 117 111 111
query21 219 139 120 120
query22 4089 3978 3869 3869
query23 16630 16157 15980 15980
query23_1 16160 15909 16125 15909
query24 7421 1667 1244 1244
query24_1 1255 1223 1264 1223
query25 579 517 449 449
query26 1265 269 163 163
query27 2741 463 305 305
query28 4489 2154 2124 2124
query29 807 575 480 480
query30 319 249 224 224
query31 821 686 652 652
query32 80 69 69 69
query33 555 335 297 297
query34 898 914 556 556
query35 809 823 741 741
query36 909 911 814 814
query37 127 93 79 79
query38 2830 2862 2860 2860
query39 762 741 719 719
query39_1 691 697 702 697
query40 224 134 118 118
query41 66 63 69 63
query42 105 101 105 101
query43 432 424 392 392
query44 1324 754 732 732
query45 189 193 183 183
query46 874 972 610 610
query47 1634 1709 1618 1618
query48 317 325 239 239
query49 629 412 342 342
query50 671 290 219 219
query51 3791 3864 3827 3827
query52 105 108 99 99
query53 312 345 295 295
query54 281 267 254 254
query55 88 74 72 72
query56 297 304 283 283
query57 1158 1141 1072 1072
query58 272 248 300 248
query59 2394 2391 2406 2391
query60 316 320 292 292
query61 158 156 152 152
query62 694 662 620 620
query63 327 298 295 295
query64 4977 1304 993 993
query65 4005 3953 3962 3953
query66 1447 450 315 315
query67 14999 14783 15014 14783
query68 8307 1008 725 725
query69 510 356 309 309
query70 1051 1004 977 977
query71 373 303 284 284
query72 6115 4907 4917 4907
query73 663 595 306 306
query74 8834 8813 8626 8626
query75 3214 3129 2741 2741
query76 3839 1139 752 752
query77 522 418 291 291
query78 9369 9621 8867 8867
query79 1461 872 600 600
query80 745 651 550 550
query81 505 273 235 235
query82 222 124 106 106
query83 264 258 234 234
query84 256 116 97 97
query85 940 508 461 461
query86 308 284 279 279
query87 2981 3051 2964 2964
query88 3169 2273 2247 2247
query89 464 421 391 391
query90 2029 159 143 143
query91 172 169 141 141
query92 71 66 63 63
query93 1036 902 557 557
query94 468 299 266 266
query95 577 318 355 318
query96 600 458 207 207
query97 2233 2313 2199 2199
query98 212 201 190 190
query99 1272 1275 1193 1193
Total cold run time: 258258 ms
Total hot run time: 178060 ms
ClickBench: Total hot run time: 27.24 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit e04ac300312a9cc2b308fa73f7f766db34afb485, data reload: false
query1 0.05 0.04 0.04
query2 0.10 0.05 0.04
query3 0.25 0.09 0.09
query4 1.61 0.11 0.11
query5 0.27 0.27 0.24
query6 1.16 0.63 0.63
query7 0.03 0.02 0.03
query8 0.06 0.04 0.04
query9 0.56 0.50 0.50
query10 0.55 0.56 0.55
query11 0.16 0.11 0.11
query12 0.15 0.11 0.11
query13 0.62 0.60 0.61
query14 0.99 0.99 1.00
query15 0.81 0.79 0.80
query16 0.41 0.40 0.41
query17 0.98 1.01 1.00
query18 0.22 0.21 0.21
query19 1.88 1.78 1.77
query20 0.02 0.01 0.01
query21 15.44 0.28 0.14
query22 4.95 0.05 0.05
query23 16.20 0.29 0.10
query24 1.63 0.53 0.29
query25 0.11 0.06 0.07
query26 0.15 0.14 0.14
query27 0.09 0.06 0.05
query28 3.28 1.22 1.03
query29 12.60 4.06 3.34
query30 0.29 0.14 0.11
query31 2.82 0.63 0.39
query32 3.25 0.55 0.45
query33 2.99 2.97 2.97
query34 16.95 5.20 4.53
query35 4.51 4.53 4.57
query36 0.64 0.51 0.49
query37 0.11 0.06 0.07
query38 0.07 0.05 0.04
query39 0.04 0.02 0.03
query40 0.18 0.14 0.13
query41 0.09 0.03 0.02
query42 0.04 0.03 0.02
query43 0.04 0.03 0.04
Total cold run time: 97.35 s
Total hot run time: 27.24 s
PR approved by at least one committer and no changes requested.
![github-actions[bot] avatar](https://avatars.githubusercontent.com/in/15368?v=4 "Published by a pub.dev verified publisher"){kind=small}
PR approved by at least one committer and no changes requested.
BE UT Coverage Report
Increment line coverage 33.47% (164/490) :tada:
Increment coverage report Complete coverage report
| Category | Coverage |
|---|---|
| Function Coverage | 53.41% (18830/35258) |
| Line Coverage | 39.18% (174284/444797) |
| Region Coverage | 33.76% (134938/399666) |
| Branch Coverage | 34.67% (58104/167608) |
TPC-H: Total hot run time: 35290 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit bea143ee6504b08d05336e64ee4929ed7bebe94a, data reload: false
------ Round 1 ----------------------------------
q1 17660 4268 4141 4141
q2 2067 350 238 238
q3 10174 1321 749 749
q4 10225 901 318 318
q5 7530 2124 1940 1940
q6 190 167 137 137
q7 1008 840 706 706
q8 9363 1466 1114 1114
q9 6984 5436 5384 5384
q10 6841 2384 1995 1995
q11 526 335 299 299
q12 665 710 635 635
q13 18227 3665 3145 3145
q14 311 316 280 280
q15 603 525 523 523
q16 728 712 645 645
q17 723 880 469 469
q18 7767 7135 6944 6944
q19 1235 968 612 612
q20 413 361 263 263
q21 4289 4051 3800 3800
q22 1091 985 953 953
Total cold run time: 108620 ms
Total hot run time: 35290 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4353 4098 4105 4098
q2 335 393 316 316
q3 2132 2677 2306 2306
q4 1332 1777 1272 1272
q5 4255 4721 4733 4721
q6 236 181 145 145
q7 2114 1974 1835 1835
q8 2729 2527 2587 2527
q9 7584 7423 7477 7423
q10 3060 3315 2855 2855
q11 592 514 489 489
q12 716 900 633 633
q13 3579 4056 3274 3274
q14 283 309 296 296
q15 549 508 525 508
q16 651 697 809 697
q17 1216 1642 1415 1415
q18 7809 7646 7770 7646
q19 903 854 870 854
q20 1969 2116 1967 1967
q21 5018 4411 4114 4114
q22 1083 1054 999 999
Total cold run time: 52498 ms
Total hot run time: 50390 ms
TPC-DS: Total hot run time: 178572 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 bea143ee6504b08d05336e64ee4929ed7bebe94a, data reload: false
query5 4450 610 486 486
query6 346 243 227 227
query7 4231 471 285 285
query8 302 265 261 261
query9 8742 2559 2564 2559
query10 542 370 329 329
query11 15264 14789 14731 14731
query12 184 124 118 118
query13 1273 506 397 397
query14 6130 3296 3010 3010
query14_1 2941 2908 2949 2908
query15 218 201 177 177
query16 879 477 474 474
query17 1179 721 622 622
query18 2552 459 355 355
query19 238 248 215 215
query20 131 119 115 115
query21 219 135 118 118
query22 3894 4142 4021 4021
query23 16596 16141 15872 15872
query23_1 16111 16123 15926 15926
query24 7340 1673 1277 1277
query24_1 1291 1250 1294 1250
query25 598 510 454 454
query26 1259 263 165 165
query27 2751 476 307 307
query28 4461 2153 2144 2144
query29 810 570 468 468
query30 326 246 220 220
query31 818 724 628 628
query32 78 74 70 70
query33 560 353 300 300
query34 890 927 546 546
query35 832 821 743 743
query36 881 943 823 823
query37 126 94 86 86
query38 2869 2907 2815 2815
query39 777 735 710 710
query39_1 702 710 712 710
query40 223 137 123 123
query41 72 67 63 63
query42 110 115 111 111
query43 434 434 428 428
query44 1370 777 771 771
query45 190 195 184 184
query46 899 1004 630 630
query47 1650 1712 1620 1620
query48 316 333 245 245
query49 625 425 352 352
query50 662 309 230 230
query51 3915 3812 3897 3812
query52 117 113 101 101
query53 327 359 302 302
query54 304 263 243 243
query55 82 82 74 74
query56 305 298 308 298
query57 1131 1133 1074 1074
query58 274 257 249 249
query59 2452 2531 2337 2337
query60 308 311 289 289
query61 154 161 159 159
query62 699 670 629 629
query63 328 311 340 311
query64 4893 1307 997 997
query65 4092 3945 3935 3935
query66 1438 457 329 329
query67 14929 14774 14734 14734
query68 8350 994 738 738
query69 491 344 310 310
query70 1086 999 1017 999
query71 390 319 285 285
query72 6117 4927 5178 4927
query73 721 614 319 319
query74 8680 9067 8627 8627
query75 3221 3146 2830 2830
query76 3941 1156 764 764
query77 650 394 296 296
query78 9399 9589 8912 8912
query79 1682 892 612 612
query80 733 637 562 562
query81 515 270 237 237
query82 221 140 105 105
query83 262 255 240 240
query84 267 121 118 118
query85 909 521 456 456
query86 390 305 275 275
query87 3105 3080 2906 2906
query88 3474 2296 2261 2261
query89 468 422 399 399
query90 2205 162 151 151
query91 177 166 150 150
query92 83 70 64 64
query93 2039 897 569 569
query94 474 292 284 284
query95 582 376 311 311
query96 588 475 210 210
query97 2280 2333 2254 2254
query98 225 191 194 191
query99 1290 1279 1202 1202
Total cold run time: 261161 ms
Total hot run time: 178572 ms
ClickBench: Total hot run time: 27.28 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit bea143ee6504b08d05336e64ee4929ed7bebe94a, data reload: false
query1 0.05 0.04 0.05
query2 0.11 0.05 0.05
query3 0.26 0.09 0.09
query4 1.61 0.12 0.11
query5 0.29 0.26 0.28
query6 1.16 0.63 0.64
query7 0.03 0.02 0.02
query8 0.05 0.05 0.05
query9 0.57 0.52 0.51
query10 0.56 0.57 0.56
query11 0.15 0.11 0.10
query12 0.14 0.11 0.12
query13 0.62 0.61 0.60
query14 1.00 0.99 0.99
query15 0.83 0.79 0.80
query16 0.41 0.40 0.41
query17 1.02 1.04 0.99
query18 0.24 0.22 0.22
query19 1.84 1.89 1.77
query20 0.02 0.01 0.02
query21 15.47 0.31 0.14
query22 4.90 0.05 0.05
query23 16.18 0.29 0.10
query24 0.97 0.64 0.24
query25 0.09 0.08 0.07
query26 0.14 0.13 0.14
query27 0.09 0.05 0.06
query28 3.87 1.24 1.03
query29 12.59 4.13 3.25
query30 0.28 0.15 0.12
query31 2.81 0.64 0.40
query32 3.25 0.55 0.46
query33 2.96 3.06 3.02
query34 16.87 5.17 4.53
query35 4.60 4.55 4.56
query36 0.65 0.50 0.49
query37 0.11 0.07 0.06
query38 0.07 0.05 0.04
query39 0.04 0.03 0.03
query40 0.17 0.15 0.13
query41 0.08 0.03 0.03
query42 0.05 0.03 0.03
query43 0.04 0.04 0.03
Total cold run time: 97.24 s
Total hot run time: 27.28 s
BE Regression && UT Coverage Report
Increment line coverage 64.08% (314/490) :tada:
Increment coverage report Complete coverage report
| Category | Coverage |
|---|---|
| Function Coverage | 72.25% (24964/34551) |
| Line Coverage | 59.04% (262251/444183) |
| Region Coverage | 53.87% (217789/404295) |
| Branch Coverage | 55.46% (93402/168421) |
BE Regression && UT Coverage Report
Increment line coverage 64.08% (314/490) :tada:
Increment coverage report Complete coverage report
| Category | Coverage |
|---|---|
| Function Coverage | 72.25% (24964/34551) |
| Line Coverage | 59.04% (262251/444183) |
| Region Coverage | 53.87% (217789/404295) |
| Branch Coverage | 55.46% (93402/168421) |