You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "w41ter (via GitHub)" <gi...@apache.org> on 2024/09/14 09:59:06 UTC
[PR] [fix](restore) Fix view name in atomic restore [doris]
w41ter opened a new pull request, #40876:
URL: https://github.com/apache/doris/pull/40876
Only olap table need to be replaced in atomic.
--
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](restore) Fix view name in atomic restore [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40876:
URL: https://github.com/apache/doris/pull/40876#issuecomment-2350953123
<details>
<summary>TPC-H: <b>Total hot run time: 42197 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 eaef2ebfac1cafcc8e446e460f6951b0a63243a5, data reload: false
------ Round 1 ----------------------------------
q1 17567 7256 7178 7178
q2 2041 159 156 156
q3 10782 1179 1330 1179
q4 10559 844 921 844
q5 7753 3203 3188 3188
q6 230 149 145 145
q7 1009 621 603 603
q8 9448 2021 2090 2021
q9 6784 6438 6369 6369
q10 7059 2375 2384 2375
q11 439 246 251 246
q12 397 211 209 209
q13 17788 3005 2978 2978
q14 243 211 224 211
q15 571 504 513 504
q16 498 425 423 423
q17 989 923 926 923
q18 7370 6755 6733 6733
q19 1392 1262 1240 1240
q20 588 294 275 275
q21 3920 3397 3443 3397
q22 1121 1000 1016 1000
Total cold run time: 108548 ms
Total hot run time: 42197 ms
----- Round 2, with runtime_filter_mode=off -----
q1 7114 7067 7077 7067
q2 319 228 237 228
q3 3048 3045 3050 3045
q4 2039 1982 2006 1982
q5 5618 5606 5623 5606
q6 237 146 142 142
q7 2188 1782 1820 1782
q8 3291 3398 3397 3397
q9 8787 8902 8703 8703
q10 3515 3558 3529 3529
q11 588 488 470 470
q12 816 577 622 577
q13 11282 3115 3155 3115
q14 299 277 297 277
q15 585 520 529 520
q16 532 478 459 459
q17 1758 1723 1733 1723
q18 8518 8004 8104 8004
q19 1726 1729 1719 1719
q20 2102 1913 1869 1869
q21 5499 5088 5307 5088
q22 1180 1054 1022 1022
Total cold run time: 71041 ms
Total hot run time: 60324 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](restore) Fix view name in atomic restore [doris]
Posted by "w41ter (via GitHub)" <gi...@apache.org>.
w41ter commented on PR #40876:
URL: https://github.com/apache/doris/pull/40876#issuecomment-2350936492
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](restore) Fix view name in atomic restore [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40876:
URL: https://github.com/apache/doris/pull/40876#issuecomment-2350957598
<details>
<summary>ClickBench: <b>Total hot run time: 30.66 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 eaef2ebfac1cafcc8e446e460f6951b0a63243a5, data reload: false
query1 0.05 0.04 0.04
query2 0.05 0.03 0.03
query3 0.24 0.06 0.06
query4 1.65 0.10 0.10
query5 0.50 0.50 0.51
query6 1.14 0.73 0.72
query7 0.02 0.02 0.02
query8 0.04 0.03 0.03
query9 0.56 0.51 0.50
query10 0.57 0.58 0.57
query11 0.14 0.10 0.11
query12 0.14 0.11 0.10
query13 0.61 0.58 0.59
query14 1.43 1.47 1.49
query15 0.88 0.85 0.86
query16 0.38 0.37 0.38
query17 1.02 1.02 1.04
query18 0.18 0.17 0.18
query19 1.89 1.85 1.78
query20 0.01 0.01 0.00
query21 15.38 0.58 0.57
query22 3.10 4.15 2.23
query23 17.51 1.03 0.97
query24 2.32 0.21 0.36
query25 0.28 0.09 0.05
query26 0.16 0.13 0.13
query27 0.04 0.03 0.04
query28 12.28 1.03 0.99
query29 12.55 3.25 3.23
query30 0.25 0.06 0.05
query31 2.87 0.38 0.38
query32 3.27 0.47 0.46
query33 3.02 3.01 3.07
query34 15.44 4.27 4.28
query35 4.31 4.31 4.30
query36 0.71 0.47 0.48
query37 0.08 0.06 0.05
query38 0.05 0.03 0.03
query39 0.03 0.02 0.02
query40 0.16 0.13 0.13
query41 0.07 0.03 0.02
query42 0.02 0.02 0.02
query43 0.03 0.04 0.03
Total cold run time: 105.43 s
Total hot run time: 30.66 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](restore) Fix view name in atomic restore [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #40876:
URL: https://github.com/apache/doris/pull/40876#issuecomment-2351041585
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](restore) Fix view name in atomic restore [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #40876:
URL: https://github.com/apache/doris/pull/40876#issuecomment-2351041593
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](restore) Fix view name in atomic restore [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40876:
URL: https://github.com/apache/doris/pull/40876#issuecomment-2350956258
<details>
<summary>TPC-DS: <b>Total hot run time: 198886 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 eaef2ebfac1cafcc8e446e460f6951b0a63243a5, data reload: false
query1 1285 862 861 861
query2 6412 1774 1841 1774
query3 10777 3849 3852 3849
query4 54678 25921 24005 24005
query5 5340 513 528 513
query6 426 179 170 170
query7 5779 303 303 303
query8 287 226 219 219
query9 7345 2579 2579 2579
query10 470 312 280 280
query11 16519 15523 15457 15457
query12 150 101 100 100
query13 1511 437 413 413
query14 10020 6969 6891 6891
query15 210 175 200 175
query16 6971 513 498 498
query17 1153 614 616 614
query18 1761 325 319 319
query19 196 153 161 153
query20 125 110 112 110
query21 215 110 103 103
query22 4877 4524 4658 4524
query23 34538 34111 33802 33802
query24 6182 3061 3069 3061
query25 515 413 422 413
query26 628 160 162 160
query27 1596 291 297 291
query28 2836 2092 2066 2066
query29 681 432 428 428
query30 225 154 143 143
query31 965 788 784 784
query32 73 57 55 55
query33 464 301 297 297
query34 880 488 487 487
query35 860 737 743 737
query36 1022 917 948 917
query37 131 80 77 77
query38 4022 3914 4034 3914
query39 1459 1393 1406 1393
query40 213 100 99 99
query41 50 50 48 48
query42 126 101 101 101
query43 484 452 463 452
query44 1185 777 770 770
query45 199 165 165 165
query46 1091 829 824 824
query47 1913 1829 1823 1823
query48 515 346 354 346
query49 687 400 384 384
query50 927 431 436 431
query51 7118 6967 6904 6904
query52 97 85 84 84
query53 251 180 177 177
query54 579 454 463 454
query55 77 76 78 76
query56 269 248 255 248
query57 1232 1096 1089 1089
query58 250 227 298 227
query59 2839 2746 2568 2568
query60 285 277 274 274
query61 127 102 99 99
query62 766 682 660 660
query63 224 190 183 183
query64 1463 652 663 652
query65 3214 3143 3155 3143
query66 703 305 292 292
query67 15900 15726 15483 15483
query68 2017 598 588 588
query69 433 302 290 290
query70 1199 1135 1138 1135
query71 330 284 263 263
query72 5247 4092 4042 4042
query73 763 332 331 331
query74 9310 8942 9134 8942
query75 3442 2646 2760 2646
query76 1337 1262 1188 1188
query77 508 314 287 287
query78 9882 9216 9288 9216
query79 1610 901 889 889
query80 852 583 563 563
query81 501 240 236 236
query82 1404 197 200 197
query83 166 160 154 154
query84 296 111 108 108
query85 933 368 356 356
query86 331 307 309 307
query87 4416 4308 4389 4308
query88 4148 4035 4052 4035
query89 386 373 367 367
query90 1845 309 298 298
query91 176 164 162 162
query92 78 75 77 75
query93 1171 1000 1004 1000
query94 752 355 348 348
query95 474 405 414 405
query96 469 475 470 470
query97 3171 3147 3195 3147
query98 227 229 226 226
query99 1702 1335 1316 1316
Total cold run time: 295944 ms
Total hot run time: 198886 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](restore) Fix view name in atomic restore [doris]
Posted by "w41ter (via GitHub)" <gi...@apache.org>.
w41ter merged PR #40876:
URL: https://github.com/apache/doris/pull/40876
--
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](restore) Fix view name in atomic restore [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40876:
URL: https://github.com/apache/doris/pull/40876#issuecomment-2350936477
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