You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "morrySnow (via GitHub)" <gi...@apache.org> on 2025/04/07 10:22:07 UTC
[PR] [refactor](Nereids) let nullable always correct [doris]
morrySnow opened a new pull request, #49845:
URL: https://github.com/apache/doris/pull/49845
### 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] [refactor](Nereids) let nullable always correct [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49845:
URL: https://github.com/apache/doris/pull/49845#issuecomment-2782972543
<details>
<summary>ClickBench: <b>Total hot run time: 31.62 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 2ebb3037c3aca64717975d1bd2dd149a2851f7fc, data reload: false
query1 0.04 0.04 0.03
query2 0.11 0.11 0.11
query3 0.26 0.19 0.19
query4 1.59 0.20 0.20
query5 0.59 0.57 0.57
query6 1.19 0.71 0.71
query7 0.02 0.02 0.02
query8 0.04 0.03 0.03
query9 0.58 0.51 0.52
query10 0.58 0.60 0.56
query11 0.15 0.10 0.10
query12 0.14 0.11 0.11
query13 0.61 0.60 0.60
query14 2.68 2.82 2.67
query15 0.94 0.87 0.84
query16 0.38 0.37 0.38
query17 1.03 1.01 1.01
query18 0.21 0.20 0.20
query19 1.87 1.77 1.96
query20 0.02 0.01 0.01
query21 15.36 0.91 0.55
query22 0.76 1.19 0.64
query23 14.92 1.37 0.66
query24 6.64 2.17 1.19
query25 0.49 0.14 0.08
query26 0.65 0.17 0.14
query27 0.05 0.06 0.04
query28 10.05 0.85 0.43
query29 12.52 3.96 3.33
query30 0.25 0.09 0.07
query31 2.84 0.59 0.40
query32 3.23 0.55 0.46
query33 2.98 3.08 3.09
query34 15.80 5.14 4.59
query35 4.59 4.53 4.55
query36 0.68 0.50 0.49
query37 0.09 0.06 0.06
query38 0.06 0.04 0.04
query39 0.03 0.03 0.02
query40 0.16 0.14 0.13
query41 0.08 0.03 0.03
query42 0.03 0.02 0.02
query43 0.04 0.04 0.03
Total cold run time: 105.33 s
Total hot run time: 31.62 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] [refactor](Nereids) let nullable always correct [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #49845:
URL: https://github.com/apache/doris/pull/49845#issuecomment-2782833250
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] [refactor](Nereids) let nullable always correct [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #49845:
URL: https://github.com/apache/doris/pull/49845#issuecomment-2782833167
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] [refactor](Nereids) let nullable always correct [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49845:
URL: https://github.com/apache/doris/pull/49845#issuecomment-2782928751
<details>
<summary>TPC-H: <b>Total hot run time: 34110 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 2ebb3037c3aca64717975d1bd2dd149a2851f7fc, data reload: false
------ Round 1 ----------------------------------
q1 25306 5060 5033 5033
q2 2071 299 187 187
q3 10370 1228 689 689
q4 10223 1023 544 544
q5 7522 2321 2321 2321
q6 183 162 131 131
q7 887 732 597 597
q8 9324 1254 1010 1010
q9 6774 5099 5068 5068
q10 6847 2305 1900 1900
q11 498 286 254 254
q12 349 359 220 220
q13 17771 3667 3092 3092
q14 243 223 206 206
q15 527 486 473 473
q16 618 594 603 594
q17 590 849 350 350
q18 7355 7149 7214 7149
q19 1521 937 565 565
q20 334 335 221 221
q21 4001 3441 2495 2495
q22 1104 1016 1011 1011
Total cold run time: 114418 ms
Total hot run time: 34110 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5200 5069 5184 5069
q2 243 329 237 237
q3 2100 2608 2251 2251
q4 1472 1796 1383 1383
q5 4360 4339 4344 4339
q6 220 176 129 129
q7 1976 1974 1790 1790
q8 2569 2492 2511 2492
q9 7304 7218 6962 6962
q10 3070 3188 2744 2744
q11 587 507 499 499
q12 682 773 608 608
q13 3618 3893 3308 3308
q14 287 309 299 299
q15 550 497 493 493
q16 646 685 655 655
q17 1141 1556 1376 1376
q18 7694 7525 7592 7525
q19 799 806 949 806
q20 1946 2042 1821 1821
q21 5276 4852 4786 4786
q22 1133 1070 1039 1039
Total cold run time: 52873 ms
Total hot run time: 50611 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] [refactor](Nereids) let nullable always correct [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49845:
URL: https://github.com/apache/doris/pull/49845#issuecomment-2782959579
<details>
<summary>TPC-DS: <b>Total hot run time: 193421 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 2ebb3037c3aca64717975d1bd2dd149a2851f7fc, data reload: false
query1 1399 1044 1046 1044
query2 6178 1914 1849 1849
query3 11145 4679 4623 4623
query4 54255 25358 23219 23219
query5 5200 584 493 493
query6 357 219 199 199
query7 4891 508 301 301
query8 311 253 251 251
query9 5593 2603 2598 2598
query10 432 325 277 277
query11 15085 14944 14924 14924
query12 164 110 109 109
query13 1043 527 408 408
query14 10330 6605 6406 6406
query15 218 208 195 195
query16 7096 671 493 493
query17 1097 783 603 603
query18 1549 419 321 321
query19 207 204 171 171
query20 129 132 117 117
query21 210 125 108 108
query22 4308 4396 4460 4396
query23 34067 33509 33376 33376
query24 6602 2466 2469 2466
query25 454 473 436 436
query26 707 278 156 156
query27 2218 507 335 335
query28 2979 2482 2441 2441
query29 580 572 440 440
query30 276 230 199 199
query31 851 911 786 786
query32 78 66 63 63
query33 485 368 311 311
query34 792 871 522 522
query35 798 883 766 766
query36 948 1013 883 883
query37 119 102 85 85
query38 4060 4331 4166 4166
query39 1492 1435 1443 1435
query40 222 126 110 110
query41 58 56 49 49
query42 131 119 111 111
query43 528 504 486 486
query44 1374 837 819 819
query45 187 179 172 172
query46 865 1027 685 685
query47 1869 1871 1837 1837
query48 378 426 298 298
query49 684 505 428 428
query50 665 691 415 415
query51 4252 4310 4169 4169
query52 119 115 98 98
query53 241 282 188 188
query54 592 581 521 521
query55 83 83 81 81
query56 304 302 293 293
query57 1193 1184 1103 1103
query58 270 297 269 269
query59 2601 2706 2624 2624
query60 352 356 337 337
query61 156 131 132 131
query62 735 761 688 688
query63 237 202 204 202
query64 1761 1034 716 716
query65 4382 4347 4201 4201
query66 772 402 307 307
query67 15937 15652 15404 15404
query68 8316 842 511 511
query69 533 301 272 272
query70 1301 1108 1044 1044
query71 508 340 294 294
query72 6377 4864 4949 4864
query73 1477 702 349 349
query74 9254 8978 8603 8603
query75 4513 3200 2769 2769
query76 5398 1191 788 788
query77 823 378 287 287
query78 9915 10315 9281 9281
query79 5421 771 553 553
query80 623 518 445 445
query81 479 255 224 224
query82 651 129 100 100
query83 309 324 243 243
query84 306 106 86 86
query85 786 354 328 328
query86 330 306 274 274
query87 4396 4516 4415 4415
query88 3175 2245 2228 2228
query89 450 316 284 284
query90 1975 220 221 220
query91 144 143 111 111
query92 78 61 58 58
query93 2461 942 589 589
query94 687 416 310 310
query95 377 303 339 303
query96 494 566 278 278
query97 3155 3205 3135 3135
query98 229 216 197 197
query99 1434 1378 1265 1265
Total cold run time: 306026 ms
Total hot run time: 193421 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] [refactor](Nereids) let nullable always correct [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow closed pull request #49845: [refactor](Nereids) let nullable always correct
URL: https://github.com/apache/doris/pull/49845
--
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