You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "starocean999 (via GitHub)" <gi...@apache.org> on 2024/07/16 04:39:16 UTC
[PR] [fix](nereids)the keys of agg table with random distribute are not unique [doris]
starocean999 opened a new pull request, #37881:
URL: https://github.com/apache/doris/pull/37881
## Proposed changes
Issue Number: close #xxx
<!--Describe your changes.-->
--
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)the keys of agg table with random distribute are not unique [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37881:
URL: https://github.com/apache/doris/pull/37881#issuecomment-2230040810
<details>
<summary>ClickBench: <b>Total hot run time: 30.5 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 af2e27801a604e5150f5ce1d8ff7ff7645c437aa, data reload: false
query1 0.04 0.03 0.03
query2 0.08 0.04 0.05
query3 0.22 0.05 0.04
query4 1.68 0.07 0.07
query5 0.49 0.50 0.46
query6 1.13 0.72 0.71
query7 0.02 0.01 0.02
query8 0.05 0.05 0.05
query9 0.54 0.49 0.48
query10 0.56 0.56 0.54
query11 0.15 0.11 0.11
query12 0.15 0.11 0.11
query13 0.60 0.58 0.58
query14 0.76 0.77 0.78
query15 0.85 0.81 0.81
query16 0.37 0.36 0.35
query17 0.96 0.97 0.96
query18 0.22 0.22 0.22
query19 1.77 1.70 1.71
query20 0.01 0.01 0.01
query21 15.39 0.72 0.64
query22 4.13 6.94 1.95
query23 18.26 1.43 1.34
query24 2.15 0.22 0.23
query25 0.16 0.09 0.08
query26 0.30 0.22 0.20
query27 0.45 0.22 0.22
query28 13.26 1.02 1.00
query29 12.61 3.29 3.27
query30 0.25 0.06 0.05
query31 2.90 0.39 0.39
query32 3.28 0.48 0.47
query33 2.90 2.92 2.86
query34 17.06 4.38 4.36
query35 4.41 4.40 4.37
query36 0.65 0.46 0.47
query37 0.19 0.16 0.15
query38 0.15 0.14 0.15
query39 0.04 0.03 0.04
query40 0.15 0.13 0.11
query41 0.09 0.05 0.05
query42 0.06 0.05 0.05
query43 0.05 0.04 0.04
Total cold run time: 109.54 s
Total hot run time: 30.5 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] [fix](nereids)the keys of agg table with random distribute are not unique [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #37881:
URL: https://github.com/apache/doris/pull/37881#issuecomment-2232512865
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
Re: [PR] [fix](nereids)the keys of agg table with random distribute are not unique [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #37881:
URL: https://github.com/apache/doris/pull/37881#issuecomment-2232512817
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] [fix](nereids)the keys of agg table with random distribute are not unique [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37881:
URL: https://github.com/apache/doris/pull/37881#issuecomment-2230021426
<details>
<summary>TPC-H: <b>Total hot run time: 39832 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 af2e27801a604e5150f5ce1d8ff7ff7645c437aa, data reload: false
------ Round 1 ----------------------------------
q1 18018 4491 4420 4420
q2 2602 196 203 196
q3 11063 1174 1099 1099
q4 11678 710 798 710
q5 7738 2753 2701 2701
q6 221 136 138 136
q7 962 594 593 593
q8 9216 2049 2083 2049
q9 8679 6561 6500 6500
q10 8623 3791 3732 3732
q11 475 240 241 240
q12 390 221 228 221
q13 18777 2959 2970 2959
q14 291 227 236 227
q15 533 496 490 490
q16 493 387 384 384
q17 961 634 627 627
q18 8047 7516 7435 7435
q19 5481 1361 1465 1361
q20 697 322 327 322
q21 4939 3154 3262 3154
q22 347 293 276 276
Total cold run time: 120231 ms
Total hot run time: 39832 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4390 4287 4287 4287
q2 379 266 261 261
q3 3016 2762 2705 2705
q4 1833 1566 1608 1566
q5 5309 5291 5282 5282
q6 226 129 130 129
q7 2131 1700 1725 1700
q8 3180 3338 3305 3305
q9 8392 8349 8308 8308
q10 3904 3747 3681 3681
q11 566 492 499 492
q12 775 603 624 603
q13 17391 2963 2990 2963
q14 294 267 286 267
q15 512 487 477 477
q16 460 421 411 411
q17 1785 1511 1449 1449
q18 7685 7442 7445 7442
q19 1652 1530 1485 1485
q20 2014 1773 1784 1773
q21 4980 4666 4637 4637
q22 552 475 491 475
Total cold run time: 71426 ms
Total hot run time: 53698 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)the keys of agg table with random distribute are not unique [doris]
Posted by "starocean999 (via GitHub)" <gi...@apache.org>.
starocean999 commented on PR #37881:
URL: https://github.com/apache/doris/pull/37881#issuecomment-2230005822
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)the keys of agg table with random distribute are not unique [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37881:
URL: https://github.com/apache/doris/pull/37881#issuecomment-2230036208
<details>
<summary>TPC-DS: <b>Total hot run time: 172481 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 af2e27801a604e5150f5ce1d8ff7ff7645c437aa, data reload: false
query1 918 368 366 366
query2 6453 1849 1778 1778
query3 6656 202 216 202
query4 25611 17717 17127 17127
query5 4248 485 489 485
query6 262 166 158 158
query7 4585 285 284 284
query8 240 191 195 191
query9 8585 2421 2407 2407
query10 459 271 268 268
query11 12164 10048 10070 10048
query12 135 80 80 80
query13 1624 363 365 363
query14 10544 7611 6864 6864
query15 216 162 165 162
query16 7814 310 301 301
query17 1780 529 518 518
query18 1959 284 270 270
query19 192 150 150 150
query20 90 82 81 81
query21 205 136 133 133
query22 4348 4043 4121 4043
query23 33709 33107 33025 33025
query24 12103 2930 2838 2838
query25 665 365 375 365
query26 1763 148 143 143
query27 3030 272 275 272
query28 7627 2054 2016 2016
query29 1165 623 606 606
query30 286 148 150 148
query31 955 786 747 747
query32 99 54 54 54
query33 777 293 291 291
query34 976 487 487 487
query35 672 578 594 578
query36 1119 936 947 936
query37 282 83 82 82
query38 2872 2756 2751 2751
query39 862 802 825 802
query40 288 122 123 122
query41 49 49 46 46
query42 115 99 99 99
query43 512 472 474 472
query44 1175 747 742 742
query45 193 161 164 161
query46 1090 778 714 714
query47 1868 1771 1796 1771
query48 369 302 295 295
query49 1212 430 421 421
query50 786 395 390 390
query51 6882 6829 6801 6801
query52 110 92 102 92
query53 353 299 289 289
query54 1039 466 455 455
query55 77 74 78 74
query56 303 303 292 292
query57 1161 1027 1048 1027
query58 281 252 260 252
query59 2906 2664 2763 2664
query60 318 288 290 288
query61 116 117 116 116
query62 823 666 670 666
query63 322 290 293 290
query64 10409 2293 7565 2293
query65 3183 3115 3121 3115
query66 1374 350 341 341
query67 15604 15295 14967 14967
query68 6201 575 549 549
query69 737 441 352 352
query70 1113 1125 1085 1085
query71 514 275 283 275
query72 7923 5942 5525 5525
query73 777 333 325 325
query74 6073 5610 5715 5610
query75 4202 2690 2719 2690
query76 4421 955 963 955
query77 669 291 340 291
query78 9654 8983 12486 8983
query79 6426 513 516 513
query80 2392 479 473 473
query81 590 222 225 222
query82 492 138 134 134
query83 266 176 169 169
query84 303 86 88 86
query85 1469 325 313 313
query86 446 280 331 280
query87 3285 3127 3101 3101
query88 3748 2362 2352 2352
query89 500 389 387 387
query90 1991 204 194 194
query91 132 100 100 100
query92 59 53 52 52
query93 2042 529 524 524
query94 1291 213 250 213
query95 394 320 318 318
query96 611 279 271 271
query97 3208 3006 3026 3006
query98 224 205 194 194
query99 1546 1264 1264 1264
Total cold run time: 294667 ms
Total hot run time: 172481 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)the keys of agg table with random distribute are not unique [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37881:
URL: https://github.com/apache/doris/pull/37881#issuecomment-2230005738
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)the keys of agg table with random distribute are not unique [doris]
Posted by "starocean999 (via GitHub)" <gi...@apache.org>.
starocean999 merged PR #37881:
URL: https://github.com/apache/doris/pull/37881
--
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