You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "eldenmoon (via GitHub)" <gi...@apache.org> on 2024/02/06 12:10:58 UTC
[PR] [Optimize](Variant) make tablet schema more well-organized (#99) [doris]
eldenmoon opened a new pull request, #30922:
URL: https://github.com/apache/doris/pull/30922
## 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] [Optimize](Variant) make tablet schema more well-organized (#99) [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30922:
URL: https://github.com/apache/doris/pull/30922#issuecomment-1931176885
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] [Optimize](Variant) make tablet schema more well-organized (#99) [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30922:
URL: https://github.com/apache/doris/pull/30922#issuecomment-1930163920
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] [Optimize](Variant) make tablet schema more well-organized (#99) [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30922:
URL: https://github.com/apache/doris/pull/30922#issuecomment-1929407631
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] [Optimize](Variant) make tablet schema more well-organized (#99) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30922:
URL: https://github.com/apache/doris/pull/30922#issuecomment-1931212558
<details>
<summary>ClickBench: <b>Total hot run time: 30.74 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 d4d7e63a575f7ea053af88bfc149dc37ac620990, data reload: false
query1 0.04 0.04 0.03
query2 0.06 0.02 0.03
query3 0.23 0.06 0.06
query4 1.67 0.10 0.10
query5 0.54 0.51 0.52
query6 1.19 0.65 0.63
query7 0.02 0.02 0.01
query8 0.03 0.02 0.02
query9 0.54 0.49 0.51
query10 0.54 0.57 0.55
query11 0.13 0.09 0.09
query12 0.11 0.09 0.09
query13 0.61 0.61 0.62
query14 0.76 0.82 0.79
query15 0.81 0.78 0.77
query16 0.38 0.39 0.37
query17 1.06 1.02 0.99
query18 0.22 0.25 0.28
query19 1.89 1.78 1.75
query20 0.01 0.01 0.01
query21 15.41 0.57 0.57
query22 2.37 2.37 1.70
query23 17.24 0.86 0.83
query24 2.68 0.87 0.77
query25 0.26 0.25 0.13
query26 0.51 0.14 0.15
query27 0.06 0.04 0.05
query28 12.00 0.88 0.84
query29 12.54 3.14 3.14
query30 0.64 0.54 0.53
query31 2.78 0.36 0.35
query32 3.34 0.48 0.50
query33 3.19 3.30 3.23
query34 15.77 4.24 4.35
query35 4.27 4.29 4.29
query36 1.11 1.05 1.06
query37 0.06 0.05 0.05
query38 0.04 0.03 0.03
query39 0.02 0.02 0.02
query40 0.16 0.13 0.13
query41 0.07 0.01 0.02
query42 0.02 0.02 0.01
query43 0.02 0.03 0.02
Total cold run time: 105.4 s
Total hot run time: 30.74 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] [Optimize](Variant) make tablet schema more well-organized (#99) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30922:
URL: https://github.com/apache/doris/pull/30922#issuecomment-1930282738
TeamCity be ut coverage result:
Function Coverage: 36.26% (8654/23867)
Line Coverage: 28.24% (70717/250389)
Region Coverage: 27.26% (36505/133931)
Branch Coverage: 24.04% (18704/77814)
Coverage Report: http://coverage.selectdb-in.cc/coverage/aad008d891009a21432fe8892ed3a8a1a7eefc18_aad008d891009a21432fe8892ed3a8a1a7eefc18/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] [Optimize](Variant) make tablet schema more well-organized (#99) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30922:
URL: https://github.com/apache/doris/pull/30922#issuecomment-1929549423
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit a13abaa734f1cd3a0eb465a6326b73e2bb608bec with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 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: 14.6 seconds inserted 10000000 Rows, about 684K 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] [Optimize](Variant) make tablet schema more well-organized (#99) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30922:
URL: https://github.com/apache/doris/pull/30922#issuecomment-1930322502
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit aad008d891009a21432fe8892ed3a8a1a7eefc18 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: 13.8 seconds inserted 10000000 Rows, about 724K 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] [Optimize](Variant) make tablet schema more well-organized (#99) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30922:
URL: https://github.com/apache/doris/pull/30922#issuecomment-1931215985
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit d4d7e63a575f7ea053af88bfc149dc37ac620990 with default session variables
Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 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: 14.4 seconds inserted 10000000 Rows, about 694K 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] [Optimize](Variant) make tablet schema more well-organized (#99) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30922:
URL: https://github.com/apache/doris/pull/30922#issuecomment-1929508918
<details>
<summary>TPC-DS: <b>Total hot run time: 174024 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 a13abaa734f1cd3a0eb465a6326b73e2bb608bec, data reload: false
query1 928 349 334 334
query2 6550 2094 1919 1919
query3 6701 211 199 199
query4 31915 21996 21907 21907
query5 4260 373 370 370
query6 256 167 183 167
query7 4629 288 289 288
query8 249 180 175 175
query9 9044 2274 2247 2247
query10 425 235 216 216
query11 17951 15371 15354 15354
query12 135 80 82 80
query13 1626 423 470 423
query14 9804 6727 6963 6727
query15 260 182 189 182
query16 8143 264 246 246
query17 1966 543 501 501
query18 2116 277 263 263
query19 361 143 143 143
query20 84 77 75 75
query21 190 121 125 121
query22 4948 4603 4388 4388
query23 31920 30001 29958 29958
query24 9440 2801 2788 2788
query25 540 342 349 342
query26 713 150 151 150
query27 2156 304 306 304
query28 5783 1853 1832 1832
query29 863 604 598 598
query30 287 131 143 131
query31 907 683 725 683
query32 90 53 49 49
query33 579 227 219 219
query34 867 459 464 459
query35 843 767 775 767
query36 958 948 942 942
query37 100 55 62 55
query38 3295 3075 3166 3075
query39 1304 1251 1243 1243
query40 184 96 93 93
query41 40 35 35 35
query42 95 88 99 88
query43 545 507 486 486
query44 1074 689 696 689
query45 198 177 177 177
query46 1048 683 668 668
query47 1576 1439 1558 1439
query48 448 359 354 354
query49 1038 289 286 286
query50 792 379 388 379
query51 5235 5138 5148 5138
query52 101 85 95 85
query53 334 281 263 263
query54 276 218 234 218
query55 79 80 71 71
query56 222 206 205 205
query57 985 899 894 894
query58 208 178 182 178
query59 2592 2211 2376 2211
query60 245 217 209 209
query61 84 83 84 83
query62 624 353 377 353
query63 310 274 286 274
query64 4651 3588 3563 3563
query65 3264 3240 3210 3210
query66 824 313 298 298
query67 14494 14154 14347 14154
query68 4357 547 560 547
query69 461 338 338 338
query70 1297 1225 1227 1225
query71 328 259 248 248
query72 6020 2834 2647 2647
query73 734 328 321 321
query74 6622 6246 6226 6226
query75 3038 2376 2365 2365
query76 2544 951 980 951
query77 354 228 224 224
query78 9292 8835 8439 8439
query79 3055 497 510 497
query80 2126 359 351 351
query81 543 197 197 197
query82 853 80 85 80
query83 237 126 123 123
query84 289 86 82 82
query85 2172 347 323 323
query86 489 325 289 289
query87 3439 3187 3232 3187
query88 4116 2387 2367 2367
query89 445 383 367 367
query90 2046 171 165 165
query91 149 118 121 118
query92 52 44 44 44
query93 4307 517 477 477
query94 1317 187 174 174
query95 473 7757 364 364
query96 608 286 283 283
query97 4248 4111 4125 4111
query98 211 210 189 189
query99 1139 702 684 684
Total cold run time: 282113 ms
Total hot run time: 174024 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] [Optimize](Variant) make tablet schema more well-organized (#99) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30922:
URL: https://github.com/apache/doris/pull/30922#issuecomment-1931197724
<details>
<summary>TPC-H: <b>Total hot run time: 37162 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 d4d7e63a575f7ea053af88bfc149dc37ac620990, data reload: false
------ Round 1 ----------------------------------
q1 18267 4652 4417 4417
q2 2056 144 135 135
q3 10604 935 926 926
q4 4655 739 750 739
q5 7685 2781 2797 2781
q6 186 124 124 124
q7 1153 731 749 731
q8 9290 1995 2055 1995
q9 7744 6406 6383 6383
q10 8164 2532 2459 2459
q11 418 199 208 199
q12 739 283 278 278
q13 18006 3329 3334 3329
q14 281 249 258 249
q15 529 506 497 497
q16 481 408 416 408
q17 951 601 512 512
q18 6887 5942 5998 5942
q19 1562 1396 1381 1381
q20 616 355 327 327
q21 6714 3052 3082 3052
q22 812 298 300 298
Total cold run time: 107800 ms
Total hot run time: 37162 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4486 4465 4384 4384
q2 326 247 240 240
q3 2984 2894 2865 2865
q4 1816 1695 1685 1685
q5 5259 5270 5253 5253
q6 194 113 116 113
q7 2154 1721 1757 1721
q8 3131 3218 3256 3218
q9 8335 8325 8364 8325
q10 5808 3612 3629 3612
q11 567 473 466 466
q12 752 577 631 577
q13 10243 3091 3099 3091
q14 288 252 254 252
q15 556 489 491 489
q16 528 470 446 446
q17 1834 1683 1735 1683
q18 7959 7845 7471 7471
q19 7481 1531 1564 1531
q20 2165 1929 1909 1909
q21 4790 4584 4604 4584
q22 548 442 494 442
Total cold run time: 72204 ms
Total hot run time: 54357 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] [Optimize](Variant) make tablet schema more well-organized (#99) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30922:
URL: https://github.com/apache/doris/pull/30922#issuecomment-1930307976
<details>
<summary>ClickBench: <b>Total hot run time: 31.75 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 aad008d891009a21432fe8892ed3a8a1a7eefc18, data reload: false
query1 0.04 0.03 0.03
query2 0.07 0.03 0.03
query3 0.23 0.06 0.07
query4 1.67 0.10 0.10
query5 0.53 0.52 0.52
query6 1.18 0.63 0.67
query7 0.02 0.01 0.01
query8 0.04 0.03 0.03
query9 0.56 0.51 0.50
query10 0.56 0.56 0.55
query11 0.12 0.09 0.09
query12 0.11 0.09 0.10
query13 0.60 0.61 0.60
query14 0.78 0.80 0.80
query15 0.81 0.78 0.78
query16 0.37 0.40 0.38
query17 1.04 1.00 1.05
query18 0.21 0.27 0.25
query19 1.90 1.76 1.83
query20 0.01 0.01 0.01
query21 15.39 0.59 0.60
query22 2.45 2.58 2.39
query23 17.25 0.94 0.75
query24 2.45 1.43 1.02
query25 0.27 0.26 0.12
query26 0.60 0.15 0.15
query27 0.04 0.06 0.05
query28 10.96 0.86 0.85
query29 12.55 3.21 3.18
query30 0.67 0.53 0.56
query31 2.78 0.36 0.35
query32 3.36 0.48 0.49
query33 3.20 3.25 3.24
query34 15.73 4.23 4.31
query35 4.27 4.27 4.28
query36 1.10 1.06 1.07
query37 0.06 0.05 0.05
query38 0.04 0.03 0.03
query39 0.02 0.02 0.02
query40 0.16 0.13 0.13
query41 0.07 0.02 0.01
query42 0.02 0.01 0.02
query43 0.02 0.02 0.02
Total cold run time: 104.31 s
Total hot run time: 31.75 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] [Optimize](Variant) make tablet schema more well-organized (#99) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30922:
URL: https://github.com/apache/doris/pull/30922#issuecomment-1930286005
<details>
<summary>TPC-DS: <b>Total hot run time: 174963 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 aad008d891009a21432fe8892ed3a8a1a7eefc18, data reload: false
query1 964 352 339 339
query2 6508 2025 1922 1922
query3 6694 212 206 206
query4 31677 22143 22083 22083
query5 4309 363 414 363
query6 261 169 163 163
query7 4620 288 277 277
query8 239 185 182 182
query9 9343 2266 2256 2256
query10 410 223 226 223
query11 18151 15529 15397 15397
query12 127 81 77 77
query13 1616 435 418 418
query14 8861 7327 7354 7327
query15 293 183 185 183
query16 8171 258 254 254
query17 2028 527 501 501
query18 2108 269 272 269
query19 365 141 141 141
query20 79 79 78 78
query21 197 130 124 124
query22 4951 4610 4605 4605
query23 31333 30040 30012 30012
query24 10979 2773 2769 2769
query25 575 350 340 340
query26 1231 142 150 142
query27 2953 305 304 304
query28 7389 1840 1823 1823
query29 891 626 599 599
query30 282 130 144 130
query31 930 691 710 691
query32 86 57 47 47
query33 730 224 216 216
query34 1068 466 473 466
query35 884 770 765 765
query36 1093 929 910 910
query37 121 55 58 55
query38 3254 3075 3091 3075
query39 1310 1251 1250 1250
query40 187 100 93 93
query41 36 35 34 34
query42 97 87 96 87
query43 537 470 480 470
query44 1075 690 694 690
query45 196 180 176 176
query46 1060 663 662 662
query47 1609 1456 1509 1456
query48 437 352 352 352
query49 1087 290 292 290
query50 770 401 386 386
query51 5258 5176 5139 5139
query52 106 87 88 87
query53 332 271 275 271
query54 269 218 228 218
query55 82 74 77 74
query56 220 197 208 197
query57 991 911 897 897
query58 198 177 181 177
query59 2507 2459 2342 2342
query60 240 208 215 208
query61 86 84 83 83
query62 663 355 353 353
query63 311 273 280 273
query64 5255 3434 3678 3434
query65 3268 3226 3222 3222
query66 813 313 318 313
query67 14592 14102 14203 14102
query68 4355 532 524 524
query69 459 335 332 332
query70 1286 1220 1255 1220
query71 335 241 249 241
query72 6032 2874 2665 2665
query73 721 330 322 322
query74 6620 6234 6176 6176
query75 3059 2351 2379 2351
query76 2538 965 884 884
query77 363 225 226 225
query78 9110 8908 8510 8510
query79 3167 510 495 495
query80 2108 365 358 358
query81 540 198 198 198
query82 885 84 80 80
query83 251 125 130 125
query84 280 84 79 79
query85 2222 337 331 331
query86 477 309 295 295
query87 3417 3225 3200 3200
query88 4502 2396 2377 2377
query89 447 370 366 366
query90 2037 165 167 165
query91 158 120 120 120
query92 57 44 46 44
query93 5238 484 476 476
query94 1273 177 178 177
query95 463 369 357 357
query96 625 272 277 272
query97 4247 4105 4128 4105
query98 226 206 189 189
query99 1182 666 636 636
Total cold run time: 288043 ms
Total hot run time: 174963 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] [Optimize](Variant) make tablet schema more well-organized (#99) [doris]
Posted by "eldenmoon (via GitHub)" <gi...@apache.org>.
eldenmoon commented on PR #30922:
URL: https://github.com/apache/doris/pull/30922#issuecomment-1931167599
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] [Optimize](Variant) make tablet schema more well-organized (#99) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30922:
URL: https://github.com/apache/doris/pull/30922#issuecomment-1931198625
TeamCity be ut coverage result:
Function Coverage: 36.16% (8638/23886)
Line Coverage: 28.19% (70613/250486)
Region Coverage: 27.18% (36426/134042)
Branch Coverage: 23.97% (18661/77848)
Coverage Report: http://coverage.selectdb-in.cc/coverage/d4d7e63a575f7ea053af88bfc149dc37ac620990_d4d7e63a575f7ea053af88bfc149dc37ac620990/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] [Optimize](Variant) make tablet schema more well-organized (#99) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30922:
URL: https://github.com/apache/doris/pull/30922#issuecomment-1931207393
<details>
<summary>TPC-DS: <b>Total hot run time: 175792 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 d4d7e63a575f7ea053af88bfc149dc37ac620990, data reload: false
query1 945 357 361 357
query2 6516 2049 1885 1885
query3 6698 210 208 208
query4 31739 21996 22188 21996
query5 4268 450 383 383
query6 261 170 160 160
query7 4616 302 298 298
query8 249 171 190 171
query9 9000 2283 2259 2259
query10 407 225 228 225
query11 17819 15339 15536 15339
query12 134 79 76 76
query13 1620 422 410 410
query14 9211 7125 7336 7125
query15 238 184 187 184
query16 8150 258 249 249
query17 2053 551 536 536
query18 2104 283 265 265
query19 353 149 141 141
query20 84 82 79 79
query21 202 127 136 127
query22 4847 4366 4575 4366
query23 31400 30158 30217 30158
query24 10787 2863 2944 2863
query25 596 348 341 341
query26 1200 161 149 149
query27 2884 308 309 308
query28 7461 1857 1861 1857
query29 939 636 628 628
query30 286 136 147 136
query31 945 709 743 709
query32 91 55 48 48
query33 738 235 233 233
query34 1041 471 472 471
query35 887 760 756 756
query36 1048 920 967 920
query37 123 59 58 58
query38 3263 3145 3130 3130
query39 1308 1253 1259 1253
query40 184 100 96 96
query41 37 36 35 35
query42 105 89 92 89
query43 543 492 493 492
query44 1081 686 696 686
query45 195 178 175 175
query46 1136 722 711 711
query47 1524 1502 1489 1489
query48 437 351 349 349
query49 1083 297 307 297
query50 821 382 378 378
query51 5317 5182 5200 5182
query52 99 86 84 84
query53 359 289 265 265
query54 277 218 217 217
query55 87 75 80 75
query56 224 202 204 202
query57 979 912 903 903
query58 204 180 188 180
query59 2362 2257 2298 2257
query60 254 218 226 218
query61 87 83 86 83
query62 717 357 349 349
query63 293 269 279 269
query64 5245 3684 3692 3684
query65 3289 3267 3261 3261
query66 814 311 331 311
query67 14290 14325 14427 14325
query68 4339 553 535 535
query69 465 336 341 336
query70 1318 1216 1133 1133
query71 330 249 253 249
query72 6187 2868 2670 2670
query73 764 334 324 324
query74 6565 6213 6223 6213
query75 3215 2413 2346 2346
query76 2747 1080 1049 1049
query77 369 231 232 231
query78 9129 8795 8697 8697
query79 3233 522 488 488
query80 2102 357 347 347
query81 547 199 200 199
query82 894 81 82 81
query83 247 130 133 130
query84 284 85 84 84
query85 2182 332 326 326
query86 467 297 309 297
query87 3399 3226 3195 3195
query88 4488 2385 2379 2379
query89 460 365 356 356
query90 2041 167 167 167
query91 149 122 126 122
query92 56 47 48 47
query93 5234 514 478 478
query94 1280 178 178 178
query95 8097 369 7747 369
query96 668 289 278 278
query97 4262 4088 4140 4088
query98 229 207 200 200
query99 1145 773 681 681
Total cold run time: 295446 ms
Total hot run time: 175792 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] [Optimize](Variant) make tablet schema more well-organized (#99) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30922:
URL: https://github.com/apache/doris/pull/30922#issuecomment-1929536094
<details>
<summary>ClickBench: <b>Total hot run time: 30.81 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 a13abaa734f1cd3a0eb465a6326b73e2bb608bec, data reload: false
query1 0.03 0.03 0.03
query2 0.06 0.02 0.02
query3 0.23 0.06 0.06
query4 1.68 0.10 0.09
query5 0.54 0.51 0.52
query6 1.22 0.68 0.63
query7 0.02 0.01 0.02
query8 0.04 0.02 0.02
query9 0.54 0.49 0.50
query10 0.56 0.56 0.54
query11 0.12 0.08 0.09
query12 0.11 0.09 0.10
query13 0.61 0.60 0.61
query14 0.78 0.79 0.81
query15 0.79 0.77 0.76
query16 0.40 0.38 0.38
query17 1.04 1.02 1.02
query18 0.24 0.28 0.22
query19 1.84 1.79 1.78
query20 0.02 0.01 0.01
query21 15.39 0.61 0.60
query22 2.67 2.91 1.93
query23 17.32 0.92 0.79
query24 2.44 1.16 0.67
query25 0.34 0.25 0.07
query26 0.52 0.14 0.15
query27 0.05 0.04 0.04
query28 12.28 0.83 0.84
query29 12.54 3.20 3.21
query30 0.63 0.55 0.53
query31 2.78 0.35 0.35
query32 3.36 0.49 0.47
query33 3.20 3.23 3.18
query34 15.62 4.30 4.28
query35 4.34 4.32 4.27
query36 1.10 1.06 1.07
query37 0.06 0.05 0.05
query38 0.04 0.03 0.03
query39 0.02 0.02 0.01
query40 0.16 0.13 0.13
query41 0.07 0.02 0.02
query42 0.02 0.01 0.02
query43 0.02 0.02 0.02
Total cold run time: 105.84 s
Total hot run time: 30.81 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] [Optimize](Variant) make tablet schema more well-organized (#99) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30922:
URL: https://github.com/apache/doris/pull/30922#issuecomment-1930233763
<details>
<summary>TPC-H: <b>Total hot run time: 37058 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 aad008d891009a21432fe8892ed3a8a1a7eefc18, data reload: false
------ Round 1 ----------------------------------
q1 17617 4632 4470 4470
q2 2044 139 136 136
q3 10601 914 920 914
q4 4682 774 679 679
q5 7688 2841 2806 2806
q6 190 121 121 121
q7 1149 728 724 724
q8 9296 1972 2009 1972
q9 7263 6617 6329 6329
q10 8108 2488 2418 2418
q11 430 206 196 196
q12 811 273 282 273
q13 18030 3294 3315 3294
q14 284 252 254 252
q15 525 503 493 493
q16 475 440 409 409
q17 935 518 535 518
q18 6937 5957 5976 5957
q19 1576 1405 1380 1380
q20 605 337 356 337
q21 6978 3162 3083 3083
q22 822 317 297 297
Total cold run time: 107046 ms
Total hot run time: 37058 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4529 4512 4439 4439
q2 329 239 238 238
q3 3012 2853 2882 2853
q4 1815 1635 1650 1635
q5 5244 5222 5261 5222
q6 194 116 117 116
q7 2146 1723 1769 1723
q8 3144 3263 3267 3263
q9 8378 8273 8368 8273
q10 5984 3625 3568 3568
q11 536 467 460 460
q12 743 629 578 578
q13 15225 3096 3051 3051
q14 281 260 265 260
q15 530 495 496 495
q16 505 488 483 483
q17 1838 1634 1698 1634
q18 8028 7912 7640 7640
q19 8106 1550 1556 1550
q20 2146 1916 1908 1908
q21 4795 4721 4603 4603
q22 523 452 499 452
Total cold run time: 78031 ms
Total hot run time: 54444 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] [Optimize](Variant) make tablet schema more well-organized (#99) [doris]
Posted by "eldenmoon (via GitHub)" <gi...@apache.org>.
eldenmoon commented on PR #30922:
URL: https://github.com/apache/doris/pull/30922#issuecomment-1929392372
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] [Optimize](Variant) make tablet schema more well-organized (#99) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30922:
URL: https://github.com/apache/doris/pull/30922#issuecomment-1929599901
TeamCity be ut coverage result:
Function Coverage: 36.19% (8637/23867)
Line Coverage: 28.20% (70613/250389)
Region Coverage: 27.21% (36436/133931)
Branch Coverage: 23.98% (18661/77814)
Coverage Report: http://coverage.selectdb-in.cc/coverage/a13abaa734f1cd3a0eb465a6326b73e2bb608bec_a13abaa734f1cd3a0eb465a6326b73e2bb608bec/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] [Optimize](Variant) make tablet schema more well-organized (#99) [doris]
Posted by "eldenmoon (via GitHub)" <gi...@apache.org>.
eldenmoon commented on PR #30922:
URL: https://github.com/apache/doris/pull/30922#issuecomment-1930130564
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] [Optimize](Variant) make tablet schema more well-organized (#99) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30922:
URL: https://github.com/apache/doris/pull/30922#issuecomment-1929468805
<details>
<summary>TPC-H: <b>Total hot run time: 37280 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 a13abaa734f1cd3a0eb465a6326b73e2bb608bec, data reload: false
------ Round 1 ----------------------------------
q1 17668 4702 4531 4531
q2 2045 144 136 136
q3 10662 924 915 915
q4 4694 773 770 770
q5 7682 2851 2848 2848
q6 190 121 121 121
q7 1170 727 715 715
q8 9348 2020 2002 2002
q9 7273 6393 6382 6382
q10 8073 2455 2434 2434
q11 424 210 218 210
q12 708 274 276 274
q13 18029 3356 3326 3326
q14 276 259 244 244
q15 542 493 482 482
q16 466 405 404 404
q17 966 543 534 534
q18 6799 5991 5897 5897
q19 1574 1425 1394 1394
q20 624 322 338 322
q21 6587 3041 3216 3041
q22 804 320 298 298
Total cold run time: 106604 ms
Total hot run time: 37280 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4500 4393 4484 4393
q2 337 231 235 231
q3 3026 2886 2860 2860
q4 1810 1622 1610 1610
q5 5238 5219 5253 5219
q6 201 114 116 114
q7 2156 1726 1787 1726
q8 3069 3234 3252 3234
q9 8420 8355 8282 8282
q10 5799 3546 3588 3546
q11 542 457 465 457
q12 724 572 577 572
q13 15413 3119 3079 3079
q14 271 249 266 249
q15 530 484 489 484
q16 531 489 490 489
q17 1857 1675 1670 1670
q18 8043 7669 7543 7543
q19 9572 1539 1548 1539
q20 2128 1907 1914 1907
q21 4811 4544 4607 4544
q22 579 494 431 431
Total cold run time: 79557 ms
Total hot run time: 54179 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] [Optimize](Variant) make tablet schema more well-organized (#99) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30922:
URL: https://github.com/apache/doris/pull/30922#issuecomment-1929391643
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)
--
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