You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "hello-stephen (via GitHub)" <gi...@apache.org> on 2024/02/22 07:36:50 UTC
[PR] [chore](ci) change bucket to keep track of costs [doris]
hello-stephen opened a new pull request, #31274:
URL: https://github.com/apache/doris/pull/31274
## 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] [chore](ci) change bucket to keep track of costs [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #31274:
URL: https://github.com/apache/doris/pull/31274#issuecomment-1959079733
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] [chore](ci) change bucket to keep track of costs [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31274:
URL: https://github.com/apache/doris/pull/31274#issuecomment-1958890583
<details>
<summary>TPC-H: <b>Total hot run time: 41085 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 d1b6f62656bd25197ffa982c50fd27649d91956a, data reload: false
------ Round 1 ----------------------------------
q1 17638 5012 4880 4880
q2 2047 148 131 131
q3 10576 991 987 987
q4 4649 972 969 969
q5 7653 3151 3175 3151
q6 195 131 131 131
q7 1265 798 767 767
q8 9226 2084 2051 2051
q9 7508 6663 6638 6638
q10 8321 2673 2621 2621
q11 409 217 215 215
q12 763 332 331 331
q13 17937 3597 3608 3597
q14 291 269 278 269
q15 624 507 509 507
q16 476 413 432 413
q17 925 847 841 841
q18 7361 6670 6590 6590
q19 1551 1486 1492 1486
q20 476 270 272 270
q21 5869 3923 4022 3923
q22 397 336 317 317
Total cold run time: 106157 ms
Total hot run time: 41085 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4889 4863 4870 4863
q2 296 187 182 182
q3 3604 3581 3570 3570
q4 2510 2500 2523 2500
q5 5792 5837 5905 5837
q6 208 126 125 125
q7 2260 1659 1667 1659
q8 3018 3101 3112 3101
q9 8779 8736 8728 8728
q10 4134 4241 4258 4241
q11 501 396 361 361
q12 775 531 537 531
q13 4175 3421 3415 3415
q14 255 240 247 240
q15 592 496 498 496
q16 487 431 446 431
q17 1665 1605 1594 1594
q18 8244 7558 7709 7558
q19 1635 1629 1633 1629
q20 2119 1814 1859 1814
q21 6570 6201 6171 6171
q22 574 509 501 501
Total cold run time: 63082 ms
Total hot run time: 59547 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] [chore](ci) change bucket to keep track of costs [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31274:
URL: https://github.com/apache/doris/pull/31274#issuecomment-1958905405
<details>
<summary>TPC-DS: <b>Total hot run time: 176745 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 d1b6f62656bd25197ffa982c50fd27649d91956a, data reload: false
query1 926 347 351 347
query2 6496 1704 1740 1704
query3 6692 212 204 204
query4 23165 21077 21103 21077
query5 4271 380 373 373
query6 256 167 163 163
query7 4639 294 302 294
query8 242 193 200 193
query9 8426 2813 2836 2813
query10 407 222 225 222
query11 15016 14570 14512 14512
query12 128 85 81 81
query13 1675 422 434 422
query14 8919 7574 7633 7574
query15 215 183 190 183
query16 7108 249 257 249
query17 1399 554 526 526
query18 2094 264 274 264
query19 204 145 148 145
query20 85 82 86 82
query21 185 121 123 121
query22 5067 4883 4754 4754
query23 32543 31545 31445 31445
query24 12736 3487 3398 3398
query25 661 362 357 357
query26 1872 159 160 159
query27 3033 320 332 320
query28 6638 1861 1854 1854
query29 1198 624 622 622
query30 280 144 150 144
query31 962 745 754 745
query32 101 58 59 58
query33 712 236 221 221
query34 1113 503 500 500
query35 952 830 826 826
query36 970 890 884 884
query37 177 64 67 64
query38 3327 3203 3246 3203
query39 1379 1315 1325 1315
query40 285 106 104 104
query41 37 35 36 35
query42 106 104 97 97
query43 471 439 453 439
query44 1067 684 704 684
query45 195 179 178 178
query46 1062 801 779 779
query47 1623 1547 1535 1535
query48 416 338 355 338
query49 1245 318 311 311
query50 774 382 381 381
query51 4399 4329 4302 4302
query52 111 96 93 93
query53 406 297 299 297
query54 301 219 229 219
query55 81 79 85 79
query56 229 196 202 196
query57 1083 931 947 931
query58 208 201 204 201
query59 2219 2072 2096 2072
query60 259 215 207 207
query61 82 80 87 80
query62 595 373 376 373
query63 337 283 289 283
query64 6489 3062 3122 3062
query65 3304 3281 3243 3243
query66 1403 336 324 324
query67 14806 14418 14524 14418
query68 5074 559 548 548
query69 516 352 351 351
query70 1255 1190 1199 1190
query71 380 251 252 251
query72 6533 2742 2623 2623
query73 704 310 309 309
query74 6924 6381 6444 6381
query75 3237 2581 2561 2561
query76 3257 1156 1206 1156
query77 356 242 232 232
query78 9621 8672 8825 8672
query79 968 514 533 514
query80 519 367 348 348
query81 405 207 207 207
query82 162 86 84 84
query83 139 126 120 120
query84 223 77 76 76
query85 752 351 335 335
query86 302 323 304 304
query87 3533 3364 3360 3360
query88 2756 2287 2320 2287
query89 440 366 351 351
query90 1926 166 165 165
query91 159 125 126 125
query92 58 50 47 47
query93 1025 526 504 504
query94 851 182 175 175
query95 436 336 352 336
query96 585 266 264 264
query97 4449 4322 4258 4258
query98 217 200 189 189
query99 1098 764 743 743
Total cold run time: 268722 ms
Total hot run time: 176745 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] [chore](ci) change bucket to keep track of costs [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #31274:
URL: https://github.com/apache/doris/pull/31274#issuecomment-1958864342
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] [chore](ci) change bucket to keep track of costs [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #31274:
URL: https://github.com/apache/doris/pull/31274#issuecomment-1959079799
PR approved by anyone and no changes requested.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [chore](ci) change bucket to keep track of costs [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31274:
URL: https://github.com/apache/doris/pull/31274#issuecomment-1958864173
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
Re: [PR] [chore](ci) change bucket to keep track of costs [doris]
Posted by "yiguolei (via GitHub)" <gi...@apache.org>.
yiguolei merged PR #31274:
URL: https://github.com/apache/doris/pull/31274
--
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] [chore](ci) change bucket to keep track of costs [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31274:
URL: https://github.com/apache/doris/pull/31274#issuecomment-1958916050
<details>
<summary>ClickBench: <b>Total hot run time: 31.16 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 d1b6f62656bd25197ffa982c50fd27649d91956a, data reload: false
query1 0.03 0.02 0.02
query2 0.06 0.03 0.02
query3 0.24 0.07 0.07
query4 1.65 0.08 0.08
query5 0.49 0.48 0.48
query6 1.40 0.65 0.60
query7 0.02 0.02 0.01
query8 0.04 0.02 0.02
query9 0.52 0.43 0.46
query10 0.48 0.48 0.48
query11 0.12 0.10 0.09
query12 0.12 0.10 0.10
query13 0.59 0.59 0.58
query14 0.76 0.79 0.77
query15 0.82 0.80 0.79
query16 0.32 0.33 0.35
query17 0.90 0.92 0.91
query18 0.17 0.18 0.17
query19 1.75 1.70 1.69
query20 0.01 0.01 0.02
query21 15.41 0.61 0.61
query22 3.95 3.78 2.91
query23 17.76 1.03 0.96
query24 1.99 0.37 0.12
query25 0.53 0.06 0.05
query26 0.15 0.13 0.13
query27 0.05 0.06 0.05
query28 12.60 0.80 0.81
query29 12.60 3.32 3.35
query30 0.51 0.48 0.46
query31 2.77 0.35 0.35
query32 3.38 0.47 0.47
query33 3.13 3.11 3.16
query34 15.34 4.47 4.50
query35 4.46 4.48 4.49
query36 1.07 0.96 0.94
query37 0.07 0.05 0.06
query38 0.05 0.03 0.03
query39 0.02 0.02 0.01
query40 0.17 0.14 0.16
query41 0.07 0.01 0.02
query42 0.02 0.02 0.02
query43 0.02 0.02 0.02
Total cold run time: 106.61 s
Total hot run time: 31.16 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] [chore](ci) change bucket to keep track of costs [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31274:
URL: https://github.com/apache/doris/pull/31274#issuecomment-1958921603
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit d1b6f62656bd25197ffa982c50fd27649d91956a with default session variables
Stream load json: 20 seconds loaded 2358488459 Bytes, about 112 MB/s
Stream load orc: 60 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet: 32 seconds loaded 861443392 Bytes, about 25 MB/s
Insert into select: 13.1 seconds inserted 10000000 Rows, about 763K 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