Re: [PR] [fix](Nereids) not process must shuffle when regulate can not be banned agg [doris]
morrySnow merged PR #52827: URL: https://github.com/apache/doris/pull/52827 -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [fix](Nereids) not process must shuffle when regulate can not be banned agg [doris]
github-actions[bot] commented on PR #52827: URL: https://github.com/apache/doris/pull/52827#issuecomment-3043928154 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [fix](Nereids) not process must shuffle when regulate can not be banned agg [doris]
github-actions[bot] commented on PR #52827: URL: https://github.com/apache/doris/pull/52827#issuecomment-3043928280 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [fix](Nereids) not process must shuffle when regulate can not be banned agg [doris]
doris-robot commented on PR #52827: URL: https://github.com/apache/doris/pull/52827#issuecomment-3043697988 ClickBench: Total hot run time: 29.18 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit d8819cbea1ce03bd15642f16c85784718677945e, data reload: false query1 0.040.030.04 query2 0.070.040.04 query3 0.240.080.08 query4 1.600.110.11 query5 0.460.410.44 query6 1.190.660.66 query7 0.020.020.01 query8 0.040.030.04 query9 0.610.520.53 query10 0.570.560.56 query11 0.160.110.11 query12 0.150.120.11 query13 0.640.610.62 query14 0.800.810.81 query15 0.900.860.87 query16 0.400.390.38 query17 1.061.081.06 query18 0.230.220.22 query19 1.951.931.92 query20 0.020.010.01 query21 15.39 0.880.55 query22 0.741.180.64 query23 15.01 1.380.64 query24 7.730.620.35 query25 0.290.130.10 query26 0.510.160.14 query27 0.060.050.06 query28 9.300.900.44 query29 12.54 4.023.34 query30 0.260.090.06 query31 2.830.580.42 query32 3.230.550.47 query33 3.073.143.09 query34 16.09 5.364.77 query35 4.844.764.85 query36 0.700.530.48 query37 0.090.070.06 query38 0.050.040.04 query39 0.030.030.02 query40 0.180.140.14 query41 0.080.020.03 query42 0.040.030.03 query43 0.030.030.03 Total cold run time: 104.24 s Total hot run time: 29.18 s ``` -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [fix](Nereids) not process must shuffle when regulate can not be banned agg [doris]
doris-robot commented on PR #52827: URL: https://github.com/apache/doris/pull/52827#issuecomment-3043680778 TPC-DS: Total hot run time: 185531 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 d8819cbea1ce03bd15642f16c85784718677945e, data reload: false query1 982 391 391 391 query2 6541174017241724 query3 6735211 208 208 query4 26321 23890 23022 23022 query5 4338563 443 443 query6 309 213 213 213 query7 4617483 293 293 query8 266 228 213 213 query9 8608260926202609 query10 491 321 269 269 query11 15812 15052 14786 14786 query12 158 114 108 108 query13 1658547 436 436 query14 9090592358555855 query15 204 194 180 180 query16 7690439 272 272 query17 1311729 588 588 query18 2005418 304 304 query19 200 190 161 161 query20 134 120 114 114 query21 216 130 114 114 query22 4165419940234023 query23 34612 33084 32951 32951 query24 8496235924142359 query25 532 468 386 386 query26 1222268 145 145 query27 2778516 344 344 query28 4283212321132113 query29 734 556 435 435 query30 287 235 197 197 query31 922 832 729 729 query32 76 63 63 63 query33 550 360 283 283 query34 790 839 521 521 query35 622 634 560 560 query36 944 972 882 882 query37 109 98 77 77 query38 4185417240414041 query39 1514141714671417 query40 210 115 105 105 query41 55 55 51 51 query42 122 104 102 102 query43 509 503 484 484 query44 1314816 815 815 query45 173 170 161 161 query46 854 1010622 622 query47 1738180417061706 query48 389 421 323 323 query49 713 467 398 398 query50 658 687 413 413 query51 4182427141254125 query52 106 106 105 105 query53 231 248 179 179 query54 589 587 507 507 query55 79 80 79 79 query56 297 307 266 266 query57 11891188 query58 263 266 264 264 query59 2620268625382538 query60 324 322 300 300 query61 124 123 116 116 query62 811 699 663 663 query63 224 190 190 190 query64 43261209866 866 query65 4222416141624161 query66 1095410 309 309 query67 15724 15463 15402 15402 query68 8668884 532 532 query69 492 306 267 267 query70 1193108711051087 query71 460 326 291 291 query72 5296469346964693 query73 696 558 348 348 query74 8913909689428942 query75 3932318127092709 query76 36101141707 707 query77 777 385 296 296 query78 10965 11218 10414 10414 query79 2127911 588 588 query80 588 510 447 447 query81 490 255 216 216 query82 442 127 96 96 query83 255 251 234 234 query84 250 98 85 85 query85 814 367 315 315 query86 386 319 278 278 query87 4502443743184318 query88 3650228122782278 query89 377 327 288 288 query90 1833211 209 209 query91 142 140 111 111 query92 78 62 56 56 query93 1603954 595 595 query94 678 312 194 194 query95 386 282 284 282 query96 494 560 323 323 query97 2742277626672667 query98 228 201 206 201 query99 1683140212741274 Total cold run time: 276398 ms Total hot run time: 185531 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 t
Re: [PR] [fix](Nereids) not process must shuffle when regulate can not be banned agg [doris]
doris-robot commented on PR #52827: URL: https://github.com/apache/doris/pull/52827#issuecomment-3043653884 TPC-H: Total hot run time: 33217 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit d8819cbea1ce03bd15642f16c85784718677945e, data reload: false -- Round 1 -- q1 17590 510251715102 q2 1935276 186 186 q3 10344 1297711 711 q4 10430 1021507 507 q5 8546242523542354 q6 215 163 129 129 q7 901 760 609 609 q8 9329130510551055 q9 7138513551795135 q10 6931237519701970 q11 522 303 284 284 q12 346 350 215 215 q13 17760 363930483048 q14 228 231 219 219 q15 559 482 471 471 q16 428 419 393 393 q17 575 851 346 346 q18 7420724271207120 q19 1365925 529 529 q20 319 338 223 223 q21 3697255223152315 q22 358 313 296 296 Total cold run time: 106936 ms Total hot run time: 33217 ms - Round 2, with runtime_filter_mode=off - q1 5086504650575046 q2 237 334 220 220 q3 2155262022892289 q4 1384174813451345 q5 4149428445774284 q6 242 175 131 131 q7 2008189318281828 q8 2614249924482448 q9 7366736072897289 q10 3177328628812881 q11 593 523 492 492 q12 922 763 617 617 q13 3412402533303330 q14 285 318 296 296 q15 517 466 474 466 q16 452 493 450 450 q17 1142161613661366 q18 7733792774547454 q19 813 797 851 797 q20 2036205019301930 q21 4621435341784178 q22 617 577 548 548 Total cold run time: 51561 ms Total hot run time: 49685 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [fix](Nereids) not process must shuffle when regulate can not be banned agg [doris]
morrySnow commented on PR #52827: URL: https://github.com/apache/doris/pull/52827#issuecomment-3043573891 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [fix](Nereids) not process must shuffle when regulate can not be banned agg [doris]
doris-robot commented on PR #52827: URL: https://github.com/apache/doris/pull/52827#issuecomment-3039343666 ClickBench: Total hot run time: 29.41 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 2b3c64963f83c5323390ea9838ef17f2b281af0a, data reload: false query1 0.040.040.04 query2 0.080.040.04 query3 0.240.080.08 query4 1.610.110.11 query5 0.430.430.41 query6 1.180.660.65 query7 0.030.020.02 query8 0.040.040.04 query9 0.610.520.53 query10 0.570.570.57 query11 0.160.110.11 query12 0.140.120.12 query13 0.630.610.61 query14 0.810.810.80 query15 0.900.870.86 query16 0.390.370.39 query17 1.031.061.04 query18 0.220.220.22 query19 1.971.821.81 query20 0.010.010.02 query21 15.45 0.900.56 query22 0.761.200.70 query23 14.85 1.380.65 query24 7.371.360.65 query25 0.480.170.10 query26 0.620.180.14 query27 0.060.060.05 query28 9.630.860.44 query29 12.59 3.963.30 query30 0.240.100.07 query31 2.840.590.40 query32 3.250.550.47 query33 3.053.043.12 query34 16.14 5.374.76 query35 4.774.844.83 query36 0.670.520.49 query37 0.090.070.07 query38 0.060.040.04 query39 0.030.030.02 query40 0.180.140.14 query41 0.090.020.03 query42 0.030.020.03 query43 0.040.020.02 Total cold run time: 104.38 s Total hot run time: 29.41 s ``` -- 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [fix](Nereids) not process must shuffle when regulate can not be banned agg [doris]
doris-robot commented on PR #52827: URL: https://github.com/apache/doris/pull/52827#issuecomment-3039333150 TPC-DS: Total hot run time: 185394 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 2b3c64963f83c5323390ea9838ef17f2b281af0a, data reload: false query1 990 389 385 385 query2 6538171016471647 query3 6740209 212 209 query4 26452 23201 22965 22965 query5 4371584 421 421 query6 300 210 186 186 query7 4609484 277 277 query8 270 212 211 211 query9 8607261126232611 query10 481 333 274 274 query11 15324 15053 14890 14890 query12 149 107 101 101 query13 1659524 406 406 query14 8579576857485748 query15 200 187 175 175 query16 7129631 461 461 query17 964 731 607 607 query18 1990407 318 318 query19 199 198 163 163 query20 125 122 114 114 query21 217 123 106 106 query22 4296466345374537 query23 34704 33875 33370 33370 query24 8440237323532353 query25 538 497 391 391 query26 1232258 145 145 query27 2776496 334 334 query28 4294212520842084 query29 760 550 443 443 query30 283 216 187 187 query31 896 809 772 772 query32 67 57 59 57 query33 566 358 300 300 query34 797 843 510 510 query35 791 827 750 750 query36 930 980 875 875 query37 114 101 73 73 query38 4112414740844084 query39 1473139413941394 query40 211 116 103 103 query41 54 56 50 50 query42 122 104 104 104 query43 485 503 478 478 query44 1331847 815 815 query45 179 177 168 168 query46 868 1003642 642 query47 1721178717131713 query48 391 416 306 306 query49 723 491 394 394 query50 634 686 403 403 query51 4166427541094109 query52 115 111 100 100 query53 247 263 185 185 query54 602 589 511 511 query55 84 86 85 85 query56 310 305 280 280 query57 1201122011331133 query58 266 254 268 254 query59 2735276326082608 query60 347 324 333 324 query61 131 122 122 122 query62 800 710 667 667 query63 230 187 186 186 query64 43851039644 644 query65 4283423441854185 query66 1130394 297 297 query67 15866 15559 15243 15243 query68 8457880 531 531 query69 494 317 269 269 query70 1253113711351135 query71 457 328 302 302 query72 5687463345944594 query73 697 555 349 349 query74 8841911089078907 query75 3807321827242724 query76 36401164833 833 query77 784 436 300 300 query78 10082 10032 93559355 query79 2936816 574 574 query80 627 508 460 460 query81 499 254 219 219 query82 488 125 95 95 query83 277 262 228 228 query84 293 99 97 97 query85 802 358 308 308 query86 381 303 288 288 query87 4337446443004300 query88 3402227222542254 query89 392 324 282 282 query90 1843202 204 202 query91 136 139 115 115 query92 70 56 57 56 query93 2499962 576 576 query94 663 417 335 335 query95 369 285 280 280 query96 491 569 276 276 query97 2697279126532653 query98 238 196 202 196 query99 1427141412581258 Total cold run time: 275645 ms Total hot run time: 185394 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] [fix](Nereids) not process must shuffle when regulate can not be banned agg [doris]
doris-robot commented on PR #52827: URL: https://github.com/apache/doris/pull/52827#issuecomment-3039308275 TPC-H: Total hot run time: 33775 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 2b3c64963f83c5323390ea9838ef17f2b281af0a, data reload: false -- Round 1 -- q1 17585 515050265026 q2 1919282 185 185 q3 10319 1296690 690 q4 10215 1020514 514 q5 7526238123582358 q6 178 162 129 129 q7 878 742 592 592 q8 9308126910721072 q9 6717509250565056 q10 6869238619631963 q11 492 293 273 273 q12 348 356 219 219 q13 17747 363430813081 q14 239 224 223 223 q15 537 484 478 478 q16 414 419 381 381 q17 594 860 351 351 q18 7487732971117111 q19 1074938 556 556 q20 339 337 220 220 q21 3761316423332333 q22 10831046964 964 Total cold run time: 105629 ms Total hot run time: 33775 ms - Round 2, with runtime_filter_mode=off - q1 5133505651015056 q2 234 323 224 224 q3 2180268522792279 q4 1378177713381338 q5 4224444646234446 q6 217 170 126 126 q7 2034197018781878 q8 2643261325732573 q9 7271725372287228 q10 3088328328592859 q11 568 509 499 499 q12 719 835 683 683 q13 3848397434253425 q14 283 307 297 297 q15 529 472 489 472 q16 457 497 443 443 q17 1168158514001400 q18 8141769277017692 q19 779 841 1003841 q20 2074207419101910 q21 4990469244724472 q22 1150110610861086 Total cold run time: 53108 ms Total hot run time: 51227 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [fix](Nereids) not process must shuffle when regulate can not be banned agg [doris]
morrySnow commented on PR #52827: URL: https://github.com/apache/doris/pull/52827#issuecomment-3039272398 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
Re: [PR] [fix](Nereids) not process must shuffle when regulate can not be banned agg [doris]
Thearas commented on PR #52827: URL: https://github.com/apache/doris/pull/52827#issuecomment-3039270767 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: [email protected] For queries about this service, please contact Infrastructure at: [email protected] - To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
