You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "kaijchen (via GitHub)" <gi...@apache.org> on 2024/07/19 05:42:25 UTC
[PR] [fix](move-memtable) tolerate minority failures in load_stream [doris]
kaijchen opened a new pull request, #38119:
URL: https://github.com/apache/doris/pull/38119
## Proposed changes
LoadStream should not fail on any errors caused by single tablet.
--
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](move-memtable) tolerate minority replica failure in load stream [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2255474182
<details>
<summary>TPC-H: <b>Total hot run time: 41860 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 ff3287d28ccead387ef801a117c84768ce2f9a98, data reload: false
------ Round 1 ----------------------------------
q1 18728 4252 4206 4206
q2 2588 211 215 211
q3 12125 1306 1344 1306
q4 10304 890 936 890
q5 7751 3070 2970 2970
q6 220 137 141 137
q7 1033 603 606 603
q8 9425 1887 1943 1887
q9 8370 6601 6612 6601
q10 8715 3835 3850 3835
q11 425 253 248 248
q12 407 225 228 225
q13 17772 2951 2944 2944
q14 270 242 250 242
q15 529 484 488 484
q16 492 405 387 387
q17 1006 893 893 893
q18 7918 7309 7268 7268
q19 1389 1214 1209 1209
q20 565 326 350 326
q21 5373 4714 4707 4707
q22 354 288 281 281
Total cold run time: 115759 ms
Total hot run time: 41860 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4028 4029 4012 4012
q2 333 219 221 219
q3 3007 3017 2995 2995
q4 1899 1854 1873 1854
q5 5241 5233 5267 5233
q6 215 130 132 130
q7 2031 1659 1703 1659
q8 3198 3266 3273 3266
q9 8258 8242 8270 8242
q10 3761 3846 3809 3809
q11 535 445 454 445
q12 716 574 535 535
q13 13297 2934 2944 2934
q14 283 258 252 252
q15 520 479 482 479
q16 449 398 409 398
q17 1713 1677 1687 1677
q18 7725 7314 7275 7275
q19 1655 1658 1665 1658
q20 1935 1758 1739 1739
q21 5348 5168 5180 5168
q22 510 455 439 439
Total cold run time: 66657 ms
Total hot run time: 54418 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](move-memtable) tolerate minority replica failure in load stream [doris]
Posted by "kaijchen (via GitHub)" <gi...@apache.org>.
kaijchen commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2260078985
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](move-memtable) tolerate minority replica failure in load stream [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2255496066
<details>
<summary>TPC-DS: <b>Total hot run time: 169820 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 ff3287d28ccead387ef801a117c84768ce2f9a98, data reload: false
query1 917 368 386 368
query2 6483 1779 1700 1700
query3 6687 214 232 214
query4 20211 17644 17339 17339
query5 4312 508 524 508
query6 278 167 159 159
query7 4603 317 306 306
query8 259 208 197 197
query9 8507 2423 2409 2409
query10 467 278 269 269
query11 10400 10110 10074 10074
query12 136 91 96 91
query13 1636 388 396 388
query14 9826 7511 7886 7511
query15 202 164 173 164
query16 7091 464 453 453
query17 953 582 561 561
query18 1286 303 298 298
query19 192 153 152 152
query20 91 87 88 87
query21 208 103 102 102
query22 4251 3955 3939 3939
query23 33714 33012 32911 32911
query24 10333 3067 3019 3019
query25 716 432 417 417
query26 1763 155 153 153
query27 2806 279 283 279
query28 6621 2010 1999 1999
query29 1122 453 448 448
query30 289 151 154 151
query31 926 774 746 746
query32 106 56 56 56
query33 712 315 325 315
query34 904 470 488 470
query35 855 761 719 719
query36 1007 876 877 876
query37 304 77 82 77
query38 2900 2727 2790 2727
query39 851 808 812 808
query40 282 115 116 115
query41 49 47 49 47
query42 120 102 102 102
query43 485 421 433 421
query44 1190 726 729 726
query45 211 185 177 177
query46 1086 831 792 792
query47 1796 1695 1720 1695
query48 370 300 295 295
query49 1183 438 428 428
query50 887 438 447 438
query51 6690 6704 6628 6628
query52 104 95 91 91
query53 253 188 178 178
query54 657 469 472 469
query55 78 79 78 78
query56 293 268 279 268
query57 1146 1067 1035 1035
query58 288 280 269 269
query59 2487 2451 2339 2339
query60 298 292 284 284
query61 127 216 109 109
query62 894 669 652 652
query63 211 184 189 184
query64 5912 1931 1903 1903
query65 3184 3114 3111 3111
query66 1350 335 336 335
query67 15424 14732 14806 14732
query68 6765 562 585 562
query69 741 394 312 312
query70 1120 1063 1076 1063
query71 561 270 277 270
query72 8095 2733 2537 2537
query73 946 334 330 330
query74 6019 5633 5659 5633
query75 4407 2736 2739 2736
query76 4865 1395 1398 1395
query77 769 309 303 303
query78 9492 9120 8927 8927
query79 2648 540 548 540
query80 1406 503 501 501
query81 574 230 230 230
query82 732 138 125 125
query83 311 173 170 170
query84 276 80 83 80
query85 1470 342 305 305
query86 427 292 305 292
query87 3301 3095 3101 3095
query88 3194 2490 2471 2471
query89 425 300 283 283
query90 2097 189 193 189
query91 131 102 107 102
query92 64 53 49 49
query93 3893 625 626 625
query94 973 294 302 294
query95 383 271 280 271
query96 621 281 280 280
query97 3181 3009 3041 3009
query98 219 203 208 203
query99 1612 1343 1277 1277
Total cold run time: 273698 ms
Total hot run time: 169820 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](move-memtable) tolerate minority replica failure in load stream [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2260240290
<details>
<summary>ClickBench: <b>Total hot run time: 30.16 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 cacc69e0be0c23dc4ef1037ff8514f19bdc3f4e8, data reload: false
query1 0.05 0.03 0.04
query2 0.07 0.04 0.03
query3 0.22 0.05 0.05
query4 1.68 0.07 0.07
query5 0.48 0.49 0.48
query6 1.12 0.72 0.72
query7 0.02 0.01 0.01
query8 0.06 0.05 0.04
query9 0.56 0.51 0.52
query10 0.57 0.56 0.56
query11 0.16 0.13 0.12
query12 0.16 0.12 0.12
query13 0.61 0.60 0.60
query14 0.77 0.79 0.79
query15 0.90 0.86 0.86
query16 0.36 0.36 0.35
query17 0.99 1.00 1.02
query18 0.22 0.21 0.21
query19 1.93 1.77 1.78
query20 0.01 0.01 0.01
query21 15.42 0.76 0.65
query22 4.27 7.54 1.29
query23 17.96 1.44 1.37
query24 2.25 0.22 0.21
query25 0.18 0.08 0.07
query26 0.31 0.22 0.21
query27 0.46 0.24 0.24
query28 13.16 0.99 0.97
query29 12.55 3.36 3.31
query30 0.25 0.06 0.05
query31 2.87 0.42 0.41
query32 3.24 0.48 0.48
query33 2.95 2.96 2.98
query34 15.44 4.27 4.24
query35 4.25 4.28 4.28
query36 0.68 0.48 0.48
query37 0.19 0.16 0.16
query38 0.16 0.15 0.15
query39 0.04 0.04 0.04
query40 0.15 0.13 0.12
query41 0.09 0.05 0.06
query42 0.06 0.05 0.05
query43 0.05 0.04 0.04
Total cold run time: 107.92 s
Total hot run time: 30.16 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](move-memtable) tolerate minority failures in load_stream [doris]
Posted by "kaijchen (via GitHub)" <gi...@apache.org>.
kaijchen commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2238242058
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](move-memtable) tolerate minority replica failure in load stream [doris]
Posted by "kaijchen (via GitHub)" <gi...@apache.org>.
kaijchen commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2254852107
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](move-memtable) tolerate minority replica failure in load stream [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2254890104
<details>
<summary>ClickBench: <b>Total hot run time: 30.36 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 dd7d95e67e95ee66a2e58527a1227f2aae76c4f2, data reload: false
query1 0.04 0.03 0.04
query2 0.08 0.04 0.04
query3 0.22 0.05 0.05
query4 1.68 0.07 0.07
query5 0.48 0.48 0.50
query6 1.13 0.72 0.73
query7 0.02 0.01 0.02
query8 0.05 0.05 0.05
query9 0.55 0.50 0.49
query10 0.55 0.55 0.53
query11 0.16 0.11 0.12
query12 0.15 0.12 0.13
query13 0.61 0.59 0.58
query14 0.78 0.78 0.78
query15 0.87 0.82 0.81
query16 0.37 0.37 0.37
query17 1.02 0.96 1.05
query18 0.23 0.22 0.21
query19 1.83 1.76 1.70
query20 0.01 0.01 0.00
query21 15.42 0.75 0.64
query22 4.59 7.39 1.70
query23 18.44 1.48 1.26
query24 2.16 0.23 0.22
query25 0.15 0.08 0.08
query26 0.31 0.22 0.21
query27 0.45 0.23 0.22
query28 13.23 1.02 1.01
query29 12.54 3.33 3.28
query30 0.25 0.05 0.06
query31 2.86 0.40 0.40
query32 3.27 0.48 0.47
query33 2.96 2.92 2.92
query34 16.98 4.29 4.40
query35 4.42 4.41 4.43
query36 0.66 0.49 0.49
query37 0.19 0.16 0.16
query38 0.16 0.15 0.15
query39 0.04 0.04 0.04
query40 0.15 0.14 0.12
query41 0.10 0.05 0.04
query42 0.06 0.05 0.05
query43 0.04 0.04 0.04
Total cold run time: 110.26 s
Total hot run time: 30.36 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](move-memtable) tolerate minority replica failure in load stream [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2257406810
<details>
<summary>TPC-DS: <b>Total hot run time: 170634 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 f88d45a0c398e15f7b413312a15f1bd7f0f34d47, data reload: false
query1 927 381 385 381
query2 6454 1647 1651 1647
query3 6657 216 223 216
query4 20293 17427 17503 17427
query5 3670 507 502 502
query6 267 168 166 166
query7 4595 307 297 297
query8 254 194 196 194
query9 8499 2399 2394 2394
query10 442 292 284 284
query11 10555 10016 9875 9875
query12 125 85 84 84
query13 1628 377 372 372
query14 9180 8215 7829 7829
query15 204 161 166 161
query16 6793 447 419 419
query17 939 591 539 539
query18 1887 284 276 276
query19 189 144 144 144
query20 95 88 82 82
query21 201 102 101 101
query22 4061 4056 3965 3965
query23 33970 33371 33719 33371
query24 9030 3134 3126 3126
query25 615 435 414 414
query26 760 153 160 153
query27 2217 284 305 284
query28 5687 2049 2042 2042
query29 913 464 448 448
query30 239 157 159 157
query31 951 773 768 768
query32 97 53 55 53
query33 582 323 322 322
query34 917 494 497 494
query35 859 798 779 779
query36 1043 894 894 894
query37 140 82 86 82
query38 3003 2849 2947 2849
query39 894 805 806 805
query40 205 118 113 113
query41 46 44 46 44
query42 125 98 103 98
query43 449 422 422 422
query44 1138 737 723 723
query45 230 181 176 176
query46 1102 799 757 757
query47 1799 1716 1701 1701
query48 374 294 302 294
query49 845 420 418 418
query50 901 428 434 428
query51 6711 6722 6680 6680
query52 107 90 98 90
query53 257 186 174 174
query54 624 456 455 455
query55 77 77 76 76
query56 285 262 267 262
query57 1133 1013 1043 1013
query58 260 265 278 265
query59 2412 2325 2394 2325
query60 295 277 288 277
query61 102 96 98 96
query62 894 649 668 649
query63 207 184 191 184
query64 4303 1926 1896 1896
query65 3148 3105 3093 3093
query66 847 324 327 324
query67 15411 14990 14861 14861
query68 4333 562 584 562
query69 455 309 305 305
query70 1112 1022 1075 1022
query71 383 287 279 279
query72 7190 2712 2501 2501
query73 756 328 333 328
query74 5966 5707 5637 5637
query75 3355 2726 2743 2726
query76 2148 1361 1447 1361
query77 487 338 326 326
query78 9535 9076 8880 8880
query79 1387 533 525 525
query80 1343 516 518 516
query81 585 234 224 224
query82 1218 135 128 128
query83 264 171 172 171
query84 270 83 83 83
query85 1109 323 314 314
query86 401 279 305 279
query87 3239 3162 3100 3100
query88 2980 2478 2493 2478
query89 396 290 293 290
query90 1689 191 193 191
query91 129 113 104 104
query92 57 50 53 50
query93 1297 621 632 621
query94 834 303 293 293
query95 388 277 268 268
query96 600 286 286 286
query97 3228 3010 3051 3010
query98 224 214 209 209
query99 1695 1299 1277 1277
Total cold run time: 253172 ms
Total hot run time: 170634 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](move-memtable) tolerate minority replica failure in load stream [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2257411001
<details>
<summary>ClickBench: <b>Total hot run time: 29.95 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 f88d45a0c398e15f7b413312a15f1bd7f0f34d47, data reload: false
query1 0.04 0.04 0.04
query2 0.07 0.04 0.04
query3 0.22 0.04 0.04
query4 1.68 0.07 0.07
query5 0.48 0.47 0.47
query6 1.17 0.72 0.71
query7 0.02 0.01 0.01
query8 0.05 0.04 0.04
query9 0.60 0.53 0.54
query10 0.59 0.59 0.58
query11 0.15 0.12 0.12
query12 0.15 0.12 0.12
query13 0.61 0.61 0.60
query14 0.78 0.79 0.79
query15 0.91 0.87 0.86
query16 0.35 0.36 0.36
query17 1.01 1.01 0.98
query18 0.23 0.22 0.21
query19 1.85 1.77 1.72
query20 0.02 0.01 0.01
query21 15.42 0.79 0.67
query22 4.15 7.02 1.32
query23 17.66 1.28 1.22
query24 2.24 0.22 0.21
query25 0.18 0.08 0.08
query26 0.33 0.21 0.22
query27 0.46 0.24 0.23
query28 13.16 1.01 0.96
query29 12.50 3.28 3.29
query30 0.25 0.06 0.06
query31 2.85 0.41 0.41
query32 3.23 0.50 0.49
query33 2.97 2.94 2.90
query34 15.44 4.26 4.27
query35 4.31 4.28 4.31
query36 0.69 0.48 0.47
query37 0.19 0.16 0.17
query38 0.16 0.15 0.15
query39 0.04 0.04 0.04
query40 0.17 0.12 0.13
query41 0.10 0.04 0.04
query42 0.06 0.05 0.05
query43 0.04 0.04 0.04
Total cold run time: 107.58 s
Total hot run time: 29.95 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](move-memtable) tolerate minority replica failure in load stream [doris]
Posted by "kaijchen (via GitHub)" <gi...@apache.org>.
kaijchen commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2259993510
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](move-memtable) tolerate minority replica failure in load stream [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2255507078
<details>
<summary>ClickBench: <b>Total hot run time: 30.03 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 ff3287d28ccead387ef801a117c84768ce2f9a98, data reload: false
query1 0.04 0.04 0.04
query2 0.08 0.04 0.04
query3 0.23 0.05 0.05
query4 1.68 0.08 0.07
query5 0.49 0.48 0.48
query6 1.14 0.73 0.72
query7 0.02 0.02 0.01
query8 0.05 0.05 0.05
query9 0.57 0.51 0.51
query10 0.55 0.57 0.56
query11 0.16 0.12 0.13
query12 0.15 0.13 0.13
query13 0.60 0.60 0.60
query14 0.78 0.79 0.81
query15 0.89 0.86 0.86
query16 0.35 0.36 0.34
query17 0.99 0.98 0.98
query18 0.23 0.21 0.21
query19 1.82 1.72 1.73
query20 0.01 0.01 0.01
query21 15.45 0.75 0.65
query22 3.81 6.67 1.40
query23 17.76 1.31 1.22
query24 2.31 0.22 0.22
query25 0.19 0.08 0.09
query26 0.31 0.22 0.22
query27 0.46 0.24 0.23
query28 13.16 1.00 0.97
query29 12.50 3.32 3.33
query30 0.26 0.06 0.05
query31 2.88 0.42 0.39
query32 3.24 0.48 0.49
query33 2.98 2.91 2.96
query34 15.44 4.27 4.26
query35 4.30 4.29 4.28
query36 0.68 0.50 0.48
query37 0.19 0.17 0.17
query38 0.16 0.14 0.15
query39 0.04 0.04 0.03
query40 0.16 0.12 0.13
query41 0.10 0.04 0.05
query42 0.06 0.05 0.05
query43 0.04 0.03 0.04
Total cold run time: 107.31 s
Total hot run time: 30.03 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](move-memtable) tolerate minority failures in load_stream [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2238241837
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](move-memtable) tolerate minority replica failure in load stream [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2257333727
clang-tidy review says "All clean, LGTM! :+1:"
--
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](move-memtable) tolerate minority replica failure in load stream [doris]
Posted by "kaijchen (via GitHub)" <gi...@apache.org>.
kaijchen commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2255424185
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](move-memtable) tolerate minority replica failure in load stream [doris]
Posted by "kaijchen (via GitHub)" <gi...@apache.org>.
kaijchen commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2268040953
superseded by #38119
--
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](move-memtable) tolerate minority replica failure in load stream [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2260211953
<details>
<summary>TPC-H: <b>Total hot run time: 41853 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 cacc69e0be0c23dc4ef1037ff8514f19bdc3f4e8, data reload: false
------ Round 1 ----------------------------------
q1 17777 4179 4087 4087
q2 2030 212 201 201
q3 10551 1367 1326 1326
q4 10219 872 905 872
q5 7655 3047 3005 3005
q6 226 139 140 139
q7 1049 617 616 616
q8 9440 1919 1962 1919
q9 8625 6634 6617 6617
q10 8750 3882 3864 3864
q11 428 253 246 246
q12 408 230 224 224
q13 17778 2939 2956 2939
q14 271 243 239 239
q15 523 476 502 476
q16 532 394 383 383
q17 992 943 909 909
q18 8083 7235 7321 7235
q19 1381 1229 1215 1215
q20 551 332 335 332
q21 5428 4730 4786 4730
q22 365 290 279 279
Total cold run time: 113062 ms
Total hot run time: 41853 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4078 4041 4006 4006
q2 324 217 215 215
q3 2965 3020 3149 3020
q4 2007 2040 1967 1967
q5 5631 5492 5496 5492
q6 217 128 129 128
q7 2137 1766 1846 1766
q8 3333 3423 3360 3360
q9 8719 8720 8862 8720
q10 3948 4106 3950 3950
q11 564 459 468 459
q12 765 636 612 612
q13 16333 3122 3145 3122
q14 310 280 276 276
q15 523 490 479 479
q16 466 410 421 410
q17 1769 1751 1729 1729
q18 8139 7799 7740 7740
q19 1713 1720 1756 1720
q20 2043 1823 1850 1823
q21 5692 5565 5279 5279
q22 560 469 496 469
Total cold run time: 72236 ms
Total hot run time: 56742 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](move-memtable) tolerate minority replica failure in load stream [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2260108470
clang-tidy review says "All clean, LGTM! :+1:"
--
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](move-memtable) tolerate minority replica failure in load stream [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2255436519
clang-tidy review says "All clean, LGTM! :+1:"
--
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](move-memtable) tolerate minority replica failure in load stream [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2254838397
clang-tidy review says "All clean, LGTM! :+1:"
--
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](move-memtable) tolerate minority failures in load_stream [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2238247959
clang-tidy review says "All clean, LGTM! :+1:"
--
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](move-memtable) tolerate minority replica failure in load stream [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2254876935
<details>
<summary>TPC-H: <b>Total hot run time: 39407 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 dd7d95e67e95ee66a2e58527a1227f2aae76c4f2, data reload: false
------ Round 1 ----------------------------------
q1 17676 4336 4269 4269
q2 2016 204 220 204
q3 10975 1230 1069 1069
q4 10493 768 805 768
q5 7575 2760 2663 2663
q6 223 143 143 143
q7 987 615 611 611
q8 9279 1934 1949 1934
q9 8955 6659 6622 6622
q10 8917 3798 3774 3774
q11 468 255 254 254
q12 400 230 226 226
q13 17919 2991 2990 2990
q14 281 242 249 242
q15 544 484 488 484
q16 501 389 396 389
q17 959 680 676 676
q18 8128 7453 7368 7368
q19 3018 974 1001 974
q20 683 333 341 333
q21 5003 3124 3244 3124
q22 346 290 299 290
Total cold run time: 115346 ms
Total hot run time: 39407 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4386 4252 4261 4252
q2 386 280 274 274
q3 2996 2744 2834 2744
q4 1921 1710 1732 1710
q5 5596 5544 5551 5544
q6 220 131 143 131
q7 2190 1831 1873 1831
q8 3265 3493 3457 3457
q9 8777 8659 8693 8659
q10 4073 3873 3833 3833
q11 595 508 497 497
q12 814 648 628 628
q13 16584 3129 3231 3129
q14 315 301 282 282
q15 539 480 496 480
q16 510 436 433 433
q17 1844 1524 1537 1524
q18 8202 8235 7803 7803
q19 4253 1607 1606 1606
q20 2067 1785 1796 1785
q21 5054 4895 4901 4895
q22 608 510 524 510
Total cold run time: 75195 ms
Total hot run time: 56007 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](move-memtable) tolerate minority replica failure in load stream [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2256675817
<details>
<summary>TPC-DS: <b>Total hot run time: 170805 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 ff3287d28ccead387ef801a117c84768ce2f9a98, data reload: false
query1 926 398 369 369
query2 6461 1788 1759 1759
query3 6643 209 225 209
query4 20015 17495 17414 17414
query5 3684 521 505 505
query6 293 181 170 170
query7 4598 301 298 298
query8 253 193 190 190
query9 8490 2387 2382 2382
query10 420 280 271 271
query11 10469 10102 9878 9878
query12 127 90 89 89
query13 1644 401 364 364
query14 9193 7725 7798 7725
query15 205 160 170 160
query16 6837 446 461 446
query17 942 556 533 533
query18 1897 276 276 276
query19 195 147 150 147
query20 90 107 85 85
query21 201 99 98 98
query22 4220 4025 4097 4025
query23 33860 33511 33554 33511
query24 10360 3089 3042 3042
query25 710 427 430 427
query26 1665 158 156 156
query27 3229 295 302 295
query28 7333 2046 2038 2038
query29 1185 443 449 443
query30 248 158 164 158
query31 964 794 805 794
query32 107 57 60 57
query33 694 326 345 326
query34 940 504 513 504
query35 871 766 754 754
query36 1056 899 865 865
query37 245 80 85 80
query38 2837 2780 2746 2746
query39 844 791 829 791
query40 298 115 113 113
query41 52 46 45 45
query42 120 97 100 97
query43 471 428 429 428
query44 1193 727 739 727
query45 213 180 184 180
query46 1090 830 798 798
query47 1802 1696 1696 1696
query48 364 297 291 291
query49 974 442 425 425
query50 911 444 454 444
query51 6968 6679 6675 6675
query52 103 90 94 90
query53 254 185 183 183
query54 609 465 479 465
query55 76 75 75 75
query56 278 275 273 273
query57 1154 1065 1013 1013
query58 296 267 294 267
query59 2830 2534 2400 2400
query60 311 281 285 281
query61 116 117 118 117
query62 886 654 673 654
query63 223 187 188 187
query64 5866 2014 1976 1976
query65 3179 3085 3098 3085
query66 1341 342 348 342
query67 15323 14795 14946 14795
query68 4821 706 569 569
query69 747 374 316 316
query70 1124 1058 1101 1058
query71 489 279 268 268
query72 8174 2673 2533 2533
query73 856 331 330 330
query74 6005 5600 5646 5600
query75 4429 2718 2743 2718
query76 3608 1366 1411 1366
query77 734 311 303 303
query78 9550 8956 8837 8837
query79 3979 533 538 533
query80 2547 508 495 495
query81 566 225 227 225
query82 785 128 127 127
query83 298 174 173 173
query84 275 82 77 77
query85 1516 306 308 306
query86 426 307 281 281
query87 3313 3077 3055 3055
query88 4068 2498 2535 2498
query89 475 290 290 290
query90 1982 190 192 190
query91 124 100 99 99
query92 61 53 48 48
query93 5222 629 629 629
query94 959 286 285 285
query95 385 278 311 278
query96 627 286 284 284
query97 3196 3041 3061 3041
query98 223 209 199 199
query99 1613 1292 1336 1292
Total cold run time: 275429 ms
Total hot run time: 170805 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](move-memtable) tolerate minority replica failure in load stream [doris]
Posted by "kaijchen (via GitHub)" <gi...@apache.org>.
kaijchen commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2256582734
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](move-memtable) tolerate minority replica failure in load stream [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2260144219
clang-tidy review says "All clean, LGTM! :+1:"
--
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](move-memtable) tolerate minority replica failure in load stream [doris]
Posted by "kaijchen (via GitHub)" <gi...@apache.org>.
kaijchen closed pull request #38119: [fix](move-memtable) tolerate minority replica failure in load stream
URL: https://github.com/apache/doris/pull/38119
--
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](move-memtable) tolerate minority replica failure in load stream [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2256654535
<details>
<summary>TPC-H: <b>Total hot run time: 41478 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 ff3287d28ccead387ef801a117c84768ce2f9a98, data reload: false
------ Round 1 ----------------------------------
q1 17592 4091 4042 4042
q2 2027 203 209 203
q3 10460 1299 1337 1299
q4 10183 843 946 843
q5 7637 2992 2958 2958
q6 222 140 140 140
q7 1037 603 594 594
q8 9433 1929 1933 1929
q9 8501 6607 6609 6607
q10 8743 3831 3827 3827
q11 426 245 248 245
q12 413 229 223 223
q13 17762 2937 2905 2905
q14 280 238 243 238
q15 516 482 492 482
q16 521 397 387 387
q17 964 912 910 910
q18 7978 7206 7188 7188
q19 1583 1217 1213 1213
q20 571 319 355 319
q21 5303 4767 4641 4641
q22 355 290 285 285
Total cold run time: 112507 ms
Total hot run time: 41478 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4106 4033 4027 4027
q2 322 221 224 221
q3 2979 2972 3117 2972
q4 1993 2012 1979 1979
q5 5601 5454 5409 5409
q6 228 131 130 130
q7 2152 1777 1845 1777
q8 3307 3386 3346 3346
q9 8658 8680 8787 8680
q10 3962 4081 3990 3990
q11 548 439 444 439
q12 762 612 638 612
q13 16406 3093 3128 3093
q14 306 282 268 268
q15 521 512 489 489
q16 457 405 417 405
q17 1750 1702 1713 1702
q18 8182 7792 7719 7719
q19 1716 1710 1720 1710
q20 2049 1887 1821 1821
q21 5806 5443 5307 5307
q22 504 458 459 458
Total cold run time: 72315 ms
Total hot run time: 56554 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](move-memtable) tolerate minority replica failure in load stream [doris]
Posted by "kaijchen (via GitHub)" <gi...@apache.org>.
kaijchen commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2257328309
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](move-memtable) tolerate minority replica failure in load stream [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2254885772
<details>
<summary>TPC-DS: <b>Total hot run time: 174213 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 dd7d95e67e95ee66a2e58527a1227f2aae76c4f2, data reload: false
query1 913 367 361 361
query2 6324 1977 1889 1889
query3 6658 207 223 207
query4 28409 17652 17367 17367
query5 3661 484 490 484
query6 282 187 164 164
query7 4597 286 283 283
query8 265 194 200 194
query9 8524 2468 2445 2445
query10 427 274 273 273
query11 11708 10028 10044 10028
query12 134 87 86 86
query13 1617 374 360 360
query14 10661 8695 8339 8339
query15 216 174 177 174
query16 7708 477 488 477
query17 1604 568 553 553
query18 1969 299 294 294
query19 196 144 141 141
query20 93 85 85 85
query21 206 106 100 100
query22 4265 4097 3860 3860
query23 34223 33778 33462 33462
query24 11946 2942 2951 2942
query25 697 420 432 420
query26 1792 159 151 151
query27 2960 279 280 279
query28 7485 2093 2095 2093
query29 1153 445 440 440
query30 284 158 169 158
query31 946 741 741 741
query32 102 55 55 55
query33 766 353 341 341
query34 966 483 498 483
query35 901 771 767 767
query36 1104 980 943 943
query37 277 78 82 78
query38 2969 2850 2838 2838
query39 908 837 802 802
query40 246 109 111 109
query41 44 44 44 44
query42 115 93 94 93
query43 503 466 470 466
query44 1226 736 715 715
query45 202 179 179 179
query46 1127 717 731 717
query47 1828 1774 1781 1774
query48 369 298 307 298
query49 995 414 417 414
query50 822 406 432 406
query51 6795 6743 6710 6710
query52 104 95 89 89
query53 252 183 178 178
query54 888 465 455 455
query55 75 75 72 72
query56 304 277 271 271
query57 1140 1052 1026 1026
query58 259 256 267 256
query59 2836 2551 2775 2551
query60 306 285 272 272
query61 99 94 97 94
query62 821 645 639 639
query63 211 184 186 184
query64 10304 2296 1715 1715
query65 3146 3085 3099 3085
query66 1280 333 346 333
query67 15244 14814 14816 14814
query68 6416 559 559 559
query69 612 427 324 324
query70 1158 1119 1082 1082
query71 475 274 261 261
query72 7158 5612 5823 5612
query73 795 329 333 329
query74 6060 5643 5702 5643
query75 4115 2661 2663 2661
query76 4328 1057 1035 1035
query77 661 309 301 301
query78 11149 9088 9097 9088
query79 6611 535 518 518
query80 1149 487 485 485
query81 553 222 226 222
query82 800 134 131 131
query83 212 171 171 171
query84 274 79 79 79
query85 1320 309 299 299
query86 453 270 297 270
query87 3205 3020 3071 3020
query88 4675 2465 2478 2465
query89 438 284 287 284
query90 1885 199 198 198
query91 124 101 101 101
query92 62 48 48 48
query93 4974 549 542 542
query94 823 305 305 305
query95 360 267 267 267
query96 611 277 279 277
query97 3194 3064 3046 3046
query98 221 217 192 192
query99 1648 1290 1282 1282
Total cold run time: 297976 ms
Total hot run time: 174213 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](move-memtable) tolerate minority replica failure in load stream [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2257398862
<details>
<summary>TPC-H: <b>Total hot run time: 41655 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 f88d45a0c398e15f7b413312a15f1bd7f0f34d47, data reload: false
------ Round 1 ----------------------------------
q1 17615 4132 4105 4105
q2 2019 205 203 203
q3 10442 1281 1350 1281
q4 10160 793 937 793
q5 7609 2931 2985 2931
q6 221 141 140 140
q7 1037 614 597 597
q8 9452 1937 1963 1937
q9 8546 6655 6614 6614
q10 8724 3838 3850 3838
q11 429 244 244 244
q12 402 226 224 224
q13 17766 2963 2935 2935
q14 275 233 244 233
q15 524 476 481 476
q16 525 394 387 387
q17 967 926 922 922
q18 8080 7321 7181 7181
q19 1507 1227 1234 1227
q20 569 323 339 323
q21 5337 4868 4786 4786
q22 347 281 278 278
Total cold run time: 112553 ms
Total hot run time: 41655 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4077 4013 4011 4011
q2 329 221 228 221
q3 3029 2998 3142 2998
q4 1986 2058 1969 1969
q5 5622 5523 5472 5472
q6 220 128 141 128
q7 2105 1780 1822 1780
q8 3343 3385 3367 3367
q9 8747 8682 8783 8682
q10 4000 4055 3957 3957
q11 550 450 455 450
q12 737 579 619 579
q13 16445 3106 3085 3085
q14 309 276 264 264
q15 525 496 480 480
q16 468 436 407 407
q17 1769 1746 1790 1746
q18 8193 7857 7716 7716
q19 1737 1738 1721 1721
q20 2061 1931 1865 1865
q21 5693 5493 5283 5283
q22 512 458 474 458
Total cold run time: 72457 ms
Total hot run time: 56639 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](move-memtable) tolerate minority replica failure in load stream [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2256684553
<details>
<summary>ClickBench: <b>Total hot run time: 29.94 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 ff3287d28ccead387ef801a117c84768ce2f9a98, data reload: false
query1 0.05 0.04 0.04
query2 0.07 0.04 0.04
query3 0.22 0.05 0.05
query4 1.68 0.08 0.08
query5 0.51 0.49 0.48
query6 1.15 0.71 0.71
query7 0.02 0.01 0.01
query8 0.05 0.04 0.04
query9 0.56 0.50 0.52
query10 0.56 0.57 0.58
query11 0.15 0.11 0.12
query12 0.16 0.12 0.13
query13 0.61 0.60 0.59
query14 0.77 0.78 0.81
query15 0.90 0.86 0.87
query16 0.36 0.34 0.35
query17 0.97 0.98 0.97
query18 0.22 0.20 0.21
query19 1.85 1.74 1.78
query20 0.02 0.01 0.00
query21 15.39 0.76 0.66
query22 4.29 7.68 1.13
query23 18.02 1.38 1.43
query24 2.23 0.23 0.21
query25 0.19 0.09 0.08
query26 0.30 0.21 0.22
query27 0.45 0.23 0.24
query28 13.16 1.00 0.96
query29 12.50 3.24 3.23
query30 0.25 0.05 0.06
query31 2.87 0.41 0.40
query32 3.22 0.49 0.48
query33 2.92 2.93 3.00
query34 15.89 4.32 4.30
query35 4.38 4.35 4.38
query36 0.68 0.50 0.51
query37 0.19 0.17 0.16
query38 0.17 0.16 0.15
query39 0.05 0.04 0.04
query40 0.17 0.13 0.14
query41 0.10 0.05 0.05
query42 0.06 0.04 0.05
query43 0.05 0.04 0.04
Total cold run time: 108.41 s
Total hot run time: 29.94 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](move-memtable) tolerate minority replica failure in load stream [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38119:
URL: https://github.com/apache/doris/pull/38119#issuecomment-2260231124
<details>
<summary>TPC-DS: <b>Total hot run time: 169948 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 cacc69e0be0c23dc4ef1037ff8514f19bdc3f4e8, data reload: false
query1 921 377 376 376
query2 6448 1667 1685 1667
query3 6666 215 231 215
query4 20038 17490 17363 17363
query5 3645 506 532 506
query6 288 182 176 176
query7 4602 297 302 297
query8 247 194 197 194
query9 8519 2404 2368 2368
query10 427 271 289 271
query11 10391 10002 10016 10002
query12 124 90 90 90
query13 1645 379 371 371
query14 10312 8663 7245 7245
query15 201 163 167 163
query16 6876 430 438 430
query17 937 560 556 556
query18 1916 294 290 290
query19 200 151 148 148
query20 93 90 89 89
query21 212 105 100 100
query22 4180 4082 4099 4082
query23 33978 33590 33582 33582
query24 10316 3060 3093 3060
query25 677 402 424 402
query26 1682 149 153 149
query27 2943 280 284 280
query28 7636 2009 2000 2000
query29 1196 447 450 447
query30 240 160 155 155
query31 941 755 778 755
query32 100 58 61 58
query33 688 327 324 324
query34 918 478 509 478
query35 904 772 771 771
query36 1027 884 860 860
query37 166 82 79 79
query38 2914 2815 2770 2770
query39 878 810 823 810
query40 281 110 115 110
query41 45 43 44 43
query42 117 105 102 102
query43 452 414 429 414
query44 1163 732 733 732
query45 203 172 178 172
query46 1074 779 764 764
query47 1822 1679 1707 1679
query48 352 303 289 289
query49 961 427 419 419
query50 895 432 438 432
query51 6773 6734 6632 6632
query52 102 93 89 89
query53 247 185 178 178
query54 611 458 445 445
query55 78 77 76 76
query56 289 261 258 258
query57 1135 1050 1031 1031
query58 279 277 300 277
query59 2446 2389 2414 2389
query60 289 279 274 274
query61 98 93 93 93
query62 885 679 653 653
query63 210 184 187 184
query64 5682 1923 1936 1923
query65 3154 3076 3088 3076
query66 1102 338 333 333
query67 15199 14875 14812 14812
query68 4374 552 567 552
query69 498 306 306 306
query70 1128 1060 1043 1043
query71 450 276 271 271
query72 7097 2671 2466 2466
query73 761 322 327 322
query74 6048 5597 5588 5588
query75 3379 2728 2752 2728
query76 2702 1326 1401 1326
query77 455 305 311 305
query78 9418 8857 8924 8857
query79 1941 538 532 532
query80 1123 561 505 505
query81 575 227 226 226
query82 1045 140 126 126
query83 233 172 172 172
query84 268 80 82 80
query85 1342 305 299 299
query86 467 286 319 286
query87 3253 3163 3105 3105
query88 2920 2389 2400 2389
query89 381 290 287 287
query90 1768 238 192 192
query91 127 100 100 100
query92 62 50 51 50
query93 2110 609 621 609
query94 825 300 281 281
query95 372 264 277 264
query96 602 282 293 282
query97 3229 3047 3032 3032
query98 220 203 199 199
query99 1678 1310 1317 1310
Total cold run time: 262887 ms
Total hot run time: 169948 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