You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "SWJTU-ZhangLei (via GitHub)" <gi...@apache.org> on 2025/05/08 08:32:20 UTC
[PR] [fix](storage vault) Fix two storage vault regression cases [doris]
SWJTU-ZhangLei opened a new pull request, #50703:
URL: https://github.com/apache/doris/pull/50703
* move `not set use_path_style` case from `test_create_vault` to `test_minio_storage_vault` because aliyun oss don't allow path style, but default is path style
* fix `test_create_vault_with_case_sensitive` case fail, indroduced by code refactor by https://github.com/apache/doris/pull/50395
### What problem does this PR solve?
Issue Number: close #xxx
Related PR: #xxx
Problem Summary:
### Release note
None
### Check List (For Author)
- Test <!-- At least one of them must be included. -->
- [ ] Regression test
- [ ] Unit Test
- [ ] Manual test (add detailed scripts or steps below)
- [ ] No need to test or manual test. Explain why:
- [ ] This is a refactor/code format and no logic has been changed.
- [ ] Previous test can cover this change.
- [ ] No code files have been changed.
- [ ] Other reason <!-- Add your reason? -->
- Behavior changed:
- [ ] No.
- [ ] Yes. <!-- Explain the behavior change -->
- Does this need documentation?
- [ ] No.
- [ ] Yes. <!-- Add document PR link here. eg: https://github.com/apache/doris-website/pull/1214 -->
### Check List (For Reviewer who merge this PR)
- [ ] Confirm the release note
- [ ] Confirm test cases
- [ ] Confirm document
- [ ] Add branch pick label <!-- Add branch pick label that this PR should merge into -->
--
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](storage vault) Fix two storage vault regression cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2865253518
<details>
<summary>TPC-H: <b>Total hot run time: 35047 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 2acf9e2de6d3f570efea7fdec4be1249833c2533, data reload: false
------ Round 1 ----------------------------------
q1 26405 5154 5133 5133
q2 2088 290 191 191
q3 10380 1276 733 733
q4 10221 1040 531 531
q5 7503 2399 2379 2379
q6 191 166 137 137
q7 940 749 643 643
q8 9331 1436 1127 1127
q9 6802 5096 5132 5096
q10 6809 2290 1917 1917
q11 506 285 269 269
q12 357 351 213 213
q13 17747 3707 3136 3136
q14 226 225 211 211
q15 525 478 483 478
q16 425 430 369 369
q17 610 868 361 361
q18 7505 7346 7182 7182
q19 1215 972 553 553
q20 341 341 231 231
q21 4242 3605 3190 3190
q22 1043 967 980 967
Total cold run time: 115412 ms
Total hot run time: 35047 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5148 5165 5167 5165
q2 243 336 234 234
q3 2149 2721 2292 2292
q4 1331 1905 1495 1495
q5 4566 4430 4448 4430
q6 218 175 131 131
q7 2048 1911 1789 1789
q8 2569 2640 2558 2558
q9 7086 7113 7079 7079
q10 3035 3196 2726 2726
q11 582 515 494 494
q12 717 787 631 631
q13 3534 3898 3238 3238
q14 279 299 265 265
q15 526 478 483 478
q16 423 519 445 445
q17 1173 1606 1363 1363
q18 7749 7585 7330 7330
q19 825 817 862 817
q20 1975 2016 1867 1867
q21 5126 4720 4533 4533
q22 1019 1015 975 975
Total cold run time: 52321 ms
Total hot run time: 50335 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](storage vault) Fix two storage vault regression cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2865181674
<details>
<summary>ClickBench: <b>Total hot run time: 29.3 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 2acf9e2de6d3f570efea7fdec4be1249833c2533, data reload: false
query1 0.05 0.04 0.02
query2 0.13 0.10 0.10
query3 0.25 0.20 0.19
query4 1.59 0.20 0.20
query5 0.60 0.59 0.60
query6 1.22 0.70 0.72
query7 0.02 0.02 0.01
query8 0.04 0.04 0.04
query9 0.57 0.50 0.52
query10 0.57 0.57 0.57
query11 0.16 0.11 0.11
query12 0.15 0.11 0.11
query13 0.61 0.60 0.59
query14 0.78 0.79 0.80
query15 0.89 0.84 0.86
query16 0.38 0.38 0.38
query17 1.03 1.03 1.03
query18 0.22 0.20 0.20
query19 1.92 1.78 1.84
query20 0.01 0.01 0.01
query21 15.39 0.91 0.56
query22 0.77 1.13 0.61
query23 15.04 1.38 0.62
query24 6.85 1.91 0.92
query25 0.50 0.09 0.13
query26 0.58 0.17 0.13
query27 0.05 0.05 0.05
query28 9.93 0.87 0.44
query29 12.57 4.03 3.39
query30 0.26 0.09 0.06
query31 2.82 0.58 0.38
query32 3.22 0.54 0.47
query33 2.97 3.08 3.12
query34 15.76 5.08 4.52
query35 4.50 4.45 4.42
query36 0.67 0.49 0.47
query37 0.09 0.06 0.07
query38 0.05 0.04 0.04
query39 0.03 0.02 0.02
query40 0.16 0.14 0.13
query41 0.09 0.03 0.03
query42 0.04 0.02 0.03
query43 0.03 0.04 0.03
Total cold run time: 103.56 s
Total hot run time: 29.3 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](storage vault) Fix two storage vault regression cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2866270699
<details>
<summary>TPC-H: <b>Total hot run time: 33963 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 2acf9e2de6d3f570efea7fdec4be1249833c2533, data reload: false
------ Round 1 ----------------------------------
q1 26491 5037 4986 4986
q2 2080 295 200 200
q3 10562 1270 694 694
q4 10255 1018 524 524
q5 8022 2383 2397 2383
q6 186 171 134 134
q7 948 774 609 609
q8 9354 1304 1119 1119
q9 6833 5180 5093 5093
q10 6844 2301 1874 1874
q11 481 286 264 264
q12 349 354 211 211
q13 17770 3665 3087 3087
q14 237 227 212 212
q15 529 488 486 486
q16 441 438 377 377
q17 619 870 365 365
q18 7653 7395 7145 7145
q19 1593 969 552 552
q20 334 342 227 227
q21 4076 3376 2460 2460
q22 998 1000 961 961
Total cold run time: 116655 ms
Total hot run time: 33963 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5070 5274 5086 5086
q2 238 328 233 233
q3 2172 2636 2320 2320
q4 1339 1792 1430 1430
q5 4514 4417 4360 4360
q6 226 170 127 127
q7 2038 1939 1768 1768
q8 2628 2641 2556 2556
q9 7306 7081 7235 7081
q10 2968 3151 2727 2727
q11 575 514 487 487
q12 670 761 637 637
q13 3539 3901 3316 3316
q14 321 302 275 275
q15 519 475 462 462
q16 443 488 445 445
q17 1168 1539 1393 1393
q18 7763 7577 7399 7399
q19 840 851 1063 851
q20 2055 1985 1830 1830
q21 5071 4715 4610 4610
q22 1077 1048 1012 1012
Total cold run time: 52540 ms
Total hot run time: 50405 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](storage vault) Fix two storage vault regression cases [doris]
Posted by "SWJTU-ZhangLei (via GitHub)" <gi...@apache.org>.
SWJTU-ZhangLei commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2868207377
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](storage vault) Fix two storage vault regression cases [doris]
Posted by "SWJTU-ZhangLei (via GitHub)" <gi...@apache.org>.
SWJTU-ZhangLei commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2871414229
new MockUp<S3Client>(S3Client.class) {
@Mock
public ListObjectsV2Response listObjectsV2(ListObjectsV2Request listObjectsV2Request) {
ListObjectsV2Response.Builder builder = ListObjectsV2Response.builder();
List<S3Object> s3Objects = new ArrayList<>();
String prefix = listObjectsV2Request.prefix();
String continuationToken = listObjectsV2Request.continuationToken();
int startIndex = 0;
if (continuationToken != null) {
startIndex = Integer.parseInt(continuationToken);
}
int endIndex = Math.min(startIndex + numBatch, allObjKeys.size());
for (int i = startIndex; i < endIndex; ++i) {
String objKey = allObjKeys.get(i);
if (prefix != null && !objKey.startsWith(prefix)) {
continue;
}
s3Objects.add(S3Object.builder().key(objKey).build());
}
builder.contents(s3Objects);
if (endIndex < allObjKeys.size()) {
builder.isTruncated(true);
builder.nextContinuationToken(String.valueOf(endIndex));
} else {
builder.isTruncated(false);
builder.nextContinuationToken(null);
}
return builder.build();
} mock没生效
--
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](storage vault) Fix two storage vault regression cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2865284789
<details>
<summary>ClickBench: <b>Total hot run time: 28.67 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 2acf9e2de6d3f570efea7fdec4be1249833c2533, data reload: false
query1 0.04 0.03 0.03
query2 0.12 0.10 0.11
query3 0.25 0.20 0.20
query4 1.59 0.19 0.12
query5 0.59 0.55 0.55
query6 1.18 0.73 0.72
query7 0.03 0.02 0.02
query8 0.05 0.04 0.03
query9 0.59 0.52 0.50
query10 0.56 0.58 0.56
query11 0.16 0.11 0.11
query12 0.16 0.12 0.12
query13 0.62 0.59 0.60
query14 0.79 0.80 0.80
query15 0.87 0.85 0.89
query16 0.38 0.39 0.38
query17 0.97 1.03 1.08
query18 0.20 0.20 0.21
query19 1.87 1.74 1.73
query20 0.02 0.01 0.01
query21 15.41 0.93 0.57
query22 0.74 1.15 0.63
query23 15.01 1.37 0.63
query24 7.83 0.86 0.43
query25 0.49 0.27 0.07
query26 0.58 0.16 0.14
query27 0.05 0.05 0.04
query28 9.11 0.90 0.44
query29 12.55 4.09 3.40
query30 0.26 0.09 0.07
query31 2.82 0.57 0.37
query32 3.22 0.56 0.46
query33 3.03 2.99 3.10
query34 15.69 5.08 4.46
query35 4.53 4.52 4.53
query36 0.69 0.49 0.48
query37 0.09 0.07 0.06
query38 0.05 0.04 0.04
query39 0.03 0.02 0.02
query40 0.17 0.14 0.13
query41 0.07 0.03 0.03
query42 0.02 0.02 0.03
query43 0.04 0.03 0.02
Total cold run time: 103.52 s
Total hot run time: 28.67 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](storage vault) Fix two storage vault regression cases [doris]
Posted by "SWJTU-ZhangLei (via GitHub)" <gi...@apache.org>.
SWJTU-ZhangLei commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2862691984
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](storage vault) Fix two storage vault regression cases [doris]
Posted by "SWJTU-ZhangLei (via GitHub)" <gi...@apache.org>.
SWJTU-ZhangLei commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2864903977
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](storage vault) Fix two storage vault regression cases [doris]
Posted by "SWJTU-ZhangLei (via GitHub)" <gi...@apache.org>.
SWJTU-ZhangLei commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2865195336
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](storage vault) Fix two storage vault regression cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2865274677
<details>
<summary>TPC-DS: <b>Total hot run time: 185136 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 2acf9e2de6d3f570efea7fdec4be1249833c2533, data reload: false
query1 1002 478 508 478
query2 6550 1772 1782 1772
query3 6756 233 223 223
query4 26395 23646 23384 23384
query5 4369 618 453 453
query6 293 201 190 190
query7 4622 500 275 275
query8 295 240 241 240
query9 8627 2549 2529 2529
query10 469 330 286 286
query11 15354 15065 14824 14824
query12 161 110 107 107
query13 1668 519 404 404
query14 8704 6059 6031 6031
query15 217 188 161 161
query16 7222 626 453 453
query17 1182 704 544 544
query18 1961 390 293 293
query19 180 178 155 155
query20 119 118 116 116
query21 213 120 108 108
query22 4051 4189 3929 3929
query23 33718 33013 32851 32851
query24 8459 2380 2421 2380
query25 540 449 402 402
query26 1233 266 152 152
query27 2748 494 329 329
query28 4348 2081 2060 2060
query29 759 556 426 426
query30 280 216 181 181
query31 920 836 751 751
query32 73 70 65 65
query33 583 390 322 322
query34 784 838 520 520
query35 783 814 741 741
query36 938 1000 880 880
query37 113 103 80 80
query38 4136 4197 4109 4109
query39 1457 1401 1412 1401
query40 225 126 116 116
query41 64 63 61 61
query42 123 114 111 111
query43 502 490 476 476
query44 1298 807 808 807
query45 191 178 172 172
query46 829 1033 641 641
query47 1784 1787 1717 1717
query48 379 438 307 307
query49 805 521 456 456
query50 652 692 404 404
query51 4087 4170 4040 4040
query52 105 104 95 95
query53 226 258 182 182
query54 580 573 504 504
query55 85 77 91 77
query56 304 308 310 308
query57 1165 1141 1063 1063
query58 264 248 256 248
query59 2537 2611 2560 2560
query60 330 324 303 303
query61 148 124 124 124
query62 820 760 653 653
query63 225 186 188 186
query64 4376 1018 669 669
query65 4329 4244 4290 4244
query66 1144 414 312 312
query67 15805 15631 15330 15330
query68 9030 889 509 509
query69 467 321 259 259
query70 1226 1115 1123 1115
query71 465 312 294 294
query72 5349 4654 4649 4649
query73 713 583 342 342
query74 9244 8798 8747 8747
query75 4229 3185 2694 2694
query76 3668 1192 753 753
query77 861 366 288 288
query78 9862 10195 9198 9198
query79 2596 817 566 566
query80 628 505 440 440
query81 470 266 216 216
query82 471 132 102 102
query83 288 255 233 233
query84 293 100 85 85
query85 791 353 325 325
query86 336 365 292 292
query87 4428 4464 4353 4353
query88 3106 2214 2210 2210
query89 428 321 284 284
query90 1952 219 211 211
query91 148 167 113 113
query92 77 67 58 58
query93 1361 930 581 581
query94 669 406 311 311
query95 372 296 290 290
query96 494 567 280 280
query97 3168 3190 3104 3104
query98 219 208 204 204
query99 1426 1411 1259 1259
Total cold run time: 274499 ms
Total hot run time: 185136 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](storage vault) Fix two storage vault regression cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2862281378
<details>
<summary>TPC-H: <b>Total hot run time: 33913 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 11774a1e01e8447b9d3e8aac376bfde8c010501d, data reload: false
------ Round 1 ----------------------------------
q1 26116 5106 5040 5040
q2 2074 282 181 181
q3 10395 1243 716 716
q4 10230 1008 551 551
q5 7994 2362 2383 2362
q6 182 162 131 131
q7 919 758 624 624
q8 9325 1291 1054 1054
q9 6793 5086 5037 5037
q10 6821 2323 1887 1887
q11 474 286 260 260
q12 340 349 216 216
q13 17795 3679 3093 3093
q14 227 230 210 210
q15 531 484 498 484
q16 431 435 366 366
q17 609 851 381 381
q18 7544 7223 7094 7094
q19 1296 975 582 582
q20 342 350 224 224
q21 4124 2704 2464 2464
q22 1061 1013 956 956
Total cold run time: 115623 ms
Total hot run time: 33913 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5087 5081 5079 5079
q2 243 325 229 229
q3 2181 2690 2318 2318
q4 1359 1748 1386 1386
q5 4603 4453 4406 4406
q6 212 173 127 127
q7 1988 1938 1760 1760
q8 2602 2595 2512 2512
q9 7188 7174 7155 7155
q10 2981 3241 2735 2735
q11 556 494 505 494
q12 688 794 608 608
q13 3435 3918 3276 3276
q14 287 301 259 259
q15 525 488 478 478
q16 448 490 442 442
q17 1144 1520 1389 1389
q18 7700 7572 7405 7405
q19 791 778 851 778
q20 1967 1999 1842 1842
q21 5104 4597 4554 4554
q22 1041 992 1001 992
Total cold run time: 52130 ms
Total hot run time: 50224 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](storage vault) Fix two storage vault regression cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2871160532
<details>
<summary>TPC-DS: <b>Total hot run time: 193246 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 bf860a61a2ad3b414e5381fe081d33171011cd73, data reload: false
query1 1453 1095 1061 1061
query2 6349 1825 1810 1810
query3 11033 4489 4419 4419
query4 54916 25292 23520 23520
query5 5097 558 474 474
query6 336 213 216 213
query7 4874 512 297 297
query8 337 263 241 241
query9 5440 2669 2670 2669
query10 440 335 284 284
query11 15088 15166 14948 14948
query12 160 112 105 105
query13 1038 532 399 399
query14 10313 6624 6469 6469
query15 200 196 187 187
query16 7038 643 516 516
query17 1067 760 605 605
query18 1531 402 301 301
query19 192 196 166 166
query20 129 124 121 121
query21 208 126 118 118
query22 4473 4329 4152 4152
query23 34485 33356 33586 33356
query24 6576 2399 2462 2399
query25 457 471 421 421
query26 692 279 157 157
query27 2214 511 351 351
query28 3078 2169 2173 2169
query29 562 557 433 433
query30 282 222 194 194
query31 860 862 793 793
query32 73 66 65 65
query33 446 386 316 316
query34 768 872 539 539
query35 785 840 751 751
query36 926 999 901 901
query37 127 105 75 75
query38 4188 4280 4208 4208
query39 1520 1451 1626 1451
query40 215 124 107 107
query41 55 58 60 58
query42 129 110 113 110
query43 498 500 493 493
query44 1360 870 843 843
query45 183 181 170 170
query46 844 1032 672 672
query47 1833 1851 1828 1828
query48 418 445 343 343
query49 728 576 500 500
query50 674 708 413 413
query51 4238 4266 4188 4188
query52 117 108 100 100
query53 229 261 188 188
query54 601 568 518 518
query55 84 88 85 85
query56 303 316 278 278
query57 1171 1172 1127 1127
query58 268 257 264 257
query59 2682 2780 2675 2675
query60 329 334 319 319
query61 131 130 126 126
query62 763 713 668 668
query63 229 194 192 192
query64 1689 1045 686 686
query65 4399 4274 4211 4211
query66 727 404 295 295
query67 16005 15872 15331 15331
query68 6788 881 525 525
query69 535 303 277 277
query70 1225 1153 1056 1056
query71 519 324 317 317
query72 6037 4876 4986 4876
query73 1427 724 359 359
query74 9166 9086 8675 8675
query75 3959 3235 2761 2761
query76 4161 1173 747 747
query77 651 383 297 297
query78 10041 10119 9262 9262
query79 2702 778 601 601
query80 736 523 456 456
query81 486 252 223 223
query82 530 129 99 99
query83 357 243 240 240
query84 296 100 90 90
query85 770 430 315 315
query86 370 304 281 281
query87 4412 4537 4340 4340
query88 3402 2287 2282 2282
query89 426 318 291 291
query90 1806 204 200 200
query91 143 138 113 113
query92 72 66 64 64
query93 2257 940 573 573
query94 661 412 310 310
query95 367 289 299 289
query96 484 572 281 281
query97 3180 3201 3162 3162
query98 236 228 199 199
query99 1399 1374 1250 1250
Total cold run time: 300254 ms
Total hot run time: 193246 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](storage vault) Fix two storage vault regression cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2871109528
<details>
<summary>TPC-H: <b>Total hot run time: 33900 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 bf860a61a2ad3b414e5381fe081d33171011cd73, data reload: false
------ Round 1 ----------------------------------
q1 25621 5081 5049 5049
q2 2079 298 191 191
q3 10374 1253 679 679
q4 10222 979 513 513
q5 7510 2345 2320 2320
q6 178 160 131 131
q7 904 762 625 625
q8 9345 1259 1088 1088
q9 7122 5044 5045 5044
q10 6864 2302 1865 1865
q11 489 284 272 272
q12 346 347 212 212
q13 17783 3675 3109 3109
q14 223 229 217 217
q15 516 481 496 481
q16 424 425 371 371
q17 608 880 384 384
q18 7608 7183 7237 7183
q19 2001 984 554 554
q20 328 332 214 214
q21 3868 2614 2449 2449
q22 1004 999 949 949
Total cold run time: 115417 ms
Total hot run time: 33900 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5235 5130 5072 5072
q2 240 322 221 221
q3 2173 2660 2307 2307
q4 1352 1841 1329 1329
q5 4444 4408 4380 4380
q6 215 164 134 134
q7 1986 1932 1811 1811
q8 2621 2549 2549 2549
q9 7215 7173 6948 6948
q10 2982 3203 2755 2755
q11 601 531 506 506
q12 715 790 625 625
q13 3461 4019 3291 3291
q14 289 298 290 290
q15 530 489 494 489
q16 472 497 434 434
q17 1166 1560 1411 1411
q18 7679 7630 7442 7442
q19 797 769 842 769
q20 1955 2068 1882 1882
q21 5164 4905 4731 4731
q22 1067 1030 1060 1030
Total cold run time: 52359 ms
Total hot run time: 50406 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](storage vault) Fix two storage vault regression cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2862940735
<details>
<summary>TPC-H: <b>Total hot run time: 34060 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 94dea4fbf5dcb0f6ac6774056d4e462d0a250cfb, data reload: false
------ Round 1 ----------------------------------
q1 26971 5207 5269 5207
q2 2068 280 180 180
q3 10395 1267 689 689
q4 10232 1001 513 513
q5 7529 2331 2385 2331
q6 185 167 133 133
q7 913 750 618 618
q8 9343 1285 1117 1117
q9 6781 5071 5135 5071
q10 6864 2321 1903 1903
q11 494 274 259 259
q12 348 358 210 210
q13 17779 3706 3087 3087
q14 239 226 206 206
q15 517 484 492 484
q16 428 435 376 376
q17 616 876 372 372
q18 7571 7205 7083 7083
q19 1585 961 548 548
q20 353 342 235 235
q21 3905 3384 2464 2464
q22 1055 1047 974 974
Total cold run time: 116171 ms
Total hot run time: 34060 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5151 5083 5061 5061
q2 248 332 232 232
q3 2215 2669 2269 2269
q4 1322 1913 1450 1450
q5 4474 4471 4447 4447
q6 218 168 128 128
q7 2027 1945 1770 1770
q8 2589 2613 2529 2529
q9 7264 7033 7233 7033
q10 3019 3176 2735 2735
q11 587 496 501 496
q12 695 773 599 599
q13 3513 3870 3330 3330
q14 283 292 268 268
q15 515 475 485 475
q16 457 491 447 447
q17 1188 1551 1430 1430
q18 7733 7591 7341 7341
q19 833 875 943 875
q20 1989 1971 1837 1837
q21 5197 4724 4794 4724
q22 1092 1063 1020 1020
Total cold run time: 52609 ms
Total hot run time: 50496 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](storage vault) Fix two storage vault regression cases [doris]
Posted by "SWJTU-ZhangLei (via GitHub)" <gi...@apache.org>.
SWJTU-ZhangLei commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2862218253
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](storage vault) Fix two storage vault regression cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2862333413
<details>
<summary>ClickBench: <b>Total hot run time: 29.05 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 11774a1e01e8447b9d3e8aac376bfde8c010501d, data reload: false
query1 0.04 0.04 0.03
query2 0.13 0.11 0.11
query3 0.26 0.20 0.19
query4 1.59 0.20 0.11
query5 0.55 0.54 0.56
query6 1.19 0.73 0.72
query7 0.03 0.02 0.02
query8 0.04 0.03 0.04
query9 0.57 0.53 0.51
query10 0.58 0.59 0.56
query11 0.16 0.12 0.11
query12 0.15 0.12 0.12
query13 0.61 0.60 0.60
query14 0.79 0.80 0.79
query15 0.88 0.85 0.86
query16 0.39 0.38 0.42
query17 1.02 1.05 1.03
query18 0.21 0.19 0.20
query19 1.89 1.78 1.81
query20 0.01 0.01 0.01
query21 15.42 0.88 0.54
query22 0.77 1.31 0.66
query23 14.74 1.40 0.63
query24 6.95 1.38 0.66
query25 0.51 0.14 0.15
query26 0.65 0.17 0.14
query27 0.04 0.05 0.05
query28 9.50 0.85 0.43
query29 12.59 3.88 3.28
query30 0.25 0.09 0.07
query31 2.82 0.60 0.39
query32 3.23 0.55 0.47
query33 2.98 3.12 3.16
query34 15.80 5.08 4.50
query35 4.52 4.53 4.50
query36 0.67 0.50 0.48
query37 0.09 0.06 0.07
query38 0.06 0.05 0.03
query39 0.03 0.02 0.02
query40 0.17 0.14 0.12
query41 0.09 0.03 0.03
query42 0.03 0.02 0.02
query43 0.03 0.03 0.03
Total cold run time: 103.03 s
Total hot run time: 29.05 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](storage vault) Fix two storage vault regression cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2864963212
<details>
<summary>TPC-DS: <b>Total hot run time: 192289 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 94dea4fbf5dcb0f6ac6774056d4e462d0a250cfb, data reload: false
query1 1413 1102 1038 1038
query2 6209 1780 1754 1754
query3 10988 4448 4609 4448
query4 54957 24754 23237 23237
query5 5185 524 448 448
query6 331 197 193 193
query7 4876 518 289 289
query8 323 263 238 238
query9 5600 2546 2543 2543
query10 416 325 265 265
query11 15322 15103 15144 15103
query12 157 114 112 112
query13 1037 545 389 389
query14 10297 6427 6484 6427
query15 198 189 186 186
query16 7009 682 491 491
query17 1100 768 594 594
query18 1552 437 327 327
query19 210 198 180 180
query20 137 122 119 119
query21 211 127 109 109
query22 4380 4413 4312 4312
query23 34042 33424 33505 33424
query24 6615 2449 2477 2449
query25 451 476 409 409
query26 670 281 155 155
query27 2201 500 346 346
query28 2965 2098 2094 2094
query29 578 597 431 431
query30 273 229 188 188
query31 850 871 778 778
query32 74 67 72 67
query33 438 358 307 307
query34 797 880 531 531
query35 790 855 768 768
query36 948 1011 943 943
query37 122 98 77 77
query38 4297 4255 4187 4187
query39 1659 1425 1434 1425
query40 229 131 109 109
query41 53 52 52 52
query42 128 115 109 109
query43 511 514 479 479
query44 1358 818 835 818
query45 185 171 169 169
query46 877 1038 661 661
query47 1796 1851 1798 1798
query48 397 436 308 308
query49 696 519 398 398
query50 705 704 408 408
query51 4295 4235 4175 4175
query52 108 111 101 101
query53 246 269 190 190
query54 595 577 525 525
query55 84 86 84 84
query56 322 309 301 301
query57 1207 1188 1129 1129
query58 261 264 259 259
query59 2604 2704 2629 2629
query60 337 324 318 318
query61 129 127 122 122
query62 715 729 669 669
query63 244 201 195 195
query64 1502 1065 714 714
query65 4314 4226 4233 4226
query66 757 398 300 300
query67 16084 15445 15456 15445
query68 7520 898 518 518
query69 544 299 263 263
query70 1244 1107 1131 1107
query71 512 313 296 296
query72 5526 4762 4929 4762
query73 1461 654 349 349
query74 8898 8996 8577 8577
query75 3900 3186 2693 2693
query76 4304 1180 781 781
query77 644 388 287 287
query78 9899 10089 9173 9173
query79 5436 805 553 553
query80 658 580 430 430
query81 482 262 222 222
query82 503 126 96 96
query83 331 253 243 243
query84 288 100 83 83
query85 745 358 313 313
query86 333 318 298 298
query87 4368 4422 4328 4328
query88 2840 2213 2214 2213
query89 439 326 279 279
query90 2081 212 216 212
query91 145 146 107 107
query92 77 59 55 55
query93 3054 935 572 572
query94 693 392 305 305
query95 365 303 281 281
query96 494 546 274 274
query97 3093 3216 3086 3086
query98 221 217 202 202
query99 1419 1423 1259 1259
Total cold run time: 302934 ms
Total hot run time: 192289 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](storage vault) Fix two storage vault regression cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2866328407
<details>
<summary>ClickBench: <b>Total hot run time: 28.58 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 2acf9e2de6d3f570efea7fdec4be1249833c2533, data reload: false
query1 0.04 0.04 0.03
query2 0.11 0.11 0.11
query3 0.24 0.20 0.19
query4 1.59 0.19 0.11
query5 0.56 0.55 0.55
query6 1.18 0.73 0.73
query7 0.02 0.01 0.02
query8 0.04 0.03 0.04
query9 0.57 0.52 0.52
query10 0.58 0.58 0.57
query11 0.16 0.10 0.10
query12 0.15 0.12 0.12
query13 0.62 0.60 0.59
query14 0.78 0.78 0.80
query15 0.89 0.85 0.86
query16 0.37 0.38 0.39
query17 1.05 1.08 1.03
query18 0.20 0.20 0.20
query19 1.93 1.76 1.73
query20 0.02 0.01 0.01
query21 15.42 0.91 0.53
query22 0.75 1.20 0.81
query23 14.73 1.40 0.61
query24 7.10 1.49 0.35
query25 0.40 0.26 0.06
query26 0.50 0.17 0.14
query27 0.05 0.05 0.05
query28 9.32 0.91 0.45
query29 12.60 3.95 3.25
query30 0.25 0.10 0.07
query31 2.82 0.60 0.39
query32 3.22 0.56 0.46
query33 3.12 3.09 3.03
query34 15.69 5.11 4.46
query35 4.52 4.56 4.47
query36 0.66 0.48 0.49
query37 0.08 0.06 0.06
query38 0.05 0.04 0.04
query39 0.03 0.03 0.03
query40 0.17 0.14 0.13
query41 0.08 0.02 0.02
query42 0.03 0.02 0.02
query43 0.03 0.04 0.03
Total cold run time: 102.72 s
Total hot run time: 28.58 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](storage vault) Fix two storage vault regression cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2868238627
<details>
<summary>ClickBench: <b>Total hot run time: 29.93 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 2acf9e2de6d3f570efea7fdec4be1249833c2533, data reload: false
query1 0.04 0.04 0.03
query2 0.12 0.10 0.12
query3 0.25 0.20 0.19
query4 1.60 0.19 0.11
query5 0.57 0.56 0.58
query6 1.18 0.72 0.72
query7 0.03 0.02 0.01
query8 0.04 0.03 0.03
query9 0.59 0.52 0.52
query10 0.58 0.58 0.56
query11 0.16 0.11 0.12
query12 0.15 0.12 0.12
query13 0.62 0.60 0.59
query14 0.79 0.80 0.81
query15 0.88 0.85 0.85
query16 0.40 0.39 0.39
query17 1.00 1.01 1.04
query18 0.20 0.20 0.20
query19 1.92 1.84 1.81
query20 0.02 0.01 0.01
query21 15.40 0.90 0.54
query22 0.75 1.22 0.78
query23 14.78 1.42 0.62
query24 6.80 1.94 1.43
query25 0.48 0.13 0.14
query26 0.69 0.16 0.14
query27 0.05 0.05 0.04
query28 9.95 0.91 0.46
query29 12.58 3.93 3.27
query30 0.25 0.11 0.07
query31 2.82 0.63 0.40
query32 3.21 0.54 0.47
query33 3.14 3.09 3.08
query34 15.71 5.14 4.46
query35 4.52 4.50 4.51
query36 0.64 0.50 0.48
query37 0.08 0.06 0.07
query38 0.04 0.04 0.04
query39 0.03 0.03 0.03
query40 0.17 0.15 0.13
query41 0.08 0.03 0.03
query42 0.03 0.02 0.03
query43 0.04 0.04 0.03
Total cold run time: 103.38 s
Total hot run time: 29.93 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](storage vault) Fix two storage vault regression cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2871177103
<details>
<summary>ClickBench: <b>Total hot run time: 29.65 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 bf860a61a2ad3b414e5381fe081d33171011cd73, data reload: false
query1 0.04 0.04 0.03
query2 0.12 0.11 0.11
query3 0.24 0.20 0.19
query4 1.59 0.18 0.11
query5 0.57 0.57 0.55
query6 1.20 0.72 0.72
query7 0.03 0.01 0.02
query8 0.04 0.03 0.03
query9 0.56 0.53 0.50
query10 0.57 0.57 0.58
query11 0.16 0.11 0.11
query12 0.14 0.12 0.12
query13 0.61 0.60 0.60
query14 0.78 0.81 0.80
query15 0.87 0.85 0.84
query16 0.39 0.38 0.40
query17 1.07 1.03 1.07
query18 0.22 0.22 0.22
query19 1.89 1.78 1.84
query20 0.01 0.01 0.02
query21 15.39 0.91 0.54
query22 0.75 1.20 0.90
query23 14.69 1.38 0.67
query24 6.67 2.67 1.05
query25 0.53 0.31 0.12
query26 0.61 0.16 0.14
query27 0.05 0.05 0.06
query28 9.78 0.81 0.44
query29 12.54 3.95 3.32
query30 0.25 0.10 0.06
query31 2.84 0.59 0.39
query32 3.23 0.54 0.46
query33 3.11 3.08 3.04
query34 15.83 5.10 4.48
query35 4.46 4.49 4.48
query36 0.66 0.48 0.47
query37 0.09 0.07 0.07
query38 0.05 0.03 0.04
query39 0.03 0.02 0.02
query40 0.17 0.13 0.13
query41 0.08 0.03 0.03
query42 0.03 0.03 0.02
query43 0.03 0.04 0.03
Total cold run time: 102.97 s
Total hot run time: 29.65 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](storage vault) Fix two storage vault regression cases [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2862838882
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](storage vault) Fix two storage vault regression cases [doris]
Posted by "SWJTU-ZhangLei (via GitHub)" <gi...@apache.org>.
SWJTU-ZhangLei commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2862455647
run feut
--
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](storage vault) Fix two storage vault regression cases [doris]
Posted by "SWJTU-ZhangLei (via GitHub)" <gi...@apache.org>.
SWJTU-ZhangLei commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2862646427
run vault_p0
--
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](storage vault) Fix two storage vault regression cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2863003517
<details>
<summary>ClickBench: <b>Total hot run time: 29.33 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 94dea4fbf5dcb0f6ac6774056d4e462d0a250cfb, data reload: false
query1 0.04 0.04 0.03
query2 0.12 0.10 0.12
query3 0.25 0.20 0.19
query4 1.59 0.20 0.11
query5 0.57 0.55 0.58
query6 1.18 0.72 0.71
query7 0.02 0.01 0.01
query8 0.04 0.04 0.04
query9 0.59 0.53 0.51
query10 0.57 0.59 0.56
query11 0.15 0.11 0.11
query12 0.16 0.12 0.12
query13 0.61 0.60 0.60
query14 0.77 0.81 0.79
query15 0.86 0.86 0.86
query16 0.37 0.38 0.38
query17 1.03 1.01 1.00
query18 0.21 0.19 0.19
query19 1.92 1.82 1.85
query20 0.02 0.01 0.01
query21 15.40 0.94 0.58
query22 0.77 1.22 0.65
query23 14.92 1.39 0.62
query24 6.80 1.04 1.26
query25 0.47 0.23 0.09
query26 0.57 0.16 0.15
query27 0.06 0.06 0.05
query28 9.30 0.90 0.44
query29 12.54 3.94 3.26
query30 0.25 0.10 0.07
query31 2.80 0.60 0.38
query32 3.23 0.55 0.46
query33 3.11 3.02 3.01
query34 15.79 5.15 4.51
query35 4.56 4.57 4.54
query36 0.65 0.50 0.48
query37 0.09 0.06 0.07
query38 0.05 0.04 0.03
query39 0.04 0.03 0.02
query40 0.17 0.15 0.14
query41 0.08 0.02 0.02
query42 0.03 0.02 0.03
query43 0.04 0.03 0.02
Total cold run time: 102.79 s
Total hot run time: 29.33 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](storage vault) Fix two storage vault regression cases [doris]
Posted by "SWJTU-ZhangLei (via GitHub)" <gi...@apache.org>.
SWJTU-ZhangLei commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2865081686
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](storage vault) Fix two storage vault regression cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2866309608
<details>
<summary>TPC-DS: <b>Total hot run time: 191770 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 2acf9e2de6d3f570efea7fdec4be1249833c2533, data reload: false
query1 1395 1071 1084 1071
query2 6251 1826 1802 1802
query3 11022 4319 4670 4319
query4 53867 25812 22928 22928
query5 5278 482 454 454
query6 342 207 214 207
query7 4875 507 286 286
query8 314 264 235 235
query9 5614 2609 2597 2597
query10 400 334 251 251
query11 14991 14980 14815 14815
query12 163 108 107 107
query13 1028 511 385 385
query14 10040 6153 6177 6153
query15 199 195 173 173
query16 7073 663 539 539
query17 1080 713 592 592
query18 1533 399 304 304
query19 195 193 166 166
query20 126 121 117 117
query21 201 133 109 109
query22 4573 4585 4501 4501
query23 33996 33239 33342 33239
query24 6596 2448 2470 2448
query25 516 500 437 437
query26 694 288 157 157
query27 2230 512 341 341
query28 3408 2137 2136 2136
query29 602 585 498 498
query30 271 219 195 195
query31 871 852 781 781
query32 81 62 58 58
query33 466 359 300 300
query34 755 872 509 509
query35 772 824 768 768
query36 927 978 903 903
query37 113 102 79 79
query38 4148 4323 4147 4147
query39 1494 1440 1480 1440
query40 227 119 114 114
query41 55 53 52 52
query42 130 111 107 107
query43 500 508 472 472
query44 1313 823 800 800
query45 180 169 163 163
query46 836 1031 629 629
query47 1850 1889 1797 1797
query48 386 419 315 315
query49 685 519 447 447
query50 672 710 419 419
query51 4247 4264 4164 4164
query52 106 109 95 95
query53 231 273 185 185
query54 594 563 533 533
query55 82 80 86 80
query56 311 287 287 287
query57 1191 1232 1143 1143
query58 264 257 246 246
query59 2715 2862 2684 2684
query60 333 338 303 303
query61 127 121 123 121
query62 708 754 660 660
query63 220 187 189 187
query64 1489 1091 703 703
query65 4304 4188 4209 4188
query66 747 393 305 305
query67 15862 15767 15554 15554
query68 7563 881 504 504
query69 529 305 263 263
query70 1261 1100 1085 1085
query71 512 329 306 306
query72 5932 4885 4994 4885
query73 1467 704 348 348
query74 8892 8794 8910 8794
query75 3769 3192 2668 2668
query76 4215 1219 745 745
query77 616 373 282 282
query78 9983 10196 9219 9219
query79 2128 803 566 566
query80 602 509 448 448
query81 467 250 215 215
query82 448 132 94 94
query83 252 242 233 233
query84 293 99 86 86
query85 790 371 314 314
query86 406 301 295 295
query87 4404 4426 4314 4314
query88 3677 2185 2206 2185
query89 393 316 282 282
query90 1825 209 255 209
query91 144 141 110 110
query92 73 60 60 60
query93 1760 957 580 580
query94 651 404 278 278
query95 366 293 280 280
query96 495 570 282 282
query97 3185 3219 3098 3098
query98 242 202 191 191
query99 1444 1381 1251 1251
Total cold run time: 297649 ms
Total hot run time: 191770 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](storage vault) Fix two storage vault regression cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2865174919
<details>
<summary>TPC-DS: <b>Total hot run time: 191751 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 2acf9e2de6d3f570efea7fdec4be1249833c2533, data reload: false
query1 1413 1116 1086 1086
query2 6186 1781 1784 1781
query3 11030 4523 4437 4437
query4 54318 24878 23120 23120
query5 5097 479 440 440
query6 329 204 192 192
query7 4872 505 294 294
query8 316 264 233 233
query9 5655 2548 2550 2548
query10 460 320 266 266
query11 14997 15447 14888 14888
query12 162 112 104 104
query13 1037 519 411 411
query14 10249 6439 6358 6358
query15 218 200 179 179
query16 7019 672 501 501
query17 1079 760 600 600
query18 1534 406 313 313
query19 189 189 155 155
query20 124 134 116 116
query21 203 129 108 108
query22 4285 4351 4207 4207
query23 34085 33156 33300 33156
query24 6658 2450 2485 2450
query25 455 493 415 415
query26 672 278 153 153
query27 2184 524 335 335
query28 3270 2148 2119 2119
query29 581 562 426 426
query30 270 226 189 189
query31 861 887 777 777
query32 76 66 67 66
query33 456 388 331 331
query34 780 930 532 532
query35 791 833 752 752
query36 952 1013 902 902
query37 122 101 76 76
query38 4239 4194 4183 4183
query39 1494 1419 1449 1419
query40 221 130 110 110
query41 57 54 54 54
query42 116 110 108 108
query43 502 503 487 487
query44 1322 828 809 809
query45 183 183 169 169
query46 847 1035 681 681
query47 1823 1838 1734 1734
query48 389 416 298 298
query49 682 530 425 425
query50 662 708 427 427
query51 4189 4204 4146 4146
query52 118 109 108 108
query53 239 273 190 190
query54 609 584 514 514
query55 85 86 80 80
query56 294 316 327 316
query57 1182 1190 1145 1145
query58 269 258 265 258
query59 2604 2780 2662 2662
query60 357 355 322 322
query61 184 127 127 127
query62 735 763 697 697
query63 227 194 194 194
query64 1492 1056 704 704
query65 4395 4395 4300 4300
query66 711 408 306 306
query67 15825 15431 15323 15323
query68 4689 909 543 543
query69 516 323 275 275
query70 1165 1118 1042 1042
query71 453 320 290 290
query72 6039 4904 5162 4904
query73 966 801 352 352
query74 8969 8917 8795 8795
query75 3496 3210 2714 2714
query76 3532 1185 749 749
query77 563 375 294 294
query78 9990 10170 9211 9211
query79 2417 815 560 560
query80 650 514 434 434
query81 488 253 217 217
query82 442 131 95 95
query83 336 255 228 228
query84 299 107 83 83
query85 783 355 310 310
query86 420 303 277 277
query87 4466 4392 4254 4254
query88 3400 2207 2213 2207
query89 410 306 282 282
query90 1895 209 209 209
query91 141 147 109 109
query92 73 59 59 59
query93 2111 921 571 571
query94 654 396 270 270
query95 368 288 295 288
query96 488 574 275 275
query97 3162 3188 3103 3103
query98 228 212 206 206
query99 1359 1400 1233 1233
Total cold run time: 294005 ms
Total hot run time: 191751 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](storage vault) Fix two storage vault regression cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2862971711
<details>
<summary>TPC-DS: <b>Total hot run time: 193515 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 94dea4fbf5dcb0f6ac6774056d4e462d0a250cfb, data reload: false
query1 1414 1086 1069 1069
query2 6083 1780 1767 1767
query3 11140 4740 4653 4653
query4 53373 24829 23239 23239
query5 5260 581 455 455
query6 335 233 196 196
query7 4889 516 288 288
query8 318 264 234 234
query9 5498 2638 2723 2638
query10 450 317 281 281
query11 14994 15025 14859 14859
query12 170 111 106 106
query13 1051 536 395 395
query14 10198 6397 6496 6397
query15 208 204 188 188
query16 7116 691 524 524
query17 1109 755 610 610
query18 1538 421 323 323
query19 209 204 181 181
query20 140 129 127 127
query21 212 166 102 102
query22 4478 4536 4426 4426
query23 34439 33507 33665 33507
query24 6568 2474 2448 2448
query25 459 460 402 402
query26 719 278 159 159
query27 2400 513 350 350
query28 3188 2177 2162 2162
query29 577 560 450 450
query30 268 219 196 196
query31 871 862 803 803
query32 72 64 66 64
query33 459 362 315 315
query34 819 873 526 526
query35 807 826 757 757
query36 964 1019 955 955
query37 113 102 79 79
query38 4172 4267 4131 4131
query39 1527 1437 1453 1437
query40 225 118 109 109
query41 55 54 54 54
query42 129 108 122 108
query43 519 511 493 493
query44 1371 832 847 832
query45 186 177 163 163
query46 867 1055 658 658
query47 1858 1873 1839 1839
query48 394 426 318 318
query49 689 515 444 444
query50 704 719 410 410
query51 4269 4298 4157 4157
query52 114 106 98 98
query53 227 263 188 188
query54 607 580 516 516
query55 85 80 84 80
query56 311 304 297 297
query57 1155 1200 1160 1160
query58 291 264 259 259
query59 2694 2735 2586 2586
query60 341 336 306 306
query61 130 124 121 121
query62 755 747 692 692
query63 234 186 191 186
query64 1799 1055 680 680
query65 4325 4254 4253 4253
query66 745 405 304 304
query67 15736 15692 15346 15346
query68 7743 904 532 532
query69 552 297 313 297
query70 1223 1183 1099 1099
query71 493 314 289 289
query72 5517 4853 4788 4788
query73 1487 647 355 355
query74 8921 9088 8882 8882
query75 4032 3216 2757 2757
query76 4255 1202 757 757
query77 638 379 284 284
query78 10164 10254 9350 9350
query79 2677 829 571 571
query80 620 503 459 459
query81 499 255 216 216
query82 477 133 99 99
query83 340 249 233 233
query84 295 101 85 85
query85 791 349 400 349
query86 382 300 303 300
query87 4376 4437 4372 4372
query88 3542 2205 2245 2205
query89 411 309 288 288
query90 1969 208 209 208
query91 140 140 111 111
query92 71 59 59 59
query93 1723 967 595 595
query94 679 398 310 310
query95 375 366 286 286
query96 490 590 274 274
query97 3204 3234 3170 3170
query98 238 216 202 202
query99 1446 1400 1277 1277
Total cold run time: 299190 ms
Total hot run time: 193515 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](storage vault) Fix two storage vault regression cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2868229715
<details>
<summary>TPC-H: <b>Total hot run time: 34361 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 2acf9e2de6d3f570efea7fdec4be1249833c2533, data reload: false
------ Round 1 ----------------------------------
q1 25946 5065 5047 5047
q2 2055 281 189 189
q3 10399 1260 718 718
q4 10213 998 536 536
q5 7555 2385 2358 2358
q6 185 165 134 134
q7 906 771 620 620
q8 9324 1274 1071 1071
q9 6912 5076 5191 5076
q10 6869 2299 1905 1905
q11 476 287 265 265
q12 348 355 217 217
q13 17763 3712 3142 3142
q14 241 232 204 204
q15 525 489 492 489
q16 427 432 387 387
q17 619 861 375 375
q18 7684 7514 7351 7351
q19 1646 988 555 555
q20 348 352 227 227
q21 4317 3388 2511 2511
q22 1049 999 984 984
Total cold run time: 115807 ms
Total hot run time: 34361 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5255 5132 5112 5112
q2 247 333 225 225
q3 2140 2628 2289 2289
q4 1336 1776 1478 1478
q5 4468 4382 4402 4382
q6 219 165 129 129
q7 2012 1915 1754 1754
q8 2609 2602 2531 2531
q9 7261 7116 7207 7116
q10 3003 3155 2770 2770
q11 583 514 485 485
q12 684 763 620 620
q13 3552 3931 3336 3336
q14 281 291 271 271
q15 525 487 476 476
q16 462 512 441 441
q17 1168 1556 1416 1416
q18 7766 7496 7358 7358
q19 806 820 914 820
q20 2019 1970 1870 1870
q21 5107 4787 4632 4632
q22 1089 1050 1019 1019
Total cold run time: 52592 ms
Total hot run time: 50530 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](storage vault) Fix two storage vault regression cases [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2875531491
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](storage vault) Fix two storage vault regression cases [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring merged PR #50703:
URL: https://github.com/apache/doris/pull/50703
--
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](storage vault) Fix two storage vault regression cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2864949083
<details>
<summary>TPC-H: <b>Total hot run time: 33938 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 94dea4fbf5dcb0f6ac6774056d4e462d0a250cfb, data reload: false
------ Round 1 ----------------------------------
q1 26119 5026 5017 5017
q2 2051 272 180 180
q3 10410 1217 709 709
q4 10237 1010 527 527
q5 7533 2384 2326 2326
q6 180 165 132 132
q7 896 723 599 599
q8 9320 1274 1183 1183
q9 6838 5068 5073 5068
q10 6869 2301 1881 1881
q11 488 291 270 270
q12 353 355 215 215
q13 17800 3683 3126 3126
q14 220 228 206 206
q15 540 480 499 480
q16 425 422 364 364
q17 606 860 369 369
q18 7663 7244 7041 7041
q19 1919 945 553 553
q20 334 320 212 212
q21 4116 3422 2500 2500
q22 1068 1029 980 980
Total cold run time: 115985 ms
Total hot run time: 33938 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5237 5066 5095 5066
q2 239 332 239 239
q3 2244 2723 2291 2291
q4 1409 1832 1425 1425
q5 4452 4409 4396 4396
q6 223 161 133 133
q7 2017 1952 1742 1742
q8 2562 2578 2463 2463
q9 7179 7122 7142 7122
q10 2977 3174 2754 2754
q11 568 498 499 498
q12 668 760 607 607
q13 3496 3903 3359 3359
q14 304 310 258 258
q15 514 482 471 471
q16 436 479 442 442
q17 1163 1565 1385 1385
q18 7812 7692 7415 7415
q19 859 842 939 842
q20 1966 1957 1841 1841
q21 5155 4754 4756 4754
q22 1074 1074 1020 1020
Total cold run time: 52554 ms
Total hot run time: 50523 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](storage vault) Fix two storage vault regression cases [doris]
Posted by "SWJTU-ZhangLei (via GitHub)" <gi...@apache.org>.
SWJTU-ZhangLei commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2871163046
run p0
--
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](storage vault) Fix two storage vault regression cases [doris]
Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2862217577
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] [fix](storage vault) Fix two storage vault regression cases [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2862838700
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](storage vault) Fix two storage vault regression cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2865150861
<details>
<summary>TPC-H: <b>Total hot run time: 34058 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 2acf9e2de6d3f570efea7fdec4be1249833c2533, data reload: false
------ Round 1 ----------------------------------
q1 25913 5070 5012 5012
q2 2077 273 183 183
q3 10401 1260 699 699
q4 10221 997 528 528
q5 7540 2350 2322 2322
q6 183 176 136 136
q7 923 743 635 635
q8 9326 1292 1098 1098
q9 6855 5076 5066 5066
q10 6865 2291 1895 1895
q11 482 290 273 273
q12 354 355 215 215
q13 17789 3697 3075 3075
q14 234 224 211 211
q15 528 484 489 484
q16 424 428 379 379
q17 622 861 370 370
q18 7395 7134 7050 7050
q19 1705 949 587 587
q20 366 365 231 231
q21 4578 3508 2618 2618
q22 1074 1045 991 991
Total cold run time: 115855 ms
Total hot run time: 34058 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5155 5113 5114 5113
q2 240 324 228 228
q3 2140 2640 2270 2270
q4 1357 1780 1404 1404
q5 4440 4429 4395 4395
q6 233 175 129 129
q7 2005 1945 1787 1787
q8 2586 2528 2574 2528
q9 7168 7144 7006 7006
q10 3017 3168 2724 2724
q11 564 511 493 493
q12 640 774 621 621
q13 3523 3901 3253 3253
q14 308 301 267 267
q15 505 467 464 464
q16 435 469 461 461
q17 1133 1525 1447 1447
q18 7527 7535 7345 7345
q19 845 851 810 810
q20 2017 2019 1829 1829
q21 5189 4683 4766 4683
q22 1080 1051 1032 1032
Total cold run time: 52107 ms
Total hot run time: 50289 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](storage vault) Fix two storage vault regression cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2868236228
<details>
<summary>TPC-DS: <b>Total hot run time: 190892 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 2acf9e2de6d3f570efea7fdec4be1249833c2533, data reload: false
query1 1422 1105 1086 1086
query2 6372 1774 1793 1774
query3 11006 4377 4616 4377
query4 54601 25335 23376 23376
query5 5134 539 467 467
query6 382 240 198 198
query7 4939 511 291 291
query8 320 271 246 246
query9 5669 2578 2598 2578
query10 399 323 282 282
query11 15063 15081 14910 14910
query12 166 121 107 107
query13 1073 529 398 398
query14 10344 6465 6490 6465
query15 206 205 181 181
query16 7080 658 516 516
query17 1108 747 624 624
query18 1554 426 332 332
query19 215 204 168 168
query20 128 138 121 121
query21 208 131 109 109
query22 4404 4496 4431 4431
query23 34189 33504 33580 33504
query24 6550 2394 2498 2394
query25 463 469 407 407
query26 709 282 165 165
query27 2253 509 351 351
query28 3123 2135 2112 2112
query29 573 563 440 440
query30 272 223 187 187
query31 860 863 762 762
query32 71 60 69 60
query33 450 362 318 318
query34 778 861 521 521
query35 823 835 777 777
query36 974 1013 923 923
query37 114 107 86 86
query38 4182 4347 4224 4224
query39 1498 1499 1447 1447
query40 214 121 107 107
query41 57 56 52 52
query42 121 105 108 105
query43 509 489 487 487
query44 1297 807 816 807
query45 185 178 170 170
query46 915 1041 659 659
query47 1859 1905 1785 1785
query48 400 415 311 311
query49 696 502 432 432
query50 668 692 403 403
query51 4274 4311 4224 4224
query52 107 116 110 110
query53 232 249 185 185
query54 619 578 524 524
query55 83 80 84 80
query56 302 299 295 295
query57 1190 1197 1136 1136
query58 266 267 262 262
query59 2721 2818 2654 2654
query60 326 342 343 342
query61 128 137 163 137
query62 743 734 728 728
query63 233 200 201 200
query64 1692 1063 723 723
query65 4314 4208 4213 4208
query66 717 402 310 310
query67 15776 15619 15185 15185
query68 7175 899 514 514
query69 534 309 279 279
query70 1133 1141 1064 1064
query71 526 322 352 322
query72 5851 2385 5173 2385
query73 1532 776 342 342
query74 9278 9140 9042 9042
query75 3956 3220 2739 2739
query76 4196 1186 760 760
query77 678 368 294 294
query78 10043 10131 9342 9342
query79 2725 832 567 567
query80 662 520 452 452
query81 479 260 225 225
query82 457 131 96 96
query83 341 250 238 238
query84 300 162 88 88
query85 782 352 309 309
query86 366 309 294 294
query87 4411 4329 4292 4292
query88 3341 2208 2147 2147
query89 420 320 297 297
query90 1951 213 212 212
query91 144 144 114 114
query92 75 61 55 55
query93 1291 977 583 583
query94 672 406 297 297
query95 369 294 286 286
query96 504 568 280 280
query97 3189 3278 3161 3161
query98 230 216 199 199
query99 1414 1415 1281 1281
Total cold run time: 299344 ms
Total hot run time: 190892 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](storage vault) Fix two storage vault regression cases [doris]
Posted by "SWJTU-ZhangLei (via GitHub)" <gi...@apache.org>.
SWJTU-ZhangLei commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2865975312
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](storage vault) Fix two storage vault regression cases [doris]
Posted by "SWJTU-ZhangLei (via GitHub)" <gi...@apache.org>.
SWJTU-ZhangLei commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2870513426
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](storage vault) Fix two storage vault regression cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2864968215
<details>
<summary>ClickBench: <b>Total hot run time: 29.47 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 94dea4fbf5dcb0f6ac6774056d4e462d0a250cfb, data reload: false
query1 0.04 0.04 0.03
query2 0.13 0.11 0.12
query3 0.25 0.20 0.20
query4 1.60 0.20 0.19
query5 0.59 0.59 0.57
query6 1.20 0.73 0.71
query7 0.02 0.02 0.02
query8 0.04 0.03 0.04
query9 0.58 0.51 0.51
query10 0.57 0.57 0.55
query11 0.15 0.10 0.11
query12 0.15 0.11 0.11
query13 0.61 0.59 0.59
query14 0.77 0.80 0.80
query15 0.88 0.85 0.84
query16 0.38 0.39 0.38
query17 1.02 1.02 1.01
query18 0.21 0.20 0.19
query19 1.91 1.74 1.79
query20 0.01 0.01 0.01
query21 15.39 0.89 0.57
query22 0.74 1.28 0.68
query23 14.84 1.37 0.61
query24 6.93 1.03 1.49
query25 0.52 0.19 0.13
query26 0.63 0.18 0.14
query27 0.05 0.05 0.05
query28 9.02 0.87 0.42
query29 12.55 4.04 3.40
query30 0.26 0.09 0.06
query31 2.83 0.61 0.38
query32 3.23 0.54 0.46
query33 2.97 3.04 3.09
query34 15.83 5.12 4.51
query35 4.48 4.51 4.50
query36 0.69 0.50 0.48
query37 0.09 0.07 0.06
query38 0.05 0.04 0.03
query39 0.03 0.03 0.03
query40 0.18 0.14 0.13
query41 0.08 0.04 0.02
query42 0.04 0.02 0.03
query43 0.04 0.03 0.03
Total cold run time: 102.58 s
Total hot run time: 29.47 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](storage vault) Fix two storage vault regression cases [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #50703:
URL: https://github.com/apache/doris/pull/50703#issuecomment-2862316171
<details>
<summary>TPC-DS: <b>Total hot run time: 185849 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 11774a1e01e8447b9d3e8aac376bfde8c010501d, data reload: false
query1 1015 474 491 474
query2 6559 1827 1779 1779
query3 6750 225 224 224
query4 26242 24071 23647 23647
query5 4373 626 470 470
query6 297 203 184 184
query7 4611 491 271 271
query8 290 239 224 224
query9 8584 2527 2562 2527
query10 510 315 263 263
query11 15512 15027 14744 14744
query12 154 108 102 102
query13 1647 504 381 381
query14 8663 6112 6384 6112
query15 207 200 180 180
query16 7135 649 460 460
query17 962 741 579 579
query18 1966 413 319 319
query19 189 188 164 164
query20 117 116 128 116
query21 221 128 109 109
query22 4106 4155 4022 4022
query23 33755 32896 32899 32896
query24 8523 2427 2382 2382
query25 569 463 411 411
query26 1242 275 160 160
query27 2752 494 336 336
query28 4316 2067 2051 2051
query29 856 535 431 431
query30 279 212 184 184
query31 916 880 767 767
query32 75 67 63 63
query33 554 382 311 311
query34 780 830 517 517
query35 770 879 723 723
query36 941 979 884 884
query37 105 98 78 78
query38 4094 4184 4119 4119
query39 1442 1415 1408 1408
query40 210 121 108 108
query41 62 53 57 53
query42 127 107 111 107
query43 483 509 479 479
query44 1277 795 787 787
query45 183 172 166 166
query46 896 1028 624 624
query47 1755 1809 1744 1744
query48 369 400 315 315
query49 777 501 409 409
query50 648 677 392 392
query51 4124 4262 4056 4056
query52 114 105 96 96
query53 218 249 184 184
query54 567 590 498 498
query55 83 80 77 77
query56 301 298 291 291
query57 1147 1128 1085 1085
query58 260 256 250 250
query59 2641 2673 2533 2533
query60 332 317 304 304
query61 129 154 124 124
query62 786 765 650 650
query63 218 182 185 182
query64 4426 1011 670 670
query65 4360 4290 4233 4233
query66 1151 436 316 316
query67 16075 15457 15374 15374
query68 8159 882 499 499
query69 476 303 272 272
query70 1225 1135 1128 1128
query71 459 307 319 307
query72 5618 4715 4739 4715
query73 727 613 353 353
query74 8953 9212 8938 8938
query75 3840 3204 2728 2728
query76 3708 1178 762 762
query77 790 377 289 289
query78 10028 10042 9264 9264
query79 2211 797 549 549
query80 595 512 433 433
query81 497 253 219 219
query82 457 126 96 96
query83 258 260 243 243
query84 295 116 82 82
query85 795 354 324 324
query86 396 329 278 278
query87 4364 4439 4393 4393
query88 3615 2186 2169 2169
query89 391 314 276 276
query90 1834 213 209 209
query91 148 147 109 109
query92 76 64 60 60
query93 1646 938 559 559
query94 728 407 319 319
query95 379 291 291 291
query96 482 568 270 270
query97 3172 3239 3110 3110
query98 233 202 198 198
query99 1643 1417 1228 1228
Total cold run time: 273996 ms
Total hot run time: 185849 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