Re: [PR] [feat](nereids) add rewrite rule :EliminateGroupByKeyByUniform (#43391) [doris]

2024-12-09 Thread via GitHub


morrySnow merged PR #45075:
URL: https://github.com/apache/doris/pull/45075


-- 
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-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org



Re: [PR] [feat](nereids) add rewrite rule :EliminateGroupByKeyByUniform (#43391) [doris]

2024-12-05 Thread via GitHub


feiniaofeiafei commented on PR #45075:
URL: https://github.com/apache/doris/pull/45075#issuecomment-2522300328

   run cloud_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-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org



Re: [PR] [feat](nereids) add rewrite rule :EliminateGroupByKeyByUniform (#43391) [doris]

2024-12-05 Thread via GitHub


doris-robot commented on PR #45075:
URL: https://github.com/apache/doris/pull/45075#issuecomment-2522194248

   
   
   TPC-DS: Total hot run time: 195818 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit 9de5d5c54c7cced91988bc7a72def1261c4aed4f, 
data reload: false
   
   query1   1240958 919 919
   query2   6239214120862086
   query3   10858   415740814081
   query4   66329   29556   23332   23332
   query5   5520447 424 424
   query6   447 179 175 175
   query7   5683316 316 316
   query8   324 229 238 229
   query9   9278270526772677
   query10  467 283 250 250
   query11  17916   15344   15750   15344
   query12  151 103 115 103
   query13  1550426 417 417
   query14  10112   754371807180
   query15  210 184 176 176
   query16  7744519 523 519
   query17  1060584 588 584
   query18  1944319 322 319
   query19  239 159 160 159
   query20  115 110 113 110
   query21  214 112 105 105
   query22  471343974397
   query23  34355   34132   34238   34132
   query24  6125289228842884
   query25  561 410 436 410
   query26  696 184 173 173
   query27  2036300 307 300
   query28  4248251525322515
   query29  723 470 458 458
   query30  248 164 172 164
   query31  1046831 846 831
   query32  66  55  57  55
   query33  444 284 297 284
   query34  932 498 515 498
   query35  870 743 720 720
   query36  1119979 956 956
   query37  119 68  70  68
   query38  4031400239603960
   query39  1545147214591459
   query40  194 94  99  94
   query41  47  46  46  46
   query42  109 97  98  97
   query43  548 481 504 481
   query44  1177805 789 789
   query45  186 163 172 163
   query46  1175756 738 738
   query47  1970191419291914
   query48  453 376 376 376
   query49  754 366 384 366
   query50  863 425 427 425
   query51  7364733169576957
   query52  93  93  88  88
   query53  269 181 182 181
   query54  577 432 439 432
   query55  79  76  75  75
   query56  238 234 230 230
   query57  1221108311041083
   query58  200 199 219 199
   query59  3279308930183018
   query60  271 238 259 238
   query61  105 106 107 106
   query62  759 637 646 637
   query63  214 192 201 192
   query64  1752637 623 623
   query65  3246317231603160
   query66  713 296 299 296
   query67  15707   15302   15204   15204
   query68  4467552 551 551
   query69  429 253 250 250
   query70  106811251068
   query71  357 250 243 243
   query72  6448392638753875
   query73  797 344 335 335
   query74  10231   885389448853
   query75  3341261926352619
   query76  2280104810411041
   query77  474 256 264 256
   query78  10718   976194339433
   query79  8066590 587 587
   query80  1931427 417 417
   query81  560 246 243 243
   query82  1181115 114 114
   query83  259 143 146 143
   query84  289 77  81  77
   query85  1640306 295 295
   query86  447 306 281 281
   query87  4389428542144214
   query88  5696233523712335
   query89  486 300 295 295
   query90  2108184 186 184
   query91  197 141 145 141
   query92  63  47  48  47
   query93  6254533 524 524
   query94  881 267 276 267
   query95  344 247 251 247
   query96  651 280 277 277
   query97  3370315232183152
   query98  219 200 195 195
   query99  1583128212861282
   Total cold run time: 336347 ms
   Total hot run time: 195818 ms
   ```
   
   


-- 
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

Re: [PR] [feat](nereids) add rewrite rule :EliminateGroupByKeyByUniform (#43391) [doris]

2024-12-05 Thread via GitHub


doris-robot commented on PR #45075:
URL: https://github.com/apache/doris/pull/45075#issuecomment-2522182260

   
   
   TPC-H: Total hot run time: 40643 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 9de5d5c54c7cced91988bc7a72def1261c4aed4f, 
data reload: false
   
   -- Round 1 --
   q1   17616   744073687368
   q2   2048179 157 157
   q3   10663   111311751113
   q4   10550   743 698 698
   q5   7737285027952795
   q6   233 148 148 148
   q7   972 606 611 606
   q8   9346197119681968
   q9   6637644964426442
   q10  7005230523042304
   q11  457 262 264 262
   q12  404 221 218 218
   q13  17789   295630052956
   q14  232 213 207 207
   q15  563 515 522 515
   q16  692 594 602 594
   q17  982 581 544 544
   q18  7326659664566456
   q19  2820103711521037
   q20  484 199 187 187
   q21  4170322631063106
   q22  1091996 962 962
   Total cold run time: 109817 ms
   Total hot run time: 40643 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   7436730072477247
   q2   326 234 227 227
   q3   2964286528672865
   q4   1994182517371737
   q5   5684576057785760
   q6   239 143 145 143
   q7   2191180117701770
   q8   3335352834263426
   q9   8895895188508850
   q10  3572350434863486
   q11  596 506 500 500
   q12  840 619 612 612
   q13  16531   314131183118
   q14  305 267 278 267
   q15  559 518 538 518
   q16  700 652 677 652
   q17  1861162315921592
   q18  8318788273897389
   q19  1752153716051537
   q20  2070189718441844
   q21  5510536053335333
   q22  1083995 996 995
   Total cold run time: 76761 ms
   Total hot run time: 59868 ms
   ```
   
   


-- 
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-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org



Re: [PR] [feat](nereids) add rewrite rule :EliminateGroupByKeyByUniform (#43391) [doris]

2024-12-05 Thread via GitHub


feiniaofeiafei commented on PR #45075:
URL: https://github.com/apache/doris/pull/45075#issuecomment-2522094828

   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-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org



Re: [PR] [feat](nereids) add rewrite rule :EliminateGroupByKeyByUniform (#43391) [doris]

2024-12-05 Thread via GitHub


doris-robot commented on PR #45075:
URL: https://github.com/apache/doris/pull/45075#issuecomment-2522084518

   
   
   TPC-DS: Total hot run time: 194843 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit 0bcf46c3cceed1150821fe8e9c3c8b7c83efe502, 
data reload: false
   
   query1   1275929 912 912
   query2   6227214220802080
   query3   10836   418143084181
   query4   66657   29396   23451   23451
   query5   5387433 428 428
   query6   416 179 174 174
   query7   5652315 315 315
   query8   318 240 232 232
   query9   9504268926582658
   query10  522 267 255 255
   query11  17834   15117   15817   15117
   query12  165 103 107 103
   query13  1580442 435 435
   query14  10708   664468586644
   query15  215 178 184 178
   query16  8040500 466 466
   query17  1051583 592 583
   query18  2144319 326 319
   query19  207 159 154 154
   query20  115 107 111 107
   query21  208 105 104 104
   query22  4701429645364296
   query23  34606   33796   34230   33796
   query24  6175295528922892
   query25  530 413 410 410
   query26  690 182 173 173
   query27  1727305 306 305
   query28  4196255025632550
   query29  711 455 437 437
   query30  249 165 179 165
   query31  1015822 848 822
   query32  64  52  53  52
   query33  428 269 266 266
   query34  901 498 510 498
   query35  850 742 734 734
   query36  1057967 961 961
   query37  117 73  71  71
   query38  4115407639633963
   query39  1544152014671467
   query40  208 96  96  96
   query41  47  46  45  45
   query42  113 95  93  93
   query43  536 511 515 511
   query44  1192821 810 810
   query45  182 164 167 164
   query46  1135702 724 702
   query47  1981187919161879
   query48  480 379 374 374
   query49  729 388 375 375
   query50  832 416 415 415
   query51  7380720470727072
   query52  97  88  84  84
   query53  247 179 177 177
   query54  557 450 442 442
   query55  76  72  75  72
   query56  239 231 224 224
   query57  1197109611151096
   query58  202 195 199 195
   query59  3137298128322832
   query60  272 250 243 243
   query61  108 102 100 100
   query62  771 654 649 649
   query63  204 178 191 178
   query64  1807635 649 635
   query65  3280316132013161
   query66  716 296 297 296
   query67  15951   15327   15258   15258
   query68  4563545 561 545
   query69  418 255 257 255
   query70  1202112211591122
   query71  392 260 255 255
   query72  6257389840023898
   query73  753 342 335 335
   query74  10152   888689158886
   query75  3312259326372593
   query76  20201026933 933
   query77  513 258 265 258
   query78  10658   969695349534
   query79  6829585 591 585
   query80  1857427 422 422
   query81  540 246 241 241
   query82  1102121 112 112
   query83  261 146 138 138
   query84  281 82  75  75
   query85  1746305 287 287
   query86  470 296 304 296
   query87  4578421842164216
   query88  5534247923482348
   query89  421 296 289 289
   query90  2046183 181 181
   query91  177 143 143 143
   query92  66  50  47  47
   query93  5967534 533 533
   query94  895 275 290 275
   query95  354 248 247 247
   query96  630 276 272 272
   query97  3360309831413098
   query98  221 212 198 198
   query99  1625129413111294
   Total cold run time: 335613 ms
   Total hot run time: 194843 ms
   ```
   
   


-- 
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 

Re: [PR] [feat](nereids) add rewrite rule :EliminateGroupByKeyByUniform (#43391) [doris]

2024-12-05 Thread via GitHub


doris-robot commented on PR #45075:
URL: https://github.com/apache/doris/pull/45075#issuecomment-2522071969

   
   
   TPC-H: Total hot run time: 40614 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 0bcf46c3cceed1150821fe8e9c3c8b7c83efe502, 
data reload: false
   
   -- Round 1 --
   q1   17567   752672687268
   q2   2070168 167 167
   q3   10835   1200
   q4   10561   760 724 724
   q5   7783282127652765
   q6   238 148 149 148
   q7   982 609 614 609
   q8   9350196219721962
   q9   6615642764216421
   q10  6999227623412276
   q11  460 260 251 251
   q12  415 223 211 211
   q13  17785   294129712941
   q14  262 208 209 208
   q15  558 517 577 517
   q16  676 602 611 602
   q17  969 526 573 526
   q18  7253657365856573
   q19  3585104010101010
   q20  487 196 193 193
   q21  3981320731673167
   q22  1056976 964 964
   Total cold run time: 110487 ms
   Total hot run time: 40614 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   7365720371927192
   q2   331 239 224 224
   q3   2971289828662866
   q4   2059178617401740
   q5   5690569857205698
   q6   219 141 145 141
   q7   2187176017821760
   q8   3311355234203420
   q9   8946890088538853
   q10  3553354535473545
   q11  608 500 487 487
   q12  830 634 588 588
   q13  16414   310831333108
   q14  309 276 272 272
   q15  574 534 512 512
   q16  704 659 678 659
   q17  1849161416111611
   q18  8255773175927592
   q19  4478164315391539
   q20  2080186518671865
   q21  5795529052675267
   q22  11251032995 995
   Total cold run time: 79653 ms
   Total hot run time: 59934 ms
   ```
   
   


-- 
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-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org



Re: [PR] [feat](nereids) add rewrite rule :EliminateGroupByKeyByUniform (#43391) [doris]

2024-12-05 Thread via GitHub


feiniaofeiafei commented on PR #45075:
URL: https://github.com/apache/doris/pull/45075#issuecomment-2521964576

   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-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org



Re: [PR] [feat](nereids) add rewrite rule :EliminateGroupByKeyByUniform (#43391) [doris]

2024-12-05 Thread via GitHub


doris-robot commented on PR #45075:
URL: https://github.com/apache/doris/pull/45075#issuecomment-2521963100

   
   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-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org