You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "zddr (via GitHub)" <gi...@apache.org> on 2024/09/03 07:48:43 UTC
[PR] [fix](mtmv)Fix that after insert overwrite, the partition version will always be 2 [doris]
zddr opened a new pull request, #40318:
URL: https://github.com/apache/doris/pull/40318
The replaced partition version should inherit from the original partition
--
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](mtmv)Fix that after insert overwrite, the partition version will always be 2 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40318:
URL: https://github.com/apache/doris/pull/40318#issuecomment-2325935950
<details>
<summary>TPC-DS: <b>Total hot run time: 192366 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 705345f4aeadb74f056c1e12229854ed1f2ec184, data reload: false
query1 1263 893 869 869
query2 6335 2070 2024 2024
query3 10625 4064 3896 3896
query4 59506 23836 23214 23214
query5 5387 512 494 494
query6 407 166 169 166
query7 5757 300 302 300
query8 294 202 228 202
query9 8989 2453 2465 2453
query10 478 275 258 258
query11 18085 15102 15228 15102
query12 161 105 102 102
query13 1600 392 391 391
query14 10395 6891 7713 6891
query15 227 176 190 176
query16 7667 470 470 470
query17 1179 583 617 583
query18 2083 304 300 300
query19 306 180 144 144
query20 117 115 108 108
query21 216 102 106 102
query22 4477 4679 4618 4618
query23 34177 33593 33301 33301
query24 5946 2835 2812 2812
query25 529 387 380 380
query26 683 151 148 148
query27 1825 268 269 268
query28 3681 2034 2014 2014
query29 695 401 409 401
query30 228 151 160 151
query31 960 761 784 761
query32 113 56 52 52
query33 474 277 279 277
query34 846 497 493 493
query35 829 765 700 700
query36 1047 933 931 931
query37 147 89 85 85
query38 4004 4016 3928 3928
query39 1430 1400 1418 1400
query40 194 111 116 111
query41 48 44 45 44
query42 112 96 92 92
query43 520 476 479 476
query44 1065 737 725 725
query45 200 169 167 167
query46 1096 733 703 703
query47 1908 1824 1801 1801
query48 372 292 297 292
query49 761 424 457 424
query50 822 415 402 402
query51 6980 6925 6880 6880
query52 101 88 90 88
query53 249 173 177 173
query54 584 454 498 454
query55 75 75 73 73
query56 284 251 254 251
query57 1159 1063 1077 1063
query58 223 252 248 248
query59 3069 2782 2730 2730
query60 288 256 265 256
query61 102 97 101 97
query62 731 654 651 651
query63 216 181 183 181
query64 2836 671 701 671
query65 3202 3129 3172 3129
query66 695 333 334 333
query67 15346 15167 15373 15167
query68 2957 582 573 573
query69 401 284 283 283
query70 1202 1091 1146 1091
query71 351 290 276 276
query72 5122 4106 3974 3974
query73 743 326 337 326
query74 9119 8969 8902 8902
query75 3330 2683 2663 2663
query76 1335 1060 975 975
query77 524 320 316 316
query78 10445 9639 9065 9065
query79 1030 539 522 522
query80 688 488 573 488
query81 472 235 237 235
query82 255 142 149 142
query83 173 148 148 148
query84 261 74 79 74
query85 683 276 277 276
query86 295 300 288 288
query87 4433 4353 4372 4353
query88 3006 2342 2330 2330
query89 379 281 287 281
query90 1952 194 195 194
query91 125 100 102 100
query92 62 48 49 48
query93 1035 519 517 517
query94 725 294 282 282
query95 329 255 250 250
query96 590 274 263 263
query97 3213 3054 3078 3054
query98 211 222 196 196
query99 1527 1336 1234 1234
Total cold run time: 303379 ms
Total hot run time: 192366 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](mtmv)Fix that after insert overwrite, the partition version will always be 2 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40318:
URL: https://github.com/apache/doris/pull/40318#issuecomment-2325910708
<details>
<summary>TPC-H: <b>Total hot run time: 37852 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 705345f4aeadb74f056c1e12229854ed1f2ec184, data reload: false
------ Round 1 ----------------------------------
q1 17622 4394 4297 4297
q2 2026 186 181 181
q3 11758 989 1064 989
q4 10514 754 763 754
q5 7751 2791 2760 2760
q6 231 144 142 142
q7 970 619 587 587
q8 9333 2083 2040 2040
q9 7067 6541 6577 6541
q10 7000 2426 2178 2178
q11 444 235 238 235
q12 396 221 219 219
q13 17774 3056 3106 3056
q14 277 239 240 239
q15 515 495 497 495
q16 584 503 508 503
q17 984 632 816 632
q18 7312 6713 6875 6713
q19 1399 1009 1082 1009
q20 670 344 329 329
q21 3899 3036 2962 2962
q22 1124 991 1033 991
Total cold run time: 109650 ms
Total hot run time: 37852 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4355 4345 4317 4317
q2 393 285 277 277
q3 2867 2695 2654 2654
q4 1942 1657 1652 1652
q5 5638 5659 5711 5659
q6 232 141 148 141
q7 2248 1802 1885 1802
q8 3297 3409 3411 3409
q9 8847 8890 8846 8846
q10 3592 3369 3417 3369
q11 599 504 522 504
q12 818 646 671 646
q13 14999 3227 3325 3227
q14 336 301 292 292
q15 529 485 494 485
q16 610 599 589 589
q17 1824 1533 1536 1533
q18 8066 7846 7884 7846
q19 1729 1578 1626 1578
q20 2157 1906 1945 1906
q21 5711 5491 5424 5424
q22 1114 1043 1030 1030
Total cold run time: 71903 ms
Total hot run time: 57186 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](mtmv)Fix that after insert overwrite, the partition version will always be 2 [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr closed pull request #40318: [fix](mtmv)Fix that after insert overwrite, the partition version will always be 2
URL: https://github.com/apache/doris/pull/40318
--
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](mtmv)Fix that after insert overwrite, the partition version will always be 2 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40318:
URL: https://github.com/apache/doris/pull/40318#issuecomment-2325948508
<details>
<summary>ClickBench: <b>Total hot run time: 32.27 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 705345f4aeadb74f056c1e12229854ed1f2ec184, data reload: false
query1 0.04 0.04 0.04
query2 0.08 0.04 0.04
query3 0.22 0.06 0.06
query4 1.65 0.10 0.10
query5 0.50 0.49 0.50
query6 1.12 0.73 0.73
query7 0.02 0.01 0.02
query8 0.05 0.04 0.04
query9 0.54 0.48 0.49
query10 0.54 0.53 0.55
query11 0.16 0.11 0.11
query12 0.15 0.12 0.13
query13 0.62 0.59 0.58
query14 2.03 2.06 2.06
query15 0.91 0.83 0.81
query16 0.39 0.36 0.38
query17 1.04 1.08 1.04
query18 0.20 0.21 0.20
query19 1.94 1.72 1.78
query20 0.01 0.01 0.01
query21 15.40 0.66 0.67
query22 4.15 7.27 2.05
query23 18.28 1.47 1.38
query24 2.12 0.24 0.22
query25 0.15 0.09 0.08
query26 0.26 0.19 0.18
query27 0.08 0.08 0.08
query28 13.30 1.03 0.98
query29 12.64 3.34 3.31
query30 0.24 0.06 0.05
query31 2.85 0.39 0.40
query32 3.27 0.48 0.48
query33 2.96 3.00 3.02
query34 17.10 4.38 4.36
query35 4.52 4.44 4.44
query36 0.65 0.50 0.49
query37 0.19 0.16 0.15
query38 0.15 0.15 0.14
query39 0.05 0.04 0.04
query40 0.16 0.13 0.14
query41 0.10 0.05 0.05
query42 0.06 0.04 0.05
query43 0.05 0.04 0.04
Total cold run time: 110.94 s
Total hot run time: 32.27 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](mtmv)Fix that after insert overwrite, the partition version will always be 2 [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40318:
URL: https://github.com/apache/doris/pull/40318#issuecomment-2325829209
Thank you for your contribution to Apache Doris.
Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR)
Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website).
See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [fix](mtmv)Fix that after insert overwrite, the partition version will always be 2 [doris]
Posted by "zddr (via GitHub)" <gi...@apache.org>.
zddr commented on PR #40318:
URL: https://github.com/apache/doris/pull/40318#issuecomment-2325829637
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