Re: [PR] branch-3.0:[improve](nereids)Remove use of session variable deprecated_group_by_and_having_use_alias_first (#51015) [doris]
dataroaring merged PR #51060: URL: https://github.com/apache/doris/pull/51060 -- 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] branch-3.0:[improve](nereids)Remove use of session variable deprecated_group_by_and_having_use_alias_first (#51015) [doris]
github-actions[bot] commented on PR #51060: URL: https://github.com/apache/doris/pull/51060#issuecomment-2939723475 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] branch-3.0:[improve](nereids)Remove use of session variable deprecated_group_by_and_having_use_alias_first (#51015) [doris]
github-actions[bot] commented on PR #51060: URL: https://github.com/apache/doris/pull/51060#issuecomment-2939723330 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] branch-3.0:[improve](nereids)Remove use of session variable deprecated_group_by_and_having_use_alias_first (#51015) [doris]
doris-robot commented on PR #51060: URL: https://github.com/apache/doris/pull/51060#issuecomment-2893215825 ClickBench: Total hot run time: 33.26 s ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools ClickBench test result on commit a885cc9e205b0dcdf70efb504b1486b6b7bd13fd, data reload: false query1 0.030.030.03 query2 0.080.030.03 query3 0.240.060.07 query4 1.620.100.10 query5 0.530.530.52 query6 1.130.730.73 query7 0.020.020.02 query8 0.040.030.04 query9 0.570.510.50 query10 0.550.550.55 query11 0.150.110.10 query12 0.140.100.11 query13 0.600.600.60 query14 2.742.742.75 query15 0.900.810.82 query16 0.380.380.38 query17 1.071.071.06 query18 0.240.220.22 query19 1.921.842.02 query20 0.010.010.01 query21 15.37 0.620.57 query22 2.612.262.14 query23 16.84 1.130.79 query24 3.131.702.35 query25 0.240.070.07 query26 0.730.140.14 query27 0.050.040.05 query28 8.540.510.51 query29 12.58 3.233.23 query30 0.240.050.06 query31 2.860.380.39 query32 3.240.470.46 query33 2.992.993.03 query34 17.02 4.484.46 query35 4.524.534.54 query36 0.660.480.49 query37 0.090.060.06 query38 0.050.040.03 query39 0.040.020.02 query40 0.160.130.12 query41 0.080.020.03 query42 0.030.020.02 query43 0.030.020.02 Total cold run time: 105.06 s Total hot run time: 33.26 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] branch-3.0:[improve](nereids)Remove use of session variable deprecated_group_by_and_having_use_alias_first (#51015) [doris]
doris-robot commented on PR #51060: URL: https://github.com/apache/doris/pull/51060#issuecomment-2893202079 TPC-DS: Total hot run time: 197785 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 a885cc9e205b0dcdf70efb504b1486b6b7bd13fd, data reload: false query1 1337944 903 903 query2 6340200619921992 query3 10834 429243754292 query4 60695 29757 23582 23582 query5 5244475 450 450 query6 391 170 176 170 query7 5432328 302 302 query8 309 228 228 228 query9 8514262725982598 query10 441 267 268 267 query11 17851 15203 15634 15203 query12 171 109 104 104 query13 1440465 451 451 query14 10346 720672557206 query15 206 181 184 181 query16 7092512 453 453 query17 1175589 599 589 query18 1844331 325 325 query19 217 161 160 160 query20 117 111 110 110 query21 214 105 106 105 query22 4656453846234538 query23 34503 33824 33692 33692 query24 6134297229772972 query25 549 423 431 423 query26 660 174 169 169 query27 2084382 376 376 query28 4486248924542454 query29 724 483 443 443 query30 246 160 159 159 query31 981 818 851 818 query32 66 57 56 56 query33 465 278 291 278 query34 921 514 516 514 query35 856 736 724 724 query36 1076998 966 966 query37 117 69 64 64 query38 4086397040273970 query39 1543147915081479 query40 212 101 100 100 query41 48 47 47 47 query42 118 100 100 100 query43 538 489 494 489 query44 1181821 847 821 query45 185 167 167 167 query46 1152753 745 745 query47 2025189919621899 query48 497 388 384 384 query49 739 408 394 394 query50 841 443 425 425 query51 7508719873867198 query52 106 92 89 89 query53 262 190 197 190 query54 582 458 473 458 query55 88 81 82 81 query56 268 270 254 254 query57 1297117711611161 query58 220 212 221 212 query59 3176314530093009 query60 285 259 258 258 query61 169 143 112 112 query62 787 672 690 672 query63 229 196 194 194 query64 1391683 649 649 query65 3271320531963196 query66 706 305 300 300 query67 15988 15788 15582 15582 query68 4031618 575 575 query69 441 272 272 272 query70 1198110311061103 query71 353 259 266 259 query72 6339396040563960 query73 758 357 370 357 query74 10463 919091889188 query75 3383268626502650 query76 2038104310371037 query77 484 276 285 276 query78 10798 957895799578 query79 1349605 612 605 query80 860 446 427 427 query81 531 243 240 240 query82 130891 87 87 query83 244 144 143 143 query84 287 84 77 77 query85 879 301 297 297 query86 327 304 301 301 query87 4460429643374296 query88 3893242523912391 query89 427 298 298 298 query90 2038191 190 190 query91 190 150 152 150 query92 65 51 51 51 query93 1872573 585 573 query94 746 298 283 283 query95 350 268 259 259 query96 627 281 281 281 query97 3335318131373137 query98 219 196 212 196 query99 1515129613071296 Total cold run time: 314040 ms Total hot run time: 197785 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] branch-3.0:[improve](nereids)Remove use of session variable deprecated_group_by_and_having_use_alias_first (#51015) [doris]
doris-robot commented on PR #51060: URL: https://github.com/apache/doris/pull/51060#issuecomment-2893171821 TPC-H: Total hot run time: 40013 ms ``` machine: 'aliyun_ecs.c7a.8xlarge_32C64G' scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools Tpch sf100 test result on commit a885cc9e205b0dcdf70efb504b1486b6b7bd13fd, data reload: false -- Round 1 -- q1 17573 686766696669 q2 2055165 175 165 q3 10696 107011441070 q4 10558 783 736 736 q5 7732288227842784 q6 224 135 133 133 q7 980 620 606 606 q8 9591195720101957 q9 7002638264316382 q10 7013227722772277 q11 463 265 257 257 q12 405 207 212 207 q13 17765 296130122961 q14 232 214 201 201 q15 494 461 459 459 q16 665 596 577 577 q17 990 533 548 533 q18 7173661165476547 q19 1406108711281087 q20 498 203 206 203 q21 4036321232923212 q22 1089990 1003990 Total cold run time: 108640 ms Total hot run time: 40013 ms - Round 2, with runtime_filter_mode=off - q1 6625666066786660 q2 339 239 237 237 q3 2901280729602807 q4 2076182318331823 q5 5784574357095709 q6 222 131 132 131 q7 2232180117831783 q8 3417360135263526 q9 8887886489088864 q10 3539355535333533 q11 589 502 486 486 q12 823 580 598 580 q13 8408310531633105 q14 299 272 276 272 q15 529 475 473 473 q16 704 670 644 644 q17 1847163916281628 q18 8164760778687607 q19 1735161116081608 q20 2113179718271797 q21 5786537552955295 q22 1104105010271027 Total cold run time: 68123 ms Total hot run time: 59595 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] branch-3.0:[improve](nereids)Remove use of session variable deprecated_group_by_and_having_use_alias_first (#51015) [doris]
Jibing-Li commented on PR #51060: URL: https://github.com/apache/doris/pull/51060#issuecomment-2893088807 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] branch-3.0:[improve](nereids)Remove use of session variable deprecated_group_by_and_having_use_alias_first (#51015) [doris]
hello-stephen commented on PR #51060: URL: https://github.com/apache/doris/pull/51060#issuecomment-2893079424 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
