You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Jibing-Li (via GitHub)" <gi...@apache.org> on 2025/05/20 06:11:16 UTC
[PR] branch-3.0:[improve](nereids)Remove use of session variable deprecated_group_by_and_having_use_alias_first (#51015) [doris]
Jibing-Li opened a new pull request, #51060:
URL: https://github.com/apache/doris/pull/51060
backport: 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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@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]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@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]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@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]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@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]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51060:
URL: https://github.com/apache/doris/pull/51060#issuecomment-2893215825
<details>
<summary>ClickBench: <b>Total hot run time: 33.26 s</b></summary>
```
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.03 0.03 0.03
query2 0.08 0.03 0.03
query3 0.24 0.06 0.07
query4 1.62 0.10 0.10
query5 0.53 0.53 0.52
query6 1.13 0.73 0.73
query7 0.02 0.02 0.02
query8 0.04 0.03 0.04
query9 0.57 0.51 0.50
query10 0.55 0.55 0.55
query11 0.15 0.11 0.10
query12 0.14 0.10 0.11
query13 0.60 0.60 0.60
query14 2.74 2.74 2.75
query15 0.90 0.81 0.82
query16 0.38 0.38 0.38
query17 1.07 1.07 1.06
query18 0.24 0.22 0.22
query19 1.92 1.84 2.02
query20 0.01 0.01 0.01
query21 15.37 0.62 0.57
query22 2.61 2.26 2.14
query23 16.84 1.13 0.79
query24 3.13 1.70 2.35
query25 0.24 0.07 0.07
query26 0.73 0.14 0.14
query27 0.05 0.04 0.05
query28 8.54 0.51 0.51
query29 12.58 3.23 3.23
query30 0.24 0.05 0.06
query31 2.86 0.38 0.39
query32 3.24 0.47 0.46
query33 2.99 2.99 3.03
query34 17.02 4.48 4.46
query35 4.52 4.53 4.54
query36 0.66 0.48 0.49
query37 0.09 0.06 0.06
query38 0.05 0.04 0.03
query39 0.04 0.02 0.02
query40 0.16 0.13 0.12
query41 0.08 0.02 0.03
query42 0.03 0.02 0.02
query43 0.03 0.02 0.02
Total cold run time: 105.06 s
Total hot run time: 33.26 s
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@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]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51060:
URL: https://github.com/apache/doris/pull/51060#issuecomment-2893202079
<details>
<summary>TPC-DS: <b>Total hot run time: 197785 ms</b></summary>
```
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 1337 944 903 903
query2 6340 2006 1992 1992
query3 10834 4292 4375 4292
query4 60695 29757 23582 23582
query5 5244 475 450 450
query6 391 170 176 170
query7 5432 328 302 302
query8 309 228 228 228
query9 8514 2627 2598 2598
query10 441 267 268 267
query11 17851 15203 15634 15203
query12 171 109 104 104
query13 1440 465 451 451
query14 10346 7206 7255 7206
query15 206 181 184 181
query16 7092 512 453 453
query17 1175 589 599 589
query18 1844 331 325 325
query19 217 161 160 160
query20 117 111 110 110
query21 214 105 106 105
query22 4656 4538 4623 4538
query23 34503 33824 33692 33692
query24 6134 2972 2977 2972
query25 549 423 431 423
query26 660 174 169 169
query27 2084 382 376 376
query28 4486 2489 2454 2454
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 1076 998 966 966
query37 117 69 64 64
query38 4086 3970 4027 3970
query39 1543 1479 1508 1479
query40 212 101 100 100
query41 48 47 47 47
query42 118 100 100 100
query43 538 489 494 489
query44 1181 821 847 821
query45 185 167 167 167
query46 1152 753 745 745
query47 2025 1899 1962 1899
query48 497 388 384 384
query49 739 408 394 394
query50 841 443 425 425
query51 7508 7198 7386 7198
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 1297 1177 1161 1161
query58 220 212 221 212
query59 3176 3145 3009 3009
query60 285 259 258 258
query61 169 143 112 112
query62 787 672 690 672
query63 229 196 194 194
query64 1391 683 649 649
query65 3271 3205 3196 3196
query66 706 305 300 300
query67 15988 15788 15582 15582
query68 4031 618 575 575
query69 441 272 272 272
query70 1198 1103 1106 1103
query71 353 259 266 259
query72 6339 3960 4056 3960
query73 758 357 370 357
query74 10463 9190 9188 9188
query75 3383 2686 2650 2650
query76 2038 1043 1037 1037
query77 484 276 285 276
query78 10798 9578 9579 9578
query79 1349 605 612 605
query80 860 446 427 427
query81 531 243 240 240
query82 1308 91 87 87
query83 244 144 143 143
query84 287 84 77 77
query85 879 301 297 297
query86 327 304 301 301
query87 4460 4296 4337 4296
query88 3893 2425 2391 2391
query89 427 298 298 298
query90 2038 191 190 190
query91 190 150 152 150
query92 65 51 51 51
query93 1872 573 585 573
query94 746 298 283 283
query95 350 268 259 259
query96 627 281 281 281
query97 3335 3181 3137 3137
query98 219 196 212 196
query99 1515 1296 1307 1296
Total cold run time: 314040 ms
Total hot run time: 197785 ms
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@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]
Posted by "Jibing-Li (via GitHub)" <gi...@apache.org>.
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@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]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #51060:
URL: https://github.com/apache/doris/pull/51060#issuecomment-2893171821
<details>
<summary>TPC-H: <b>Total hot run time: 40013 ms</b></summary>
```
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 6867 6669 6669
q2 2055 165 175 165
q3 10696 1070 1144 1070
q4 10558 783 736 736
q5 7732 2882 2784 2784
q6 224 135 133 133
q7 980 620 606 606
q8 9591 1957 2010 1957
q9 7002 6382 6431 6382
q10 7013 2277 2277 2277
q11 463 265 257 257
q12 405 207 212 207
q13 17765 2961 3012 2961
q14 232 214 201 201
q15 494 461 459 459
q16 665 596 577 577
q17 990 533 548 533
q18 7173 6611 6547 6547
q19 1406 1087 1128 1087
q20 498 203 206 203
q21 4036 3212 3292 3212
q22 1089 990 1003 990
Total cold run time: 108640 ms
Total hot run time: 40013 ms
----- Round 2, with runtime_filter_mode=off -----
q1 6625 6660 6678 6660
q2 339 239 237 237
q3 2901 2807 2960 2807
q4 2076 1823 1833 1823
q5 5784 5743 5709 5709
q6 222 131 132 131
q7 2232 1801 1783 1783
q8 3417 3601 3526 3526
q9 8887 8864 8908 8864
q10 3539 3555 3533 3533
q11 589 502 486 486
q12 823 580 598 580
q13 8408 3105 3163 3105
q14 299 272 276 272
q15 529 475 473 473
q16 704 670 644 644
q17 1847 1639 1628 1628
q18 8164 7607 7868 7607
q19 1735 1611 1608 1608
q20 2113 1797 1827 1797
q21 5786 5375 5295 5295
q22 1104 1050 1027 1027
Total cold run time: 68123 ms
Total hot run time: 59595 ms
```
</details>
--
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@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]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
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-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org