You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "924060929 (via GitHub)" <gi...@apache.org> on 2025/12/04 11:51:57 UTC
[PR] [fix](distribute) fix forward insert statement core when use local shuffle union [doris]
924060929 opened a new pull request, #58726:
URL: https://github.com/apache/doris/pull/58726
### What problem does this PR solve?
fix forward insert statement core when use local shuffle union, because the `ConnectContext.get().getStatementContext().getParsedStatement()` is null.
this is a distribute cluster bug so can not add test
### Check List (For Author)
- Test <!-- At least one of them must be included. -->
- [ ] 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.
- [x] Other reason <!-- Add your reason? -->
- Behavior changed:
- [x] No.
- [ ] Yes. <!-- Explain the behavior change -->
- Does this need documentation?
- [x] No.
- [ ] Yes. <!-- Add document PR link here. eg: https://github.com/apache/doris-website/pull/1214 -->
### Check List (For Reviewer who merge this PR)
- [ ] Confirm the release note
- [ ] Confirm test cases
- [ ] Confirm document
- [ ] Add branch pick label <!-- Add branch pick label that this PR should merge into -->
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](distribute) fix forward insert statement core when use local shuffle union [doris]
Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #58726:
URL: https://github.com/apache/doris/pull/58726#issuecomment-3611817726
Thank you for your contribution to Apache Doris.
Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR).
Please clearly describe your PR:
1. What problem was fixed (it's best to include specific error reporting information). How it was fixed.
2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
3. What features were added. Why was this function added?
4. Which code was refactored and why was this part of the code refactored?
5. Which functions were optimized and what is the difference before and after the optimization?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](distribute) fix forward insert statement cause backend core when use local shuffle union [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58726:
URL: https://github.com/apache/doris/pull/58726#issuecomment-3612686234
<details>
<summary>ClickBench: <b>Total hot run time: 27.58 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit f4a1f063643ac48982e7fdf9af77cf3cc69dfc82, data reload: false
query1 0.05 0.04 0.05
query2 0.11 0.05 0.05
query3 0.25 0.10 0.08
query4 1.60 0.11 0.12
query5 0.28 0.26 0.25
query6 1.16 0.66 0.64
query7 0.04 0.02 0.02
query8 0.06 0.04 0.04
query9 0.58 0.53 0.51
query10 0.57 0.57 0.56
query11 0.15 0.10 0.11
query12 0.16 0.12 0.12
query13 0.63 0.62 0.62
query14 1.02 1.00 1.00
query15 0.82 0.81 0.84
query16 0.43 0.42 0.41
query17 1.08 1.06 1.06
query18 0.27 0.22 0.21
query19 1.98 1.90 1.83
query20 0.01 0.01 0.01
query21 15.42 0.28 0.15
query22 4.75 0.06 0.05
query23 15.99 0.30 0.10
query24 1.06 0.54 0.26
query25 0.08 0.08 0.07
query26 0.15 0.13 0.13
query27 0.05 0.06 0.07
query28 3.47 1.24 1.03
query29 12.60 4.00 3.24
query30 0.28 0.14 0.12
query31 2.83 0.64 0.41
query32 3.24 0.56 0.46
query33 3.04 3.09 3.04
query34 16.80 5.30 4.58
query35 4.60 4.55 4.58
query36 0.65 0.51 0.52
query37 0.11 0.06 0.07
query38 0.07 0.04 0.04
query39 0.05 0.03 0.04
query40 0.17 0.15 0.13
query41 0.08 0.04 0.03
query42 0.05 0.03 0.03
query43 0.05 0.04 0.03
Total cold run time: 96.84 s
Total hot run time: 27.58 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](distribute) fix forward insert statement cause backend core when use local shuffle union [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58726:
URL: https://github.com/apache/doris/pull/58726#issuecomment-3612004283
<details>
<summary>ClickBench: <b>Total hot run time: 27.4 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 0a324e5f4b85f065a62d5439b99c2c169546f2f0, data reload: false
query1 0.05 0.05 0.04
query2 0.12 0.04 0.04
query3 0.26 0.09 0.08
query4 1.61 0.12 0.11
query5 0.28 0.25 0.25
query6 1.18 0.63 0.63
query7 0.03 0.03 0.02
query8 0.06 0.05 0.05
query9 0.59 0.51 0.51
query10 0.57 0.55 0.55
query11 0.16 0.11 0.12
query12 0.15 0.12 0.12
query13 0.62 0.60 0.60
query14 0.98 0.99 0.98
query15 0.82 0.82 0.81
query16 0.40 0.39 0.42
query17 1.02 1.00 1.03
query18 0.23 0.22 0.21
query19 1.91 1.86 1.84
query20 0.02 0.01 0.01
query21 15.49 0.31 0.14
query22 4.56 0.05 0.05
query23 15.97 0.29 0.10
query24 1.57 0.60 0.32
query25 0.08 0.05 0.08
query26 0.14 0.13 0.14
query27 0.10 0.06 0.05
query28 3.40 1.22 1.02
query29 12.56 4.00 3.27
query30 0.27 0.15 0.13
query31 2.82 0.63 0.39
query32 3.25 0.56 0.47
query33 3.05 3.03 3.08
query34 16.92 5.23 4.53
query35 4.64 4.54 4.54
query36 0.66 0.51 0.48
query37 0.11 0.06 0.06
query38 0.08 0.04 0.04
query39 0.04 0.03 0.04
query40 0.16 0.15 0.14
query41 0.09 0.03 0.02
query42 0.04 0.03 0.03
query43 0.04 0.04 0.03
Total cold run time: 97.1 s
Total hot run time: 27.4 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](distribute) fix forward insert statement cause backend core when use local shuffle union [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #58726:
URL: https://github.com/apache/doris/pull/58726#issuecomment-3615154618
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](distribute) fix forward insert statement cause backend core when use local shuffle union [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #58726:
URL: https://github.com/apache/doris/pull/58726#issuecomment-3612043085
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](distribute) fix forward insert statement cause backend core when use local shuffle union [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58726:
URL: https://github.com/apache/doris/pull/58726#issuecomment-3615652749
# FE Regression Coverage Report
Increment line coverage ` 25.00% (4/16)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58726_4911eec93bb51609e1741b2ad5950cbf91256dfa_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58726_4911eec93bb51609e1741b2ad5950cbf91256dfa_merge_fe/report/index.html)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](distribute) fix forward insert statement cause backend core when use local shuffle union [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58726:
URL: https://github.com/apache/doris/pull/58726#issuecomment-3615206900
<details>
<summary>TPC-DS: <b>Total hot run time: 179798 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 4911eec93bb51609e1741b2ad5950cbf91256dfa, data reload: false
query5 4947 653 491 491
query6 372 216 212 212
query7 4123 471 280 280
query8 309 247 231 231
query9 6438 2646 2644 2644
query10 476 320 275 275
query11 15436 15319 15059 15059
query12 181 116 112 112
query13 1824 482 361 361
query14 5060 3305 3005 3005
query14_1 2977 2831 2890 2831
query15 204 200 178 178
query16 4780 514 456 456
query17 755 695 600 600
query18 582 426 330 330
query19 219 194 169 169
query20 131 124 118 118
query21 141 141 123 123
query22 4086 3916 3804 3804
query23 16574 16241 16005 16005
query23_1 16065 16143 15970 15970
query24 6072 1629 1186 1186
query24_1 1216 1205 1207 1205
query25 612 475 412 412
query26 1053 277 172 172
query27 2766 462 310 310
query28 4438 2185 2189 2185
query29 763 555 441 441
query30 315 248 216 216
query31 809 716 633 633
query32 79 73 71 71
query33 648 352 302 302
query34 851 877 539 539
query35 802 834 717 717
query36 868 903 835 835
query37 127 91 81 81
query38 3907 3802 3802 3802
query39 753 746 719 719
query39_1 708 688 697 688
query40 228 130 120 120
query41 68 62 63 62
query42 126 98 108 98
query43 443 424 400 400
query44 1311 753 735 735
query45 197 191 190 190
query46 913 966 600 600
query47 1678 1713 1636 1636
query48 402 327 237 237
query49 765 455 352 352
query50 695 315 241 241
query51 3838 3818 3831 3818
query52 118 95 84 84
query53 233 232 185 185
query54 320 267 241 241
query55 92 82 76 76
query56 335 302 305 302
query57 1155 1138 1106 1106
query58 286 262 258 258
query59 2299 2490 2296 2296
query60 373 322 297 297
query61 169 162 179 162
query62 791 687 639 639
query63 236 182 186 182
query64 3614 1302 1003 1003
query65 4074 4006 3943 3943
query66 1018 445 344 344
query67 15222 14949 14779 14779
query68 4260 962 679 679
query69 531 302 272 272
query70 1084 971 933 933
query71 437 298 267 267
query72 6225 4975 4896 4896
query73 644 564 300 300
query74 8845 8740 8653 8653
query75 3036 3052 2512 2512
query76 3356 1165 743 743
query77 459 397 306 306
query78 9512 9841 8826 8826
query79 1009 848 607 607
query80 724 562 468 468
query81 518 270 241 241
query82 237 131 105 105
query83 283 277 252 252
query84 291 116 93 93
query85 918 505 445 445
query86 379 302 281 281
query87 4022 4069 4001 4001
query88 2953 2152 2141 2141
query89 396 315 287 287
query90 1913 162 155 155
query91 176 166 147 147
query92 72 67 67 67
query93 1154 1041 689 689
query94 771 308 250 250
query95 576 391 334 334
query96 553 483 219 219
query97 2579 2713 2602 2602
query98 239 212 198 198
query99 1331 1316 1243 1243
Total cold run time: 247030 ms
Total hot run time: 179798 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](distribute) fix forward insert statement cause backend core when use local shuffle union [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #58726:
URL: https://github.com/apache/doris/pull/58726#issuecomment-3615604789
PR approved by anyone and no changes requested.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](distribute) fix forward insert statement cause backend core when use local shuffle union [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58726:
URL: https://github.com/apache/doris/pull/58726#issuecomment-3615645537
# FE Regression Coverage Report
Increment line coverage ` 25.00% (4/16)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58726_4911eec93bb51609e1741b2ad5950cbf91256dfa_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58726_4911eec93bb51609e1741b2ad5950cbf91256dfa_merge_fe/report/index.html)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](distribute) fix forward insert statement cause backend core when use local shuffle union [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58726:
URL: https://github.com/apache/doris/pull/58726#issuecomment-3612194147
<details>
<summary>ClickBench: <b>Total hot run time: 27.76 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 2a362e9acc7fca09d15089d9a1ecad3937d5b4af, data reload: false
query1 0.05 0.05 0.05
query2 0.10 0.04 0.05
query3 0.26 0.09 0.09
query4 1.62 0.11 0.11
query5 0.28 0.25 0.25
query6 1.15 0.66 0.62
query7 0.03 0.03 0.03
query8 0.06 0.04 0.05
query9 0.60 0.51 0.51
query10 0.56 0.56 0.55
query11 0.15 0.10 0.11
query12 0.14 0.12 0.11
query13 0.62 0.59 0.60
query14 0.97 0.99 0.97
query15 0.82 0.80 0.81
query16 0.39 0.42 0.38
query17 1.05 1.04 1.02
query18 0.23 0.22 0.21
query19 1.93 1.85 1.89
query20 0.02 0.02 0.01
query21 15.45 0.29 0.14
query22 4.92 0.04 0.04
query23 15.98 0.29 0.10
query24 1.45 0.61 0.65
query25 0.09 0.08 0.10
query26 0.14 0.14 0.14
query27 0.06 0.06 0.05
query28 4.51 1.22 1.02
query29 12.60 4.00 3.20
query30 0.28 0.16 0.11
query31 2.84 0.65 0.40
query32 3.23 0.56 0.47
query33 3.09 3.10 3.06
query34 16.52 5.25 4.56
query35 4.61 4.58 4.60
query36 0.67 0.50 0.51
query37 0.12 0.07 0.07
query38 0.07 0.04 0.05
query39 0.04 0.03 0.03
query40 0.18 0.15 0.13
query41 0.09 0.03 0.03
query42 0.05 0.03 0.03
query43 0.04 0.04 0.04
Total cold run time: 98.06 s
Total hot run time: 27.76 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](distribute) fix forward insert statement cause backend core when use local shuffle union [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #58726:
URL: https://github.com/apache/doris/pull/58726#issuecomment-3612389903
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](distribute) fix forward insert statement cause backend core when use local shuffle union [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58726:
URL: https://github.com/apache/doris/pull/58726#issuecomment-3612606143
<details>
<summary>TPC-H: <b>Total hot run time: 35954 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit f4a1f063643ac48982e7fdf9af77cf3cc69dfc82, data reload: false
------ Round 1 ----------------------------------
q1 17630 5032 4942 4942
q2 2034 363 200 200
q3 10194 1335 750 750
q4 10201 820 331 331
q5 7551 2464 2305 2305
q6 186 173 137 137
q7 961 808 662 662
q8 9360 1525 1158 1158
q9 7302 5421 5440 5421
q10 6894 2251 1833 1833
q11 538 310 297 297
q12 408 375 241 241
q13 17810 3746 3071 3071
q14 240 248 212 212
q15 597 508 515 508
q16 904 889 828 828
q17 689 789 579 579
q18 7683 7785 7951 7785
q19 1139 1040 676 676
q20 421 360 243 243
q21 4667 4091 2760 2760
q22 1072 1015 1072 1015
Total cold run time: 108481 ms
Total hot run time: 35954 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5259 5225 5168 5168
q2 400 390 327 327
q3 2294 2824 2557 2557
q4 1426 1996 1420 1420
q5 4606 4464 4550 4464
q6 220 169 128 128
q7 2031 2035 1801 1801
q8 2693 2629 2580 2580
q9 7608 7549 7614 7549
q10 3083 3339 2916 2916
q11 602 519 481 481
q12 722 762 596 596
q13 3574 3814 3044 3044
q14 267 280 261 261
q15 540 505 490 490
q16 835 887 860 860
q17 1140 1436 1378 1378
q18 7294 7104 7160 7104
q19 872 805 859 805
q20 1978 2000 1844 1844
q21 4776 4337 4207 4207
q22 1056 1022 985 985
Total cold run time: 53276 ms
Total hot run time: 50965 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](distribute) fix forward insert statement cause backend core when use local shuffle union [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58726:
URL: https://github.com/apache/doris/pull/58726#issuecomment-3612663170
<details>
<summary>TPC-DS: <b>Total hot run time: 181741 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit f4a1f063643ac48982e7fdf9af77cf3cc69dfc82, data reload: false
query5 4616 679 532 532
query6 353 251 229 229
query7 4662 498 284 284
query8 328 256 252 252
query9 8746 2685 2675 2675
query10 541 330 313 313
query11 15395 14870 14663 14663
query12 181 122 124 122
query13 1700 524 379 379
query14 5835 3471 3091 3091
query14_1 2967 2931 2978 2931
query15 232 202 183 183
query16 7601 486 470 470
query17 1270 755 629 629
query18 2027 441 351 351
query19 238 201 166 166
query20 131 122 123 122
query21 233 146 120 120
query22 3968 3991 3880 3880
query23 16771 16226 15814 15814
query23_1 16214 16233 16342 16233
query24 7245 1674 1235 1235
query24_1 1244 1252 1241 1241
query25 663 538 488 488
query26 1266 294 180 180
query27 2879 492 331 331
query28 4431 2192 2197 2192
query29 812 574 463 463
query30 317 251 219 219
query31 814 710 614 614
query32 91 69 74 69
query33 679 354 301 301
query34 877 897 553 553
query35 792 848 761 761
query36 914 939 833 833
query37 120 103 78 78
query38 3896 3985 3875 3875
query39 785 743 731 731
query39_1 695 723 699 699
query40 232 137 125 125
query41 78 66 66 66
query42 128 101 99 99
query43 462 441 404 404
query44 1352 780 771 771
query45 201 196 181 181
query46 933 994 631 631
query47 1713 1719 1635 1635
query48 404 326 239 239
query49 784 442 358 358
query50 710 322 245 245
query51 3904 3985 3947 3947
query52 120 107 86 86
query53 245 243 186 186
query54 325 278 254 254
query55 101 83 80 80
query56 332 317 344 317
query57 1197 1155 1113 1113
query58 312 261 264 261
query59 2382 2365 2381 2365
query60 361 322 308 308
query61 163 160 161 160
query62 787 696 640 640
query63 240 180 179 179
query64 4550 1201 941 941
query65 4106 4003 3965 3965
query66 1246 450 350 350
query67 15573 15161 15025 15025
query68 7674 971 683 683
query69 545 315 281 281
query70 1138 1036 998 998
query71 444 304 286 286
query72 6028 4986 4984 4984
query73 684 570 318 318
query74 8903 8845 8641 8641
query75 3080 3060 2612 2612
query76 3341 1163 766 766
query77 587 431 302 302
query78 9602 9604 8760 8760
query79 1635 904 595 595
query80 688 573 486 486
query81 495 272 240 240
query82 198 128 107 107
query83 299 288 270 270
query84 268 127 96 96
query85 910 500 450 450
query86 388 309 283 283
query87 4037 4035 3999 3999
query88 4320 2167 2155 2155
query89 405 334 294 294
query90 2109 174 165 165
query91 185 170 144 144
query92 96 69 69 69
query93 1763 1090 688 688
query94 791 322 285 285
query95 597 388 332 332
query96 565 512 222 222
query97 2650 2656 2600 2600
query98 252 208 200 200
query99 1378 1388 1262 1262
Total cold run time: 271289 ms
Total hot run time: 181741 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](distribute) fix forward insert statement cause backend core when use local shuffle union [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58726:
URL: https://github.com/apache/doris/pull/58726#issuecomment-3612696339
# FE UT Coverage Report
Increment line coverage ` 62.50% (10/16)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58726_f4a1f063643ac48982e7fdf9af77cf3cc69dfc82/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58726_f4a1f063643ac48982e7fdf9af77cf3cc69dfc82/fe_report/index.html)
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](distribute) fix forward insert statement cause backend core when use local shuffle union [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58726:
URL: https://github.com/apache/doris/pull/58726#issuecomment-3612127638
<details>
<summary>TPC-H: <b>Total hot run time: 34727 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 2a362e9acc7fca09d15089d9a1ecad3937d5b4af, data reload: false
------ Round 1 ----------------------------------
q1 17626 5065 4954 4954
q2 2061 309 213 213
q3 10250 1326 741 741
q4 10228 913 327 327
q5 7533 2403 2159 2159
q6 189 166 133 133
q7 957 811 625 625
q8 9397 1361 1095 1095
q9 6970 5257 5479 5257
q10 6773 2171 1781 1781
q11 523 306 294 294
q12 342 361 223 223
q13 17776 3644 3032 3032
q14 230 241 215 215
q15 576 533 516 516
q16 888 856 827 827
q17 655 811 455 455
q18 7386 7361 7967 7361
q19 921 1022 651 651
q20 408 373 229 229
q21 4328 3820 2632 2632
q22 1110 1086 1007 1007
Total cold run time: 107127 ms
Total hot run time: 34727 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5274 5065 5164 5065
q2 340 402 323 323
q3 2359 2826 2501 2501
q4 1456 1789 1496 1496
q5 4614 4480 4514 4480
q6 208 169 125 125
q7 2100 1891 1830 1830
q8 2656 2648 2516 2516
q9 7460 7571 7496 7496
q10 3130 3246 2804 2804
q11 583 519 506 506
q12 699 755 582 582
q13 3261 3638 3032 3032
q14 259 276 271 271
q15 530 492 491 491
q16 864 931 841 841
q17 1114 1436 1328 1328
q18 7346 7229 7198 7198
q19 815 781 848 781
q20 1937 1997 1835 1835
q21 4661 4222 4091 4091
q22 1107 1017 989 989
Total cold run time: 52773 ms
Total hot run time: 50581 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](distribute) fix forward insert statement cause backend core when use local shuffle union [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58726:
URL: https://github.com/apache/doris/pull/58726#issuecomment-3611937958
<details>
<summary>TPC-H: <b>Total hot run time: 34130 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 0a324e5f4b85f065a62d5439b99c2c169546f2f0, data reload: false
------ Round 1 ----------------------------------
q1 17625 5011 4898 4898
q2 2055 310 190 190
q3 10274 1337 737 737
q4 10216 852 325 325
q5 7558 2472 2134 2134
q6 188 172 136 136
q7 947 808 637 637
q8 9368 1381 1117 1117
q9 7057 5290 5303 5290
q10 6783 2201 1774 1774
q11 516 305 298 298
q12 342 373 225 225
q13 17759 3721 3006 3006
q14 228 229 220 220
q15 578 506 500 500
q16 911 873 803 803
q17 664 761 517 517
q18 7365 7165 6983 6983
q19 1005 945 597 597
q20 386 359 223 223
q21 4033 3337 2555 2555
q22 1060 1009 965 965
Total cold run time: 106918 ms
Total hot run time: 34130 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4950 4962 4943 4943
q2 339 416 312 312
q3 2142 2687 2303 2303
q4 1364 1787 1375 1375
q5 4290 4420 4639 4420
q6 226 176 133 133
q7 2056 1966 1849 1849
q8 2697 2572 2511 2511
q9 7634 7463 7461 7461
q10 3149 3227 2870 2870
q11 593 501 504 501
q12 695 778 651 651
q13 3568 3951 3373 3373
q14 285 302 272 272
q15 554 611 530 530
q16 912 912 896 896
q17 1231 1419 1492 1419
q18 7924 7652 7706 7652
q19 860 903 895 895
q20 2067 2054 1914 1914
q21 5026 4366 4184 4184
q22 1090 1067 999 999
Total cold run time: 53652 ms
Total hot run time: 51463 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](distribute) fix forward insert statement cause backend core when use local shuffle union [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #58726:
URL: https://github.com/apache/doris/pull/58726#issuecomment-3612241320
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](distribute) fix forward insert statement cause backend core when use local shuffle union [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58726:
URL: https://github.com/apache/doris/pull/58726#issuecomment-3615190591
<details>
<summary>TPC-H: <b>Total hot run time: 34736 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 4911eec93bb51609e1741b2ad5950cbf91256dfa, data reload: false
------ Round 1 ----------------------------------
q1 17606 5075 5027 5027
q2 2078 340 201 201
q3 10199 1376 784 784
q4 10240 913 346 346
q5 8664 2498 2188 2188
q6 237 169 136 136
q7 995 818 667 667
q8 9407 1495 1218 1218
q9 7025 5332 5385 5332
q10 6864 2247 1804 1804
q11 517 321 294 294
q12 380 380 232 232
q13 17774 3726 2986 2986
q14 239 252 222 222
q15 599 522 511 511
q16 879 870 810 810
q17 694 836 509 509
q18 7980 7274 7066 7066
q19 1221 960 618 618
q20 391 350 225 225
q21 4118 3862 2598 2598
q22 1089 1001 962 962
Total cold run time: 109196 ms
Total hot run time: 34736 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5059 5015 4955 4955
q2 319 391 318 318
q3 2180 2679 2310 2310
q4 1335 1758 1283 1283
q5 4321 4169 4220 4169
q6 217 174 127 127
q7 1914 1862 1692 1692
q8 2587 2449 2436 2436
q9 7002 7009 7051 7009
q10 2955 3136 2634 2634
q11 613 518 480 480
q12 681 715 583 583
q13 3264 3695 3013 3013
q14 304 317 272 272
q15 554 509 505 505
q16 882 893 874 874
q17 1152 1343 1377 1343
q18 7358 7081 7072 7072
q19 864 856 866 856
q20 1929 1998 1862 1862
q21 4940 4307 4220 4220
q22 1121 1044 1002 1002
Total cold run time: 51551 ms
Total hot run time: 49015 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](distribute) fix forward insert statement cause backend core when use local shuffle union [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58726:
URL: https://github.com/apache/doris/pull/58726#issuecomment-3612169523
<details>
<summary>TPC-DS: <b>Total hot run time: 179866 ms</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 2a362e9acc7fca09d15089d9a1ecad3937d5b4af, data reload: false
query5 5915 648 507 507
query6 441 218 210 210
query7 4935 478 280 280
query8 353 258 237 237
query9 8715 2649 2669 2649
query10 592 324 261 261
query11 15505 15231 14665 14665
query12 187 121 121 121
query13 1686 496 389 389
query14 7786 3349 3035 3035
query14_1 2951 3002 2946 2946
query15 264 206 196 196
query16 7861 491 448 448
query17 1522 734 616 616
query18 2084 440 345 345
query19 311 198 175 175
query20 136 123 122 122
query21 226 138 117 117
query22 3816 3914 3988 3914
query23 16648 16291 15906 15906
query23_1 16168 16171 16039 16039
query24 6580 1614 1210 1210
query24_1 1237 1219 1216 1216
query25 613 502 456 456
query26 1254 284 175 175
query27 2870 476 310 310
query28 4449 2201 2181 2181
query29 834 596 482 482
query30 318 247 215 215
query31 823 714 618 618
query32 89 70 71 70
query33 685 414 306 306
query34 841 893 531 531
query35 788 834 744 744
query36 895 905 837 837
query37 119 92 75 75
query38 3883 3817 3736 3736
query39 767 753 712 712
query39_1 701 702 692 692
query40 233 127 120 120
query41 72 63 61 61
query42 131 102 96 96
query43 455 420 393 393
query44 1314 772 753 753
query45 207 195 178 178
query46 908 980 606 606
query47 1690 1721 1666 1666
query48 415 336 241 241
query49 759 440 357 357
query50 693 303 230 230
query51 3907 3885 3975 3885
query52 116 95 89 89
query53 238 232 185 185
query54 322 257 238 238
query55 96 80 77 77
query56 328 302 297 297
query57 1168 1142 1099 1099
query58 287 258 260 258
query59 2253 2573 2363 2363
query60 355 323 304 304
query61 162 156 152 152
query62 771 672 637 637
query63 239 180 177 177
query64 4637 1173 903 903
query65 4051 3978 3964 3964
query66 1139 442 346 346
query67 15239 14947 14819 14819
query68 8465 962 658 658
query69 555 297 264 264
query70 1110 1011 999 999
query71 505 297 265 265
query72 5927 4990 4868 4868
query73 680 554 295 295
query74 8641 8879 8595 8595
query75 3475 3078 2492 2492
query76 3527 1151 736 736
query77 812 417 301 301
query78 9477 9565 8906 8906
query79 1674 873 583 583
query80 657 557 489 489
query81 506 277 237 237
query82 449 132 109 109
query83 280 275 257 257
query84 267 117 102 102
query85 897 504 442 442
query86 336 309 293 293
query87 4088 4082 3912 3912
query88 3825 2143 2160 2143
query89 391 319 283 283
query90 2009 163 156 156
query91 179 166 151 151
query92 88 70 62 62
query93 1234 1057 681 681
query94 780 308 294 294
query95 561 330 339 330
query96 548 502 212 212
query97 2599 2684 2580 2580
query98 240 203 201 201
query99 1404 1316 1219 1219
Total cold run time: 274251 ms
Total hot run time: 179866 ms
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](distribute) fix forward insert statement core when use local shuffle union [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #58726:
URL: https://github.com/apache/doris/pull/58726#issuecomment-3611817923
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](distribute) fix forward insert statement cause backend core when use local shuffle union [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58726:
URL: https://github.com/apache/doris/pull/58726#issuecomment-3615214732
<details>
<summary>ClickBench: <b>Total hot run time: 27.22 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 4911eec93bb51609e1741b2ad5950cbf91256dfa, data reload: false
query1 0.06 0.05 0.05
query2 0.11 0.05 0.05
query3 0.25 0.09 0.09
query4 1.61 0.11 0.11
query5 0.26 0.25 0.24
query6 1.17 0.66 0.64
query7 0.03 0.03 0.03
query8 0.06 0.04 0.05
query9 0.56 0.51 0.50
query10 0.56 0.55 0.56
query11 0.15 0.11 0.12
query12 0.14 0.11 0.12
query13 0.62 0.60 0.61
query14 0.98 0.98 1.00
query15 0.81 0.80 0.81
query16 0.40 0.39 0.39
query17 1.02 1.07 1.04
query18 0.24 0.25 0.22
query19 1.90 1.86 1.89
query20 0.02 0.01 0.01
query21 15.47 0.28 0.13
query22 4.69 0.05 0.05
query23 15.99 0.28 0.11
query24 1.10 0.46 0.18
query25 0.08 0.05 0.05
query26 0.15 0.14 0.14
query27 0.06 0.06 0.05
query28 3.07 1.24 1.04
query29 12.58 3.98 3.15
query30 0.28 0.14 0.13
query31 2.83 0.63 0.39
query32 3.25 0.55 0.46
query33 3.05 3.11 3.01
query34 16.85 5.17 4.53
query35 4.50 4.56 4.55
query36 0.64 0.49 0.49
query37 0.10 0.07 0.06
query38 0.08 0.04 0.04
query39 0.04 0.03 0.03
query40 0.17 0.14 0.13
query41 0.09 0.03 0.03
query42 0.04 0.03 0.02
query43 0.04 0.04 0.03
Total cold run time: 96.1 s
Total hot run time: 27.22 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](distribute) fix forward insert statement cause backend core when use local shuffle union [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 commented on PR #58726:
URL: https://github.com/apache/doris/pull/58726#issuecomment-3615161832
run buildall
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](distribute) fix forward insert statement cause backend core when use local shuffle union [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #58726:
URL: https://github.com/apache/doris/pull/58726#issuecomment-3615604708
PR approved by at least one committer and no changes requested.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](distribute) fix forward insert statement cause backend core when use local shuffle union [doris]
Posted by "924060929 (via GitHub)" <gi...@apache.org>.
924060929 merged PR #58726:
URL: https://github.com/apache/doris/pull/58726
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org