You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "feiniaofeiafei (via GitHub)" <gi...@apache.org> on 2024/03/26 08:49:21 UTC
[PR] [Fix](nereids) remove duplicate expr in grouping set [doris]
feiniaofeiafei opened a new pull request, #32834:
URL: https://github.com/apache/doris/pull/32834
## Proposed changes
Issue Number: close #xxx
<!--Describe your changes.-->
## Further comments
If this is a relatively large or complex change, kick off the discussion at [dev@doris.apache.org](mailto:dev@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc...
--
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] [Fix](nereids) remove duplicate expr in grouping set [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32834:
URL: https://github.com/apache/doris/pull/32834#issuecomment-2019921314
<details>
<summary>TPC-H: <b>Total hot run time: 49778 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 a80d54811d4dd6b00e42001b58b232d0714e0935, data reload: false
------ Round 1 ----------------------------------
q1 17771 4375 4371 4371
q2 2067 145 137 137
q3 10307 1898 1916 1898
q4 10357 1254 1321 1254
q5 8440 4172 3869 3869
q6 227 121 122 121
q7 2042 1587 1587 1587
q8 9493 2704 2697 2697
q9 11931 10622 10444 10444
q10 8601 3566 3530 3530
q11 424 239 240 239
q12 459 295 301 295
q13 18344 3946 4034 3946
q14 351 320 318 318
q15 499 450 462 450
q16 680 593 604 593
q17 1112 980 927 927
q18 7295 6809 6881 6809
q19 1670 1539 1535 1535
q20 517 307 297 297
q21 4458 4071 4075 4071
q22 497 402 390 390
Total cold run time: 117542 ms
Total hot run time: 49778 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4275 4298 4301 4298
q2 316 219 219 219
q3 4154 4157 4139 4139
q4 2731 2722 2729 2722
q5 7298 7160 7200 7160
q6 234 117 117 117
q7 3229 2861 2837 2837
q8 4361 4460 4476 4460
q9 17060 16854 16875 16854
q10 4277 4255 4282 4255
q11 749 723 688 688
q12 1028 857 847 847
q13 6769 3749 3746 3746
q14 445 427 432 427
q15 502 457 453 453
q16 741 704 693 693
q17 3837 3855 3918 3855
q18 8849 8785 8715 8715
q19 1690 1652 1633 1633
q20 2383 2135 2106 2106
q21 8574 8543 8349 8349
q22 1084 963 945 945
Total cold run time: 84586 ms
Total hot run time: 79518 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] [Fix](nereids) remove duplicate expr in grouping set [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #32834:
URL: https://github.com/apache/doris/pull/32834
--
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] [Fix](nereids) remove duplicate expr in grouping set [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32834:
URL: https://github.com/apache/doris/pull/32834#issuecomment-2019945902
<details>
<summary>TPC-DS: <b>Total hot run time: 201761 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 a80d54811d4dd6b00e42001b58b232d0714e0935, data reload: false
query1 944 384 384 384
query2 6512 2107 2288 2107
query3 6916 200 203 200
query4 20984 17925 17972 17925
query5 19727 6544 6415 6415
query6 292 213 217 213
query7 4160 299 292 292
query8 273 256 237 237
query9 3070 2706 2610 2610
query10 392 284 288 284
query11 11452 10735 10688 10688
query12 120 79 73 73
query13 5570 630 633 630
query14 17655 13285 13560 13285
query15 347 223 233 223
query16 6630 295 264 264
query17 1905 1443 876 876
query18 2328 405 410 405
query19 216 145 148 145
query20 78 75 72 72
query21 188 87 97 87
query22 5125 5221 5037 5037
query23 32809 32233 32338 32233
query24 7106 6611 6553 6553
query25 559 443 441 441
query26 615 170 166 166
query27 2194 316 309 309
query28 7094 2271 2215 2215
query29 2989 2822 2921 2822
query30 239 164 160 160
query31 905 797 740 740
query32 63 61 59 59
query33 563 248 247 247
query34 869 477 485 477
query35 1113 945 887 887
query36 1349 1296 1159 1159
query37 90 82 67 67
query38 3132 2914 2899 2899
query39 1379 1315 1325 1315
query40 198 94 88 88
query41 34 32 31 31
query42 84 84 84 84
query43 618 705 657 657
query44 1138 721 721 721
query45 242 225 229 225
query46 1225 966 969 966
query47 1902 1684 1707 1684
query48 976 683 673 673
query49 620 378 375 375
query50 859 608 622 608
query51 4749 4666 4722 4666
query52 89 83 79 79
query53 438 311 319 311
query54 2616 2467 2440 2440
query55 93 73 78 73
query56 215 190 196 190
query57 1310 1177 1129 1129
query58 213 203 206 203
query59 3370 3210 3515 3210
query60 205 189 208 189
query61 85 82 88 82
query62 824 473 514 473
query63 478 351 338 338
query64 2458 1502 1479 1479
query65 3697 3588 3605 3588
query66 778 374 354 354
query67 16164 16772 15058 15058
query68 9379 679 666 666
query69 588 334 357 334
query70 1600 1415 1374 1374
query71 412 292 308 292
query72 6532 3436 3435 3435
query73 722 314 319 314
query74 6223 5933 5785 5785
query75 5471 3724 3692 3692
query76 5866 1157 1180 1157
query77 982 247 239 239
query78 12612 11840 12005 11840
query79 9859 636 635 635
query80 1239 388 381 381
query81 491 237 231 231
query82 1479 102 93 93
query83 171 137 126 126
query84 257 68 68 68
query85 847 283 276 276
query86 316 306 299 299
query87 3235 3007 3064 3007
query88 4851 2323 2317 2317
query89 461 272 278 272
query90 1945 210 210 210
query91 158 115 116 115
query92 60 42 51 42
query93 6492 628 558 558
query94 674 202 204 202
query95 1109 1071 1056 1056
query96 648 327 318 318
query97 6464 6433 6257 6257
query98 194 183 171 171
query99 2939 824 924 824
Total cold run time: 317906 ms
Total hot run time: 201761 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] [Fix](nereids) remove duplicate expr in grouping set [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32834:
URL: https://github.com/apache/doris/pull/32834#issuecomment-2019847777
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)
Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website).
See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).
--
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] [Fix](nereids) remove duplicate expr in grouping set [doris]
Posted by "feiniaofeiafei (via GitHub)" <gi...@apache.org>.
feiniaofeiafei commented on PR #32834:
URL: https://github.com/apache/doris/pull/32834#issuecomment-2019847950
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] [Fix](nereids) remove duplicate expr in grouping set [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32834:
URL: https://github.com/apache/doris/pull/32834#issuecomment-2019956767
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit a80d54811d4dd6b00e42001b58b232d0714e0935 with default session variables
Stream load json: 20 seconds loaded 2358488459 Bytes, about 112 MB/s
Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 22.7 seconds inserted 10000000 Rows, about 440K ops/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-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