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 2024/03/08 05:24:38 UTC
[PR] [opt](Nereids) remove canEliminate flag on LogicalProject [doris]
morrySnow opened a new pull request, #31977:
URL: https://github.com/apache/doris/pull/31977
## Proposed changes
Issue Number: close #xxx
<!--Describe your changes.-->
## Further comments
If this is a relatively large or complex change, kick off the discussion at [dev@doris.apache.org](mailto:dev@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc...
--
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) remove canEliminate flag on LogicalProject [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #31977:
URL: https://github.com/apache/doris/pull/31977#issuecomment-2081425462
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) remove canEliminate flag on LogicalProject [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #31977:
URL: https://github.com/apache/doris/pull/31977#issuecomment-1985125044
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) remove canEliminate flag on LogicalProject [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #31977:
URL: https://github.com/apache/doris/pull/31977#issuecomment-1985125003
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] [opt](Nereids) remove canEliminate flag on LogicalProject [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31977:
URL: https://github.com/apache/doris/pull/31977#issuecomment-2084312073
<details>
<summary>TPC-DS: <b>Total hot run time: 184807 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 fa077f13bca76d5e225dc34993be78c5e5c21841, data reload: false
query1 915 355 336 336
query2 7276 2392 2342 2342
query3 6653 216 206 206
query4 22807 21143 21170 21143
query5 4146 415 411 411
query6 275 189 180 180
query7 4606 294 279 279
query8 248 186 182 182
query9 8468 2278 2281 2278
query10 429 245 250 245
query11 14731 14214 14103 14103
query12 134 94 87 87
query13 1642 363 375 363
query14 9741 7355 7121 7121
query15 226 174 174 174
query16 7818 255 254 254
query17 1878 569 537 537
query18 1959 287 272 272
query19 211 154 172 154
query20 91 82 85 82
query21 194 126 123 123
query22 4986 4839 4812 4812
query23 34035 32972 33344 32972
query24 11831 2814 2779 2779
query25 672 357 356 356
query26 1797 150 149 149
query27 3040 319 321 319
query28 7598 1960 1958 1958
query29 1144 607 596 596
query30 284 151 162 151
query31 971 739 711 711
query32 94 53 53 53
query33 740 248 252 248
query34 1039 471 484 471
query35 798 655 685 655
query36 1071 897 922 897
query37 182 68 68 68
query38 3124 3013 3045 3013
query39 1588 1526 1537 1526
query40 281 129 130 129
query41 45 41 41 41
query42 103 99 97 97
query43 586 560 562 560
query44 1219 733 756 733
query45 264 251 264 251
query46 1076 682 704 682
query47 1919 1863 1872 1863
query48 377 309 305 305
query49 1220 410 401 401
query50 778 379 394 379
query51 6813 6764 6800 6764
query52 99 96 89 89
query53 358 269 276 269
query54 322 246 246 246
query55 81 71 73 71
query56 245 228 227 227
query57 1234 1127 1131 1127
query58 243 230 223 223
query59 3680 3280 2961 2961
query60 276 227 231 227
query61 89 88 87 87
query62 656 451 438 438
query63 299 274 270 270
query64 9488 7106 7117 7106
query65 3223 3023 3052 3023
query66 1391 337 334 334
query67 15416 15053 15059 15053
query68 8769 541 540 540
query69 535 297 309 297
query70 1242 1075 1139 1075
query71 481 272 267 267
query72 7198 2578 2330 2330
query73 727 319 320 319
query74 6492 6162 6088 6088
query75 4190 2629 2622 2622
query76 4731 1029 915 915
query77 670 259 262 259
query78 10742 10478 10124 10124
query79 7238 507 507 507
query80 909 425 431 425
query81 487 222 222 222
query82 238 96 95 95
query83 203 171 172 171
query84 267 88 87 87
query85 966 274 261 261
query86 358 291 293 291
query87 3260 3106 3074 3074
query88 4859 2397 2400 2397
query89 511 386 367 367
query90 2026 181 181 181
query91 127 97 97 97
query92 62 47 46 46
query93 5803 510 500 500
query94 1300 183 182 182
query95 398 306 295 295
query96 621 269 264 264
query97 3089 2922 2892 2892
query98 232 220 219 219
query99 1090 864 836 836
Total cold run time: 301044 ms
Total hot run time: 184807 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) remove canEliminate flag on LogicalProject [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31977:
URL: https://github.com/apache/doris/pull/31977#issuecomment-1985059460
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)
--
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) remove canEliminate flag on LogicalProject [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31977:
URL: https://github.com/apache/doris/pull/31977#issuecomment-2084298355
<details>
<summary>TPC-H: <b>Total hot run time: 39726 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 fa077f13bca76d5e225dc34993be78c5e5c21841, data reload: false
------ Round 1 ----------------------------------
q1 17935 4257 4225 4225
q2 2018 190 185 185
q3 10530 1176 1237 1176
q4 10465 735 734 734
q5 7558 2721 2647 2647
q6 217 131 132 131
q7 1025 594 607 594
q8 9553 2119 2089 2089
q9 9486 6641 6570 6570
q10 9601 3612 3679 3612
q11 440 239 233 233
q12 517 219 215 215
q13 17778 2952 2944 2944
q14 251 226 212 212
q15 505 482 466 466
q16 514 387 375 375
q17 950 752 720 720
q18 8052 7267 7326 7267
q19 1654 1536 1505 1505
q20 650 302 300 300
q21 5088 3304 3258 3258
q22 347 273 268 268
Total cold run time: 115134 ms
Total hot run time: 39726 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4297 4211 4139 4139
q2 380 268 268 268
q3 2930 2762 2667 2667
q4 1860 1587 1595 1587
q5 5257 5252 5222 5222
q6 208 122 123 122
q7 2235 1864 1865 1864
q8 3183 3352 3296 3296
q9 8396 8422 8404 8404
q10 3797 3653 3632 3632
q11 575 481 483 481
q12 768 577 594 577
q13 16341 2986 2969 2969
q14 300 256 272 256
q15 525 472 472 472
q16 480 425 429 425
q17 1750 1457 1460 1457
q18 7495 7699 7450 7450
q19 3483 1525 1468 1468
q20 1943 1773 1788 1773
q21 5008 4847 4879 4847
q22 580 482 487 482
Total cold run time: 71791 ms
Total hot run time: 53858 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) remove canEliminate flag on LogicalProject [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #31977:
URL: https://github.com/apache/doris/pull/31977
--
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) remove canEliminate flag on LogicalProject [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31977:
URL: https://github.com/apache/doris/pull/31977#issuecomment-2081436427
<details>
<summary>TPC-DS: <b>Total hot run time: 186677 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 6c769a0d0069dc1ec9f487f97a23f4e9fddbcc33, data reload: false
query1 927 360 348 348
query2 6294 2367 2406 2367
query3 6656 223 213 213
query4 23630 21796 21872 21796
query5 3789 440 452 440
query6 263 199 168 168
query7 4538 310 303 303
query8 243 185 189 185
query9 8450 2416 2410 2410
query10 429 246 260 246
query11 15377 14839 14807 14807
query12 117 82 83 82
query13 1670 369 376 369
query14 10702 6780 6734 6734
query15 260 165 164 164
query16 8162 280 268 268
query17 1670 563 560 560
query18 2118 278 265 265
query19 276 152 155 152
query20 90 83 81 81
query21 199 132 126 126
query22 4938 4866 4816 4816
query23 33810 33337 33114 33114
query24 11058 3020 2947 2947
query25 620 389 384 384
query26 1124 149 151 149
query27 2663 323 322 322
query28 7343 2038 2029 2029
query29 863 612 684 612
query30 256 149 147 147
query31 971 721 725 721
query32 90 51 53 51
query33 768 244 240 240
query34 1061 486 472 472
query35 802 659 656 656
query36 1091 894 916 894
query37 133 64 67 64
query38 3121 2984 2964 2964
query39 1572 1534 1661 1534
query40 204 120 124 120
query41 40 38 37 37
query42 101 93 110 93
query43 573 531 533 531
query44 1249 719 743 719
query45 269 261 271 261
query46 1071 715 735 715
query47 1935 1831 1838 1831
query48 374 296 291 291
query49 905 388 396 388
query50 793 383 380 380
query51 6797 6644 6660 6644
query52 97 86 90 86
query53 341 278 284 278
query54 307 225 235 225
query55 79 72 73 72
query56 238 215 215 215
query57 1176 1122 1130 1122
query58 219 192 199 192
query59 3640 3365 3506 3365
query60 259 230 235 230
query61 89 87 88 87
query62 645 448 451 448
query63 308 277 280 277
query64 8421 7099 7046 7046
query65 3080 3033 3026 3026
query66 885 327 330 327
query67 15619 14936 14835 14835
query68 9354 558 560 558
query69 566 308 304 304
query70 1258 1133 1079 1079
query71 512 266 286 266
query72 8236 2605 2430 2430
query73 1447 325 328 325
query74 6596 6129 6080 6080
query75 4564 2633 2688 2633
query76 5532 1040 1031 1031
query77 688 268 293 268
query78 11133 10143 10226 10143
query79 12353 522 518 518
query80 1625 439 432 432
query81 487 218 222 218
query82 774 89 89 89
query83 199 162 163 162
query84 264 84 83 83
query85 1357 267 261 261
query86 402 295 319 295
query87 3326 3075 3070 3070
query88 5301 2428 2448 2428
query89 533 365 371 365
query90 1993 184 185 184
query91 129 101 98 98
query92 60 47 48 47
query93 7212 519 515 515
query94 1167 180 181 180
query95 389 300 310 300
query96 603 269 268 268
query97 3210 2931 2943 2931
query98 227 220 217 217
query99 1270 890 858 858
Total cold run time: 310625 ms
Total hot run time: 186677 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) remove canEliminate flag on LogicalProject [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31977:
URL: https://github.com/apache/doris/pull/31977#issuecomment-2082467293
<details>
<summary>TPC-DS: <b>Total hot run time: 186482 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 ce6c00e34d8abd0f018c13fa21624762a6ff7a83, data reload: false
query1 905 355 349 349
query2 6150 2261 2238 2238
query3 6670 213 211 211
query4 25363 21945 22032 21945
query5 3890 456 437 437
query6 260 174 167 167
query7 4545 310 299 299
query8 230 182 185 182
query9 8673 2409 2429 2409
query10 433 259 245 245
query11 15316 14951 14896 14896
query12 120 87 100 87
query13 1614 378 369 369
query14 10816 6884 8530 6884
query15 277 180 169 169
query16 8252 276 270 270
query17 1976 567 558 558
query18 2062 273 273 273
query19 324 150 169 150
query20 87 84 79 79
query21 186 127 119 119
query22 4980 4859 4818 4818
query23 33871 33233 33092 33092
query24 10545 2890 2889 2889
query25 594 368 368 368
query26 699 147 146 146
query27 2101 314 316 314
query28 5822 2031 2015 2015
query29 831 595 586 586
query30 245 148 148 148
query31 928 716 738 716
query32 85 50 55 50
query33 745 242 238 238
query34 1049 471 495 471
query35 776 680 673 673
query36 1042 889 894 889
query37 106 68 66 66
query38 3126 3016 3010 3010
query39 1579 1534 1537 1534
query40 198 127 121 121
query41 42 38 37 37
query42 104 100 96 96
query43 572 487 524 487
query44 1234 750 755 750
query45 259 245 262 245
query46 1075 758 728 728
query47 1933 1834 1831 1831
query48 374 299 301 299
query49 835 390 385 385
query50 757 403 391 391
query51 6884 6604 6758 6604
query52 103 88 96 88
query53 347 277 278 277
query54 308 233 233 233
query55 77 73 72 72
query56 240 225 221 221
query57 1210 1124 1129 1124
query58 226 194 203 194
query59 3183 3064 3029 3029
query60 255 245 232 232
query61 111 85 89 85
query62 638 445 451 445
query63 309 275 284 275
query64 8178 7179 7174 7174
query65 3098 3009 3051 3009
query66 825 335 331 331
query67 15246 14750 15088 14750
query68 5319 531 541 531
query69 478 300 306 300
query70 1159 1143 1107 1107
query71 416 274 263 263
query72 7198 2611 2430 2430
query73 707 324 324 324
query74 6407 6067 6256 6067
query75 3438 2673 2641 2641
query76 3302 957 928 928
query77 384 270 273 270
query78 10941 10250 10227 10227
query79 3320 540 531 531
query80 2161 434 429 429
query81 545 222 216 216
query82 1170 97 94 94
query83 334 170 174 170
query84 263 100 83 83
query85 1448 283 289 283
query86 468 296 313 296
query87 3279 3081 3044 3044
query88 4697 2364 2361 2361
query89 489 362 376 362
query90 2008 182 182 182
query91 129 99 99 99
query92 64 52 47 47
query93 4554 507 514 507
query94 1413 188 184 184
query95 407 306 312 306
query96 625 279 271 271
query97 3243 3037 3013 3013
query98 242 211 224 211
query99 1242 885 833 833
Total cold run time: 287744 ms
Total hot run time: 186482 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) remove canEliminate flag on LogicalProject [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #31977:
URL: https://github.com/apache/doris/pull/31977#issuecomment-2084599155
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) remove canEliminate flag on LogicalProject [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #31977:
URL: https://github.com/apache/doris/pull/31977#issuecomment-2084614157
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] [opt](Nereids) remove canEliminate flag on LogicalProject [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #31977:
URL: https://github.com/apache/doris/pull/31977#issuecomment-2084285588
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) remove canEliminate flag on LogicalProject [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #31977:
URL: https://github.com/apache/doris/pull/31977#issuecomment-2082394074
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) remove canEliminate flag on LogicalProject [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #31977:
URL: https://github.com/apache/doris/pull/31977#issuecomment-1985059520
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