Re: [PR] [improve](nereids)Remove use of session variable deprecated_group_by_and_having_use_alias_first [doris]
Jibing-Li merged PR #51015: URL: https://github.com/apache/doris/pull/51015 -- 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] [improve](nereids)Remove use of session variable deprecated_group_by_and_having_use_alias_first [doris]
doris-robot commented on PR #51015: URL: https://github.com/apache/doris/pull/51015#issuecomment-2892737528 ClickBench: Total hot run time: 28.99 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 81fc88eab71a5f585356e830054565bd00baf81b, data reload: false query1 0.040.030.04 query2 0.130.100.11 query3 0.260.190.19 query4 1.600.200.10 query5 0.420.430.44 query6 1.190.670.66 query7 0.020.010.02 query8 0.040.030.04 query9 0.590.520.53 query10 0.580.610.58 query11 0.160.120.12 query12 0.150.130.13 query13 0.620.600.60 query14 0.840.810.82 query15 0.910.860.88 query16 0.390.400.39 query17 1.071.051.10 query18 0.240.220.22 query19 1.961.831.84 query20 0.010.010.01 query21 15.41 0.900.57 query22 0.761.490.71 query23 14.77 1.390.64 query24 7.901.550.38 query25 0.300.260.08 query26 0.630.170.14 query27 0.050.060.05 query28 8.760.920.44 query29 12.61 4.093.43 query30 0.260.090.07 query31 2.830.600.41 query32 3.230.550.49 query33 3.083.113.08 query34 15.92 5.114.51 query35 4.604.604.49 query36 0.670.500.49 query37 0.100.080.07 query38 0.060.050.04 query39 0.040.030.03 query40 0.180.140.13 query41 0.080.020.03 query42 0.030.030.02 query43 0.040.040.03 Total cold run time: 103.53 s Total hot run time: 28.99 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: 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] [improve](nereids)Remove use of session variable deprecated_group_by_and_having_use_alias_first [doris]
doris-robot commented on PR #51015: URL: https://github.com/apache/doris/pull/51015#issuecomment-2892731403 TPC-DS: Total hot run time: 197022 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 81fc88eab71a5f585356e830054565bd00baf81b, data reload: false query1 1438113010781078 query2 6229197019901970 query3 11198 467346284628 query4 26053 23551 23441 23441 query5 4681671 516 516 query6 322 224 217 217 query7 3999531 313 313 query8 321 283 261 261 query9 8563289428662866 query10 482 341 292 292 query11 15452 15098 14874 14874 query12 175 122 114 114 query13 1581585 451 451 query14 9841634264496342 query15 209 197 176 176 query16 7598699 519 519 query17 1230769 635 635 query18 2051415 331 331 query19 215 202 175 175 query20 152 153 122 122 query21 225 133 121 121 query22 4541458545844584 query23 34785 33689 33892 33689 query24 8476247724892477 query25 539 500 431 431 query26 1399295 158 158 query27 2870547 372 372 query28 4794235923782359 query29 738 612 495 495 query30 289 231 204 204 query31 943 884 824 824 query32 86 78 80 78 query33 563 403 345 345 query34 866 921 572 572 query35 847 848 783 783 query36 10141085968 968 query37 120 108 78 78 query38 4264439042784278 query39 1529148214921482 query40 223 134 116 116 query41 61 56 56 56 query42 131 121 117 117 query43 560 600 529 529 query44 1498916 937 916 query45 190 189 169 169 query46 920 1077706 706 query47 1816188318201820 query48 441 474 347 347 query49 789 571 456 456 query50 744 720 444 444 query51 4313427042494249 query52 122 126 113 113 query53 254 285 212 212 query54 671 653 563 563 query55 98 95 94 94 query56 330 326 295 295 query57 1210121211431143 query58 295 284 286 284 query59 2780288128712871 query60 370 371 339 339 query61 132 135 138 135 query62 797 737 704 704 query63 251 204 206 204 query64 39741124722 722 query65 4405433242584258 query66 931 415 318 318 query67 16301 15880 15636 15636 query68 8936976 584 584 query69 510 325 295 295 query70 1304119712071197 query71 501 349 331 331 query72 5562492648784878 query73 725 669 398 398 query74 9239925590879087 query75 4137323726962696 query76 37441225811 811 query77 814 423 310 310 query78 10202 10608 93859385 query79 1261855 606 606 query80 743 538 491 491 query81 484 252 226 226 query82 444 134 101 101 query83 315 263 254 254 query84 284 115 89 89 query85 783 412 321 321 query86 352 310 304 304 query87 4451452143294329 query88 3068248524522452 query89 414 323 295 295 query90 1941215 207 207 query91 149 151 115 115 query92 72 62 56 56 query93 10901001635 635 query94 662 416 313 313 query95 393 311 305 305 query96 537 600 297 297 query97 2737280827052705 query98 253 227 210 210 query99 1460142313041304 Total cold run time: 282852 ms Total hot run time: 197022 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
Re: [PR] [improve](nereids)Remove use of session variable deprecated_group_by_and_having_use_alias_first [doris]
doris-robot commented on PR #51015: URL: https://github.com/apache/doris/pull/51015#issuecomment-2892717821 TPC-H: Total hot run time: 35401 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 81fc88eab71a5f585356e830054565bd00baf81b, data reload: false -- Round 1 -- q1 27490 505951275059 q2 2100293 201 201 q3 10372 1229718 718 q4 10229 999 556 556 q5 7521234623392339 q6 187 163 136 136 q7 949 761 623 623 q8 9328131511261126 q9 6980520450915091 q10 6899232419221922 q11 503 297 295 295 q12 371 360 227 227 q13 17813 384133863386 q14 270 240 221 221 q15 538 495 491 491 q16 472 464 407 407 q17 649 876 403 403 q18 7757722672007200 q19 1404965 602 602 q20 367 351 241 241 q21 4274332131823182 q22 11061052975 975 Total cold run time: 117579 ms Total hot run time: 35401 ms - Round 2, with runtime_filter_mode=off - q1 5159509250755075 q2 252 322 238 238 q3 2274270223272327 q4 1555195714671467 q5 4516436743614361 q6 216 169 127 127 q7 2031202617951795 q8 2572255125812551 q9 7232690772276907 q10 2995322027412741 q11 598 531 498 498 q12 746 792 630 630 q13 3565396634063406 q14 304 308 297 297 q15 524 480 494 480 q16 448 515 462 462 q17 1202159713631363 q18 7697768574247424 q19 835 831 884 831 q20 1922199019301930 q21 5076460645194519 q22 1129112210401040 Total cold run time: 52848 ms Total hot run time: 50469 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] [improve](nereids)Remove use of session variable deprecated_group_by_and_having_use_alias_first [doris]
github-actions[bot] commented on PR #51015: URL: https://github.com/apache/doris/pull/51015#issuecomment-2892662337 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-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] [improve](nereids)Remove use of session variable deprecated_group_by_and_having_use_alias_first [doris]
Jibing-Li commented on PR #51015: URL: https://github.com/apache/doris/pull/51015#issuecomment-2892658833 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] [improve](nereids)Remove use of session variable deprecated_group_by_and_having_use_alias_first [doris]
doris-robot commented on PR #51015: URL: https://github.com/apache/doris/pull/51015#issuecomment-2890071693 ClickBench: Total hot run time: 28.87 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit 9b7b7c11b2ea5bddca649575e8f1e7c35c955985, data reload: false query1 0.040.050.03 query2 0.130.110.11 query3 0.260.200.19 query4 1.590.200.11 query5 0.430.400.42 query6 1.150.660.67 query7 0.030.020.02 query8 0.050.030.03 query9 0.580.530.51 query10 0.560.580.57 query11 0.150.120.11 query12 0.140.120.12 query13 0.600.610.60 query14 0.780.820.81 query15 0.870.850.85 query16 0.370.380.38 query17 1.011.021.06 query18 0.240.210.21 query19 1.961.881.88 query20 0.010.010.02 query21 15.43 0.900.53 query22 0.751.180.64 query23 15.02 1.410.57 query24 7.311.410.57 query25 0.490.090.18 query26 0.640.170.15 query27 0.060.050.05 query28 9.040.840.44 query29 12.59 4.053.39 query30 0.250.090.07 query31 2.840.590.40 query32 3.230.550.48 query33 3.003.063.07 query34 15.73 5.134.54 query35 4.504.524.47 query36 0.670.500.48 query37 0.090.060.06 query38 0.050.040.04 query39 0.030.030.02 query40 0.180.130.13 query41 0.080.030.02 query42 0.040.020.02 query43 0.040.030.03 Total cold run time: 103.01 s Total hot run time: 28.87 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: 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] [improve](nereids)Remove use of session variable deprecated_group_by_and_having_use_alias_first [doris]
doris-robot commented on PR #51015: URL: https://github.com/apache/doris/pull/51015#issuecomment-2890056934 TPC-DS: Total hot run time: 186621 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 9b7b7c11b2ea5bddca649575e8f1e7c35c955985, data reload: false query1 1032475 505 475 query2 6834194019121912 query3 6765220 229 220 query4 26128 23705 23106 23106 query5 5106610 448 448 query6 327 219 203 203 query7 4630520 305 305 query8 305 249 251 249 query9 8604264726442644 query10 496 336 275 275 query11 15394 15140 14786 14786 query12 178 111 118 111 query13 1662531 394 394 query14 9667620662066206 query15 199 185 180 180 query16 7642640 462 462 query17 1134693 559 559 query18 2007386 294 294 query19 189 185 163 163 query20 119 123 120 120 query21 218 159 108 108 query22 4126407440164016 query23 33996 33128 33113 33113 query24 8443238324132383 query25 519 462 420 420 query26 1244286 158 158 query27 2726517 340 340 query28 4326213421162116 query29 729 578 427 427 query30 284 209 189 189 query31 921 816 760 760 query32 74 65 73 65 query33 557 375 316 316 query34 806 864 520 520 query35 790 819 728 728 query36 946 993 896 896 query37 117 95 79 79 query38 4101414541134113 query39 1494143514321432 query40 212 124 115 115 query41 65 61 59 59 query42 124 115 118 115 query43 506 500 477 477 query44 1342857 838 838 query45 188 176 169 169 query46 845 1036650 650 query47 1753179117271727 query48 400 430 342 342 query49 801 545 482 482 query50 656 706 405 405 query51 4083413640824082 query52 120 109 104 104 query53 233 268 189 189 query54 616 587 527 527 query55 95 86 87 86 query56 327 330 309 309 query57 1119118410791079 query58 274 259 256 256 query59 2702266926352635 query60 350 338 316 316 query61 129 129 126 126 query62 809 730 657 657 query63 230 187 189 187 query64 42581003735 735 query65 4374420342384203 query66 1075417 319 319 query67 16069 15550 15364 15364 query68 8178909 521 521 query69 488 319 278 278 query70 1226113411611134 query71 468 334 313 313 query72 5564476747424742 query73 706 609 371 371 query74 8951889288558855 query75 3866326627132713 query76 37761218782 782 query77 803 377 293 293 query78 10124 10065 94119411 query79 2638837 603 603 query80 629 525 454 454 query81 494 259 220 220 query82 448 125 99 99 query83 279 309 238 238 query84 293 102 87 87 query85 758 346 310 310 query86 389 315 317 315 query87 4416449243854385 query88 3487235623572356 query89 394 325 286 286 query90 1991220 222 220 query91 147 147 110 110 query92 78 68 59 59 query93 1820953 578 578 query94 683 409 302 302 query95 378 297 292 292 query96 517 588 289 289 query97 2742276926542654 query98 251 210 209 209 query99 1445139412981298 Total cold run time: 277017 ms Total hot run time: 186621 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] [improve](nereids)Remove use of session variable deprecated_group_by_and_having_use_alias_first [doris]
doris-robot commented on PR #51015: URL: https://github.com/apache/doris/pull/51015#issuecomment-2890010697 TPC-H: Total hot run time: 33916 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit 9b7b7c11b2ea5bddca649575e8f1e7c35c955985, data reload: false -- Round 1 -- q1 26399 499450834994 q2 2084306 202 202 q3 10490 1282726 726 q4 10256 990 524 524 q5 7778238023462346 q6 182 163 130 130 q7 917 740 613 613 q8 9331130311431143 q9 6851506351425063 q10 6873234618961896 q11 496 294 274 274 q12 351 355 213 213 q13 17799 370231083108 q14 243 240 213 213 q15 546 486 475 475 q16 431 421 388 388 q17 609 868 365 365 q18 7713728071127112 q19 1667962 573 573 q20 331 336 225 225 q21 3739315723532353 q22 10861010980 980 Total cold run time: 116172 ms Total hot run time: 33916 ms - Round 2, with runtime_filter_mode=off - q1 5203507450545054 q2 253 325 237 237 q3 2211266823122312 q4 1338176613961396 q5 4263411541384115 q6 210 165 125 125 q7 1902182916881688 q8 2482243624592436 q9 6799675467886754 q10 2923310426662666 q11 569 483 476 476 q12 665 730 580 580 q13 3336371430763076 q14 279 303 259 259 q15 514 474 462 462 q16 417 514 437 437 q17 1130153814041404 q18 7484719870327032 q19 790 755 819 755 q20 1903199718181818 q21 4658440842464246 q22 10801020981 981 Total cold run time: 50409 ms Total hot run time: 48309 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] [improve](nereids)Remove use of session variable deprecated_group_by_and_having_use_alias_first [doris]
github-actions[bot] commented on PR #51015: URL: https://github.com/apache/doris/pull/51015#issuecomment-2889824558 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-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] [improve](nereids)Remove use of session variable deprecated_group_by_and_having_use_alias_first [doris]
github-actions[bot] commented on PR #51015: URL: https://github.com/apache/doris/pull/51015#issuecomment-2889824635 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-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] [improve](nereids)Remove use of session variable deprecated_group_by_and_having_use_alias_first [doris]
Jibing-Li commented on PR #51015: URL: https://github.com/apache/doris/pull/51015#issuecomment-2889754148 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] [improve](nereids)Remove use of session variable deprecated_group_by_and_having_use_alias_first [doris]
Jibing-Li commented on PR #51015: URL: https://github.com/apache/doris/pull/51015#issuecomment-2889734560 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] [improve](nereids)Remove use of session variable deprecated_group_by_and_having_use_alias_first [doris]
Thearas commented on PR #51015: URL: https://github.com/apache/doris/pull/51015#issuecomment-2889732236 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
