doris
doris copied to clipboard
apache
[Chore] (nereids) remove CancelStmt
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: 33928 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 828904f254ca4c07cd264760b1194127f78e3cc8, data reload: false
------ Round 1 ----------------------------------
q1 17592 5233 5028 5028
q2 1964 307 162 162
q3 10289 1260 779 779
q4 10211 1009 527 527
q5 7513 2333 2306 2306
q6 175 168 133 133
q7 901 766 602 602
q8 9313 1294 1159 1159
q9 6773 5074 5052 5052
q10 6926 2361 1949 1949
q11 488 290 283 283
q12 338 343 217 217
q13 17755 3705 3135 3135
q14 221 239 218 218
q15 564 493 489 489
q16 426 436 374 374
q17 603 858 362 362
q18 7645 7279 7036 7036
q19 1217 941 576 576
q20 341 342 232 232
q21 3735 3187 2350 2350
q22 1073 1025 959 959
Total cold run time: 106063 ms
Total hot run time: 33928 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5090 4999 5073 4999
q2 240 321 225 225
q3 2197 2645 2297 2297
q4 1403 1785 1324 1324
q5 4252 4086 4253 4086
q6 213 171 130 130
q7 2049 1924 1752 1752
q8 2622 2692 2557 2557
q9 7183 7109 7146 7109
q10 3094 3302 2853 2853
q11 568 517 492 492
q12 656 752 634 634
q13 3604 3878 3354 3354
q14 288 295 285 285
q15 527 478 473 473
q16 435 501 439 439
q17 1151 1538 1384 1384
q18 7756 7436 7442 7436
q19 839 829 938 829
q20 1972 2114 1923 1923
q21 5030 4609 4372 4372
q22 1061 1030 1066 1030
Total cold run time: 52230 ms
Total hot run time: 49983 ms
TPC-DS: Total hot run time: 192607 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 828904f254ca4c07cd264760b1194127f78e3cc8, data reload: false
query1 1435 1019 1008 1008
query2 6327 1869 1845 1845
query3 11016 4517 4398 4398
query4 54028 25386 23134 23134
query5 5296 479 447 447
query6 383 203 183 183
query7 5088 508 285 285
query8 296 219 201 201
query9 6519 2698 2690 2690
query10 425 329 277 277
query11 15288 14970 14724 14724
query12 161 108 105 105
query13 1131 543 417 417
query14 10102 6389 6393 6389
query15 209 199 198 198
query16 7051 656 509 509
query17 1135 710 577 577
query18 1557 406 321 321
query19 214 211 176 176
query20 134 155 120 120
query21 208 124 106 106
query22 4351 4317 4272 4272
query23 34343 33757 33483 33483
query24 6541 2445 2449 2445
query25 480 468 416 416
query26 664 282 155 155
query27 2125 502 347 347
query28 2961 2199 2198 2198
query29 632 594 462 462
query30 280 229 189 189
query31 874 849 784 784
query32 77 64 68 64
query33 505 381 341 341
query34 773 872 553 553
query35 812 851 776 776
query36 942 1002 893 893
query37 157 104 77 77
query38 4166 4268 4175 4175
query39 1542 1460 1474 1460
query40 221 123 112 112
query41 64 59 57 57
query42 131 120 124 120
query43 524 525 497 497
query44 1455 853 858 853
query45 178 183 174 174
query46 872 1023 681 681
query47 1863 1859 1808 1808
query48 404 425 341 341
query49 665 489 418 418
query50 673 716 417 417
query51 4247 4240 4183 4183
query52 119 111 104 104
query53 237 264 182 182
query54 591 592 523 523
query55 85 86 82 82
query56 329 316 299 299
query57 1229 1233 1146 1146
query58 286 273 252 252
query59 2720 2842 2687 2687
query60 346 342 313 313
query61 129 119 129 119
query62 783 729 686 686
query63 241 208 202 202
query64 1459 1003 762 762
query65 4250 4220 4126 4126
query66 759 469 314 314
query67 15777 15955 15291 15291
query68 7744 903 539 539
query69 556 306 263 263
query70 1182 1127 1086 1086
query71 514 332 299 299
query72 5685 4795 4866 4795
query73 1278 664 365 365
query74 8953 9171 9099 9099
query75 3728 3188 2665 2665
query76 4235 1192 752 752
query77 630 385 287 287
query78 10166 10289 9361 9361
query79 2098 828 589 589
query80 582 510 438 438
query81 494 266 219 219
query82 459 125 95 95
query83 259 248 238 238
query84 298 110 83 83
query85 799 368 313 313
query86 419 306 285 285
query87 4368 4405 4307 4307
query88 3514 2294 2280 2280
query89 411 316 282 282
query90 1794 217 216 216
query91 136 139 111 111
query92 80 58 58 58
query93 1858 956 591 591
query94 701 422 305 305
query95 356 289 283 283
query96 496 585 281 281
query97 2718 2726 2699 2699
query98 255 208 206 206
query99 1332 1369 1268 1268
Total cold run time: 298963 ms
Total hot run time: 192607 ms
ClickBench: Total hot run time: 29.77 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 828904f254ca4c07cd264760b1194127f78e3cc8, data reload: false
query1 0.03 0.03 0.03
query2 0.07 0.03 0.04
query3 0.24 0.07 0.07
query4 1.63 0.10 0.11
query5 0.44 0.42 0.42
query6 1.16 0.65 0.66
query7 0.02 0.02 0.02
query8 0.05 0.03 0.04
query9 0.57 0.53 0.51
query10 0.57 0.58 0.57
query11 0.16 0.11 0.11
query12 0.15 0.12 0.11
query13 0.63 0.61 0.61
query14 0.82 0.82 0.81
query15 0.89 0.85 0.88
query16 0.40 0.38 0.39
query17 1.09 1.06 1.06
query18 0.23 0.22 0.21
query19 2.04 1.87 1.84
query20 0.02 0.01 0.02
query21 15.40 0.89 0.58
query22 0.75 1.31 0.79
query23 14.76 1.40 0.65
query24 6.82 0.72 0.94
query25 0.46 0.21 0.08
query26 0.65 0.16 0.15
query27 0.07 0.05 0.06
query28 9.62 0.91 0.44
query29 12.66 4.07 3.42
query30 0.25 0.09 0.06
query31 2.82 0.60 0.40
query32 3.24 0.55 0.47
query33 3.03 3.12 3.21
query34 16.05 5.39 4.77
query35 4.87 4.84 4.82
query36 0.69 0.50 0.51
query37 0.08 0.06 0.06
query38 0.05 0.04 0.04
query39 0.03 0.03 0.02
query40 0.18 0.14 0.14
query41 0.09 0.03 0.03
query42 0.03 0.02 0.03
query43 0.04 0.03 0.02
Total cold run time: 103.85 s
Total hot run time: 29.77 s
FE UT Coverage Report
Increment line coverage 100% (0/0) :tada:
Increment coverage report
Complete coverage report
TPC-H: Total hot run time: 33830 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 43e0e5038bb7ac71be3af9045f102d2d3213c8ee, data reload: false
------ Round 1 ----------------------------------
q1 17582 5092 4965 4965
q2 1931 277 195 195
q3 10307 1260 699 699
q4 10218 982 516 516
q5 7520 2416 2344 2344
q6 174 164 128 128
q7 902 726 600 600
q8 9309 1238 1142 1142
q9 6821 5052 5074 5052
q10 6886 2386 1965 1965
q11 485 283 273 273
q12 351 340 209 209
q13 17761 3614 3061 3061
q14 231 221 214 214
q15 557 480 486 480
q16 432 428 386 386
q17 607 850 376 376
q18 7556 7118 7169 7118
q19 1281 956 549 549
q20 344 337 232 232
q21 3757 3263 2375 2375
q22 1053 994 951 951
Total cold run time: 106065 ms
Total hot run time: 33830 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5051 4988 4976 4976
q2 238 318 222 222
q3 2146 2660 2318 2318
q4 1357 1760 1340 1340
q5 4205 4120 4265 4120
q6 205 171 127 127
q7 2010 1899 1731 1731
q8 2562 2522 2443 2443
q9 7198 7009 7132 7009
q10 3065 3246 2797 2797
q11 573 515 489 489
q12 664 771 617 617
q13 3503 3885 3287 3287
q14 286 336 275 275
q15 510 474 487 474
q16 444 475 432 432
q17 1147 1484 1355 1355
q18 7571 7234 7199 7199
q19 763 733 775 733
q20 1940 2006 1814 1814
q21 4783 4391 4309 4309
q22 1069 995 1017 995
Total cold run time: 51290 ms
Total hot run time: 49062 ms
TPC-DS: Total hot run time: 185751 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 43e0e5038bb7ac71be3af9045f102d2d3213c8ee, data reload: false
query1 1014 400 398 398
query2 6537 1833 1789 1789
query3 6749 230 230 230
query4 26550 23563 23310 23310
query5 4376 618 476 476
query6 307 207 218 207
query7 4618 486 285 285
query8 264 213 206 206
query9 8648 2613 2617 2613
query10 480 323 265 265
query11 15261 15024 14704 14704
query12 157 111 108 108
query13 1653 532 423 423
query14 8726 6084 6066 6066
query15 202 188 175 175
query16 7282 612 491 491
query17 1213 721 578 578
query18 1994 419 313 313
query19 202 194 166 166
query20 125 119 114 114
query21 213 140 110 110
query22 4170 4311 4161 4161
query23 33847 33064 33128 33064
query24 8465 2373 2392 2373
query25 525 465 380 380
query26 826 275 150 150
query27 2728 510 331 331
query28 4298 2111 2100 2100
query29 692 559 437 437
query30 292 220 200 200
query31 900 840 753 753
query32 118 62 62 62
query33 547 374 322 322
query34 786 841 529 529
query35 770 801 712 712
query36 935 977 857 857
query37 114 104 79 79
query38 4031 4119 4027 4027
query39 1484 1403 1412 1403
query40 205 117 104 104
query41 62 86 63 63
query42 114 104 109 104
query43 491 493 484 484
query44 1310 838 825 825
query45 173 173 174 173
query46 852 1016 622 622
query47 1768 1787 1750 1750
query48 400 410 310 310
query49 704 480 390 390
query50 641 660 390 390
query51 4090 4088 4182 4088
query52 111 111 100 100
query53 217 253 184 184
query54 569 559 500 500
query55 88 80 86 80
query56 307 298 276 276
query57 1160 1196 1151 1151
query58 269 254 258 254
query59 2566 2623 2572 2572
query60 323 315 302 302
query61 142 122 121 121
query62 785 733 657 657
query63 221 184 185 184
query64 3496 993 667 667
query65 4245 4224 4148 4148
query66 1015 407 302 302
query67 15603 15599 15510 15510
query68 8004 890 522 522
query69 479 301 269 269
query70 1251 1123 1098 1098
query71 464 330 305 305
query72 5582 4781 4932 4781
query73 731 663 359 359
query74 9198 9088 8962 8962
query75 3906 3206 2707 2707
query76 3646 1192 735 735
query77 781 378 280 280
query78 10094 10222 9359 9359
query79 1990 822 579 579
query80 603 519 459 459
query81 489 255 223 223
query82 468 125 97 97
query83 244 255 233 233
query84 249 115 90 90
query85 788 349 309 309
query86 336 294 282 282
query87 4368 4487 4264 4264
query88 3515 2293 2351 2293
query89 386 322 284 284
query90 1936 215 211 211
query91 140 142 110 110
query92 81 63 58 58
query93 1215 959 592 592
query94 695 408 313 313
query95 374 286 286 286
query96 493 562 284 284
query97 2747 2799 2658 2658
query98 227 210 205 205
query99 1428 1420 1266 1266
Total cold run time: 270934 ms
Total hot run time: 185751 ms
ClickBench: Total hot run time: 29.16 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 43e0e5038bb7ac71be3af9045f102d2d3213c8ee, data reload: false
query1 0.03 0.04 0.03
query2 0.07 0.03 0.04
query3 0.24 0.07 0.06
query4 1.61 0.10 0.11
query5 0.43 0.42 0.40
query6 1.16 0.66 0.64
query7 0.02 0.02 0.01
query8 0.05 0.04 0.04
query9 0.59 0.52 0.52
query10 0.58 0.57 0.58
query11 0.16 0.11 0.11
query12 0.15 0.12 0.11
query13 0.63 0.61 0.61
query14 0.81 0.82 0.79
query15 0.89 0.84 0.86
query16 0.38 0.38 0.38
query17 1.04 1.06 1.11
query18 0.23 0.21 0.22
query19 1.92 1.86 1.85
query20 0.01 0.01 0.02
query21 15.41 0.89 0.52
query22 0.78 1.23 0.67
query23 14.88 1.40 0.63
query24 6.96 1.56 0.56
query25 0.52 0.17 0.06
query26 0.64 0.16 0.13
query27 0.06 0.06 0.05
query28 9.16 0.95 0.46
query29 12.54 3.98 3.30
query30 0.25 0.09 0.06
query31 2.84 0.61 0.40
query32 3.29 0.55 0.52
query33 3.10 3.09 3.07
query34 16.04 5.41 4.78
query35 4.84 4.84 4.78
query36 0.68 0.50 0.48
query37 0.09 0.06 0.06
query38 0.05 0.04 0.04
query39 0.03 0.03 0.03
query40 0.17 0.16 0.13
query41 0.08 0.03 0.02
query42 0.03 0.02 0.02
query43 0.04 0.03 0.02
Total cold run time: 103.48 s
Total hot run time: 29.16 s
FE UT Coverage Report
Increment line coverage 100% (0/0) :tada:
Increment coverage report
Complete coverage report
FE UT Coverage Report
Increment line coverage 100% (0/0) :tada:
Increment coverage report
Complete coverage report
TPC-H: Total hot run time: 33515 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit d712b17fdeff56afad75de42d774e7ccb486d350, data reload: false
------ Round 1 ----------------------------------
q1 17594 5151 5008 5008
q2 1938 291 195 195
q3 10365 1306 703 703
q4 10237 1006 512 512
q5 7531 2227 2350 2227
q6 174 170 133 133
q7 893 732 598 598
q8 9302 1245 1103 1103
q9 6744 4963 5261 4963
q10 6934 2345 1955 1955
q11 491 290 288 288
q12 342 349 211 211
q13 17775 3677 3088 3088
q14 231 232 216 216
q15 568 483 465 465
q16 430 422 369 369
q17 586 931 361 361
q18 7600 7031 7156 7031
q19 1914 954 551 551
q20 326 332 228 228
q21 3615 2557 2340 2340
q22 1012 974 970 970
Total cold run time: 106602 ms
Total hot run time: 33515 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5289 5103 5114 5103
q2 254 317 220 220
q3 2155 2663 2244 2244
q4 1333 1777 1294 1294
q5 4183 4099 4349 4099
q6 208 174 128 128
q7 1962 1869 1721 1721
q8 2593 2624 2538 2538
q9 7180 6993 6999 6993
q10 3024 3253 2799 2799
q11 567 507 484 484
q12 672 773 611 611
q13 3502 3943 3290 3290
q14 277 307 264 264
q15 522 482 476 476
q16 447 500 435 435
q17 1132 1550 1367 1367
q18 7536 7192 7023 7023
q19 776 767 861 767
q20 1896 1971 1804 1804
q21 4920 4431 4302 4302
q22 1068 975 1002 975
Total cold run time: 51496 ms
Total hot run time: 48937 ms
TPC-DS: Total hot run time: 185396 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 d712b17fdeff56afad75de42d774e7ccb486d350, data reload: false
query1 994 411 389 389
query2 6533 1852 1832 1832
query3 6752 224 221 221
query4 26345 23245 23190 23190
query5 4346 613 443 443
query6 324 202 203 202
query7 4632 486 290 290
query8 272 227 223 223
query9 8583 2633 2637 2633
query10 491 321 266 266
query11 15790 15055 15398 15055
query12 163 108 102 102
query13 1648 540 401 401
query14 9559 6019 6154 6019
query15 207 194 176 176
query16 7405 605 500 500
query17 1191 731 589 589
query18 2028 414 312 312
query19 198 198 162 162
query20 121 117 116 116
query21 220 132 121 121
query22 4145 4159 4004 4004
query23 33762 33038 32984 32984
query24 8495 2384 2369 2369
query25 540 496 424 424
query26 772 275 154 154
query27 2728 509 341 341
query28 4306 2141 2127 2127
query29 746 560 484 484
query30 289 221 194 194
query31 925 836 753 753
query32 77 66 72 66
query33 612 362 313 313
query34 798 840 528 528
query35 779 818 726 726
query36 951 967 886 886
query37 122 102 75 75
query38 4065 4049 4067 4049
query39 1499 1434 1410 1410
query40 204 116 106 106
query41 64 57 74 57
query42 127 116 114 114
query43 543 512 492 492
query44 1338 829 835 829
query45 180 171 162 162
query46 834 1012 636 636
query47 1720 1775 1682 1682
query48 386 443 323 323
query49 701 491 395 395
query50 651 663 407 407
query51 4122 4174 4147 4147
query52 112 105 102 102
query53 232 255 185 185
query54 575 575 503 503
query55 84 86 87 86
query56 329 289 300 289
query57 1154 1186 1105 1105
query58 269 265 251 251
query59 2615 2725 2554 2554
query60 345 320 300 300
query61 131 127 128 127
query62 808 714 664 664
query63 217 187 186 186
query64 3333 1003 703 703
query65 4271 4186 4174 4174
query66 957 411 321 321
query67 15420 15372 15256 15256
query68 8565 897 533 533
query69 475 313 271 271
query70 1209 1120 1114 1114
query71 473 324 297 297
query72 5513 4651 4583 4583
query73 704 578 354 354
query74 8807 9273 8626 8626
query75 3959 3163 2671 2671
query76 3611 1183 754 754
query77 801 388 291 291
query78 9950 10181 9454 9454
query79 1229 811 579 579
query80 576 522 449 449
query81 485 256 224 224
query82 406 126 97 97
query83 260 254 235 235
query84 245 113 85 85
query85 792 430 303 303
query86 333 332 296 296
query87 4403 4469 4356 4356
query88 2853 2283 2282 2282
query89 388 316 283 283
query90 1932 209 205 205
query91 146 146 109 109
query92 77 64 59 59
query93 1036 941 590 590
query94 673 403 296 296
query95 378 292 347 292
query96 491 572 281 281
query97 2699 2745 2617 2617
query98 220 208 209 208
query99 1418 1408 1317 1317
Total cold run time: 270242 ms
Total hot run time: 185396 ms
ClickBench: Total hot run time: 29.86 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit d712b17fdeff56afad75de42d774e7ccb486d350, data reload: false
query1 0.03 0.03 0.03
query2 0.06 0.04 0.03
query3 0.24 0.07 0.06
query4 1.60 0.11 0.10
query5 0.44 0.43 0.43
query6 1.18 0.66 0.65
query7 0.02 0.01 0.01
query8 0.04 0.03 0.04
query9 0.57 0.51 0.52
query10 0.57 0.58 0.56
query11 0.16 0.11 0.11
query12 0.14 0.12 0.12
query13 0.63 0.62 0.61
query14 0.80 0.81 0.81
query15 0.92 0.87 0.87
query16 0.40 0.39 0.39
query17 1.04 1.04 1.10
query18 0.22 0.22 0.21
query19 1.90 1.82 1.84
query20 0.01 0.01 0.02
query21 15.40 0.91 0.52
query22 0.77 1.16 0.59
query23 15.02 1.40 0.59
query24 6.71 1.72 1.23
query25 0.51 0.20 0.13
query26 0.55 0.16 0.14
query27 0.06 0.05 0.06
query28 10.09 0.84 0.46
query29 12.57 3.96 3.30
query30 0.25 0.09 0.07
query31 2.82 0.57 0.40
query32 3.24 0.55 0.47
query33 3.08 3.10 3.11
query34 16.23 5.40 4.80
query35 4.87 4.81 4.80
query36 0.69 0.50 0.48
query37 0.09 0.06 0.07
query38 0.05 0.04 0.04
query39 0.03 0.02 0.02
query40 0.18 0.14 0.13
query41 0.09 0.03 0.03
query42 0.03 0.03 0.02
query43 0.04 0.03 0.04
Total cold run time: 104.34 s
Total hot run time: 29.86 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}