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 2026/02/12 09:06:49 UTC
[PR] [opt](nereids)Unnest subquery cte 0212 [doris]
englefly opened a new pull request, #60717:
URL: https://github.com/apache/doris/pull/60717
### 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)Unnest subquery cte 0212 [doris]
Posted by "englefly (via GitHub)" <gi...@apache.org>.
englefly commented on PR #60717:
URL: https://github.com/apache/doris/pull/60717#issuecomment-3889642269
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)Unnest subquery cte 0212 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60717:
URL: https://github.com/apache/doris/pull/60717#issuecomment-3890234785
<details>
<summary>TPC-DS: <b>Total hot run time: 189435 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 87ea2a6458da7e19c55178f37bed4bf7c672b55a, data reload: false
query5 4425 606 497 497
query6 327 215 206 206
query7 4219 474 274 274
query8 336 245 230 230
query9 8753 2777 2796 2777
query10 486 391 344 344
query11 17285 17061 16864 16864
query12 178 122 129 122
query13 1265 470 360 360
query14 6259 3241 2998 2998
query14_1 2865 2833 2829 2829
query15 201 194 181 181
query16 970 490 469 469
query17 1084 693 589 589
query18 2489 450 341 341
query19 210 206 186 186
query20 140 126 131 126
query21 254 149 121 121
query22 4885 5180 4956 4956
query23 17386 16919 16864 16864
query23_1 16775 16668 16797 16668
query24 7104 1598 1245 1245
query24_1 1239 1196 1242 1196
query25 534 426 398 398
query26 1238 267 153 153
query27 2773 467 302 302
query28 4518 1878 1870 1870
query29 787 529 447 447
query30 315 261 209 209
query31 898 762 636 636
query32 86 78 71 71
query33 522 355 290 290
query34 935 917 567 567
query35 631 676 602 602
query36 1117 1125 1000 1000
query37 135 102 82 82
query38 2977 2941 2910 2910
query39 886 886 819 819
query39_1 799 817 811 811
query40 223 135 120 120
query41 65 68 64 64
query42 106 102 106 102
query43 379 376 349 349
query44 1311 727 727 727
query45 198 191 185 185
query46 879 990 613 613
query47 2121 2145 2092 2092
query48 308 316 233 233
query49 605 419 342 342
query50 676 282 212 212
query51 4135 4117 4102 4102
query52 109 111 95 95
query53 295 327 280 280
query54 291 269 261 261
query55 89 87 81 81
query56 302 317 308 308
query57 1398 1314 1275 1275
query58 298 285 284 284
query59 2557 2723 2555 2555
query60 346 347 343 343
query61 182 172 168 168
query62 629 564 554 554
query63 314 280 277 277
query64 4946 1235 922 922
query65 4636 4531 4542 4531
query66 1444 455 359 359
query67 16595 16663 16387 16387
query68 2411 1069 700 700
query69 405 306 288 288
query70 1018 999 958 958
query71 332 313 298 298
query72 2871 2527 2500 2500
query73 516 546 313 313
query74 9614 9581 9428 9428
query75 2794 2785 2441 2441
query76 2298 1061 656 656
query77 381 378 294 294
query78 10876 11011 10379 10379
query79 1100 866 603 603
query80 639 547 501 501
query81 486 284 260 260
query82 1308 150 112 112
query83 360 263 236 236
query84 255 128 102 102
query85 844 467 431 431
query86 380 303 334 303
query87 3114 3112 3057 3057
query88 3555 2691 2665 2665
query89 429 376 359 359
query90 1918 176 169 169
query91 164 155 136 136
query92 78 77 65 65
query93 886 870 481 481
query94 451 319 293 293
query95 578 398 308 308
query96 653 521 226 226
query97 2507 2469 2425 2425
query98 226 218 219 218
query99 1008 971 903 903
Total cold run time: 260303 ms
Total hot run time: 189435 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)Unnest subquery cte 0212 [doris]
Posted by "englefly (via GitHub)" <gi...@apache.org>.
englefly commented on PR #60717:
URL: https://github.com/apache/doris/pull/60717#issuecomment-3891434411
run external
--
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)Unnest subquery cte 0212 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60717:
URL: https://github.com/apache/doris/pull/60717#issuecomment-3890267971
<details>
<summary>ClickBench: <b>Total hot run time: 28.21 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 87ea2a6458da7e19c55178f37bed4bf7c672b55a, data reload: false
query1 0.05 0.05 0.05
query2 0.09 0.05 0.04
query3 0.26 0.09 0.08
query4 1.60 0.11 0.10
query5 0.27 0.24 0.24
query6 1.16 0.68 0.67
query7 0.03 0.03 0.03
query8 0.05 0.04 0.04
query9 0.58 0.49 0.49
query10 0.56 0.54 0.54
query11 0.15 0.10 0.10
query12 0.14 0.10 0.11
query13 0.63 0.60 0.62
query14 1.08 1.07 1.06
query15 0.88 0.87 0.88
query16 0.40 0.39 0.37
query17 1.17 1.07 1.08
query18 0.23 0.22 0.22
query19 2.10 2.01 2.01
query20 0.02 0.02 0.01
query21 15.41 0.27 0.15
query22 5.11 0.06 0.05
query23 15.87 0.30 0.10
query24 0.98 0.26 0.18
query25 0.07 0.07 0.06
query26 0.15 0.14 0.14
query27 0.09 0.05 0.08
query28 3.14 1.17 0.97
query29 12.56 3.97 3.23
query30 0.28 0.14 0.11
query31 2.82 0.64 0.40
query32 3.24 0.60 0.49
query33 3.22 3.24 3.24
query34 16.19 5.42 4.70
query35 4.77 4.78 4.77
query36 0.65 0.49 0.50
query37 0.11 0.08 0.07
query38 0.08 0.05 0.04
query39 0.05 0.03 0.03
query40 0.19 0.17 0.16
query41 0.09 0.04 0.03
query42 0.04 0.03 0.03
query43 0.04 0.04 0.03
Total cold run time: 96.6 s
Total hot run time: 28.21 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)Unnest subquery cte 0212 [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60717:
URL: https://github.com/apache/doris/pull/60717#issuecomment-3892330103
# FE Regression Coverage Report
Increment line coverage ` 100.00% (61/61)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60717_87ea2a6458da7e19c55178f37bed4bf7c672b55a_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60717_87ea2a6458da7e19c55178f37bed4bf7c672b55a_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](cte) unnest subquery before RewriteCteChildren [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #60717:
URL: https://github.com/apache/doris/pull/60717#issuecomment-3894233366
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] [opt](nereids)Unnest subquery cte 0212 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #60717:
URL: https://github.com/apache/doris/pull/60717#issuecomment-3890167177
<details>
<summary>TPC-H: <b>Total hot run time: 30769 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 87ea2a6458da7e19c55178f37bed4bf7c672b55a, data reload: false
------ Round 1 ----------------------------------
q1 17614 4506 4265 4265
q2 2043 385 225 225
q3 10145 1329 786 786
q4 10200 785 312 312
q5 7522 2188 1999 1999
q6 199 186 151 151
q7 897 762 607 607
q8 9280 1450 1226 1226
q9 4993 4693 4655 4655
q10 6889 1965 1551 1551
q11 471 288 253 253
q12 410 382 228 228
q13 17832 4197 3252 3252
q14 239 241 227 227
q15 895 815 795 795
q16 685 683 623 623
q17 701 804 568 568
q18 6887 5737 6351 5737
q19 1185 1096 691 691
q20 560 539 421 421
q21 2873 1989 1942 1942
q22 356 299 255 255
Total cold run time: 102876 ms
Total hot run time: 30769 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4496 4521 4621 4521
q2 258 344 256 256
q3 2293 2954 2500 2500
q4 1508 1881 1440 1440
q5 4753 4721 4531 4531
q6 214 176 143 143
q7 2021 1933 1794 1794
q8 2538 2508 2397 2397
q9 7735 7455 7518 7455
q10 2861 2997 2543 2543
q11 518 446 452 446
q12 708 739 628 628
q13 4030 4436 3645 3645
q14 298 299 285 285
q15 869 806 800 800
q16 676 713 643 643
q17 1096 1260 1300 1260
q18 7532 7508 7385 7385
q19 897 833 860 833
q20 1969 2012 1857 1857
q21 4667 4257 4145 4145
q22 477 448 422 422
Total cold run time: 52414 ms
Total hot run time: 49929 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)Unnest subquery cte 0212 [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #60717:
URL: https://github.com/apache/doris/pull/60717#issuecomment-3891143924
# FE Regression Coverage Report
Increment line coverage ` 100.00% (61/61)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/60717_87ea2a6458da7e19c55178f37bed4bf7c672b55a_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/60717_87ea2a6458da7e19c55178f37bed4bf7c672b55a_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](cte) unnest subquery before RewriteCteChildren [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #60717:
URL: https://github.com/apache/doris/pull/60717#issuecomment-3894233227
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](cte) unnest subquery before RewriteCteChildren [doris]
Posted by "englefly (via GitHub)" <gi...@apache.org>.
englefly merged PR #60717:
URL: https://github.com/apache/doris/pull/60717
--
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)Unnest subquery cte 0212 [doris]
Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #60717:
URL: https://github.com/apache/doris/pull/60717#issuecomment-3889637786
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