You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "englefly (via GitHub)" <gi...@apache.org> on 2025/11/03 01:44:32 UTC
[PR] push down one-row-join through set operation [doris]
englefly opened a new pull request, #57605:
URL: https://github.com/apache/doris/pull/57605
### What problem does this PR solve?
Issue Number: close #xxx
Related PR: #xxx
Problem Summary:
### Release note
None
### 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.
- [ ] Other reason <!-- Add your reason? -->
- Behavior changed:
- [ ] No.
- [ ] Yes. <!-- Explain the behavior change -->
- Does this need documentation?
- [ ] 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] [opt](nereids)push down one-row-join through set operation [doris]
Posted by "englefly (via GitHub)" <gi...@apache.org>.
englefly commented on PR #57605:
URL: https://github.com/apache/doris/pull/57605#issuecomment-3501421975
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] push down one-row-join through set operation [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57605:
URL: https://github.com/apache/doris/pull/57605#issuecomment-3481212136
# FE Regression Coverage Report
Increment line coverage ` 21.64% (29/134)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/57605_b7b8bf7caf568645bc9921a71cbd0df83c5c1833_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/57605_b7b8bf7caf568645bc9921a71cbd0df83c5c1833_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] [opt](nereids)push down one-row-join through set operation [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] closed pull request #57605: [opt](nereids)push down one-row-join through set operation
URL: https://github.com/apache/doris/pull/57605
--
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] push down one-row-join through set operation [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57605:
URL: https://github.com/apache/doris/pull/57605#issuecomment-3484244246
# FE Regression Coverage Report
Increment line coverage ` 21.64% (29/134)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/57605_b7b8bf7caf568645bc9921a71cbd0df83c5c1833_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/57605_b7b8bf7caf568645bc9921a71cbd0df83c5c1833_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] [opt](nereids)push down one-row-join through set operation [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57605:
URL: https://github.com/apache/doris/pull/57605#issuecomment-3502075688
# FE Regression Coverage Report
Increment line coverage ` 85.07% (114/134)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/57605_4d179f665d3483f015a40298e2245b7e13ed9867_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/57605_4d179f665d3483f015a40298e2245b7e13ed9867_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] push down one-row-join through set operation [doris]
Posted by "englefly (via GitHub)" <gi...@apache.org>.
englefly commented on PR #57605:
URL: https://github.com/apache/doris/pull/57605#issuecomment-3483603199
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] [opt](nereids)push down one-row-join through set operation [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57605:
URL: https://github.com/apache/doris/pull/57605#issuecomment-3501562575
<details>
<summary>ClickBench: <b>Total hot run time: 27.77 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 4d179f665d3483f015a40298e2245b7e13ed9867, data reload: false
query1 0.06 0.04 0.05
query2 0.10 0.05 0.05
query3 0.25 0.08 0.09
query4 1.60 0.12 0.11
query5 0.27 0.25 0.26
query6 1.19 0.65 0.64
query7 0.04 0.03 0.03
query8 0.05 0.04 0.04
query9 0.60 0.51 0.52
query10 0.58 0.57 0.58
query11 0.16 0.11 0.12
query12 0.15 0.12 0.12
query13 0.61 0.61 0.60
query14 1.02 1.00 1.01
query15 0.85 0.83 0.83
query16 0.39 0.40 0.38
query17 1.01 1.02 1.03
query18 0.21 0.20 0.19
query19 1.94 1.82 1.73
query20 0.02 0.02 0.01
query21 15.43 0.18 0.12
query22 5.17 0.07 0.05
query23 15.66 0.26 0.11
query24 2.19 1.68 0.85
query25 0.11 0.07 0.06
query26 0.14 0.14 0.14
query27 0.07 0.06 0.06
query28 5.61 1.14 0.93
query29 12.58 3.91 3.24
query30 0.27 0.13 0.12
query31 2.81 0.59 0.37
query32 3.23 0.54 0.47
query33 2.99 3.05 3.05
query34 15.86 5.14 4.51
query35 4.61 4.55 4.59
query36 0.67 0.51 0.49
query37 0.10 0.06 0.07
query38 0.07 0.05 0.04
query39 0.04 0.03 0.03
query40 0.18 0.14 0.13
query41 0.08 0.03 0.02
query42 0.04 0.03 0.03
query43 0.05 0.03 0.04
Total cold run time: 99.06 s
Total hot run time: 27.77 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] [opt](nereids)push down one-row-join through set operation [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57605:
URL: https://github.com/apache/doris/pull/57605#issuecomment-3502037161
# FE Regression Coverage Report
Increment line coverage ` 85.07% (114/134)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/57605_4d179f665d3483f015a40298e2245b7e13ed9867_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/57605_4d179f665d3483f015a40298e2245b7e13ed9867_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] [opt](nereids)push down one-row-join through set operation [doris]
Posted by "englefly (via GitHub)" <gi...@apache.org>.
englefly commented on PR #57605:
URL: https://github.com/apache/doris/pull/57605#issuecomment-3530666274
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] push down one-row-join through set operation [doris]
Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #57605:
URL: https://github.com/apache/doris/pull/57605#issuecomment-3478660893
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] [opt](nereids)push down one-row-join through set operation [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57605:
URL: https://github.com/apache/doris/pull/57605#issuecomment-3501500132
<details>
<summary>TPC-H: <b>Total hot run time: 34333 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 4d179f665d3483f015a40298e2245b7e13ed9867, data reload: false
------ Round 1 ----------------------------------
q1 17650 5205 5057 5057
q2 2037 322 207 207
q3 10269 1321 719 719
q4 10217 904 384 384
q5 7498 2421 2300 2300
q6 179 170 136 136
q7 922 763 618 618
q8 9367 1349 1122 1122
q9 6922 5187 5155 5155
q10 6821 2213 1807 1807
q11 497 313 279 279
q12 338 374 224 224
q13 17797 3664 3056 3056
q14 226 229 218 218
q15 569 509 524 509
q16 1035 994 953 953
q17 578 878 359 359
q18 7835 7188 7177 7177
q19 1238 976 547 547
q20 362 347 237 237
q21 4088 3185 2286 2286
q22 1079 1049 983 983
Total cold run time: 107524 ms
Total hot run time: 34333 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5074 5071 5091 5071
q2 255 329 247 247
q3 2175 2664 2329 2329
q4 1353 1790 1342 1342
q5 4218 4567 4603 4567
q6 208 170 127 127
q7 2018 1973 1816 1816
q8 2590 2451 2609 2451
q9 7387 7540 7039 7039
q10 3075 3390 2840 2840
q11 617 546 506 506
q12 701 765 646 646
q13 3584 3901 3365 3365
q14 311 302 306 302
q15 544 506 505 505
q16 1077 1146 1113 1113
q17 1164 1602 1376 1376
q18 7804 7721 7621 7621
q19 809 768 819 768
q20 2060 2100 1906 1906
q21 4950 4658 4407 4407
q22 1097 1055 1017 1017
Total cold run time: 53071 ms
Total hot run time: 51361 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] [opt](nereids)push down one-row-join through set operation [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57605:
URL: https://github.com/apache/doris/pull/57605#issuecomment-3501542857
<details>
<summary>TPC-DS: <b>Total hot run time: 187588 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 4d179f665d3483f015a40298e2245b7e13ed9867, data reload: false
query1 1078 426 390 390
query2 6570 1820 1703 1703
query3 6756 236 230 230
query4 26402 23662 22921 22921
query5 4368 619 475 475
query6 354 243 220 220
query7 4658 496 304 304
query8 303 261 244 244
query9 8725 2591 2587 2587
query10 507 336 302 302
query11 15944 15147 14866 14866
query12 174 122 114 114
query13 1673 552 445 445
query14 10520 9249 9325 9249
query15 200 193 173 173
query16 7205 666 519 519
query17 1240 755 607 607
query18 1985 442 322 322
query19 213 200 173 173
query20 134 122 117 117
query21 213 133 116 116
query22 3984 3982 3920 3920
query23 33844 33002 33019 33002
query24 8466 2392 2395 2392
query25 614 538 451 451
query26 1240 268 156 156
query27 2772 502 349 349
query28 4377 2204 2190 2190
query29 847 621 471 471
query30 299 224 194 194
query31 908 789 729 729
query32 85 76 69 69
query33 595 381 314 314
query34 802 834 531 531
query35 800 840 745 745
query36 951 1003 903 903
query37 122 112 91 91
query38 3497 3546 3413 3413
query39 1477 1423 1424 1423
query40 222 131 117 117
query41 65 63 61 61
query42 127 111 114 111
query43 479 496 490 490
query44 1223 742 745 742
query45 189 181 182 181
query46 878 994 630 630
query47 1749 1768 1757 1757
query48 389 417 328 328
query49 779 496 416 416
query50 648 680 404 404
query51 3888 3901 3877 3877
query52 119 116 105 105
query53 244 276 208 208
query54 330 314 306 306
query55 86 96 90 90
query56 336 346 328 328
query57 1175 1212 1105 1105
query58 313 291 285 285
query59 2535 2655 2551 2551
query60 366 379 347 347
query61 190 192 188 188
query62 814 729 672 672
query63 238 205 201 201
query64 4714 1292 973 973
query65 3978 3954 3926 3926
query66 1211 461 358 358
query67 15441 15138 14877 14877
query68 8289 864 600 600
query69 521 330 297 297
query70 1398 1319 1198 1198
query71 432 349 325 325
query72 6085 5004 4885 4885
query73 653 577 356 356
query74 9071 9106 8905 8905
query75 3290 3334 2844 2844
query76 3307 1196 759 759
query77 516 397 320 320
query78 9612 9762 8935 8935
query79 2710 789 591 591
query80 695 583 523 523
query81 509 270 236 236
query82 485 155 129 129
query83 283 271 259 259
query84 260 121 107 107
query85 945 483 439 439
query86 379 296 283 283
query87 3727 3705 3604 3604
query88 3804 2275 2253 2253
query89 393 334 290 290
query90 1892 231 238 231
query91 177 164 135 135
query92 91 71 61 61
query93 2460 979 639 639
query94 724 445 330 330
query95 402 324 328 324
query96 483 573 278 278
query97 2928 2958 2895 2895
query98 248 212 204 204
query99 1366 1433 1299 1299
Total cold run time: 275763 ms
Total hot run time: 187588 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] push down one-row-join through set operation [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57605:
URL: https://github.com/apache/doris/pull/57605#issuecomment-3480538589
# FE UT Coverage Report
Increment line coverage ` 85.07% (114/134)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/57605_b7b8bf7caf568645bc9921a71cbd0df83c5c1833/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/57605_b7b8bf7caf568645bc9921a71cbd0df83c5c1833/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] push down one-row-join through set operation [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57605:
URL: https://github.com/apache/doris/pull/57605#issuecomment-3483862897
<details>
<summary>ClickBench: <b>Total hot run time: 27.79 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 b7b8bf7caf568645bc9921a71cbd0df83c5c1833, data reload: false
query1 0.05 0.05 0.05
query2 0.09 0.05 0.04
query3 0.25 0.08 0.08
query4 1.61 0.12 0.12
query5 0.28 0.25 0.26
query6 1.21 0.69 0.67
query7 0.04 0.03 0.02
query8 0.06 0.04 0.04
query9 0.61 0.52 0.52
query10 0.59 0.58 0.57
query11 0.16 0.12 0.11
query12 0.15 0.12 0.12
query13 0.63 0.60 0.61
query14 1.03 1.02 1.03
query15 0.87 0.85 0.86
query16 0.40 0.39 0.40
query17 0.99 1.04 1.03
query18 0.22 0.20 0.20
query19 1.93 1.84 1.82
query20 0.01 0.02 0.02
query21 15.44 0.20 0.14
query22 5.15 0.06 0.05
query23 15.72 0.27 0.10
query24 2.84 0.65 0.39
query25 0.09 0.06 0.05
query26 0.14 0.13 0.13
query27 0.07 0.07 0.05
query28 4.39 1.19 0.94
query29 12.60 3.88 3.24
query30 0.27 0.15 0.12
query31 2.82 0.61 0.39
query32 3.23 0.59 0.48
query33 3.14 3.06 3.07
query34 15.86 5.31 4.63
query35 4.64 4.62 4.60
query36 0.67 0.51 0.51
query37 0.09 0.07 0.07
query38 0.06 0.04 0.04
query39 0.04 0.03 0.03
query40 0.17 0.15 0.15
query41 0.08 0.04 0.03
query42 0.04 0.03 0.03
query43 0.04 0.04 0.04
Total cold run time: 98.77 s
Total hot run time: 27.79 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] push down one-row-join through set operation [doris]
Posted by "englefly (via GitHub)" <gi...@apache.org>.
englefly commented on PR #57605:
URL: https://github.com/apache/doris/pull/57605#issuecomment-3478660962
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] push down one-row-join through set operation [doris]
Posted by "englefly (via GitHub)" <gi...@apache.org>.
englefly commented on PR #57605:
URL: https://github.com/apache/doris/pull/57605#issuecomment-3480203831
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] push down one-row-join through set operation [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57605:
URL: https://github.com/apache/doris/pull/57605#issuecomment-3480364291
<details>
<summary>ClickBench: <b>Total hot run time: 28.06 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 b7b8bf7caf568645bc9921a71cbd0df83c5c1833, data reload: false
query1 0.06 0.05 0.04
query2 0.10 0.05 0.05
query3 0.26 0.09 0.08
query4 1.61 0.12 0.11
query5 0.28 0.27 0.25
query6 1.18 0.64 0.65
query7 0.03 0.03 0.03
query8 0.06 0.04 0.05
query9 0.63 0.54 0.54
query10 0.60 0.59 0.60
query11 0.17 0.11 0.12
query12 0.17 0.13 0.13
query13 0.63 0.61 0.61
query14 1.02 1.00 1.01
query15 0.86 0.85 0.86
query16 0.42 0.41 0.41
query17 1.07 1.06 1.04
query18 0.25 0.21 0.21
query19 1.98 1.84 1.91
query20 0.02 0.02 0.01
query21 15.41 0.21 0.14
query22 5.11 0.08 0.05
query23 15.66 0.27 0.11
query24 2.70 0.62 0.75
query25 0.08 0.07 0.06
query26 0.14 0.14 0.15
query27 0.08 0.06 0.05
query28 4.51 1.15 0.93
query29 12.56 4.01 3.34
query30 0.27 0.13 0.12
query31 2.82 0.60 0.39
query32 3.24 0.57 0.48
query33 3.09 3.23 3.07
query34 15.98 5.19 4.57
query35 4.59 4.55 4.63
query36 0.70 0.50 0.50
query37 0.11 0.07 0.06
query38 0.07 0.05 0.04
query39 0.04 0.03 0.03
query40 0.18 0.16 0.13
query41 0.08 0.04 0.03
query42 0.04 0.03 0.03
query43 0.05 0.05 0.04
Total cold run time: 98.91 s
Total hot run time: 28.06 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] push down one-row-join through set operation [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57605:
URL: https://github.com/apache/doris/pull/57605#issuecomment-3483844216
<details>
<summary>TPC-DS: <b>Total hot run time: 189395 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 b7b8bf7caf568645bc9921a71cbd0df83c5c1833, data reload: false
query1 1069 397 391 391
query2 6582 1691 1695 1691
query3 6753 226 224 224
query4 26567 23382 23245 23245
query5 4416 623 463 463
query6 330 255 243 243
query7 4655 511 301 301
query8 322 285 253 253
query9 8746 2572 2556 2556
query10 482 346 295 295
query11 15356 15037 15623 15037
query12 199 126 116 116
query13 1858 594 461 461
query14 12514 9536 9673 9536
query15 247 198 201 198
query16 8058 729 579 579
query17 1935 811 686 686
query18 2086 452 376 376
query19 250 219 184 184
query20 133 136 128 128
query21 216 140 120 120
query22 4502 4616 4460 4460
query23 35005 34161 33893 33893
query24 8435 2429 2413 2413
query25 543 518 440 440
query26 1225 267 155 155
query27 2708 482 352 352
query28 4238 2171 2199 2171
query29 781 598 482 482
query30 297 225 199 199
query31 916 853 751 751
query32 78 69 65 65
query33 586 377 317 317
query34 783 852 511 511
query35 793 827 737 737
query36 929 1009 897 897
query37 122 106 85 85
query38 3546 3580 3470 3470
query39 1485 1422 1406 1406
query40 212 123 115 115
query41 60 58 58 58
query42 119 110 105 105
query43 482 497 460 460
query44 1217 742 718 718
query45 184 180 170 170
query46 891 978 632 632
query47 1772 1791 1711 1711
query48 401 417 318 318
query49 769 521 413 413
query50 646 676 411 411
query51 3942 3859 3891 3859
query52 109 110 101 101
query53 235 266 195 195
query54 292 288 270 270
query55 84 84 80 80
query56 322 329 301 301
query57 1174 1190 1107 1107
query58 280 272 275 272
query59 2568 2647 2493 2493
query60 345 344 329 329
query61 168 149 162 149
query62 793 741 654 654
query63 229 190 195 190
query64 4464 1170 853 853
query65 4019 3939 3944 3939
query66 1088 433 346 346
query67 15190 15075 14979 14979
query68 8612 881 592 592
query69 478 316 294 294
query70 1341 1309 1230 1230
query71 475 363 306 306
query72 5926 4968 4852 4852
query73 543 565 356 356
query74 9164 9101 8884 8884
query75 4208 3445 2865 2865
query76 3333 1166 722 722
query77 927 388 306 306
query78 9551 9768 8908 8908
query79 1804 811 582 582
query80 623 549 491 491
query81 506 256 223 223
query82 474 156 136 136
query83 272 264 252 252
query84 250 110 100 100
query85 904 491 443 443
query86 343 329 291 291
query87 3665 3640 3599 3599
query88 3558 2250 2218 2218
query89 377 331 291 291
query90 1962 218 215 215
query91 175 168 135 135
query92 77 67 63 63
query93 1521 989 637 637
query94 706 404 311 311
query95 395 322 315 315
query96 475 571 283 283
query97 2965 2967 2883 2883
query98 235 205 207 205
query99 1372 1453 1292 1292
Total cold run time: 279018 ms
Total hot run time: 189395 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] [opt](nereids)push down one-row-join through set operation [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #57605:
URL: https://github.com/apache/doris/pull/57605#issuecomment-4446313663
We're closing this PR because it hasn't been updated in a while.
This isn't a judgement on the merit of the PR in any way. It's just a way of keeping the PR queue manageable.
If you'd like to revive this PR, please reopen it and feel free a maintainer to remove the Stale tag!
--
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] [opt](nereids)push down one-row-join through set operation [doris]
Posted by "englefly (via GitHub)" <gi...@apache.org>.
englefly commented on PR #57605:
URL: https://github.com/apache/doris/pull/57605#issuecomment-3494697500
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] push down one-row-join through set operation [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57605:
URL: https://github.com/apache/doris/pull/57605#issuecomment-3484213693
# FE Regression Coverage Report
Increment line coverage ` 21.64% (29/134)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/57605_b7b8bf7caf568645bc9921a71cbd0df83c5c1833_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/57605_b7b8bf7caf568645bc9921a71cbd0df83c5c1833_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] [opt](nereids)push down one-row-join through set operation [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57605:
URL: https://github.com/apache/doris/pull/57605#issuecomment-3495014570
# FE UT Coverage Report
Increment line coverage ` 85.07% (114/134)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/57605_4d179f665d3483f015a40298e2245b7e13ed9867/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/57605_4d179f665d3483f015a40298e2245b7e13ed9867/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] [opt](nereids)push down one-row-join through set operation [doris]
Posted by "englefly (via GitHub)" <gi...@apache.org>.
englefly commented on PR #57605:
URL: https://github.com/apache/doris/pull/57605#issuecomment-3530638255
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