doris
doris copied to clipboard
Published
20 hours ago •
apache
apache
[Chore](nereids) remove KillStmt
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: 33873 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit bc1211ce7fa5a0c94ed8ee00518aa2d0d8c45146, data reload: false
------ Round 1 ----------------------------------
q1 17598 5257 5035 5035
q2 1926 281 182 182
q3 10466 1247 768 768
q4 10207 1007 516 516
q5 7537 2332 2345 2332
q6 178 165 131 131
q7 896 737 616 616
q8 9336 1309 1115 1115
q9 6708 5067 5357 5067
q10 6890 2369 1946 1946
q11 473 288 279 279
q12 343 353 216 216
q13 17770 3626 3076 3076
q14 231 222 213 213
q15 572 491 494 491
q16 425 421 372 372
q17 597 854 355 355
q18 7388 7298 7072 7072
q19 1223 958 565 565
q20 332 341 217 217
q21 3762 3165 2354 2354
q22 1021 1007 955 955
Total cold run time: 105879 ms
Total hot run time: 33873 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5083 5057 5027 5027
q2 238 320 226 226
q3 2140 2635 2259 2259
q4 1371 1782 1378 1378
q5 4257 4122 4306 4122
q6 207 172 126 126
q7 2127 1944 1818 1818
q8 2643 2699 2569 2569
q9 7330 7302 7453 7302
q10 3138 3259 2858 2858
q11 596 522 523 522
q12 734 823 669 669
q13 3632 4024 3483 3483
q14 292 316 283 283
q15 539 483 471 471
q16 480 488 450 450
q17 1200 1572 1388 1388
q18 7995 7662 7519 7519
q19 808 872 952 872
q20 1970 2042 1900 1900
q21 4848 4395 4411 4395
q22 1119 1042 1012 1012
Total cold run time: 52747 ms
Total hot run time: 50649 ms
FE UT Coverage Report
Increment line coverage `` :tada: Increment coverage report Complete coverage report
TPC-H: Total hot run time: 33770 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 26ca33a42d28fbb7d696ccf658dc691af1141440, data reload: false
------ Round 1 ----------------------------------
q1 17681 5220 5035 5035
q2 1948 304 192 192
q3 10370 1316 719 719
q4 10232 987 519 519
q5 7596 2346 2324 2324
q6 180 162 129 129
q7 877 728 616 616
q8 9318 1293 1115 1115
q9 6845 5041 5094 5041
q10 6921 2377 1967 1967
q11 479 285 271 271
q12 341 348 217 217
q13 17781 3618 3058 3058
q14 223 234 207 207
q15 563 478 481 478
q16 426 447 367 367
q17 604 859 369 369
q18 7582 7171 7065 7065
q19 2293 953 544 544
q20 323 326 215 215
q21 3747 3142 2356 2356
q22 1045 983 966 966
Total cold run time: 107375 ms
Total hot run time: 33770 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5246 5092 5129 5092
q2 247 321 227 227
q3 2129 2656 2306 2306
q4 1368 1801 1379 1379
q5 4260 4125 4404 4125
q6 216 170 131 131
q7 1986 1885 1673 1673
q8 2601 2545 2476 2476
q9 7081 7150 7129 7129
q10 3038 3233 2811 2811
q11 564 513 521 513
q12 723 759 611 611
q13 3501 3860 3214 3214
q14 277 291 263 263
q15 509 477 482 477
q16 434 483 442 442
q17 1137 1564 1374 1374
q18 7552 7172 7264 7172
q19 756 809 910 809
q20 1946 1976 1810 1810
q21 4956 4338 4319 4319
q22 1095 1018 984 984
Total cold run time: 51622 ms
Total hot run time: 49337 ms
TPC-DS: Total hot run time: 184996 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 26ca33a42d28fbb7d696ccf658dc691af1141440, data reload: false
query1 975 388 404 388
query2 6518 1893 1847 1847
query3 6739 222 224 222
query4 26327 23355 22917 22917
query5 4379 634 500 500
query6 292 213 202 202
query7 4617 485 294 294
query8 269 227 217 217
query9 8634 2644 2626 2626
query10 480 331 274 274
query11 15669 15129 14687 14687
query12 167 107 107 107
query13 1650 519 424 424
query14 9636 6138 6148 6138
query15 200 208 166 166
query16 7442 656 488 488
query17 1202 736 580 580
query18 2016 418 311 311
query19 199 191 162 162
query20 122 123 125 123
query21 218 123 116 116
query22 4033 4190 3968 3968
query23 33780 32967 33013 32967
query24 7509 2371 2349 2349
query25 515 476 396 396
query26 722 265 149 149
query27 2515 504 344 344
query28 2922 2113 2098 2098
query29 656 568 444 444
query30 279 228 191 191
query31 927 856 762 762
query32 74 60 67 60
query33 531 355 313 313
query34 772 834 544 544
query35 808 804 722 722
query36 922 979 873 873
query37 110 97 77 77
query38 4133 4098 3989 3989
query39 1465 1419 1403 1403
query40 214 118 109 109
query41 62 61 58 58
query42 125 116 117 116
query43 517 520 493 493
query44 1348 839 829 829
query45 184 170 173 170
query46 848 1018 622 622
query47 1769 1783 1695 1695
query48 394 437 316 316
query49 680 492 383 383
query50 658 663 401 401
query51 4137 4298 4099 4099
query52 106 104 106 104
query53 217 257 180 180
query54 558 561 493 493
query55 83 83 85 83
query56 328 299 284 284
query57 1174 1208 1102 1102
query58 264 266 253 253
query59 2597 2729 2698 2698
query60 338 321 296 296
query61 123 125 123 123
query62 755 693 670 670
query63 226 182 178 178
query64 2802 1025 715 715
query65 4245 4203 4198 4198
query66 961 408 313 313
query67 15726 15401 15363 15363
query68 8760 826 527 527
query69 458 301 271 271
query70 1236 1141 1063 1063
query71 462 342 303 303
query72 5284 4772 4910 4772
query73 765 661 365 365
query74 8958 9139 8804 8804
query75 4206 3192 2645 2645
query76 3547 1226 759 759
query77 796 375 292 292
query78 10018 10387 9325 9325
query79 1272 807 562 562
query80 599 524 452 452
query81 478 274 225 225
query82 421 124 98 98
query83 252 252 237 237
query84 241 96 151 96
query85 770 354 318 318
query86 334 296 287 287
query87 4300 4433 4316 4316
query88 2853 2274 2260 2260
query89 378 316 277 277
query90 1919 214 211 211
query91 150 139 110 110
query92 81 63 65 63
query93 1044 935 581 581
query94 659 413 303 303
query95 370 299 288 288
query96 483 575 273 273
query97 2688 2747 2651 2651
query98 225 210 207 207
query99 1582 1386 1273 1273
Total cold run time: 267452 ms
Total hot run time: 184996 ms
ClickBench: Total hot run time: 29.26 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 26ca33a42d28fbb7d696ccf658dc691af1141440, data reload: false
query1 0.04 0.03 0.03
query2 0.07 0.03 0.04
query3 0.23 0.08 0.06
query4 1.61 0.10 0.11
query5 0.42 0.43 0.42
query6 1.19 0.65 0.67
query7 0.03 0.02 0.02
query8 0.05 0.04 0.04
query9 0.59 0.51 0.50
query10 0.57 0.57 0.57
query11 0.15 0.11 0.11
query12 0.15 0.12 0.12
query13 0.63 0.61 0.61
query14 0.80 0.82 0.80
query15 0.89 0.86 0.89
query16 0.39 0.38 0.38
query17 1.08 1.07 1.04
query18 0.23 0.21 0.21
query19 1.94 1.88 1.84
query20 0.01 0.01 0.01
query21 15.39 0.91 0.56
query22 0.74 1.26 0.65
query23 14.92 1.38 0.62
query24 7.69 0.66 0.52
query25 0.50 0.20 0.20
query26 0.54 0.17 0.14
query27 0.07 0.05 0.05
query28 9.05 0.95 0.46
query29 12.59 4.00 3.34
query30 0.26 0.10 0.06
query31 2.83 0.60 0.42
query32 3.23 0.54 0.46
query33 3.05 3.02 3.09
query34 16.17 5.38 4.78
query35 4.78 4.85 4.76
query36 0.69 0.52 0.49
query37 0.09 0.07 0.06
query38 0.05 0.04 0.04
query39 0.03 0.03 0.03
query40 0.16 0.14 0.14
query41 0.08 0.02 0.02
query42 0.03 0.02 0.02
query43 0.04 0.02 0.03
Total cold run time: 104.05 s
Total hot run time: 29.26 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}