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/01/12 06:40:53 UTC
[PR] [feature](merge-cloud) Add cloud rowset meta & tablet meta definition [doris]
w41ter opened a new pull request, #29911:
URL: https://github.com/apache/doris/pull/29911
## Proposed changes
Issue Number: close #xxx
<!--Describe your changes.-->
## Further comments
If this is a relatively large or complex change, kick off the discussion at [dev@doris.apache.org](mailto:dev@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc...
--
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] [feature](merge-cloud) Add cloud rowset meta & tablet meta definition [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29911:
URL: https://github.com/apache/doris/pull/29911#issuecomment-1888576592
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit fc6a18bfbdbea6114f59ffb051098aeb73c25962 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: 32 seconds loaded 861443392 Bytes, about 25 MB/s
Insert into select: 12.3 seconds inserted 10000000 Rows, about 813K 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] [feature](merge-cloud) Add cloud rowset meta & tablet meta definition [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29911:
URL: https://github.com/apache/doris/pull/29911#issuecomment-1888522027
clang-tidy review says "All clean, LGTM! :+1:"
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [feature](merge-cloud) Add cloud rowset meta & tablet meta definition [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29911:
URL: https://github.com/apache/doris/pull/29911#issuecomment-1888660904
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 0b88f15504a17501c7cf0b7e969bea5e4679fecd 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: 32 seconds loaded 861443392 Bytes, about 25 MB/s
Insert into select: 13.5 seconds inserted 10000000 Rows, about 740K 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] [feature](merge-cloud) Add cloud rowset meta & tablet meta definition [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29911:
URL: https://github.com/apache/doris/pull/29911#issuecomment-1888573451
<details>
<summary>ClickBench: <b>Total hot run time: 30.62 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 fc6a18bfbdbea6114f59ffb051098aeb73c25962, data reload: false
query1 0.06 0.06 0.05
query2 0.06 0.03 0.03
query3 0.26 0.12 0.11
query4 1.77 0.12 0.12
query5 0.52 0.51 0.51
query6 1.38 0.63 0.63
query7 0.02 0.01 0.01
query8 0.03 0.02 0.02
query9 0.56 0.51 0.47
query10 0.54 0.56 0.55
query11 0.13 0.09 0.09
query12 0.12 0.09 0.09
query13 0.61 0.60 0.59
query14 0.78 0.79 0.80
query15 0.82 0.79 0.80
query16 0.34 0.34 0.34
query17 0.97 0.98 0.97
query18 0.25 0.27 0.28
query19 1.84 1.77 1.77
query20 0.02 0.01 0.01
query21 15.40 0.57 0.56
query22 2.74 2.31 2.07
query23 17.21 0.71 0.88
query24 16.12 0.58 0.58
query25 2.15 0.15 0.15
query26 0.14 0.13 0.14
query27 0.14 0.16 0.15
query28 5.87 0.85 0.79
query29 12.57 3.28 3.15
query30 0.55 0.49 0.46
query31 2.78 0.35 0.36
query32 3.39 0.48 0.48
query33 3.21 3.24 3.24
query34 15.96 4.21 4.14
query35 4.19 4.17 4.15
query36 1.10 1.03 1.04
query37 0.07 0.06 0.06
query38 0.03 0.02 0.02
query39 0.02 0.02 0.02
query40 0.16 0.13 0.14
query41 0.07 0.02 0.01
query42 0.02 0.01 0.01
query43 0.03 0.02 0.02
Total cold run time: 115 s
Total hot run time: 30.62 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] [feature](merge-cloud) Add cloud rowset meta & tablet meta definition [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29911:
URL: https://github.com/apache/doris/pull/29911#issuecomment-1888568996
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 46.44 seconds
stream load tsv: 562 seconds loaded 74807831229 Bytes, about 126 MB/s
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
stream load orc: 65 seconds loaded 1101869774 Bytes, about 16 MB/s
stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
insert into select: 21.5 seconds inserted 10000000 Rows, about 465K ops/s
storage size: 17183907450 Bytes
--
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] [feature](merge-cloud) Add cloud rowset meta & tablet meta definition [doris]
Posted by "w41ter (via GitHub)" <gi...@apache.org>.
w41ter commented on PR #29911:
URL: https://github.com/apache/doris/pull/29911#issuecomment-1888582814
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] [feature](merge-cloud) Add cloud rowset meta & tablet meta definition [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring merged PR #29911:
URL: https://github.com/apache/doris/pull/29911
--
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] [feature](merge-cloud) Add cloud rowset meta & tablet meta definition [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29911:
URL: https://github.com/apache/doris/pull/29911#issuecomment-1888555927
<details>
<summary>TPC-H: <b>Total hot run time: 38808 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 fc6a18bfbdbea6114f59ffb051098aeb73c25962, data reload: false
------ Round 1 ----------------------------------
q1 18001 5029 4932 4932
q2 2047 143 130 130
q3 10798 1150 1222 1150
q4 10504 780 855 780
q5 7814 3236 3202 3202
q6 206 125 130 125
q7 892 522 496 496
q8 9282 2021 2015 2015
q9 7420 6517 6466 6466
q10 8259 3044 3092 3044
q11 420 221 216 216
q12 364 198 201 198
q13 18093 3436 3432 3432
q14 243 212 212 212
q15 560 527 503 503
q16 438 387 390 387
q17 971 586 505 505
q18 7423 6762 6678 6678
q19 1593 1353 1426 1353
q20 535 285 289 285
q21 2775 2393 2396 2393
q22 353 310 306 306
Total cold run time: 108991 ms
Total hot run time: 38808 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4958 4951 4883 4883
q2 306 198 200 198
q3 3326 3331 3293 3293
q4 2239 2235 2247 2235
q5 5826 5799 5793 5793
q6 194 116 118 116
q7 2316 1854 1848 1848
q8 3465 3567 3581 3567
q9 8945 8862 8855 8855
q10 3741 3833 3800 3800
q11 561 423 433 423
q12 794 625 610 610
q13 5412 3277 3250 3250
q14 297 264 255 255
q15 565 508 501 501
q16 500 450 446 446
q17 2041 2022 2044 2022
q18 8827 8348 8355 8348
q19 1611 1598 1620 1598
q20 2178 1944 1906 1906
q21 6144 5715 5747 5715
q22 571 454 472 454
Total cold run time: 64817 ms
Total hot run time: 60116 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] [feature](merge-cloud) Add cloud rowset meta & tablet meta definition [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29911:
URL: https://github.com/apache/doris/pull/29911#issuecomment-1888649044
<details>
<summary>TPC-DS: <b>Total hot run time: 178488 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 0b88f15504a17501c7cf0b7e969bea5e4679fecd, data reload: false
query1 926 339 320 320
query2 6730 1938 1838 1838
query3 6703 211 204 204
query4 25865 21957 22192 21957
query5 8778 577 560 560
query6 281 175 208 175
query7 4635 273 269 269
query8 233 216 195 195
query9 9171 2799 2746 2746
query10 584 242 243 242
query11 16174 15395 15247 15247
query12 138 70 71 70
query13 1761 394 388 388
query14 12481 7175 7171 7171
query15 276 179 186 179
query16 6237 266 253 253
query17 1898 497 482 482
query18 1972 262 259 259
query19 280 144 150 144
query20 80 79 73 73
query21 192 130 122 122
query22 5211 4937 5027 4937
query23 31690 30946 30818 30818
query24 11858 2830 2832 2830
query25 562 331 330 330
query26 1708 145 147 145
query27 2828 277 281 277
query28 6929 1842 1838 1838
query29 2079 679 681 679
query30 280 134 145 134
query31 974 772 780 772
query32 94 64 57 57
query33 717 247 239 239
query34 1027 460 451 451
query35 903 785 774 774
query36 1334 1352 1254 1254
query37 108 65 68 65
query38 3463 3300 3310 3300
query39 1341 1266 1289 1266
query40 319 98 93 93
query41 40 35 34 34
query42 102 90 96 90
query43 570 504 506 504
query44 1089 700 700 700
query45 208 183 195 183
query46 1053 656 655 655
query47 1677 1571 1589 1571
query48 413 320 327 320
query49 1271 307 311 307
query50 693 315 322 315
query51 5345 5252 5227 5227
query52 99 95 83 83
query53 361 287 285 285
query54 914 458 456 456
query55 87 92 90 90
query56 219 192 191 191
query57 1012 970 936 936
query58 218 193 188 188
query59 2746 2566 2394 2394
query60 225 229 222 222
query61 85 90 83 83
query62 632 402 392 392
query63 307 273 282 273
query64 5740 1691 1705 1691
query65 3340 3273 3275 3273
query66 1220 339 326 326
query67 15631 15311 15211 15211
query68 12366 491 514 491
query69 692 379 396 379
query70 1737 1615 1604 1604
query71 556 235 251 235
query72 5097 2865 2884 2865
query73 2529 311 310 310
query74 6990 6365 6436 6365
query75 5232 2345 2293 2293
query76 6401 1098 1115 1098
query77 905 271 291 271
query78 9972 8604 8585 8585
query79 1057 496 496 496
query80 610 353 347 347
query81 454 208 209 208
query82 212 87 85 85
query83 168 124 123 123
query84 286 77 75 75
query85 1057 346 336 336
query86 408 396 398 396
query87 3588 3390 3367 3367
query88 3186 2196 2211 2196
query89 475 386 382 382
query90 1920 206 206 206
query91 164 130 129 129
query92 67 54 55 54
query93 1973 410 406 406
query94 1278 193 185 185
query95 514 487 478 478
query96 638 316 313 313
query97 4258 4124 4174 4124
query98 207 193 183 183
query99 1006 757 750 750
Total cold run time: 300120 ms
Total hot run time: 178488 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] [feature](merge-cloud) Add cloud rowset meta & tablet meta definition [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29911:
URL: https://github.com/apache/doris/pull/29911#issuecomment-1888568035
<details>
<summary>TPC-DS: <b>Total hot run time: 178969 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 fc6a18bfbdbea6114f59ffb051098aeb73c25962, data reload: false
query1 952 339 338 338
query2 6705 1937 2008 1937
query3 6729 205 204 204
query4 26136 22212 22212 22212
query5 8342 545 580 545
query6 272 191 184 184
query7 4610 288 258 258
query8 246 204 203 203
query9 9283 2766 2833 2766
query10 483 241 238 238
query11 16265 15536 15295 15295
query12 130 78 75 75
query13 1704 381 383 381
query14 12212 7263 7287 7263
query15 240 194 193 193
query16 6028 251 237 237
query17 1925 489 474 474
query18 1963 263 265 263
query19 288 147 143 143
query20 80 73 77 73
query21 203 126 124 124
query22 5008 4595 4757 4595
query23 31856 31069 30894 30894
query24 11933 2816 2839 2816
query25 556 325 322 322
query26 1766 156 148 148
query27 2817 274 275 274
query28 7083 1884 1865 1865
query29 2080 684 653 653
query30 286 139 144 139
query31 972 774 789 774
query32 91 59 61 59
query33 705 242 243 242
query34 1004 471 458 458
query35 909 766 750 750
query36 1388 1321 1299 1299
query37 105 71 69 69
query38 3399 3309 3292 3292
query39 1325 1302 1289 1289
query40 324 98 93 93
query41 37 35 35 35
query42 101 94 97 94
query43 535 524 507 507
query44 1073 691 703 691
query45 204 190 179 179
query46 1042 670 639 639
query47 1640 1578 1557 1557
query48 411 321 325 321
query49 1288 309 322 309
query50 691 317 317 317
query51 5342 5257 5234 5234
query52 100 95 92 92
query53 368 289 283 283
query54 927 458 468 458
query55 99 89 91 89
query56 212 196 193 193
query57 966 976 977 976
query58 219 191 199 191
query59 2701 2658 2592 2592
query60 232 216 219 216
query61 87 85 85 85
query62 652 449 408 408
query63 297 286 291 286
query64 5847 1725 1755 1725
query65 3365 3260 3274 3260
query66 1256 340 345 340
query67 15882 15120 15097 15097
query68 11528 508 500 500
query69 701 376 384 376
query70 1722 1616 1548 1548
query71 576 256 261 256
query72 5086 2841 2855 2841
query73 2057 320 312 312
query74 6999 6409 6426 6409
query75 4843 2344 2309 2309
query76 6329 1092 1083 1083
query77 695 305 294 294
query78 9823 8544 8618 8544
query79 1030 503 493 493
query80 541 339 357 339
query81 454 208 213 208
query82 209 94 94 94
query83 145 122 119 119
query84 288 79 79 79
query85 1029 336 337 336
query86 378 396 417 396
query87 3601 3388 3394 3388
query88 3100 2194 2175 2175
query89 452 392 384 384
query90 1938 201 190 190
query91 169 124 138 124
query92 60 55 54 54
query93 1767 441 427 427
query94 1185 188 190 188
query95 538 490 475 475
query96 616 311 309 309
query97 4303 4176 4193 4176
query98 202 196 189 189
query99 996 743 748 743
Total cold run time: 297337 ms
Total hot run time: 178969 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] [feature](merge-cloud) Add cloud rowset meta & tablet meta definition [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29911:
URL: https://github.com/apache/doris/pull/29911#issuecomment-1888602281
clang-tidy review says "All clean, LGTM! :+1:"
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [feature](merge-cloud) Add cloud rowset meta & tablet meta definition [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29911:
URL: https://github.com/apache/doris/pull/29911#issuecomment-1888658815
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] [feature](merge-cloud) Add cloud rowset meta & tablet meta definition [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29911:
URL: https://github.com/apache/doris/pull/29911#issuecomment-1888644224
(From new machine)TeamCity pipeline, clickbench performance test result:
the sum of best hot time: 47.02 seconds
stream load tsv: 561 seconds loaded 74807831229 Bytes, about 127 MB/s
stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
stream load orc: 65 seconds loaded 1101869774 Bytes, about 16 MB/s
stream load parquet: 33 seconds loaded 861443392 Bytes, about 24 MB/s
insert into select: 21.6 seconds inserted 10000000 Rows, about 462K ops/s
storage size: 17183830923 Bytes
--
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] [feature](merge-cloud) Add cloud rowset meta & tablet meta definition [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29911:
URL: https://github.com/apache/doris/pull/29911#issuecomment-1888617531
TeamCity be ut coverage result:
Function Coverage: 36.71% (8651/23565)
Line Coverage: 28.73% (70477/245283)
Region Coverage: 27.65% (36419/131715)
Branch Coverage: 24.37% (18639/76476)
Coverage Report: http://coverage.selectdb-in.cc/coverage/0b88f15504a17501c7cf0b7e969bea5e4679fecd_0b88f15504a17501c7cf0b7e969bea5e4679fecd/report/index.html
--
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] [feature](merge-cloud) Add cloud rowset meta & tablet meta definition [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29911:
URL: https://github.com/apache/doris/pull/29911#issuecomment-1888634149
<details>
<summary>TPC-H: <b>Total hot run time: 38525 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 0b88f15504a17501c7cf0b7e969bea5e4679fecd, data reload: false
------ Round 1 ----------------------------------
q1 17977 4992 4999 4992
q2 2046 144 128 128
q3 10695 1143 1203 1143
q4 10244 813 809 809
q5 7807 3174 3102 3102
q6 205 128 125 125
q7 872 505 483 483
q8 9260 1962 1997 1962
q9 7334 6452 6457 6452
q10 8238 3095 3070 3070
q11 420 204 213 204
q12 365 194 194 194
q13 18091 3436 3388 3388
q14 243 210 211 210
q15 561 514 503 503
q16 427 380 376 376
q17 950 493 464 464
q18 7275 6671 6661 6661
q19 1608 1296 1470 1296
q20 589 297 307 297
q21 2840 2360 2426 2360
q22 349 317 306 306
Total cold run time: 108396 ms
Total hot run time: 38525 ms
----- Round 2, with runtime_filter_mode=off -----
q1 5020 4929 4994 4929
q2 316 200 198 198
q3 3312 3325 3294 3294
q4 2238 2241 2255 2241
q5 5772 5757 5785 5757
q6 195 120 121 120
q7 2310 1830 1875 1830
q8 3433 3553 3576 3553
q9 8801 8822 8818 8818
q10 3742 3824 3814 3814
q11 541 423 420 420
q12 771 605 601 601
q13 6165 3196 3209 3196
q14 280 259 267 259
q15 563 515 506 506
q16 495 452 459 452
q17 2023 2049 1989 1989
q18 8760 8408 8213 8213
q19 1623 1616 1617 1616
q20 2138 1933 1924 1924
q21 6043 5763 5831 5763
q22 530 474 473 473
Total cold run time: 65071 ms
Total hot run time: 59966 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] [feature](merge-cloud) Add cloud rowset meta & tablet meta definition [doris]
Posted by "w41ter (via GitHub)" <gi...@apache.org>.
w41ter commented on PR #29911:
URL: https://github.com/apache/doris/pull/29911#issuecomment-1888515069
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] [feature](merge-cloud) Add cloud rowset meta & tablet meta definition [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #29911:
URL: https://github.com/apache/doris/pull/29911#issuecomment-1888656004
<details>
<summary>ClickBench: <b>Total hot run time: 30.29 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 0b88f15504a17501c7cf0b7e969bea5e4679fecd, data reload: false
query1 0.06 0.06 0.06
query2 0.07 0.03 0.02
query3 0.26 0.12 0.12
query4 1.75 0.12 0.10
query5 0.53 0.52 0.52
query6 1.36 0.64 0.62
query7 0.01 0.01 0.01
query8 0.04 0.03 0.03
query9 0.56 0.49 0.50
query10 0.55 0.55 0.53
query11 0.12 0.08 0.09
query12 0.12 0.09 0.10
query13 0.60 0.59 0.60
query14 0.79 0.79 0.77
query15 0.82 0.79 0.80
query16 0.35 0.35 0.34
query17 0.95 0.99 0.96
query18 0.24 0.26 0.25
query19 1.79 1.77 1.68
query20 0.01 0.01 0.01
query21 15.40 0.58 0.57
query22 2.66 2.89 1.79
query23 17.60 0.75 0.77
query24 16.18 0.57 0.59
query25 2.17 0.16 0.14
query26 0.14 0.14 0.13
query27 0.16 0.15 0.14
query28 5.98 0.85 0.84
query29 12.61 3.17 3.17
query30 0.53 0.48 0.46
query31 2.77 0.34 0.36
query32 3.38 0.48 0.48
query33 3.20 3.22 3.23
query34 16.08 4.18 4.16
query35 4.15 4.19 4.18
query36 1.09 1.05 1.04
query37 0.07 0.05 0.06
query38 0.03 0.02 0.02
query39 0.02 0.02 0.01
query40 0.16 0.14 0.13
query41 0.08 0.02 0.01
query42 0.02 0.01 0.02
query43 0.02 0.02 0.02
Total cold run time: 115.48 s
Total hot run time: 30.29 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] [feature](merge-cloud) Add cloud rowset meta & tablet meta definition [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #29911:
URL: https://github.com/apache/doris/pull/29911#issuecomment-1888653869
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