You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "feiniaofeiafei (via GitHub)" <gi...@apache.org> on 2025/12/30 13:07:22 UTC
[PR] [Fix](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
feiniaofeiafei opened a new pull request, #59498:
URL: https://github.com/apache/doris/pull/59498
### 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] [Fix](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3710823779
<details>
<summary>TPC-DS: <b>Total hot run time: 173051 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 67d181b70d51ffa26de144229c33364fb8d493ef, data reload: false
query5 4358 586 452 452
query6 335 248 220 220
query7 4232 461 269 269
query8 350 247 235 235
query9 8765 2656 2647 2647
query10 512 368 317 317
query11 15093 15180 15884 15180
query12 205 128 133 128
query13 1464 521 426 426
query14 6208 3091 2806 2806
query14_1 2750 2728 2688 2688
query15 205 201 186 186
query16 1057 497 467 467
query17 1134 709 581 581
query18 2931 430 329 329
query19 215 242 199 199
query20 128 116 124 116
query21 253 143 140 140
query22 4749 4319 4264 4264
query23 16193 15517 15242 15242
query23_1 15276 15502 15273 15273
query24 7320 1512 1169 1169
query24_1 1151 1154 1165 1154
query25 515 426 370 370
query26 1239 256 148 148
query27 2738 428 280 280
query28 4501 2123 2133 2123
query29 772 521 423 423
query30 305 240 200 200
query31 777 652 541 541
query32 72 64 63 63
query33 522 324 278 278
query34 891 868 521 521
query35 748 780 718 718
query36 857 864 810 810
query37 126 92 73 73
query38 2750 2648 2706 2648
query39 762 761 705 705
query39_1 700 707 719 707
query40 214 128 109 109
query41 61 58 57 57
query42 96 94 95 94
query43 469 453 458 453
query44 1281 724 720 720
query45 189 180 170 170
query46 843 972 578 578
query47 1363 1443 1370 1370
query48 304 309 239 239
query49 616 411 314 314
query50 621 260 198 198
query51 3803 3749 3776 3749
query52 101 113 97 97
query53 297 324 267 267
query54 276 258 247 247
query55 81 75 70 70
query56 280 286 285 285
query57 1033 990 939 939
query58 266 241 238 238
query59 2016 2163 2183 2163
query60 306 311 287 287
query61 180 191 186 186
query62 406 357 313 313
query63 300 268 259 259
query64 5143 1405 1094 1094
query65 3802 3705 3672 3672
query66 1445 430 350 350
query67 15421 14980 14991 14980
query68 8340 976 699 699
query69 474 339 307 307
query70 1049 956 922 922
query71 387 291 274 274
query72 6061 3376 3383 3376
query73 785 728 298 298
query74 8810 8764 8518 8518
query75 3229 2824 2451 2451
query76 4120 1039 627 627
query77 834 366 266 266
query78 9757 9882 9214 9214
query79 1578 924 572 572
query80 610 559 466 466
query81 511 257 227 227
query82 513 143 116 116
query83 267 262 235 235
query84 253 121 97 97
query85 1018 494 462 462
query86 402 291 315 291
query87 2852 2831 2752 2752
query88 4352 2209 2225 2209
query89 392 361 324 324
query90 2055 150 147 147
query91 177 174 138 138
query92 84 67 64 64
query93 1669 874 525 525
query94 543 331 293 293
query95 573 371 307 307
query96 587 477 212 212
query97 2304 2372 2333 2333
query98 231 200 199 199
query99 587 611 503 503
Total cold run time: 258552 ms
Total hot run time: 173051 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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3712965135
<details>
<summary>ClickBench: <b>Total hot run time: 26.78 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 4da787478a992a46c5bb6e389d761200568efd15, data reload: false
query1 0.05 0.05 0.05
query2 0.10 0.05 0.04
query3 0.26 0.09 0.09
query4 1.61 0.11 0.11
query5 0.26 0.26 0.25
query6 1.14 0.66 0.64
query7 0.03 0.02 0.03
query8 0.05 0.04 0.04
query9 0.56 0.51 0.51
query10 0.56 0.55 0.56
query11 0.15 0.09 0.10
query12 0.15 0.11 0.11
query13 0.60 0.58 0.58
query14 0.95 0.95 0.95
query15 0.80 0.77 0.78
query16 0.41 0.40 0.40
query17 1.03 0.99 1.04
query18 0.23 0.22 0.22
query19 1.90 1.84 1.80
query20 0.03 0.01 0.02
query21 15.45 0.27 0.14
query22 5.16 0.05 0.05
query23 15.86 0.28 0.11
query24 0.96 0.23 0.36
query25 0.12 0.07 0.08
query26 0.16 0.13 0.12
query27 0.06 0.05 0.06
query28 3.34 1.06 0.88
query29 12.55 3.96 3.12
query30 0.27 0.14 0.12
query31 2.82 0.65 0.40
query32 3.25 0.55 0.46
query33 3.11 3.03 3.06
query34 16.60 5.13 4.51
query35 4.49 4.48 4.46
query36 0.66 0.51 0.48
query37 0.11 0.06 0.06
query38 0.08 0.05 0.04
query39 0.04 0.02 0.02
query40 0.17 0.13 0.13
query41 0.08 0.03 0.04
query42 0.05 0.03 0.02
query43 0.04 0.04 0.03
Total cold run time: 96.3 s
Total hot run time: 26.78 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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "feiniaofeiafei (via GitHub)" <gi...@apache.org>.
feiniaofeiafei commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3713934556
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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3699984137
# FE Regression Coverage Report
Increment line coverage ` 100.00% (22/22)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/59498_a9b3fd37a7dbde6d2694d38538f7f406e6f77fec_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/59498_a9b3fd37a7dbde6d2694d38538f7f406e6f77fec_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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #59498:
URL: https://github.com/apache/doris/pull/59498
--
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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3713636240
<details>
<summary>TPC-H: <b>Total hot run time: 31880 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 7b1898b6a48e347a0fc600bd7f72815ecf472277, data reload: false
------ Round 1 ----------------------------------
q1 17644 4212 4046 4046
q2 2060 356 247 247
q3 10131 1284 692 692
q4 10211 840 325 325
q5 7533 2040 1865 1865
q6 193 165 136 136
q7 932 790 652 652
q8 9272 1321 1076 1076
q9 4778 4546 4560 4546
q10 6810 1791 1428 1428
q11 505 291 285 285
q12 709 749 597 597
q13 17801 3818 3090 3090
q14 292 317 273 273
q15 592 500 500 500
q16 659 678 622 622
q17 666 822 509 509
q18 6910 6462 6635 6462
q19 1146 1009 615 615
q20 469 432 280 280
q21 3300 2613 2812 2613
q22 1121 1125 1021 1021
Total cold run time: 103734 ms
Total hot run time: 31880 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4350 4311 4429 4311
q2 336 416 319 319
q3 2284 2765 2459 2459
q4 1394 1867 1397 1397
q5 4670 4598 4238 4238
q6 204 164 125 125
q7 2005 1957 1779 1779
q8 2576 2431 2367 2367
q9 7391 6964 7107 6964
q10 2537 2761 2254 2254
q11 538 476 452 452
q12 724 783 593 593
q13 3501 3766 3141 3141
q14 266 281 252 252
q15 520 481 476 476
q16 622 663 609 609
q17 1102 1300 1334 1300
q18 7601 7429 7270 7270
q19 800 754 785 754
q20 1881 1980 1780 1780
q21 4562 4294 4151 4151
q22 1069 1027 1017 1017
Total cold run time: 50933 ms
Total hot run time: 48008 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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3712010932
# FE Regression Coverage Report
Increment line coverage ` 97.50% (39/40)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/59498_67d181b70d51ffa26de144229c33364fb8d493ef_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/59498_67d181b70d51ffa26de144229c33364fb8d493ef_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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3699390937
<details>
<summary>TPC-H: <b>Total hot run time: 33970 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 a9b3fd37a7dbde6d2694d38538f7f406e6f77fec, data reload: false
------ Round 1 ----------------------------------
q1 17646 4153 4046 4046
q2 2026 353 242 242
q3 10180 1269 728 728
q4 10214 860 316 316
q5 7532 2127 1914 1914
q6 199 177 148 148
q7 940 801 661 661
q8 9269 1414 1113 1113
q9 6711 5178 5060 5060
q10 6808 1813 1443 1443
q11 519 308 278 278
q12 698 751 653 653
q13 17765 3788 3058 3058
q14 305 291 268 268
q15 599 516 498 498
q16 702 676 643 643
q17 698 805 654 654
q18 7509 7150 7221 7150
q19 1099 940 616 616
q20 413 367 250 250
q21 4147 3824 3280 3280
q22 1060 1017 951 951
Total cold run time: 107039 ms
Total hot run time: 33970 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4065 4014 4046 4014
q2 317 415 319 319
q3 2048 2569 2206 2206
q4 1308 1734 1276 1276
q5 4031 3920 4449 3920
q6 269 181 137 137
q7 2113 1989 1842 1842
q8 2571 2352 2323 2323
q9 7136 7116 7059 7059
q10 2469 2869 2339 2339
q11 557 494 473 473
q12 679 735 603 603
q13 3786 4141 3327 3327
q14 288 320 296 296
q15 539 507 504 504
q16 652 711 656 656
q17 1155 1367 1438 1367
q18 7795 7854 7706 7706
q19 943 925 970 925
q20 2193 2072 1923 1923
q21 4635 4352 4133 4133
q22 1064 1054 990 990
Total cold run time: 50613 ms
Total hot run time: 48338 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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "feiniaofeiafei (via GitHub)" <gi...@apache.org>.
feiniaofeiafei commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3701549913
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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "feiniaofeiafei (via GitHub)" <gi...@apache.org>.
feiniaofeiafei commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3717054648
run vault_p0
--
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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3710842377
<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 67d181b70d51ffa26de144229c33364fb8d493ef, data reload: false
query1 0.05 0.05 0.05
query2 0.09 0.05 0.05
query3 0.26 0.08 0.08
query4 1.61 0.12 0.11
query5 0.28 0.26 0.27
query6 1.16 0.65 0.66
query7 0.03 0.03 0.03
query8 0.05 0.04 0.04
query9 0.57 0.50 0.51
query10 0.55 0.57 0.53
query11 0.14 0.09 0.10
query12 0.14 0.11 0.10
query13 0.60 0.59 0.58
query14 0.96 0.95 0.95
query15 0.80 0.78 0.78
query16 0.40 0.41 0.43
query17 1.02 1.02 1.04
query18 0.23 0.21 0.21
query19 1.96 1.89 1.78
query20 0.02 0.02 0.01
query21 15.44 0.28 0.13
query22 5.03 0.05 0.05
query23 15.67 0.27 0.10
query24 1.21 0.63 1.02
query25 0.11 0.06 0.08
query26 0.14 0.13 0.13
query27 0.09 0.05 0.06
query28 5.14 1.03 0.88
query29 12.65 3.93 3.13
query30 0.28 0.13 0.13
query31 2.82 0.66 0.41
query32 3.23 0.55 0.46
query33 2.98 2.99 3.11
query34 16.60 5.06 4.51
query35 4.52 4.56 4.48
query36 0.65 0.50 0.50
query37 0.11 0.06 0.07
query38 0.07 0.04 0.04
query39 0.05 0.03 0.03
query40 0.16 0.14 0.13
query41 0.09 0.03 0.04
query42 0.04 0.03 0.03
query43 0.04 0.04 0.03
Total cold run time: 98.04 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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3713665732
<details>
<summary>TPC-DS: <b>Total hot run time: 172991 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 7b1898b6a48e347a0fc600bd7f72815ecf472277, data reload: false
query5 4873 579 421 421
query6 344 232 242 232
query7 4218 459 271 271
query8 350 257 241 241
query9 8788 2663 2664 2663
query10 545 387 331 331
query11 15110 15055 14898 14898
query12 187 115 112 112
query13 1266 501 371 371
query14 6459 3037 2783 2783
query14_1 2743 2674 2713 2674
query15 204 197 175 175
query16 994 483 453 453
query17 1083 668 590 590
query18 2593 445 365 365
query19 230 223 203 203
query20 131 123 117 117
query21 216 145 123 123
query22 3919 3828 3971 3828
query23 16211 15648 15282 15282
query23_1 15504 15455 15451 15451
query24 7394 1571 1195 1195
query24_1 1220 1219 1199 1199
query25 572 478 461 461
query26 1252 267 166 166
query27 2739 451 294 294
query28 4549 2152 2143 2143
query29 794 559 463 463
query30 322 241 216 216
query31 807 624 568 568
query32 80 68 69 68
query33 554 358 308 308
query34 912 867 524 524
query35 751 799 739 739
query36 871 861 753 753
query37 128 91 83 83
query38 2787 2707 2653 2653
query39 769 759 726 726
query39_1 720 729 724 724
query40 220 132 114 114
query41 70 62 61 61
query42 103 104 110 104
query43 448 487 433 433
query44 1309 728 726 726
query45 186 181 183 181
query46 850 960 591 591
query47 1414 1436 1352 1352
query48 301 314 258 258
query49 605 426 329 329
query50 627 281 203 203
query51 3814 3766 3765 3765
query52 104 110 97 97
query53 299 333 274 274
query54 289 253 248 248
query55 81 77 77 77
query56 283 302 304 302
query57 1006 994 910 910
query58 264 256 249 249
query59 2148 2129 2033 2033
query60 323 323 342 323
query61 162 165 176 165
query62 389 351 319 319
query63 300 268 271 268
query64 4852 1301 985 985
query65 3802 3753 3725 3725
query66 1399 419 301 301
query67 15532 14777 14993 14777
query68 6739 982 705 705
query69 485 357 324 324
query70 1035 964 960 960
query71 370 302 287 287
query72 6008 3424 3482 3424
query73 780 721 306 306
query74 8869 8779 8541 8541
query75 2864 2815 2451 2451
query76 3894 1058 658 658
query77 505 385 287 287
query78 9714 9949 9229 9229
query79 1268 903 587 587
query80 615 571 502 502
query81 513 260 226 226
query82 212 142 110 110
query83 269 267 238 238
query84 258 114 100 100
query85 916 525 462 462
query86 388 296 292 292
query87 2865 2907 2747 2747
query88 3168 2224 2217 2217
query89 394 346 342 342
query90 2222 153 151 151
query91 170 174 143 143
query92 87 69 64 64
query93 1739 903 528 528
query94 561 318 269 269
query95 570 321 311 311
query96 572 455 206 206
query97 2344 2394 2284 2284
query98 258 198 198 198
query99 581 582 527 527
Total cold run time: 254730 ms
Total hot run time: 172991 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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3714131460
<details>
<summary>TPC-DS: <b>Total hot run time: 173235 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 3fd07b24ba3887e3a9519435205a4c4eb96bb393, data reload: false
query5 4373 581 451 451
query6 328 216 206 206
query7 4221 451 277 277
query8 346 236 220 220
query9 8746 2633 2677 2633
query10 492 395 352 352
query11 15324 15241 14946 14946
query12 174 114 113 113
query13 1253 482 400 400
query14 6113 3016 2721 2721
query14_1 2662 2636 2624 2624
query15 197 191 179 179
query16 1022 464 454 454
query17 1118 683 572 572
query18 2440 443 348 348
query19 229 223 199 199
query20 123 120 116 116
query21 218 146 121 121
query22 3839 3981 4048 3981
query23 16206 15645 15305 15305
query23_1 15396 15488 15398 15398
query24 7556 1530 1146 1146
query24_1 1192 1174 1188 1174
query25 553 474 428 428
query26 1245 269 159 159
query27 2753 456 288 288
query28 4521 2141 2132 2132
query29 836 571 474 474
query30 316 240 209 209
query31 790 648 552 552
query32 81 70 70 70
query33 541 369 293 293
query34 888 868 528 528
query35 782 795 721 721
query36 873 907 851 851
query37 130 101 78 78
query38 2830 2871 2673 2673
query39 770 741 728 728
query39_1 723 720 755 720
query40 215 134 114 114
query41 65 79 77 77
query42 99 101 101 101
query43 493 439 417 417
query44 1358 731 731 731
query45 189 184 177 177
query46 833 959 585 585
query47 1343 1435 1371 1371
query48 322 316 239 239
query49 611 415 323 323
query50 629 267 202 202
query51 3763 3806 3838 3806
query52 108 103 91 91
query53 291 319 275 275
query54 290 262 245 245
query55 77 73 70 70
query56 274 295 287 287
query57 1069 1004 943 943
query58 274 259 252 252
query59 2136 2223 2122 2122
query60 328 318 299 299
query61 162 200 162 162
query62 384 344 319 319
query63 295 263 269 263
query64 5059 1282 1006 1006
query65 3726 3716 3631 3631
query66 1431 416 299 299
query67 15485 15032 15046 15032
query68 7643 999 710 710
query69 478 342 315 315
query70 1060 937 970 937
query71 362 295 268 268
query72 6023 3447 3400 3400
query73 767 725 303 303
query74 8799 8804 8636 8636
query75 2825 2783 2448 2448
query76 3772 1060 665 665
query77 516 365 283 283
query78 9721 9944 9156 9156
query79 1494 900 574 574
query80 662 552 476 476
query81 546 265 234 234
query82 222 146 113 113
query83 262 258 239 239
query84 267 119 104 104
query85 940 509 476 476
query86 347 327 301 301
query87 2866 2861 2820 2820
query88 3165 2207 2207 2207
query89 388 336 329 329
query90 2038 151 141 141
query91 171 168 143 143
query92 75 68 63 63
query93 1109 890 535 535
query94 569 330 286 286
query95 565 372 296 296
query96 584 456 201 201
query97 2328 2397 2272 2272
query98 223 194 193 193
query99 579 580 528 528
Total cold run time: 253797 ms
Total hot run time: 173235 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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3702030871
# FE Regression Coverage Report
Increment line coverage ` 94.29% (33/35)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/59498_3bb843d14fb29fc8f4aad4b4a2b2bb65b1db2fcd_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/59498_3bb843d14fb29fc8f4aad4b4a2b2bb65b1db2fcd_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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "feiniaofeiafei (via GitHub)" <gi...@apache.org>.
feiniaofeiafei commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3699309505
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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "feiniaofeiafei (via GitHub)" <gi...@apache.org>.
feiniaofeiafei commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3712886301
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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3712956773
<details>
<summary>TPC-DS: <b>Total hot run time: 173347 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 4da787478a992a46c5bb6e389d761200568efd15, data reload: false
query5 4353 584 469 469
query6 339 231 212 212
query7 4218 456 264 264
query8 325 244 234 234
query9 8752 2659 2690 2659
query10 521 360 319 319
query11 15202 15305 15002 15002
query12 168 115 116 115
query13 1239 504 363 363
query14 5528 3118 2821 2821
query14_1 2745 2577 2783 2577
query15 210 195 170 170
query16 987 490 458 458
query17 1084 669 567 567
query18 2422 458 339 339
query19 232 222 195 195
query20 129 119 121 119
query21 220 142 125 125
query22 3826 3829 3795 3795
query23 15941 15683 15304 15304
query23_1 15372 15496 15362 15362
query24 7379 1561 1178 1178
query24_1 1185 1168 1204 1168
query25 541 440 399 399
query26 1250 270 169 169
query27 2754 450 292 292
query28 4586 2165 2134 2134
query29 767 557 471 471
query30 311 246 222 222
query31 779 628 595 595
query32 78 66 69 66
query33 539 339 286 286
query34 907 877 531 531
query35 744 804 700 700
query36 832 918 840 840
query37 131 93 78 78
query38 2740 2718 2602 2602
query39 780 777 716 716
query39_1 732 728 703 703
query40 219 137 122 122
query41 68 63 64 63
query42 109 108 105 105
query43 464 473 465 465
query44 1364 732 733 732
query45 188 185 184 184
query46 850 974 611 611
query47 1402 1430 1350 1350
query48 310 328 248 248
query49 615 419 336 336
query50 654 272 213 213
query51 3779 3790 3781 3781
query52 110 110 100 100
query53 304 330 276 276
query54 281 268 249 249
query55 81 79 73 73
query56 296 295 295 295
query57 959 989 961 961
query58 280 266 262 262
query59 2155 2197 2170 2170
query60 337 328 318 318
query61 183 210 184 184
query62 409 361 314 314
query63 308 272 283 272
query64 5110 1405 1101 1101
query65 3811 3742 3721 3721
query66 1477 440 327 327
query67 15347 15303 14998 14998
query68 2788 1048 759 759
query69 463 369 332 332
query70 971 943 933 933
query71 335 311 298 298
query72 6322 3488 3468 3468
query73 619 757 311 311
query74 8739 8702 8620 8620
query75 2757 2842 2465 2465
query76 2861 1058 648 648
query77 359 392 287 287
query78 9841 9714 9154 9154
query79 2247 833 608 608
query80 1513 566 464 464
query81 593 261 230 230
query82 412 141 107 107
query83 354 255 235 235
query84 263 111 101 101
query85 955 498 448 448
query86 482 306 329 306
query87 2922 2858 2763 2763
query88 3240 2234 2220 2220
query89 394 337 335 335
query90 2009 157 145 145
query91 172 164 146 146
query92 78 70 63 63
query93 1161 919 529 529
query94 636 334 285 285
query95 573 382 308 308
query96 582 457 200 200
query97 2332 2366 2284 2284
query98 230 209 200 200
query99 592 578 499 499
Total cold run time: 249371 ms
Total hot run time: 173347 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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3712939287
<details>
<summary>TPC-H: <b>Total hot run time: 32489 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 4da787478a992a46c5bb6e389d761200568efd15, data reload: false
------ Round 1 ----------------------------------
q1 17660 4292 4089 4089
q2 2070 363 240 240
q3 10113 1294 732 732
q4 10209 883 329 329
q5 7531 2197 1958 1958
q6 199 174 139 139
q7 926 805 651 651
q8 9303 1464 1226 1226
q9 4881 4661 4745 4661
q10 6781 1804 1421 1421
q11 517 296 291 291
q12 676 764 574 574
q13 17765 3892 3133 3133
q14 291 312 277 277
q15 575 516 507 507
q16 683 694 624 624
q17 675 796 587 587
q18 6486 6378 7031 6378
q19 977 1067 698 698
q20 449 405 270 270
q21 3314 2780 2658 2658
q22 1155 1070 1046 1046
Total cold run time: 103236 ms
Total hot run time: 32489 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4435 4243 4263 4243
q2 326 380 333 333
q3 2277 2812 2389 2389
q4 1434 1903 1432 1432
q5 4543 4419 4354 4354
q6 224 172 136 136
q7 1947 1974 1710 1710
q8 2547 2633 2471 2471
q9 7048 7134 7135 7134
q10 2617 2710 2346 2346
q11 547 483 450 450
q12 701 762 655 655
q13 3706 4053 3350 3350
q14 273 284 278 278
q15 525 506 493 493
q16 602 658 619 619
q17 1109 1286 1303 1286
q18 7570 7216 7376 7216
q19 896 767 842 767
q20 1915 1966 1856 1856
q21 4575 4306 4202 4202
q22 1098 1021 982 982
Total cold run time: 50915 ms
Total hot run time: 48702 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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3714153207
<details>
<summary>ClickBench: <b>Total hot run time: 27.19 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 3fd07b24ba3887e3a9519435205a4c4eb96bb393, data reload: false
query1 0.06 0.05 0.04
query2 0.09 0.04 0.04
query3 0.26 0.09 0.09
query4 1.60 0.11 0.11
query5 0.26 0.25 0.24
query6 1.14 0.66 0.66
query7 0.03 0.03 0.02
query8 0.06 0.04 0.04
query9 0.55 0.50 0.50
query10 0.55 0.54 0.53
query11 0.14 0.09 0.10
query12 0.14 0.10 0.12
query13 0.60 0.60 0.58
query14 0.94 0.96 0.95
query15 0.79 0.77 0.80
query16 0.40 0.40 0.42
query17 1.01 1.04 1.00
query18 0.24 0.21 0.22
query19 1.88 1.88 1.89
query20 0.02 0.01 0.01
query21 15.46 0.30 0.16
query22 5.20 0.04 0.04
query23 15.98 0.28 0.10
query24 1.94 0.59 0.70
query25 0.12 0.06 0.05
query26 0.14 0.13 0.14
query27 0.09 0.08 0.06
query28 4.78 1.04 0.89
query29 12.57 3.94 3.18
query30 0.27 0.13 0.12
query31 2.82 0.64 0.41
query32 3.23 0.56 0.46
query33 2.98 3.06 3.01
query34 16.36 5.15 4.44
query35 4.46 4.48 4.45
query36 0.65 0.51 0.49
query37 0.11 0.07 0.06
query38 0.08 0.04 0.04
query39 0.05 0.02 0.03
query40 0.17 0.14 0.14
query41 0.09 0.04 0.03
query42 0.04 0.03 0.03
query43 0.05 0.04 0.03
Total cold run time: 98.4 s
Total hot run time: 27.19 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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3713418664
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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "feiniaofeiafei (via GitHub)" <gi...@apache.org>.
feiniaofeiafei commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3710642533
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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3710781172
<details>
<summary>TPC-H: <b>Total hot run time: 31162 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 67d181b70d51ffa26de144229c33364fb8d493ef, data reload: false
------ Round 1 ----------------------------------
q1 17619 4245 4060 4060
q2 2019 352 240 240
q3 10171 1244 703 703
q4 10224 827 317 317
q5 7544 2079 1805 1805
q6 187 170 137 137
q7 919 786 660 660
q8 9289 1400 1126 1126
q9 4913 4513 4382 4382
q10 6780 1803 1388 1388
q11 530 290 302 290
q12 686 733 606 606
q13 17780 3751 3089 3089
q14 288 293 270 270
q15 586 515 505 505
q16 685 671 632 632
q17 678 718 598 598
q18 6626 6359 6358 6358
q19 1104 958 604 604
q20 435 351 245 245
q21 2959 2421 2210 2210
q22 1033 995 937 937
Total cold run time: 103055 ms
Total hot run time: 31162 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4073 4029 4001 4001
q2 319 394 306 306
q3 2073 2627 2206 2206
q4 1331 1706 1269 1269
q5 4050 3918 3974 3918
q6 259 172 125 125
q7 1815 1775 1682 1682
q8 2571 2531 2376 2376
q9 7242 7082 7127 7082
q10 2514 2785 2204 2204
q11 560 484 453 453
q12 699 799 667 667
q13 3731 4067 3419 3419
q14 323 303 287 287
q15 550 513 554 513
q16 768 703 631 631
q17 1149 1348 1375 1348
q18 7852 8046 7897 7897
q19 895 859 845 845
q20 2004 2004 2033 2004
q21 4699 4630 4350 4350
q22 1205 1108 1071 1071
Total cold run time: 50682 ms
Total hot run time: 48654 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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3713679407
<details>
<summary>ClickBench: <b>Total hot run time: 26.84 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 7b1898b6a48e347a0fc600bd7f72815ecf472277, data reload: false
query1 0.05 0.04 0.04
query2 0.09 0.04 0.04
query3 0.26 0.09 0.09
query4 1.61 0.11 0.12
query5 0.27 0.26 0.26
query6 1.15 0.67 0.65
query7 0.04 0.03 0.02
query8 0.05 0.03 0.04
query9 0.56 0.49 0.50
query10 0.54 0.55 0.55
query11 0.14 0.10 0.10
query12 0.14 0.10 0.10
query13 0.61 0.60 0.59
query14 0.96 0.95 0.93
query15 0.80 0.77 0.77
query16 0.42 0.39 0.39
query17 1.04 1.06 1.03
query18 0.24 0.22 0.22
query19 1.94 1.80 1.75
query20 0.02 0.01 0.01
query21 15.49 0.28 0.14
query22 5.54 0.06 0.05
query23 16.39 0.29 0.10
query24 1.38 0.56 0.23
query25 0.07 0.06 0.07
query26 0.14 0.14 0.13
query27 0.12 0.08 0.06
query28 4.27 1.04 0.88
query29 12.64 4.07 3.27
query30 0.27 0.13 0.13
query31 2.83 0.66 0.39
query32 3.24 0.57 0.47
query33 3.07 2.97 3.06
query34 16.79 5.10 4.48
query35 4.51 4.52 4.46
query36 0.67 0.50 0.50
query37 0.11 0.07 0.06
query38 0.08 0.04 0.04
query39 0.04 0.03 0.03
query40 0.16 0.14 0.14
query41 0.09 0.03 0.03
query42 0.04 0.03 0.02
query43 0.04 0.03 0.04
Total cold run time: 98.91 s
Total hot run time: 26.84 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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3714721741
# FE Regression Coverage Report
Increment line coverage ` 97.50% (39/40)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/59498_3fd07b24ba3887e3a9519435205a4c4eb96bb393_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/59498_3fd07b24ba3887e3a9519435205a4c4eb96bb393_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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "feiniaofeiafei (via GitHub)" <gi...@apache.org>.
feiniaofeiafei commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3717445183
run vault_p0
--
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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "feiniaofeiafei (via GitHub)" <gi...@apache.org>.
feiniaofeiafei commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3701550974
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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3699432324
<details>
<summary>ClickBench: <b>Total hot run time: 26.83 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 a9b3fd37a7dbde6d2694d38538f7f406e6f77fec, data reload: false
query1 0.06 0.05 0.05
query2 0.10 0.05 0.05
query3 0.26 0.08 0.08
query4 1.61 0.12 0.11
query5 0.27 0.26 0.25
query6 1.17 0.67 0.65
query7 0.03 0.03 0.02
query8 0.05 0.04 0.04
query9 0.56 0.50 0.49
query10 0.55 0.56 0.53
query11 0.15 0.11 0.11
query12 0.16 0.12 0.13
query13 0.62 0.60 0.60
query14 0.99 0.96 0.97
query15 0.82 0.78 0.79
query16 0.39 0.43 0.41
query17 1.04 1.08 1.05
query18 0.22 0.21 0.21
query19 1.89 1.78 1.88
query20 0.02 0.01 0.01
query21 15.44 0.28 0.13
query22 4.87 0.05 0.05
query23 15.99 0.28 0.10
query24 1.58 0.24 0.23
query25 0.10 0.07 0.09
query26 0.15 0.14 0.14
query27 0.08 0.04 0.05
query28 4.03 1.06 0.88
query29 12.58 3.91 3.16
query30 0.27 0.13 0.11
query31 2.81 0.62 0.37
query32 3.22 0.55 0.46
query33 2.97 3.01 3.06
query34 16.60 5.17 4.46
query35 4.51 4.48 4.49
query36 0.67 0.50 0.49
query37 0.10 0.06 0.07
query38 0.08 0.04 0.03
query39 0.05 0.03 0.04
query40 0.17 0.14 0.14
query41 0.08 0.04 0.03
query42 0.04 0.03 0.03
query43 0.04 0.04 0.03
Total cold run time: 97.39 s
Total hot run time: 26.83 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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3701646485
# FE UT Coverage Report
Increment line coverage ` 97.14% (34/35)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/59498_3bb843d14fb29fc8f4aad4b4a2b2bb65b1db2fcd/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/59498_3bb843d14fb29fc8f4aad4b4a2b2bb65b1db2fcd/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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3713190466
# FE Regression Coverage Report
Increment line coverage ` 97.50% (39/40)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/59498_4da787478a992a46c5bb6e389d761200568efd15_merge_fe/increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/59498_4da787478a992a46c5bb6e389d761200568efd15_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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3713418472
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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "feiniaofeiafei (via GitHub)" <gi...@apache.org>.
feiniaofeiafei commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3713529854
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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3714080613
<details>
<summary>TPC-H: <b>Total hot run time: 32025 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 3fd07b24ba3887e3a9519435205a4c4eb96bb393, data reload: false
------ Round 1 ----------------------------------
q1 17639 4201 4061 4061
q2 2031 383 242 242
q3 10120 1246 729 729
q4 10207 872 323 323
q5 7545 2100 1892 1892
q6 192 174 143 143
q7 905 804 656 656
q8 9264 1414 1134 1134
q9 4884 4592 4552 4552
q10 6808 1810 1410 1410
q11 557 296 271 271
q12 697 742 597 597
q13 17796 3814 3121 3121
q14 293 295 266 266
q15 589 514 506 506
q16 685 687 648 648
q17 682 787 555 555
q18 6683 6449 6763 6449
q19 1151 1042 647 647
q20 437 433 265 265
q21 3261 2547 2748 2547
q22 1102 1131 1011 1011
Total cold run time: 103528 ms
Total hot run time: 32025 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4311 4241 4256 4241
q2 334 415 322 322
q3 2305 2776 2448 2448
q4 1395 1934 1501 1501
q5 4545 4435 4339 4339
q6 226 175 129 129
q7 1968 1941 1735 1735
q8 2558 2407 2410 2407
q9 7263 7145 7010 7010
q10 2748 2712 2276 2276
q11 556 491 480 480
q12 724 957 610 610
q13 3547 3990 3127 3127
q14 270 307 269 269
q15 526 496 483 483
q16 620 660 610 610
q17 1087 1228 1301 1228
q18 7337 7253 7214 7214
q19 829 786 836 786
q20 1920 1953 1793 1793
q21 4519 4221 4143 4143
q22 1048 1013 965 965
Total cold run time: 50636 ms
Total hot run time: 48116 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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3714198760
# FE UT Coverage Report
Increment line coverage ` 100.00% (40/40)` :tada:
[Increment coverage report](http://coverage.selectdb-in.cc/coverage/59498_3fd07b24ba3887e3a9519435205a4c4eb96bb393/fe_increment_report/index.html)
[Complete coverage report](http://coverage.selectdb-in.cc/coverage/59498_3fd07b24ba3887e3a9519435205a4c4eb96bb393/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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3699309388
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](rules) fix result wrong of PushDownAggThroughJoinOnPkFk [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59498:
URL: https://github.com/apache/doris/pull/59498#issuecomment-3699419111
<details>
<summary>TPC-DS: <b>Total hot run time: 173217 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 a9b3fd37a7dbde6d2694d38538f7f406e6f77fec, data reload: false
query5 4358 605 458 458
query6 359 225 201 201
query7 4218 453 257 257
query8 335 240 238 238
query9 8792 2598 2641 2598
query10 566 371 318 318
query11 15273 15020 14748 14748
query12 186 118 117 117
query13 1266 507 412 412
query14 6170 2925 2684 2684
query14_1 2623 2619 2609 2609
query15 203 200 179 179
query16 995 464 375 375
query17 1115 702 585 585
query18 2488 436 347 347
query19 232 223 201 201
query20 125 118 114 114
query21 218 147 115 115
query22 4093 4023 4046 4023
query23 16028 15694 15363 15363
query23_1 15441 15567 15392 15392
query24 7441 1576 1240 1240
query24_1 1231 1216 1239 1216
query25 572 486 431 431
query26 1243 266 164 164
query27 2752 458 306 306
query28 4513 2183 2182 2182
query29 835 602 428 428
query30 315 237 204 204
query31 800 655 546 546
query32 76 67 69 67
query33 538 320 301 301
query34 892 866 526 526
query35 747 758 705 705
query36 849 879 851 851
query37 131 95 75 75
query38 2713 2690 2640 2640
query39 784 763 719 719
query39_1 699 697 719 697
query40 216 135 119 119
query41 68 63 65 63
query42 107 106 108 106
query43 468 474 458 458
query44 1356 764 748 748
query45 187 183 176 176
query46 869 951 610 610
query47 1340 1410 1265 1265
query48 312 326 243 243
query49 613 407 325 325
query50 644 302 212 212
query51 3858 3806 3770 3770
query52 107 110 97 97
query53 305 327 268 268
query54 278 255 240 240
query55 80 74 76 74
query56 300 278 324 278
query57 1003 1023 921 921
query58 269 255 243 243
query59 2075 2178 2016 2016
query60 322 331 304 304
query61 163 154 159 154
query62 378 364 316 316
query63 293 268 281 268
query64 5103 1307 985 985
query65 3771 3675 3712 3675
query66 1423 456 313 313
query67 14922 14930 14536 14536
query68 6118 1044 728 728
query69 480 345 306 306
query70 1075 909 892 892
query71 382 310 271 271
query72 6221 4700 4895 4700
query73 707 622 309 309
query74 8759 8769 8558 8558
query75 2907 2882 2486 2486
query76 3865 1076 659 659
query77 535 393 280 280
query78 9775 9950 9180 9180
query79 1011 920 595 595
query80 671 573 486 486
query81 481 266 241 241
query82 205 144 108 108
query83 256 245 243 243
query84 247 125 103 103
query85 890 509 448 448
query86 326 324 322 322
query87 2933 2837 2723 2723
query88 3132 2261 2249 2249
query89 391 352 324 324
query90 1967 151 144 144
query91 173 172 142 142
query92 65 66 62 62
query93 1010 902 560 560
query94 574 318 275 275
query95 567 376 313 313
query96 584 450 204 204
query97 2299 2367 2313 2313
query98 226 204 190 190
query99 571 603 504 504
Total cold run time: 251222 ms
Total hot run time: 173217 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