Re: [PR] branch-3.0: [fix](nereids) Not use rule FOUR_PHASE_AGGREGATE_WITH_DISTINCT_WITH_FULL_DISTRIBUTE when mustUseMultiDistinctAgg #51099 [doris]
dataroaring merged PR #51139: URL: https://github.com/apache/doris/pull/51139 -- 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] branch-3.0: [fix](nereids) Not use rule FOUR_PHASE_AGGREGATE_WITH_DISTINCT_WITH_FULL_DISTRIBUTE when mustUseMultiDistinctAgg #51099 [doris]
feiniaofeiafei commented on PR #51139: URL: https://github.com/apache/doris/pull/51139#issuecomment-2900027199 run 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: [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] branch-3.0: [fix](nereids) Not use rule FOUR_PHASE_AGGREGATE_WITH_DISTINCT_WITH_FULL_DISTRIBUTE when mustUseMultiDistinctAgg #51099 [doris]
doris-robot commented on PR #51139: URL: https://github.com/apache/doris/pull/51139#issuecomment-2899869844 ClickBench: Total hot run time: 30.16 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 36156e92b0455e8e11b185088d9bdc4ba406099d, data reload: false query1 0.030.030.03 query2 0.070.030.03 query3 0.240.060.06 query4 1.630.100.11 query5 0.530.500.52 query6 1.140.730.72 query7 0.020.010.01 query8 0.030.030.03 query9 0.580.480.49 query10 0.540.540.56 query11 0.150.100.10 query12 0.140.120.11 query13 0.620.600.59 query14 0.780.780.82 query15 0.850.840.82 query16 0.390.380.39 query17 1.060.991.01 query18 0.250.220.24 query19 1.891.781.87 query20 0.010.010.01 query21 15.41 0.600.59 query22 2.842.051.98 query23 16.90 0.920.82 query24 3.261.670.71 query25 0.200.190.13 query26 0.510.130.14 query27 0.040.040.04 query28 9.900.520.50 query29 12.59 3.263.27 query30 0.250.060.06 query31 2.850.400.37 query32 3.280.460.45 query33 2.982.963.04 query34 16.99 4.584.53 query35 4.594.564.63 query36 0.680.490.48 query37 0.090.060.06 query38 0.040.030.04 query39 0.040.020.02 query40 0.150.140.13 query41 0.080.020.02 query42 0.040.020.03 query43 0.040.030.03 Total cold run time: 104.7 s Total hot run time: 30.16 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] branch-3.0: [fix](nereids) Not use rule FOUR_PHASE_AGGREGATE_WITH_DISTINCT_WITH_FULL_DISTRIBUTE when mustUseMultiDistinctAgg #51099 [doris]
doris-robot commented on PR #51139: URL: https://github.com/apache/doris/pull/51139#issuecomment-2899863358 TPC-DS: Total hot run time: 197729 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 36156e92b0455e8e11b185088d9bdc4ba406099d, data reload: false query1 1278906 897 897 query2 6260194019231923 query3 10918 440544324405 query4 61796 30837 23308 23308 query5 5184464 455 455 query6 392 173 192 173 query7 5506332 314 314 query8 309 229 217 217 query9 8409259025732573 query10 441 281 251 251 query11 17980 15240 15750 15240 query12 157 102 106 102 query13 1434453 430 430 query14 10135 686179336861 query15 207 183 187 183 query16 7190518 523 518 query17 1143603 613 603 query18 1645335 316 316 query19 212 174 167 167 query20 119 111 115 111 query21 205 111 105 105 query22 4781471245484548 query23 34569 34348 34531 34348 query24 6203296529762965 query25 529 418 446 418 query26 669 180 174 174 query27 1961363 359 359 query28 4054213621612136 query29 709 487 472 472 query30 239 165 157 157 query31 989 837 836 836 query32 73 60 59 59 query33 480 304 337 304 query34 915 515 518 515 query35 822 770 741 741 query36 1068977 972 972 query37 111 67 71 67 query38 4065402740594027 query39 1506146714951467 query40 206 100 101 100 query41 51 51 53 51 query42 108 99 97 97 query43 517 501 485 485 query44 1160826 803 803 query45 190 176 177 176 query46 1176755 779 755 query47 1990189919151899 query48 485 407 385 385 query49 738 386 403 386 query50 851 433 439 433 query51 7324726271397139 query52 109 89 88 88 query53 268 184 185 184 query54 584 465 478 465 query55 78 74 79 74 query56 266 248 260 248 query57 1257116911831169 query58 222 217 216 216 query59 3274314130253025 query60 303 279 276 276 query61 110 107 114 107 query62 776 705 679 679 query63 232 198 190 190 query64 1312658 625 625 query65 3264320632083206 query66 649 294 319 294 query67 16016 15681 15660 15660 query68 4006582 567 567 query69 423 273 271 271 query70 1170105611211056 query71 327 260 258 258 query72 6376395539523952 query73 754 346 358 346 query74 10389 933292849284 query75 3359267026592659 query76 1940976 1060976 query77 505 271 270 270 query78 10637 964996429642 query79 1638594 602 594 query80 897 437 449 437 query81 508 228 224 224 query82 127191 89 89 query83 244 174 141 141 query84 282 75 79 75 query85 890 295 298 295 query86 328 302 294 294 query87 4436433542594259 query88 3795243324112411 query89 412 291 296 291 query90 1946192 185 185 query91 181 149 145 145 query92 66 48 51 48 query93 1969555 548 548 query94 712 293 296 293 query95 352 256 255 255 query96 614 280 283 280 query97 3328318932053189 query98 227 195 190 190 query99 2057130812731273 Total cold run time: 314218 ms Total hot run time: 197729 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] branch-3.0: [fix](nereids) Not use rule FOUR_PHASE_AGGREGATE_WITH_DISTINCT_WITH_FULL_DISTRIBUTE when mustUseMultiDistinctAgg #51099 [doris]
doris-robot commented on PR #51139: URL: https://github.com/apache/doris/pull/51139#issuecomment-2899848974 TPC-H: Total hot run time: 39661 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 36156e92b0455e8e11b185088d9bdc4ba406099d, data reload: false -- Round 1 -- q1 17611 673265946594 q2 2065165 158 158 q3 10674 108411841084 q4 10568 727 691 691 q5 7757288528102810 q6 214 134 131 131 q7 980 632 610 610 q8 9351192420011924 q9 6582636364146363 q10 7029225122502250 q11 461 261 254 254 q12 388 213 207 207 q13 17795 298830202988 q14 231 210 209 209 q15 505 465 460 460 q16 500 397 383 383 q17 968 567 553 553 q18 7197661966646619 q19 14211058959 959 q20 484 199 196 196 q21 4256333832163216 q22 1132100210021002 Total cold run time: 108169 ms Total hot run time: 39661 ms - Round 2, with runtime_filter_mode=off - q1 6634663465966596 q2 328 238 235 235 q3 2991283329212833 q4 2154186718801867 q5 5744573157025702 q6 205 128 128 128 q7 2209180718141807 q8 3339354235333533 q9 8962884389108843 q10 3557353634883488 q11 580 497 495 495 q12 793 606 614 606 q13 7594313531883135 q14 299 259 265 259 q15 516 466 456 456 q16 491 444 442 442 q17 1804163516181618 q18 8154784476777677 q19 1668160515011501 q20 2095179718311797 q21 5349535253215321 q22 1145108710121012 Total cold run time: 66611 ms Total hot run time: 59351 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] branch-3.0: [fix](nereids) Not use rule FOUR_PHASE_AGGREGATE_WITH_DISTINCT_WITH_FULL_DISTRIBUTE when mustUseMultiDistinctAgg #51099 [doris]
Thearas commented on PR #51139: URL: https://github.com/apache/doris/pull/51139#issuecomment-2899805094 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]
Re: [PR] branch-3.0: [fix](nereids) Not use rule FOUR_PHASE_AGGREGATE_WITH_DISTINCT_WITH_FULL_DISTRIBUTE when mustUseMultiDistinctAgg #51099 [doris]
dataroaring closed pull request #51139: branch-3.0: [fix](nereids) Not use rule FOUR_PHASE_AGGREGATE_WITH_DISTINCT_WITH_FULL_DISTRIBUTE when mustUseMultiDistinctAgg #51099 URL: https://github.com/apache/doris/pull/51139 -- 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] branch-3.0: [fix](nereids) Not use rule FOUR_PHASE_AGGREGATE_WITH_DISTINCT_WITH_FULL_DISTRIBUTE when mustUseMultiDistinctAgg #51099 [doris]
Thearas commented on PR #51139: URL: https://github.com/apache/doris/pull/51139#issuecomment-2899805168 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]
