Re: [PR] [feat](nereids) add rewrite rule :EliminateGroupByKeyByUniform (#43391) [doris]
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]
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]
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]
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]
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]
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]
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]
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]
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