You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "seawinde (via GitHub)" <gi...@apache.org> on 2025/11/17 02:49:02 UTC
[PR] [draft](mtmv) Materialized view pre rewrite support Identify expression opt rule [doris]
seawinde opened a new pull request, #58069:
URL: https://github.com/apache/doris/pull/58069
### What problem does this PR solve?
Materialized view pre rewrite support Identify expression opt rule
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] [draft](mtmv) Materialized view pre rewrite support Identify expression opt rule [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #58069:
URL: https://github.com/apache/doris/pull/58069#issuecomment-4468653551
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] [draft](mtmv) Materialized view pre rewrite support Identify expression opt rule [doris]
Posted by "seawinde (via GitHub)" <gi...@apache.org>.
seawinde closed pull request #58069: [draft](mtmv) Materialized view pre rewrite support Identify expression opt rule
URL: https://github.com/apache/doris/pull/58069
--
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] [draft](mtmv) Materialized view pre rewrite support Identify expression opt rule [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58069:
URL: https://github.com/apache/doris/pull/58069#issuecomment-3539881243
<details>
<summary>TPC-DS: <b>Total hot run time: 189094 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 c4da39340cf3e1ae8e5e44a98817bb903b5d7c2d, data reload: false
query1 1017 433 382 382
query2 6566 1699 1726 1699
query3 6749 234 226 226
query4 26572 23621 22909 22909
query5 4841 667 511 511
query6 359 244 231 231
query7 4652 517 311 311
query8 298 250 243 243
query9 8706 2970 2955 2955
query10 517 373 319 319
query11 16027 14995 14830 14830
query12 184 127 124 124
query13 1694 594 462 462
query14 11145 9287 9193 9193
query15 214 183 169 169
query16 7694 636 512 512
query17 1389 794 655 655
query18 2055 447 348 348
query19 223 211 190 190
query20 139 131 126 126
query21 219 133 118 118
query22 4145 4307 4153 4153
query23 34082 33272 33010 33010
query24 8157 2447 2399 2399
query25 651 567 500 500
query26 1251 278 179 179
query27 2704 505 374 374
query28 4417 2315 2289 2289
query29 829 663 538 538
query30 321 234 239 234
query31 914 811 726 726
query32 99 89 81 81
query33 591 420 371 371
query34 810 833 532 532
query35 839 847 760 760
query36 970 995 914 914
query37 137 112 98 98
query38 3498 3504 3482 3482
query39 1466 1446 1405 1405
query40 244 141 128 128
query41 65 61 72 61
query42 132 116 115 115
query43 469 498 482 482
query44 1270 814 802 802
query45 187 179 176 176
query46 896 1004 641 641
query47 1809 1837 1773 1773
query48 396 431 324 324
query49 766 506 418 418
query50 654 687 417 417
query51 3913 3960 4226 3960
query52 116 111 113 111
query53 245 277 205 205
query54 334 314 295 295
query55 96 95 93 93
query56 359 354 348 348
query57 1216 1211 1130 1130
query58 310 291 284 284
query59 2533 2631 2620 2620
query60 365 368 341 341
query61 168 155 180 155
query62 836 713 675 675
query63 235 203 199 199
query64 4531 1171 889 889
query65 4034 3960 3935 3935
query66 1095 441 359 359
query67 15641 15122 15004 15004
query68 8504 961 640 640
query69 495 340 311 311
query70 1308 1271 1266 1266
query71 524 354 323 323
query72 5781 4939 4910 4910
query73 657 572 372 372
query74 8918 9103 8731 8731
query75 3986 3258 2798 2798
query76 3667 1152 741 741
query77 810 413 337 337
query78 9697 9582 8890 8890
query79 2435 855 657 657
query80 662 587 526 526
query81 510 264 232 232
query82 493 167 142 142
query83 274 263 252 252
query84 269 110 90 90
query85 935 487 446 446
query86 399 324 294 294
query87 3598 3653 3632 3632
query88 3766 2287 2278 2278
query89 402 345 289 289
query90 2005 235 227 227
query91 170 166 139 139
query92 92 79 72 72
query93 1933 1015 693 693
query94 700 426 326 326
query95 407 343 337 337
query96 491 577 283 283
query97 2920 2973 2869 2869
query98 257 220 214 214
query99 1361 1372 1279 1279
Total cold run time: 278482 ms
Total hot run time: 189094 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] [draft](mtmv) Materialized view pre rewrite support Identify expression opt rule [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58069:
URL: https://github.com/apache/doris/pull/58069#issuecomment-3539742694
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] [draft](mtmv) Materialized view pre rewrite support Identify expression opt rule [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58069:
URL: https://github.com/apache/doris/pull/58069#issuecomment-3539927406
# FE UT Coverage Report
Increment line coverage ` 100.00% (34/34)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58069_c4da39340cf3e1ae8e5e44a98817bb903b5d7c2d/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58069_c4da39340cf3e1ae8e5e44a98817bb903b5d7c2d/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] [draft](mtmv) Materialized view pre rewrite support Identify expression opt rule [doris]
Posted by "seawinde (via GitHub)" <gi...@apache.org>.
seawinde commented on PR #58069:
URL: https://github.com/apache/doris/pull/58069#issuecomment-3539742804
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] [draft](mtmv) Materialized view pre rewrite support Identify expression opt rule [doris]
Posted by "seawinde (via GitHub)" <gi...@apache.org>.
seawinde commented on PR #58069:
URL: https://github.com/apache/doris/pull/58069#issuecomment-4516260392
not need
--
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] [draft](mtmv) Materialized view pre rewrite support Identify expression opt rule [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #58069:
URL: https://github.com/apache/doris/pull/58069#issuecomment-3540257994
# FE Regression Coverage Report
Increment line coverage ` 100.00% (34/34)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/58069_c4da39340cf3e1ae8e5e44a98817bb903b5d7c2d_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/58069_c4da39340cf3e1ae8e5e44a98817bb903b5d7c2d_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] [draft](mtmv) Materialized view pre rewrite support Identify expression opt rule [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58069:
URL: https://github.com/apache/doris/pull/58069#issuecomment-3539889545
<details>
<summary>ClickBench: <b>Total hot run time: 27.43 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 c4da39340cf3e1ae8e5e44a98817bb903b5d7c2d, data reload: false
query1 0.05 0.05 0.05
query2 0.10 0.05 0.04
query3 0.25 0.08 0.08
query4 1.60 0.11 0.11
query5 0.26 0.24 0.25
query6 1.19 0.65 0.64
query7 0.03 0.02 0.02
query8 0.06 0.05 0.04
query9 0.58 0.52 0.52
query10 0.59 0.56 0.57
query11 0.17 0.11 0.11
query12 0.16 0.12 0.13
query13 0.62 0.60 0.60
query14 1.01 1.00 1.00
query15 0.84 0.83 0.83
query16 0.39 0.38 0.38
query17 1.04 1.03 1.04
query18 0.22 0.21 0.21
query19 1.89 1.84 1.85
query20 0.02 0.01 0.02
query21 15.45 0.19 0.14
query22 5.16 0.08 0.04
query23 15.65 0.26 0.10
query24 2.55 1.01 0.29
query25 0.08 0.06 0.07
query26 0.14 0.14 0.12
query27 0.05 0.05 0.06
query28 4.25 1.16 0.95
query29 12.58 3.98 3.29
query30 0.28 0.13 0.12
query31 2.81 0.60 0.38
query32 3.23 0.55 0.46
query33 3.01 3.07 3.08
query34 15.68 5.22 4.55
query35 4.57 4.54 4.55
query36 0.67 0.50 0.50
query37 0.09 0.07 0.07
query38 0.06 0.04 0.03
query39 0.04 0.03 0.03
query40 0.17 0.14 0.13
query41 0.08 0.03 0.02
query42 0.04 0.03 0.03
query43 0.04 0.04 0.03
Total cold run time: 97.75 s
Total hot run time: 27.43 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] [draft](mtmv) Materialized view pre rewrite support Identify expression opt rule [doris]
Posted by "seawinde (via GitHub)" <gi...@apache.org>.
seawinde commented on PR #58069:
URL: https://github.com/apache/doris/pull/58069#issuecomment-3539823509
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] [draft](mtmv) Materialized view pre rewrite support Identify expression opt rule [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #58069:
URL: https://github.com/apache/doris/pull/58069#issuecomment-3539859825
<details>
<summary>TPC-H: <b>Total hot run time: 34260 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 c4da39340cf3e1ae8e5e44a98817bb903b5d7c2d, data reload: false
------ Round 1 ----------------------------------
q1 17631 5188 4995 4995
q2 2025 315 212 212
q3 10232 1293 732 732
q4 10229 954 379 379
q5 7528 2487 2328 2328
q6 187 169 139 139
q7 1058 768 631 631
q8 9363 1401 1117 1117
q9 6929 5256 5139 5139
q10 6872 2222 1806 1806
q11 493 296 277 277
q12 344 364 238 238
q13 17800 3610 3024 3024
q14 230 238 217 217
q15 567 511 511 511
q16 1023 987 961 961
q17 591 843 383 383
q18 7528 7127 7193 7127
q19 1652 951 544 544
q20 348 350 225 225
q21 3692 2565 2267 2267
q22 1055 1012 1008 1008
Total cold run time: 107377 ms
Total hot run time: 34260 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5206 5081 5116 5081
q2 251 321 224 224
q3 2183 2685 2309 2309
q4 1391 1795 1353 1353
q5 4196 4116 4094 4094
q6 203 165 125 125
q7 1873 1799 1674 1674
q8 2503 2412 2388 2388
q9 6826 6823 6857 6823
q10 2889 3125 2661 2661
q11 571 514 498 498
q12 636 732 592 592
q13 3240 3647 3008 3008
q14 283 292 264 264
q15 530 497 518 497
q16 1027 1058 1005 1005
q17 1089 1419 1300 1300
q18 7306 7052 7125 7052
q19 771 750 780 750
q20 1915 1965 1806 1806
q21 4749 4359 4266 4266
q22 1094 1032 1009 1009
Total cold run time: 50732 ms
Total hot run time: 48779 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