You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "github-actions[bot] (via GitHub)" <gi...@apache.org> on 2025/04/09 06:22:47 UTC
[PR] branch-3.0: [improve](string) remove check for string type can't as distributed hash key #49727 [doris]
github-actions[bot] opened a new pull request, #49898:
URL: https://github.com/apache/doris/pull/49898
Cherry-picked from #49727
--
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](string) remove check for string type can't as distributed hash key #49727 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49898:
URL: https://github.com/apache/doris/pull/49898#issuecomment-2788521021
<details>
<summary>TPC-H: <b>Total hot run time: 40147 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 6edecdf8f44bf770b6cfd522e24c1f3412c8f307, data reload: false
------ Round 1 ----------------------------------
q1 17561 6819 6609 6609
q2 2043 177 185 177
q3 10626 1074 1272 1074
q4 10537 800 732 732
q5 8028 2928 2867 2867
q6 219 135 133 133
q7 978 617 623 617
q8 9346 1909 2016 1909
q9 6577 6422 6436 6422
q10 7033 2229 2297 2229
q11 464 262 249 249
q12 394 212 211 211
q13 17800 2993 3021 2993
q14 251 216 208 208
q15 503 469 493 469
q16 653 591 587 587
q17 974 603 557 557
q18 7184 6733 6616 6616
q19 1505 1072 1123 1072
q20 472 202 210 202
q21 3982 3238 3305 3238
q22 1125 995 976 976
Total cold run time: 108255 ms
Total hot run time: 40147 ms
----- Round 2, with runtime_filter_mode=off -----
q1 6628 6596 6625 6596
q2 336 235 245 235
q3 2879 2762 2946 2762
q4 2037 1867 1779 1779
q5 5746 5767 5715 5715
q6 213 127 128 127
q7 2215 1817 1823 1817
q8 3383 3545 3520 3520
q9 8799 8901 8875 8875
q10 3572 3488 3513 3488
q11 599 493 502 493
q12 808 610 612 610
q13 8560 3129 3186 3129
q14 316 272 270 270
q15 520 460 470 460
q16 702 649 647 647
q17 1842 1590 1592 1590
q18 8302 7883 7528 7528
q19 1658 1541 1620 1541
q20 2097 1860 1870 1860
q21 5561 5269 5359 5269
q22 1133 1032 986 986
Total cold run time: 67906 ms
Total hot run time: 59297 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](string) remove check for string type can't as distributed hash key #49727 [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #49898:
URL: https://github.com/apache/doris/pull/49898#issuecomment-2788400309
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](string) remove check for string type can't as distributed hash key #49727 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49898:
URL: https://github.com/apache/doris/pull/49898#issuecomment-2788576617
<details>
<summary>ClickBench: <b>Total hot run time: 31.99 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 6edecdf8f44bf770b6cfd522e24c1f3412c8f307, data reload: false
query1 0.04 0.03 0.03
query2 0.07 0.03 0.03
query3 0.23 0.07 0.07
query4 1.62 0.11 0.10
query5 0.50 0.51 0.49
query6 1.14 0.74 0.72
query7 0.02 0.02 0.02
query8 0.04 0.05 0.03
query9 0.56 0.51 0.47
query10 0.55 0.54 0.54
query11 0.14 0.10 0.10
query12 0.14 0.12 0.12
query13 0.61 0.60 0.58
query14 2.71 2.75 2.84
query15 0.89 0.82 0.83
query16 0.37 0.39 0.42
query17 1.06 1.08 1.05
query18 0.26 0.22 0.21
query19 1.90 1.88 2.04
query20 0.02 0.01 0.01
query21 15.35 0.58 0.56
query22 2.46 2.64 1.69
query23 16.97 0.96 0.70
query24 3.13 0.87 0.99
query25 0.18 0.05 0.09
query26 0.61 0.14 0.15
query27 0.03 0.05 0.04
query28 10.52 0.52 0.54
query29 12.57 3.26 3.27
query30 0.25 0.06 0.06
query31 2.84 0.38 0.38
query32 3.28 0.45 0.45
query33 2.97 3.02 3.04
query34 17.16 4.53 4.54
query35 4.59 4.59 4.53
query36 0.66 0.47 0.47
query37 0.08 0.06 0.07
query38 0.04 0.04 0.04
query39 0.04 0.02 0.03
query40 0.16 0.12 0.13
query41 0.08 0.02 0.02
query42 0.04 0.02 0.02
query43 0.04 0.03 0.04
Total cold run time: 106.92 s
Total hot run time: 31.99 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](string) remove check for string type can't as distributed hash key #49727 [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring closed pull request #49898: branch-3.0: [improve](string) remove check for string type can't as distributed hash key #49727
URL: https://github.com/apache/doris/pull/49898
--
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](string) remove check for string type can't as distributed hash key #49727 [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #49898:
URL: https://github.com/apache/doris/pull/49898#issuecomment-2788400400
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](string) remove check for string type can't as distributed hash key #49727 [doris]
Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei closed pull request #49898: branch-3.0: [improve](string) remove check for string type can't as distributed hash key #49727
URL: https://github.com/apache/doris/pull/49898
--
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](string) remove check for string type can't as distributed hash key #49727 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #49898:
URL: https://github.com/apache/doris/pull/49898#issuecomment-2788561937
<details>
<summary>TPC-DS: <b>Total hot run time: 198762 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 6edecdf8f44bf770b6cfd522e24c1f3412c8f307, data reload: false
query1 1331 939 896 896
query2 6241 2087 2013 2013
query3 10962 4442 4410 4410
query4 65875 28311 23329 23329
query5 5015 455 437 437
query6 407 178 174 174
query7 5548 312 314 312
query8 303 210 213 210
query9 8533 2620 2612 2612
query10 496 290 260 260
query11 17431 15166 16100 15166
query12 161 100 100 100
query13 1447 440 438 438
query14 10143 7537 7816 7537
query15 207 182 176 176
query16 7129 505 500 500
query17 1053 556 590 556
query18 1833 309 312 309
query19 217 149 158 149
query20 122 118 107 107
query21 205 103 102 102
query22 4761 4686 4636 4636
query23 35202 34523 34984 34523
query24 6274 3068 3018 3018
query25 571 454 442 442
query26 3171 191 180 180
query27 2085 369 373 369
query28 4703 2527 2489 2489
query29 725 488 449 449
query30 534 181 168 168
query31 1465 852 889 852
query32 77 60 69 60
query33 1159 312 345 312
query34 1726 548 570 548
query35 929 752 762 752
query36 1138 978 973 973
query37 119 72 69 69
query38 4076 3970 4125 3970
query39 1549 1494 1477 1477
query40 204 104 100 100
query41 52 50 56 50
query42 112 110 103 103
query43 542 492 517 492
query44 1176 838 833 833
query45 187 174 179 174
query46 1159 752 744 744
query47 1989 1922 2044 1922
query48 505 380 411 380
query49 728 402 409 402
query50 837 442 432 432
query51 7515 7201 7053 7053
query52 108 88 88 88
query53 256 185 180 180
query54 566 467 451 451
query55 74 75 73 73
query56 242 235 245 235
query57 1238 1118 1079 1079
query58 214 208 207 207
query59 3215 3118 3058 3058
query60 277 260 249 249
query61 131 110 152 110
query62 777 687 661 661
query63 218 189 192 189
query64 1906 665 635 635
query65 3263 3250 3181 3181
query66 685 299 306 299
query67 16092 15617 15740 15617
query68 4115 582 576 576
query69 422 267 267 267
query70 1167 1143 1105 1105
query71 323 260 258 258
query72 6394 4013 4046 4013
query73 756 351 342 342
query74 10154 9073 9272 9073
query75 3344 2677 2686 2677
query76 1956 1108 1103 1103
query77 514 274 271 271
query78 10632 9521 9509 9509
query79 2105 600 602 600
query80 1437 421 415 415
query81 527 240 238 238
query82 1257 89 85 85
query83 159 148 147 147
query84 282 74 77 74
query85 987 315 289 289
query86 405 263 306 263
query87 4420 4339 4377 4339
query88 3880 2425 2369 2369
query89 419 293 318 293
query90 1870 192 188 188
query91 186 150 147 147
query92 63 50 47 47
query93 2946 545 536 536
query94 763 302 319 302
query95 359 258 261 258
query96 636 285 286 285
query97 3331 3146 3176 3146
query98 212 201 194 194
query99 1679 1352 1276 1276
Total cold run time: 326891 ms
Total hot run time: 198762 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