You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "TangSiyang2001 (via GitHub)" <gi...@apache.org> on 2024/09/13 12:22:20 UTC
[PR] [enhancement](show) Move storage policy info from show create table to show partitions (#39923) [doris]
TangSiyang2001 opened a new pull request, #40823:
URL: https://github.com/apache/doris/pull/40823
## Proposed changes
pick: #39923
--
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] [enhancement](show) Move storage policy info from show create table to show partitions (#39923) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40823:
URL: https://github.com/apache/doris/pull/40823#issuecomment-2349032014
<details>
<summary>TPC-DS: <b>Total hot run time: 212065 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 d15e325d721e87e33d06eca656aac42cbb4249d8, data reload: false
query1 912 386 438 386
query2 6525 2247 2011 2011
query3 6926 212 209 209
query4 23754 21679 21828 21679
query5 19736 6504 6530 6504
query6 288 233 231 231
query7 4164 294 300 294
query8 246 252 227 227
query9 3026 2616 2583 2583
query10 414 302 311 302
query11 15907 14766 14942 14766
query12 121 77 74 74
query13 1042 444 441 441
query14 17690 13492 13823 13492
query15 359 211 225 211
query16 6477 300 265 265
query17 1812 951 890 890
query18 897 322 315 315
query19 211 155 153 153
query20 82 77 76 76
query21 189 97 96 96
query22 5316 5166 5027 5027
query23 34335 33728 33522 33522
query24 6932 6305 6315 6305
query25 511 429 424 424
query26 1108 161 163 161
query27 2392 294 291 291
query28 6085 2253 2213 2213
query29 2960 2860 2568 2568
query30 248 171 175 171
query31 925 738 768 738
query32 69 64 62 62
query33 443 253 255 253
query34 858 469 475 469
query35 1116 877 931 877
query36 1188 1273 1210 1210
query37 90 61 59 59
query38 3143 2962 2907 2907
query39 1384 1325 1342 1325
query40 306 97 97 97
query41 40 39 38 38
query42 85 86 90 86
query43 619 600 564 564
query44 1211 729 721 721
query45 256 232 232 232
query46 1236 977 977 977
query47 1801 1736 1715 1715
query48 517 413 403 403
query49 635 364 381 364
query50 876 640 612 612
query51 4796 4665 4632 4632
query52 88 84 82 82
query53 235 187 192 187
query54 2672 2426 2478 2426
query55 96 84 84 84
query56 229 211 205 205
query57 1210 1181 1075 1075
query58 222 215 215 215
query59 3305 3325 3160 3160
query60 211 203 207 203
query61 97 93 97 93
query62 789 491 422 422
query63 204 174 174 174
query64 3470 1582 1428 1428
query65 3619 3578 3569 3569
query66 763 417 439 417
query67 17633 15764 15551 15551
query68 9259 652 645 645
query69 491 273 276 273
query70 1454 1395 1302 1302
query71 390 296 320 296
query72 6796 4645 4792 4645
query73 758 329 321 321
query74 6352 5865 5972 5865
query75 4952 3678 3768 3678
query76 5046 1149 1208 1149
query77 833 255 250 250
query78 12519 11825 11680 11680
query79 6890 637 630 630
query80 1305 394 377 377
query81 496 238 236 236
query82 1689 101 96 96
query83 175 134 135 134
query84 260 76 70 70
query85 893 322 316 316
query86 331 300 291 291
query87 3234 3116 2969 2969
query88 4542 2367 2388 2367
query89 392 287 276 276
query90 1957 222 217 217
query91 167 126 129 126
query92 63 51 52 51
query93 6556 578 566 566
query94 727 209 209 209
query95 2063 1946 1983 1946
query96 657 335 339 335
query97 6548 6398 6245 6245
query98 239 202 197 197
query99 2942 852 788 788
Total cold run time: 318078 ms
Total hot run time: 212065 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] [enhancement](show) Move storage policy info from show create table to show partitions (#39923) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40823:
URL: https://github.com/apache/doris/pull/40823#issuecomment-2348873399
<details>
<summary>TPC-H: <b>Total hot run time: 48904 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 d7cdfb722e3c116db526e3ce2969829674cc7a16, data reload: false
------ Round 1 ----------------------------------
q1 17939 4355 4532 4355
q2 2064 160 148 148
q3 10442 1904 1920 1904
q4 10365 1237 1323 1237
q5 8380 3875 3930 3875
q6 236 125 122 122
q7 2006 1665 1641 1641
q8 9523 2721 2699 2699
q9 12566 9914 9686 9686
q10 8629 3498 3516 3498
q11 413 244 236 236
q12 465 298 299 298
q13 18343 3973 4029 3973
q14 355 314 331 314
q15 511 458 466 458
q16 543 447 453 447
q17 1125 946 924 924
q18 7367 6721 6906 6721
q19 1694 1593 1556 1556
q20 534 317 316 316
q21 4493 4184 4114 4114
q22 502 394 382 382
Total cold run time: 118495 ms
Total hot run time: 48904 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4286 4305 4282 4282
q2 321 231 224 224
q3 4176 4129 4114 4114
q4 2741 2728 2722 2722
q5 7141 7127 7043 7043
q6 236 116 118 116
q7 3242 2834 2779 2779
q8 4401 4468 4518 4468
q9 13589 13582 13568 13568
q10 4205 4244 4272 4244
q11 749 705 681 681
q12 1013 856 860 856
q13 6705 3744 3735 3735
q14 460 422 418 418
q15 495 465 459 459
q16 635 592 598 592
q17 3923 3841 3838 3838
q18 8845 8631 8680 8631
q19 1715 1690 1642 1642
q20 2363 2125 2136 2125
q21 8431 8529 8510 8510
q22 1034 902 962 902
Total cold run time: 80706 ms
Total hot run time: 75949 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] [enhancement](show) Move storage policy info from show create table to show partitions (#39923) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40823:
URL: https://github.com/apache/doris/pull/40823#issuecomment-2356407494
<details>
<summary>ClickBench: <b>Total hot run time: 30.45 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 c12253d1a941f1aac77439f3b73e978784e5feca, data reload: false
query1 0.02 0.02 0.02
query2 0.07 0.03 0.03
query3 0.26 0.04 0.04
query4 1.80 0.07 0.07
query5 0.53 0.52 0.52
query6 1.24 0.62 0.63
query7 0.01 0.01 0.01
query8 0.04 0.04 0.02
query9 0.54 0.52 0.49
query10 0.55 0.52 0.54
query11 0.12 0.09 0.08
query12 0.13 0.09 0.10
query13 0.62 0.63 0.61
query14 0.77 0.78 0.79
query15 0.77 0.76 0.76
query16 0.40 0.35 0.37
query17 0.98 1.01 1.02
query18 0.22 0.25 0.24
query19 1.89 1.86 1.85
query20 0.02 0.01 0.01
query21 15.45 0.55 0.56
query22 2.21 2.14 1.59
query23 17.38 1.00 0.98
query24 8.62 0.71 0.99
query25 0.36 0.08 0.05
query26 0.85 0.16 0.16
query27 0.04 0.04 0.03
query28 5.11 0.71 0.72
query29 12.62 2.27 2.21
query30 0.61 0.53 0.54
query31 2.81 0.39 0.38
query32 3.38 0.49 0.50
query33 3.06 3.04 3.08
query34 15.26 4.79 4.79
query35 4.85 4.85 4.85
query36 1.05 1.02 1.01
query37 0.06 0.04 0.05
query38 0.03 0.02 0.02
query39 0.02 0.02 0.01
query40 0.16 0.14 0.15
query41 0.07 0.01 0.02
query42 0.02 0.02 0.01
query43 0.03 0.02 0.02
Total cold run time: 105.03 s
Total hot run time: 30.45 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] [enhancement](show) Move storage policy info from show create table to show partitions (#39923) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40823:
URL: https://github.com/apache/doris/pull/40823#issuecomment-2356413541
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit c12253d1a941f1aac77439f3b73e978784e5feca with default session variables
Stream load json: 20 seconds loaded 2358488459 Bytes, about 112 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.5 seconds inserted 10000000 Rows, about 465K 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] [enhancement](show) Move storage policy info from show create table to show partitions (#39923) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40823:
URL: https://github.com/apache/doris/pull/40823#issuecomment-2349049891
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit d15e325d721e87e33d06eca656aac42cbb4249d8 with default session variables
Stream load json: 20 seconds loaded 2358488459 Bytes, about 112 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: 22.0 seconds inserted 10000000 Rows, about 454K 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] [enhancement](show) Move storage policy info from show create table to show partitions (#39923) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40823:
URL: https://github.com/apache/doris/pull/40823#issuecomment-2348900505
<details>
<summary>TPC-DS: <b>Total hot run time: 214735 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 d7cdfb722e3c116db526e3ce2969829674cc7a16, data reload: false
query1 929 395 428 395
query2 6553 2309 2207 2207
query3 6918 215 208 208
query4 22908 21523 21538 21523
query5 19739 6469 6547 6469
query6 281 237 244 237
query7 4329 298 297 297
query8 300 258 243 243
query9 3017 2615 2534 2534
query10 452 308 300 300
query11 15577 14983 15258 14983
query12 122 76 74 74
query13 1032 431 439 431
query14 16995 13259 13203 13203
query15 360 214 233 214
query16 6483 280 260 260
query17 1812 905 901 901
query18 891 321 313 313
query19 208 151 158 151
query20 81 75 79 75
query21 190 96 98 96
query22 5227 4983 5046 4983
query23 34198 33339 33344 33339
query24 7885 6252 6298 6252
query25 517 421 414 414
query26 1270 162 166 162
query27 2455 292 289 289
query28 6145 2270 2218 2218
query29 2834 2783 2716 2716
query30 244 170 169 169
query31 951 721 767 721
query32 72 62 60 60
query33 455 272 243 243
query34 859 467 455 455
query35 1118 936 914 914
query36 1451 1265 1097 1097
query37 172 57 58 57
query38 3067 2935 2918 2918
query39 1371 1315 1311 1311
query40 301 91 92 91
query41 38 37 37 37
query42 90 88 84 84
query43 660 563 589 563
query44 1144 713 708 708
query45 243 233 230 230
query46 1225 963 956 956
query47 1869 1784 1699 1699
query48 508 412 400 400
query49 647 369 371 369
query50 861 595 625 595
query51 4773 4687 4615 4615
query52 89 80 81 80
query53 228 187 181 181
query54 2685 2473 2452 2452
query55 89 85 87 85
query56 225 212 211 211
query57 1182 1164 1157 1157
query58 221 206 209 206
query59 3622 3424 3318 3318
query60 213 207 196 196
query61 96 95 95 95
query62 824 451 465 451
query63 198 179 176 176
query64 3521 1591 1491 1491
query65 3627 3548 3542 3542
query66 764 383 414 383
query67 17326 18815 18309 18309
query68 4955 629 633 629
query69 435 269 261 261
query70 1457 1596 1300 1300
query71 351 306 320 306
query72 6648 4912 4799 4799
query73 736 324 313 313
query74 6332 5889 5854 5854
query75 4410 3659 3700 3659
query76 2374 1159 1205 1159
query77 453 252 260 252
query78 12519 11473 11631 11473
query79 6204 630 671 630
query80 3578 374 392 374
query81 544 245 233 233
query82 1617 104 96 96
query83 339 136 134 134
query84 258 70 72 70
query85 1667 313 314 313
query86 438 286 297 286
query87 3252 3023 3015 3015
query88 5064 2369 2339 2339
query89 351 279 279 279
query90 1654 205 213 205
query91 156 124 128 124
query92 79 51 56 51
query93 3397 576 554 554
query94 947 211 208 208
query95 1946 1932 1936 1932
query96 646 320 327 320
query97 6393 6357 6394 6357
query98 229 200 200 200
query99 3084 899 898 898
Total cold run time: 309250 ms
Total hot run time: 214735 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] [enhancement](show) Move storage policy info from show create table to show partitions (#39923) [doris]
Posted by "TangSiyang2001 (via GitHub)" <gi...@apache.org>.
TangSiyang2001 commented on PR #40823:
URL: https://github.com/apache/doris/pull/40823#issuecomment-2348941967
run feut
--
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] [enhancement](show) Move storage policy info from show create table to show partitions (#39923) [doris]
Posted by "TangSiyang2001 (via GitHub)" <gi...@apache.org>.
TangSiyang2001 commented on PR #40823:
URL: https://github.com/apache/doris/pull/40823#issuecomment-2348828496
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] [enhancement](show) Move storage policy info from show create table to show partitions (#39923) [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring merged PR #40823:
URL: https://github.com/apache/doris/pull/40823
--
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] [enhancement](show) Move storage policy info from show create table to show partitions (#39923) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40823:
URL: https://github.com/apache/doris/pull/40823#issuecomment-2349043340
<details>
<summary>ClickBench: <b>Total hot run time: 31.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 d15e325d721e87e33d06eca656aac42cbb4249d8, data reload: false
query1 0.03 0.02 0.02
query2 0.06 0.02 0.02
query3 0.25 0.05 0.05
query4 1.79 0.06 0.07
query5 0.54 0.52 0.52
query6 1.23 0.61 0.61
query7 0.02 0.01 0.02
query8 0.04 0.03 0.02
query9 0.51 0.51 0.49
query10 0.53 0.54 0.53
query11 0.12 0.09 0.09
query12 0.13 0.09 0.09
query13 0.64 0.61 0.60
query14 0.79 0.78 0.79
query15 0.79 0.76 0.76
query16 0.36 0.38 0.38
query17 1.02 1.00 0.98
query18 0.21 0.27 0.23
query19 1.86 1.86 1.80
query20 0.02 0.01 0.01
query21 15.45 0.53 0.55
query22 2.03 3.02 2.38
query23 17.18 1.02 0.90
query24 4.86 1.52 1.28
query25 0.35 0.09 0.08
query26 0.63 0.17 0.15
query27 0.04 0.04 0.03
query28 7.47 0.76 0.72
query29 12.59 2.37 2.19
query30 0.61 0.53 0.52
query31 2.80 0.38 0.37
query32 3.37 0.50 0.50
query33 3.08 3.06 3.07
query34 15.26 4.78 4.78
query35 4.84 4.84 4.87
query36 1.07 1.02 1.00
query37 0.05 0.04 0.04
query38 0.04 0.02 0.02
query39 0.02 0.02 0.01
query40 0.16 0.14 0.13
query41 0.06 0.02 0.01
query42 0.02 0.01 0.02
query43 0.02 0.02 0.02
Total cold run time: 102.94 s
Total hot run time: 31.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] [enhancement](show) Move storage policy info from show create table to show partitions (#39923) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40823:
URL: https://github.com/apache/doris/pull/40823#issuecomment-2348828403
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] [enhancement](show) Move storage policy info from show create table to show partitions (#39923) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40823:
URL: https://github.com/apache/doris/pull/40823#issuecomment-2349002253
<details>
<summary>TPC-H: <b>Total hot run time: 49074 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 d15e325d721e87e33d06eca656aac42cbb4249d8, data reload: false
------ Round 1 ----------------------------------
q1 17877 4432 4387 4387
q2 2049 159 153 153
q3 10456 1887 1914 1887
q4 10378 1292 1317 1292
q5 8389 3856 3869 3856
q6 234 120 152 120
q7 2053 1578 1594 1578
q8 9531 2721 2685 2685
q9 12883 9778 9810 9778
q10 8624 3533 3484 3484
q11 415 239 247 239
q12 462 306 293 293
q13 18353 4013 3988 3988
q14 371 333 317 317
q15 501 460 459 459
q16 535 451 455 451
q17 1123 931 961 931
q18 7218 6918 6933 6918
q19 1677 1532 1503 1503
q20 533 316 280 280
q21 4446 4104 4132 4104
q22 493 371 393 371
Total cold run time: 118601 ms
Total hot run time: 49074 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4302 4320 4309 4309
q2 324 233 223 223
q3 4143 4145 4149 4145
q4 2736 2724 2733 2724
q5 7082 7064 7124 7064
q6 238 121 118 118
q7 3268 2900 2852 2852
q8 4357 4489 4479 4479
q9 13665 13557 13611 13557
q10 4233 4261 4241 4241
q11 756 671 701 671
q12 1035 865 875 865
q13 7053 3750 3737 3737
q14 446 419 420 419
q15 501 459 447 447
q16 631 612 601 601
q17 3834 3842 3837 3837
q18 8716 8704 8904 8704
q19 1739 1680 1623 1623
q20 2333 2126 2090 2090
q21 8646 8508 8457 8457
q22 1017 881 935 881
Total cold run time: 81055 ms
Total hot run time: 76044 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] [enhancement](show) Move storage policy info from show create table to show partitions (#39923) [doris]
Posted by "TangSiyang2001 (via GitHub)" <gi...@apache.org>.
TangSiyang2001 commented on PR #40823:
URL: https://github.com/apache/doris/pull/40823#issuecomment-2356329058
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] [enhancement](show) Move storage policy info from show create table to show partitions (#39923) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40823:
URL: https://github.com/apache/doris/pull/40823#issuecomment-2356397556
<details>
<summary>TPC-DS: <b>Total hot run time: 211844 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 c12253d1a941f1aac77439f3b73e978784e5feca, data reload: false
query1 930 397 412 397
query2 6549 2229 2271 2229
query3 6920 211 210 210
query4 24005 21464 21589 21464
query5 19730 6519 6507 6507
query6 277 223 230 223
query7 4233 298 303 298
query8 246 240 234 234
query9 3022 2652 2584 2584
query10 425 386 319 319
query11 15582 15289 14826 14826
query12 127 73 77 73
query13 1014 450 438 438
query14 17487 13401 13753 13401
query15 363 226 233 226
query16 6467 289 260 260
query17 1783 930 885 885
query18 894 313 317 313
query19 210 148 151 148
query20 78 75 78 75
query21 187 94 96 94
query22 4943 5062 4893 4893
query23 34297 33397 33545 33397
query24 7745 6346 6335 6335
query25 524 435 431 431
query26 1268 163 160 160
query27 2377 295 295 295
query28 6113 2258 2219 2219
query29 3009 2779 2792 2779
query30 246 169 170 169
query31 956 744 738 738
query32 71 65 59 59
query33 449 251 260 251
query34 849 475 483 475
query35 1120 924 910 910
query36 1157 1261 1269 1261
query37 173 59 56 56
query38 3060 2924 2908 2908
query39 1383 1314 1341 1314
query40 310 93 94 93
query41 44 37 36 36
query42 103 86 84 84
query43 627 666 579 579
query44 1173 718 719 718
query45 241 233 228 228
query46 1227 969 981 969
query47 1789 1747 1601 1601
query48 506 415 409 409
query49 652 374 383 374
query50 873 644 600 600
query51 4798 4727 4587 4587
query52 94 85 88 85
query53 239 187 184 184
query54 2659 2478 2470 2470
query55 78 81 85 81
query56 239 215 206 206
query57 1154 1186 1093 1093
query58 218 210 198 198
query59 3554 3235 3129 3129
query60 220 198 199 198
query61 96 93 95 93
query62 871 522 503 503
query63 209 179 177 177
query64 3541 1601 1486 1486
query65 3630 3558 3555 3555
query66 752 417 414 414
query67 15744 15171 16092 15171
query68 9764 658 649 649
query69 504 274 275 274
query70 1548 1301 1536 1301
query71 411 289 317 289
query72 6743 4752 4874 4752
query73 759 316 322 316
query74 6337 5861 5834 5834
query75 5401 3710 3752 3710
query76 5435 1073 1090 1073
query77 945 260 257 257
query78 12629 11527 11788 11527
query79 7721 651 650 650
query80 1581 385 388 385
query81 491 244 236 236
query82 1638 98 96 96
query83 174 137 132 132
query84 251 69 70 69
query85 898 312 310 310
query86 339 290 325 290
query87 3270 2981 3023 2981
query88 4806 2394 2408 2394
query89 417 298 280 280
query90 1943 218 216 216
query91 170 123 133 123
query92 55 52 46 46
query93 6299 559 573 559
query94 714 204 213 204
query95 1970 1945 1942 1942
query96 667 339 340 339
query97 6483 6437 6375 6375
query98 241 208 210 208
query99 2976 942 852 852
Total cold run time: 319490 ms
Total hot run time: 211844 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] [enhancement](show) Move storage policy info from show create table to show partitions (#39923) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40823:
URL: https://github.com/apache/doris/pull/40823#issuecomment-2348913111
<details>
<summary>ClickBench: <b>Total hot run time: 30.69 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 d7cdfb722e3c116db526e3ce2969829674cc7a16, data reload: false
query1 0.03 0.03 0.03
query2 0.06 0.03 0.02
query3 0.26 0.05 0.06
query4 1.77 0.11 0.07
query5 0.54 0.52 0.52
query6 1.27 0.62 0.61
query7 0.02 0.01 0.01
query8 0.04 0.03 0.02
query9 0.51 0.48 0.48
query10 0.55 0.54 0.53
query11 0.13 0.09 0.08
query12 0.12 0.09 0.08
query13 0.62 0.61 0.62
query14 0.81 0.80 0.78
query15 0.77 0.77 0.78
query16 0.38 0.37 0.36
query17 1.01 1.01 0.98
query18 0.23 0.25 0.24
query19 1.88 1.86 1.84
query20 0.01 0.00 0.01
query21 15.46 0.56 0.53
query22 1.77 2.64 1.83
query23 17.24 1.31 0.88
query24 6.54 0.90 1.35
query25 0.43 0.05 0.07
query26 0.65 0.17 0.16
query27 0.04 0.05 0.03
query28 6.74 0.75 0.70
query29 12.64 2.34 2.27
query30 0.53 0.53 0.52
query31 2.82 0.39 0.37
query32 3.38 0.49 0.50
query33 3.09 3.04 3.08
query34 15.28 4.81 4.77
query35 4.87 4.82 4.84
query36 1.04 1.02 1.00
query37 0.06 0.04 0.05
query38 0.04 0.02 0.03
query39 0.02 0.01 0.02
query40 0.16 0.14 0.15
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: 103.92 s
Total hot run time: 30.69 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] [enhancement](show) Move storage policy info from show create table to show partitions (#39923) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40823:
URL: https://github.com/apache/doris/pull/40823#issuecomment-2348919949
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit d7cdfb722e3c116db526e3ce2969829674cc7a16 with default session variables
Stream load json: 20 seconds loaded 2358488459 Bytes, about 112 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: 22.1 seconds inserted 10000000 Rows, about 452K 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] [enhancement](show) Move storage policy info from show create table to show partitions (#39923) [doris]
Posted by "TangSiyang2001 (via GitHub)" <gi...@apache.org>.
TangSiyang2001 commented on PR #40823:
URL: https://github.com/apache/doris/pull/40823#issuecomment-2348948550
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] [enhancement](show) Move storage policy info from show create table to show partitions (#39923) [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #40823:
URL: https://github.com/apache/doris/pull/40823#issuecomment-2356372651
<details>
<summary>TPC-H: <b>Total hot run time: 49803 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 c12253d1a941f1aac77439f3b73e978784e5feca, data reload: false
------ Round 1 ----------------------------------
q1 17835 4430 4435 4430
q2 2093 159 147 147
q3 10322 1954 1946 1946
q4 10117 1310 1339 1310
q5 8525 4000 3983 3983
q6 236 123 126 123
q7 2073 1642 1602 1602
q8 9318 2777 2752 2752
q9 10274 9993 9930 9930
q10 8681 3580 3515 3515
q11 425 246 251 246
q12 469 304 295 295
q13 18357 4004 4016 4004
q14 348 321 332 321
q15 519 461 471 461
q16 563 455 468 455
q17 1156 961 957 957
q18 7387 6953 7051 6953
q19 1669 1577 1556 1556
q20 522 312 297 297
q21 4532 4190 4123 4123
q22 482 397 402 397
Total cold run time: 115903 ms
Total hot run time: 49803 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4313 4345 4333 4333
q2 323 236 227 227
q3 4155 4177 4146 4146
q4 2775 2754 2772 2754
q5 7229 7151 7134 7134
q6 242 117 118 117
q7 3242 2819 2803 2803
q8 4416 4506 4535 4506
q9 13789 13641 13630 13630
q10 4233 4274 4259 4259
q11 788 673 700 673
q12 1035 860 865 860
q13 7048 3748 3731 3731
q14 456 427 429 427
q15 509 471 459 459
q16 631 573 592 573
q17 3802 3957 3917 3917
q18 8917 8923 8771 8771
q19 1741 1698 1647 1647
q20 2378 2142 2125 2125
q21 8463 8464 8488 8464
q22 1071 950 891 891
Total cold run time: 81556 ms
Total hot run time: 76447 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