You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "Yukang-Lian (via GitHub)" <gi...@apache.org> on 2024/07/29 07:30:53 UTC
[PR] [cherry-pick](branch-2.0) Pick "[Fix](delete command) Mark delete sign when do delete command in MoW table #35917" [doris]
Yukang-Lian opened a new pull request, #38468:
URL: https://github.com/apache/doris/pull/38468
## Proposed changes
<!--Describe your changes.-->
Pick #35917
--
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] [cherry-pick](branch-2.0) Pick "[Fix](delete command) Mark delete sign when do delete command in MoW table #35917" [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38468:
URL: https://github.com/apache/doris/pull/38468#issuecomment-2258332053
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 36dd48d16fef68a7f882719725d48b68f781c1fb with default session variables
Stream load json: 20 seconds loaded 2358488459 Bytes, about 112 MB/s
Stream load orc: 60 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
Insert into select: 21.9 seconds inserted 10000000 Rows, about 456K ops/s
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [cherry-pick](branch-2.0) Pick "[Fix](delete command) Mark delete sign when do delete command in MoW table #35917" [doris]
Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian commented on PR #38468:
URL: https://github.com/apache/doris/pull/38468#issuecomment-2258238793
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] [cherry-pick](branch-2.0) Pick "[Fix](delete command) Mark delete sign when do delete command in MoW table #35917" [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38468:
URL: https://github.com/apache/doris/pull/38468#issuecomment-2255177678
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] [cherry-pick](branch-2.0) Pick "[Fix](delete command) Mark delete sign when do delete command in MoW table #35917" [doris]
Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian commented on PR #38468:
URL: https://github.com/apache/doris/pull/38468#issuecomment-2255221352
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] [cherry-pick](branch-2.0) Pick "[Fix](delete command) Mark delete sign when do delete command in MoW table #35917" [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38468:
URL: https://github.com/apache/doris/pull/38468#issuecomment-2258043421
<details>
<summary>ClickBench: <b>Total hot run time: 31.52 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 f635113c6c73054cb0d6d88272357a02c052f7bf, data reload: false
query1 0.02 0.02 0.03
query2 0.06 0.03 0.03
query3 0.25 0.05 0.05
query4 1.78 0.08 0.06
query5 0.54 0.53 0.52
query6 1.42 0.63 0.62
query7 0.01 0.01 0.02
query8 0.03 0.02 0.02
query9 0.53 0.48 0.47
query10 0.53 0.54 0.54
query11 0.12 0.09 0.09
query12 0.12 0.09 0.09
query13 0.62 0.62 0.62
query14 0.77 0.77 0.79
query15 0.77 0.76 0.76
query16 0.36 0.36 0.35
query17 1.03 1.03 1.02
query18 0.24 0.25 0.24
query19 1.92 1.84 1.87
query20 0.02 0.01 0.01
query21 15.48 0.54 0.56
query22 2.12 2.52 2.16
query23 17.12 1.12 1.06
query24 5.91 1.41 1.11
query25 0.39 0.11 0.04
query26 0.66 0.16 0.16
query27 0.04 0.03 0.04
query28 6.73 0.72 0.75
query29 12.71 2.33 2.26
query30 0.61 0.52 0.48
query31 2.81 0.41 0.38
query32 3.37 0.51 0.50
query33 3.13 3.07 3.09
query34 15.26 4.80 4.78
query35 4.84 4.86 4.84
query36 1.05 1.01 1.01
query37 0.06 0.04 0.04
query38 0.04 0.02 0.02
query39 0.02 0.01 0.02
query40 0.16 0.15 0.15
query41 0.07 0.01 0.02
query42 0.02 0.01 0.02
query43 0.03 0.02 0.01
Total cold run time: 103.77 s
Total hot run time: 31.52 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] [cherry-pick](branch-2.0) Pick "[Fix](delete command) Mark delete sign when do delete command in MoW table #35917" [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38468:
URL: https://github.com/apache/doris/pull/38468#issuecomment-2258048844
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit f635113c6c73054cb0d6d88272357a02c052f7bf with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 21.4 seconds inserted 10000000 Rows, about 467K ops/s
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [cherry-pick](branch-2.0) Pick "[Fix](delete command) Mark delete sign when do delete command in MoW table #35917" [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38468:
URL: https://github.com/apache/doris/pull/38468#issuecomment-2255286275
<details>
<summary>TPC-H: <b>Total hot run time: 49440 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 09b92c3ee637cf6f3cd3b686abd6337b843b7978, data reload: false
------ Round 1 ----------------------------------
q1 17629 4375 4324 4324
q2 2093 153 150 150
q3 10441 1907 2167 1907
q4 10290 1218 1341 1218
q5 8523 3854 3912 3854
q6 255 138 126 126
q7 2055 1583 1599 1583
q8 9279 2735 2695 2695
q9 10654 10312 10154 10154
q10 8637 3534 3544 3534
q11 424 249 243 243
q12 473 299 296 296
q13 18351 3934 3973 3934
q14 354 321 324 321
q15 494 451 459 451
q16 664 572 561 561
q17 1144 978 967 967
q18 7309 6757 6700 6700
q19 1798 1679 1616 1616
q20 513 305 297 297
q21 4408 4151 4067 4067
q22 536 445 442 442
Total cold run time: 116324 ms
Total hot run time: 49440 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4307 4300 4257 4257
q2 320 223 225 223
q3 4110 4107 4120 4107
q4 2740 2719 2746 2719
q5 7131 7062 7085 7062
q6 237 119 119 119
q7 3237 2833 2802 2802
q8 4326 4425 4456 4425
q9 16860 16863 16724 16724
q10 4209 4241 4254 4241
q11 805 746 690 690
q12 1021 883 862 862
q13 7560 3717 3707 3707
q14 447 417 416 416
q15 494 455 467 455
q16 763 696 681 681
q17 3809 3820 3873 3820
q18 8767 8846 8819 8819
q19 1737 1712 1692 1692
q20 2413 2103 2138 2103
q21 8336 8337 8404 8337
q22 1069 999 1007 999
Total cold run time: 84698 ms
Total hot run time: 79260 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] [cherry-pick](branch-2.0) Pick "[Fix](delete command) Mark delete sign when do delete command in MoW table #35917" [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38468:
URL: https://github.com/apache/doris/pull/38468#issuecomment-2255374983
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit bfd6ea446a49cc2b4ae39e8bf84b384714dfbd62 with default session variables
Stream load json: 20 seconds loaded 2358488459 Bytes, about 112 MB/s
Stream load orc: 59 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 21.1 seconds inserted 10000000 Rows, about 473K ops/s
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [cherry-pick](branch-2.0) Pick "[Fix](delete command) Mark delete sign when do delete command in MoW table #35917" [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38468:
URL: https://github.com/apache/doris/pull/38468#issuecomment-2258033732
<details>
<summary>TPC-DS: <b>Total hot run time: 204111 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 f635113c6c73054cb0d6d88272357a02c052f7bf, data reload: false
query1 978 408 385 385
query2 6529 2901 2887 2887
query3 6929 203 209 203
query4 20836 18069 18072 18069
query5 19736 6546 6533 6533
query6 303 225 236 225
query7 4160 305 307 305
query8 415 442 424 424
query9 3181 2719 2644 2644
query10 427 311 303 303
query11 11298 10747 10690 10690
query12 127 80 75 75
query13 5604 721 712 712
query14 17859 13477 13267 13267
query15 360 237 241 237
query16 6469 284 259 259
query17 1720 1440 911 911
query18 2283 419 407 407
query19 206 158 157 157
query20 73 80 78 78
query21 190 95 98 95
query22 5250 5134 5021 5021
query23 32809 32030 31799 31799
query24 6908 6599 6483 6483
query25 551 411 436 411
query26 527 160 162 160
query27 1865 297 291 291
query28 6192 2394 2368 2368
query29 2940 2796 2756 2756
query30 242 172 164 164
query31 912 723 788 723
query32 71 63 64 63
query33 393 263 263 263
query34 826 496 496 496
query35 1122 918 943 918
query36 1410 1253 1244 1244
query37 91 61 65 61
query38 3118 2966 2924 2924
query39 1381 1322 1312 1312
query40 223 100 98 98
query41 47 45 47 45
query42 82 89 81 81
query43 781 775 683 683
query44 1108 718 716 716
query45 251 234 236 234
query46 1230 986 989 986
query47 1894 2093 2012 2012
query48 1019 744 697 697
query49 634 376 391 376
query50 871 613 625 613
query51 4760 4645 4628 4628
query52 96 80 80 80
query53 453 339 318 318
query54 2661 2472 2467 2467
query55 98 83 86 83
query56 244 211 206 206
query57 1282 1102 1104 1102
query58 216 216 202 202
query59 4011 4092 3766 3766
query60 221 201 202 201
query61 95 103 94 94
query62 759 486 470 470
query63 487 335 339 335
query64 2573 1517 1464 1464
query65 3646 3586 3593 3586
query66 812 387 385 385
query67 16116 15875 15192 15192
query68 8128 660 649 649
query69 564 352 343 343
query70 1638 1693 1338 1338
query71 400 308 318 308
query72 6514 3490 3510 3490
query73 741 328 320 320
query74 6284 5810 5894 5810
query75 4641 3773 3723 3723
query76 4548 1113 1166 1113
query77 558 262 255 255
query78 12581 11705 11474 11474
query79 8801 675 678 675
query80 2691 406 417 406
query81 528 234 237 234
query82 1664 102 99 99
query83 169 135 133 133
query84 259 71 78 71
query85 1362 336 333 333
query86 355 289 297 289
query87 3220 3028 3072 3028
query88 5173 2321 2302 2302
query89 385 288 298 288
query90 1762 218 215 215
query91 179 152 140 140
query92 60 55 57 55
query93 5724 625 617 617
query94 889 219 208 208
query95 1120 1066 1073 1066
query96 647 324 323 323
query97 6513 6325 6324 6324
query98 186 182 177 177
query99 3000 866 862 862
Total cold run time: 314245 ms
Total hot run time: 204111 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] [cherry-pick](branch-2.0) Pick "[Fix](delete command) Mark delete sign when do delete command in MoW table #35917" [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38468:
URL: https://github.com/apache/doris/pull/38468#issuecomment-2258010505
<details>
<summary>TPC-H: <b>Total hot run time: 49886 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 f635113c6c73054cb0d6d88272357a02c052f7bf, data reload: false
------ Round 1 ----------------------------------
q1 17542 4461 4344 4344
q2 2094 167 151 151
q3 12733 2013 2039 2013
q4 11799 1307 1399 1307
q5 9368 3884 3941 3884
q6 237 123 124 123
q7 2032 1617 1578 1578
q8 9513 2747 2723 2723
q9 13440 10310 10191 10191
q10 8594 3510 3512 3510
q11 414 249 257 249
q12 476 309 308 308
q13 18316 3958 4055 3958
q14 364 316 323 316
q15 496 464 459 459
q16 677 567 569 567
q17 1129 950 940 940
q18 7306 6893 6996 6893
q19 1760 1673 1565 1565
q20 539 309 298 298
q21 4403 4145 4054 4054
q22 540 455 459 455
Total cold run time: 123772 ms
Total hot run time: 49886 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4342 4302 4294 4294
q2 321 222 229 222
q3 4160 4169 4131 4131
q4 2774 2745 2758 2745
q5 7156 7083 7094 7083
q6 244 119 120 119
q7 3208 2789 2832 2789
q8 4384 4552 4481 4481
q9 16860 16829 16792 16792
q10 4220 4251 4263 4251
q11 746 694 721 694
q12 1016 875 867 867
q13 6827 3744 3757 3744
q14 450 425 418 418
q15 496 467 463 463
q16 733 691 676 676
q17 3845 3863 3883 3863
q18 8808 8797 8962 8797
q19 1754 1715 1740 1715
q20 2364 2180 2127 2127
q21 8533 8413 8448 8413
q22 1065 960 1013 960
Total cold run time: 84306 ms
Total hot run time: 79644 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] [cherry-pick](branch-2.0) Pick "[Fix](delete command) Mark delete sign when do delete command in MoW table #35917" [doris]
Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian commented on PR #38468:
URL: https://github.com/apache/doris/pull/38468#issuecomment-2255295118
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](delete command) Mark delete sign when do delete command in MoW table #35917 [doris]
Posted by "xiaokang (via GitHub)" <gi...@apache.org>.
xiaokang merged PR #38468:
URL: https://github.com/apache/doris/pull/38468
--
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] [cherry-pick](branch-2.0) Pick "[Fix](delete command) Mark delete sign when do delete command in MoW table #35917" [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38468:
URL: https://github.com/apache/doris/pull/38468#issuecomment-2258314150
<details>
<summary>TPC-DS: <b>Total hot run time: 204093 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 36dd48d16fef68a7f882719725d48b68f781c1fb, data reload: false
query1 955 389 407 389
query2 6527 2835 2729 2729
query3 6928 210 201 201
query4 20047 18069 18075 18069
query5 19715 6519 6574 6519
query6 286 225 227 225
query7 4169 308 310 308
query8 449 473 415 415
query9 3105 2689 2637 2637
query10 424 307 313 307
query11 11427 10876 10747 10747
query12 122 80 73 73
query13 5759 721 724 721
query14 17426 13333 13273 13273
query15 371 242 269 242
query16 6458 288 268 268
query17 1701 1466 896 896
query18 2296 413 408 408
query19 211 155 151 151
query20 80 88 74 74
query21 190 97 93 93
query22 5186 4975 4889 4889
query23 32425 31817 31992 31817
query24 7022 6502 6529 6502
query25 522 437 431 431
query26 524 166 164 164
query27 1861 294 300 294
query28 6187 2410 2345 2345
query29 2866 2820 2702 2702
query30 250 167 165 165
query31 927 736 746 736
query32 72 64 58 58
query33 391 257 256 256
query34 848 463 512 463
query35 1144 906 925 906
query36 1344 1105 1173 1105
query37 85 65 61 61
query38 3088 2914 2928 2914
query39 1355 1335 1334 1334
query40 210 99 93 93
query41 47 45 45 45
query42 88 85 81 81
query43 677 718 713 713
query44 1149 720 719 719
query45 249 237 230 230
query46 1238 953 965 953
query47 1810 1641 1665 1641
query48 1012 730 703 703
query49 614 377 371 371
query50 867 619 602 602
query51 4834 4766 4688 4688
query52 92 83 95 83
query53 442 325 324 324
query54 2667 2456 2454 2454
query55 94 79 85 79
query56 226 222 212 212
query57 1178 1177 1106 1106
query58 219 194 209 194
query59 4214 4035 4127 4035
query60 223 197 196 196
query61 95 93 99 93
query62 852 431 455 431
query63 489 349 358 349
query64 2429 1562 1451 1451
query65 3662 3543 3576 3543
query66 774 367 387 367
query67 16508 15704 16173 15704
query68 8775 662 656 656
query69 569 354 351 351
query70 1659 1607 1344 1344
query71 407 299 303 299
query72 6536 3502 3506 3502
query73 751 315 319 315
query74 6285 5895 5755 5755
query75 5114 3737 3712 3712
query76 5188 1144 1150 1144
query77 772 255 265 255
query78 12606 11618 12186 11618
query79 9158 648 655 648
query80 1477 421 404 404
query81 495 239 233 233
query82 1553 101 99 99
query83 168 135 131 131
query84 263 72 70 70
query85 1012 335 333 333
query86 337 294 294 294
query87 3247 3033 3055 3033
query88 5052 2306 2303 2303
query89 376 288 296 288
query90 1858 205 210 205
query91 175 142 138 138
query92 57 51 53 51
query93 4893 623 617 617
query94 719 212 210 210
query95 1095 1054 1052 1052
query96 647 320 324 320
query97 6436 6463 6383 6383
query98 192 173 171 171
query99 2948 938 812 812
Total cold run time: 312522 ms
Total hot run time: 204093 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] [cherry-pick](branch-2.0) Pick "[Fix](delete command) Mark delete sign when do delete command in MoW table #35917" [doris]
Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian commented on PR #38468:
URL: https://github.com/apache/doris/pull/38468#issuecomment-2257973816
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] [cherry-pick](branch-2.0) Pick "[Fix](delete command) Mark delete sign when do delete command in MoW table #35917" [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38468:
URL: https://github.com/apache/doris/pull/38468#issuecomment-2255331965
<details>
<summary>TPC-H: <b>Total hot run time: 49844 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 bfd6ea446a49cc2b4ae39e8bf84b384714dfbd62, data reload: false
------ Round 1 ----------------------------------
q1 17484 4403 4334 4334
q2 1476 187 149 149
q3 10160 1915 1953 1915
q4 10112 1237 1314 1237
q5 8427 3907 3920 3907
q6 240 127 126 126
q7 2036 1625 1634 1625
q8 9322 2748 2720 2720
q9 10811 10273 10238 10238
q10 8637 3532 3596 3532
q11 428 245 254 245
q12 474 303 308 303
q13 18357 3966 4052 3966
q14 354 333 322 322
q15 498 448 457 448
q16 651 568 568 568
q17 1133 975 974 974
q18 7225 6931 6863 6863
q19 1794 1635 1532 1532
q20 544 298 311 298
q21 4483 4101 4155 4101
q22 534 442 441 441
Total cold run time: 115180 ms
Total hot run time: 49844 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4325 4340 4318 4318
q2 324 230 224 224
q3 4228 4169 4101 4101
q4 2765 2747 2753 2747
q5 7172 7145 7095 7095
q6 241 120 120 120
q7 3243 2804 2803 2803
q8 4321 4441 4451 4441
q9 16913 16751 16774 16751
q10 4243 4262 4275 4262
q11 736 693 659 659
q12 1038 864 858 858
q13 5234 3746 3781 3746
q14 455 430 432 430
q15 502 476 451 451
q16 741 677 666 666
q17 3786 3830 3885 3830
q18 8806 8737 8787 8737
q19 1753 1724 1659 1659
q20 2344 2152 2136 2136
q21 8506 8381 8450 8381
q22 1072 995 1003 995
Total cold run time: 82748 ms
Total hot run time: 79410 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] [cherry-pick](branch-2.0) Pick "[Fix](delete command) Mark delete sign when do delete command in MoW table #35917" [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38468:
URL: https://github.com/apache/doris/pull/38468#issuecomment-2255357762
<details>
<summary>TPC-DS: <b>Total hot run time: 204098 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 bfd6ea446a49cc2b4ae39e8bf84b384714dfbd62, data reload: false
query1 934 428 371 371
query2 6546 2863 2572 2572
query3 6919 210 201 201
query4 19997 17963 17898 17898
query5 19721 6504 6534 6504
query6 314 220 232 220
query7 4213 302 305 302
query8 422 390 424 390
query9 3136 2707 2644 2644
query10 445 313 321 313
query11 11359 10773 10713 10713
query12 128 81 78 78
query13 5612 695 701 695
query14 18334 13909 13540 13540
query15 334 242 242 242
query16 6053 280 265 265
query17 1310 1370 878 878
query18 2229 416 407 407
query19 201 145 152 145
query20 75 76 81 76
query21 193 101 95 95
query22 5190 5094 5027 5027
query23 32559 32010 32153 32010
query24 6865 6561 6528 6528
query25 517 424 430 424
query26 527 162 166 162
query27 1908 312 300 300
query28 6537 2463 2427 2427
query29 3016 2713 2671 2671
query30 235 169 163 163
query31 909 753 762 753
query32 68 71 58 58
query33 411 254 252 252
query34 863 489 481 481
query35 1139 908 887 887
query36 1221 1287 1275 1275
query37 91 60 60 60
query38 3076 2927 2918 2918
query39 1367 1308 1326 1308
query40 207 92 96 92
query41 47 45 43 43
query42 90 81 97 81
query43 755 620 641 620
query44 1120 720 722 720
query45 246 234 237 234
query46 1234 957 974 957
query47 1808 1771 1754 1754
query48 1021 730 683 683
query49 624 376 369 369
query50 853 644 625 625
query51 4722 4626 4675 4626
query52 89 87 93 87
query53 451 321 323 321
query54 2651 2443 2510 2443
query55 90 78 81 78
query56 237 220 214 214
query57 1152 1057 1067 1057
query58 217 209 208 208
query59 4209 4038 4015 4015
query60 219 207 212 207
query61 97 95 98 95
query62 829 444 472 444
query63 493 342 347 342
query64 2560 1551 1341 1341
query65 3623 3543 3554 3543
query66 850 376 385 376
query67 16005 15968 15773 15773
query68 9054 676 628 628
query69 572 341 362 341
query70 1705 1428 1401 1401
query71 425 299 314 299
query72 6609 3502 3495 3495
query73 732 315 316 315
query74 6323 5868 5793 5793
query75 5178 3822 3670 3670
query76 5511 1137 1218 1137
query77 957 252 252 252
query78 12764 11503 11993 11503
query79 10195 648 638 638
query80 1224 400 398 398
query81 486 233 234 233
query82 1316 96 100 96
query83 171 133 136 133
query84 262 70 72 70
query85 920 333 330 330
query86 347 297 314 297
query87 3248 2983 3008 2983
query88 4958 2314 2298 2298
query89 442 280 284 280
query90 1919 207 209 207
query91 175 138 140 138
query92 61 50 52 50
query93 6128 561 601 561
query94 713 211 201 201
query95 1101 1030 1061 1030
query96 634 319 324 319
query97 6475 6374 6377 6374
query98 185 177 168 168
query99 2726 875 859 859
Total cold run time: 314989 ms
Total hot run time: 204098 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] [cherry-pick](branch-2.0) Pick "[Fix](delete command) Mark delete sign when do delete command in MoW table #35917" [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38468:
URL: https://github.com/apache/doris/pull/38468#issuecomment-2255368535
<details>
<summary>ClickBench: <b>Total hot run time: 31.5 s</b></summary>
```
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit bfd6ea446a49cc2b4ae39e8bf84b384714dfbd62, data reload: false
query1 0.02 0.02 0.03
query2 0.06 0.03 0.02
query3 0.24 0.04 0.05
query4 1.80 0.07 0.06
query5 0.55 0.53 0.53
query6 1.23 0.61 0.62
query7 0.01 0.00 0.01
query8 0.03 0.02 0.02
query9 0.54 0.47 0.47
query10 0.53 0.53 0.53
query11 0.12 0.08 0.08
query12 0.12 0.09 0.09
query13 0.61 0.61 0.61
query14 0.79 0.78 0.78
query15 0.79 0.76 0.76
query16 0.36 0.37 0.36
query17 0.99 1.02 0.99
query18 0.22 0.25 0.24
query19 1.90 1.85 1.77
query20 0.02 0.01 0.01
query21 15.46 0.54 0.55
query22 2.20 1.97 1.99
query23 17.18 0.88 1.06
query24 6.65 1.83 1.61
query25 0.42 0.08 0.05
query26 0.78 0.16 0.14
query27 0.05 0.03 0.03
query28 5.24 0.79 0.71
query29 12.69 2.36 2.35
query30 0.58 0.54 0.52
query31 2.89 0.38 0.37
query32 3.54 0.49 0.50
query33 3.09 3.04 3.04
query34 15.25 4.77 4.74
query35 4.84 4.83 4.82
query36 1.03 1.01 1.00
query37 0.06 0.04 0.05
query38 0.04 0.02 0.02
query39 0.02 0.02 0.01
query40 0.16 0.14 0.14
query41 0.07 0.02 0.02
query42 0.02 0.01 0.01
query43 0.03 0.02 0.01
Total cold run time: 103.22 s
Total hot run time: 31.5 s
```
</details>
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [cherry-pick](branch-2.0) Pick "[Fix](delete command) Mark delete sign when do delete command in MoW table #35917" [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38468:
URL: https://github.com/apache/doris/pull/38468#issuecomment-2258325210
<details>
<summary>ClickBench: <b>Total hot run time: 31.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 36dd48d16fef68a7f882719725d48b68f781c1fb, data reload: false
query1 0.02 0.03 0.02
query2 0.06 0.02 0.03
query3 0.24 0.04 0.04
query4 1.78 0.08 0.07
query5 0.54 0.53 0.52
query6 1.26 0.61 0.62
query7 0.02 0.01 0.01
query8 0.03 0.02 0.02
query9 0.52 0.49 0.48
query10 0.54 0.53 0.53
query11 0.12 0.09 0.09
query12 0.12 0.08 0.09
query13 0.62 0.61 0.60
query14 0.80 0.78 0.78
query15 0.79 0.76 0.75
query16 0.36 0.37 0.36
query17 1.00 0.99 1.02
query18 0.23 0.23 0.26
query19 1.88 1.85 1.87
query20 0.02 0.01 0.01
query21 15.45 0.58 0.55
query22 2.22 2.91 2.07
query23 17.42 0.98 0.92
query24 4.29 1.02 1.32
query25 0.35 0.13 0.05
query26 0.49 0.16 0.15
query27 0.04 0.05 0.04
query28 8.48 0.73 0.76
query29 12.59 2.25 2.34
query30 0.57 0.53 0.49
query31 2.81 0.40 0.38
query32 3.36 0.50 0.49
query33 3.12 3.08 3.09
query34 15.24 4.79 4.80
query35 4.84 4.85 4.81
query36 1.06 1.02 1.02
query37 0.06 0.04 0.04
query38 0.04 0.02 0.02
query39 0.02 0.02 0.01
query40 0.17 0.14 0.14
query41 0.07 0.02 0.02
query42 0.02 0.02 0.01
query43 0.02 0.02 0.02
Total cold run time: 103.68 s
Total hot run time: 31.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] [cherry-pick](branch-2.0) Pick "[Fix](delete command) Mark delete sign when do delete command in MoW table #35917" [doris]
Posted by "Yukang-Lian (via GitHub)" <gi...@apache.org>.
Yukang-Lian commented on PR #38468:
URL: https://github.com/apache/doris/pull/38468#issuecomment-2259493463
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] [cherry-pick](branch-2.0) Pick "[Fix](delete command) Mark delete sign when do delete command in MoW table #35917" [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #38468:
URL: https://github.com/apache/doris/pull/38468#issuecomment-2258287216
<details>
<summary>TPC-H: <b>Total hot run time: 50029 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 36dd48d16fef68a7f882719725d48b68f781c1fb, data reload: false
------ Round 1 ----------------------------------
q1 17595 4401 4363 4363
q2 2090 155 146 146
q3 10458 1897 1916 1897
q4 10357 1244 1319 1244
q5 8404 3897 3908 3897
q6 236 123 124 123
q7 2072 1617 1604 1604
q8 9278 2716 2697 2697
q9 10694 10335 10362 10335
q10 8642 3503 3525 3503
q11 418 249 240 240
q12 477 297 310 297
q13 18351 3944 4032 3944
q14 354 336 324 324
q15 510 464 464 464
q16 678 579 575 575
q17 1128 946 947 946
q18 7249 6963 7031 6963
q19 1841 1694 1605 1605
q20 521 320 318 318
q21 4484 4153 4096 4096
q22 545 467 448 448
Total cold run time: 116382 ms
Total hot run time: 50029 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4346 4288 4321 4288
q2 326 230 224 224
q3 4185 4150 4138 4138
q4 2752 2747 2769 2747
q5 7207 7157 7076 7076
q6 237 118 119 118
q7 3254 2864 2823 2823
q8 4385 4453 4459 4453
q9 16922 16777 16694 16694
q10 4216 4270 4249 4249
q11 757 701 712 701
q12 1032 846 849 846
q13 7023 3736 3755 3736
q14 469 418 428 418
q15 493 469 452 452
q16 722 685 687 685
q17 3881 3814 3899 3814
q18 8791 8667 8734 8667
q19 1707 1702 1639 1639
q20 2375 2124 2150 2124
q21 8483 8448 8575 8448
q22 1081 975 963 963
Total cold run time: 84644 ms
Total hot run time: 79303 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