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/23 14:53:58 UTC
[PR] [chore](ci) change bucket to oss hongkong for cloud pipeline [doris]
hello-stephen opened a new pull request, #31353:
URL: https://github.com/apache/doris/pull/31353
## 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 oss hongkong for cloud pipeline [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31353:
URL: https://github.com/apache/doris/pull/31353#issuecomment-1961560335
<details>
<summary>ClickBench: <b>Total hot run time: 30.85 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 44c4d7ce5e9dfc928813cc7e7b9587cb890982df, data reload: false
query1 0.04 0.03 0.02
query2 0.06 0.02 0.02
query3 0.23 0.07 0.08
query4 1.65 0.08 0.08
query5 0.49 0.48 0.48
query6 1.37 0.60 0.61
query7 0.02 0.02 0.01
query8 0.04 0.02 0.03
query9 0.52 0.44 0.45
query10 0.51 0.48 0.48
query11 0.12 0.10 0.09
query12 0.12 0.10 0.10
query13 0.58 0.58 0.58
query14 0.76 0.77 0.78
query15 0.81 0.80 0.80
query16 0.33 0.32 0.33
query17 0.89 0.86 0.86
query18 0.18 0.16 0.20
query19 1.73 1.71 1.68
query20 0.02 0.01 0.02
query21 15.41 0.67 0.58
query22 2.96 2.93 2.36
query23 17.47 1.02 0.93
query24 1.99 0.58 0.37
query25 0.64 0.06 0.06
query26 0.16 0.14 0.13
query27 0.05 0.05 0.04
query28 12.07 0.84 0.82
query29 12.64 3.34 3.40
query30 0.52 0.52 0.49
query31 2.77 0.36 0.36
query32 3.36 0.47 0.47
query33 3.16 3.14 3.18
query34 15.36 4.49 4.49
query35 4.50 4.48 4.46
query36 1.07 0.93 0.98
query37 0.07 0.05 0.06
query38 0.04 0.03 0.03
query39 0.02 0.02 0.02
query40 0.17 0.14 0.15
query41 0.07 0.02 0.02
query42 0.02 0.02 0.01
query43 0.03 0.02 0.02
Total cold run time: 105.02 s
Total hot run time: 30.85 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 oss hongkong for cloud pipeline [doris]
Posted by "dataroaring (via GitHub)" <gi...@apache.org>.
dataroaring merged PR #31353:
URL: https://github.com/apache/doris/pull/31353
--
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 oss hongkong for cloud pipeline [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31353:
URL: https://github.com/apache/doris/pull/31353#issuecomment-1961475683
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 oss hongkong for cloud pipeline [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #31353:
URL: https://github.com/apache/doris/pull/31353#issuecomment-1962172730
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 oss hongkong for cloud pipeline [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #31353:
URL: https://github.com/apache/doris/pull/31353#issuecomment-1962172744
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 oss hongkong for cloud pipeline [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31353:
URL: https://github.com/apache/doris/pull/31353#issuecomment-1961551570
<details>
<summary>TPC-DS: <b>Total hot run time: 175961 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 44c4d7ce5e9dfc928813cc7e7b9587cb890982df, data reload: false
query1 926 349 350 349
query2 6505 1694 1687 1687
query3 6697 209 206 206
query4 23143 21127 20979 20979
query5 4258 382 378 378
query6 247 170 170 170
query7 4596 301 309 301
query8 252 194 201 194
query9 8451 2858 2824 2824
query10 428 242 231 231
query11 15060 14664 14447 14447
query12 144 84 84 84
query13 1693 424 419 419
query14 9033 7702 7629 7629
query15 216 182 194 182
query16 7476 252 251 251
query17 1421 544 542 542
query18 1944 272 259 259
query19 189 145 151 145
query20 87 77 84 77
query21 184 117 118 117
query22 4892 4729 4694 4694
query23 32453 31458 31404 31404
query24 12690 3406 3352 3352
query25 618 361 373 361
query26 1807 161 157 157
query27 3055 313 315 313
query28 6610 1820 1845 1820
query29 1118 614 608 608
query30 278 138 146 138
query31 962 744 762 744
query32 93 59 60 59
query33 743 221 233 221
query34 1074 499 500 499
query35 930 820 830 820
query36 957 885 906 885
query37 139 59 61 59
query38 3277 3188 3123 3123
query39 1379 1349 1305 1305
query40 287 105 107 105
query41 36 36 35 35
query42 106 100 103 100
query43 480 448 453 448
query44 1065 690 696 690
query45 205 190 175 175
query46 1049 778 771 771
query47 1620 1527 1559 1527
query48 426 342 343 342
query49 1166 331 300 300
query50 772 369 374 369
query51 4440 4350 4289 4289
query52 110 96 97 96
query53 397 303 297 297
query54 299 224 231 224
query55 86 81 78 78
query56 229 197 197 197
query57 1031 921 969 921
query58 223 198 198 198
query59 2289 2175 2318 2175
query60 234 209 227 209
query61 92 83 87 83
query62 567 354 361 354
query63 329 273 287 273
query64 6429 3051 3141 3051
query65 3290 3220 3227 3220
query66 1352 332 319 319
query67 14447 14050 14229 14050
query68 4020 565 559 559
query69 483 347 350 347
query70 1291 1228 1250 1228
query71 349 249 273 249
query72 6036 2757 2593 2593
query73 697 311 314 311
query74 6820 6452 6374 6374
query75 3157 2570 2546 2546
query76 2386 1177 1221 1177
query77 340 243 236 236
query78 9423 8784 8772 8772
query79 1069 523 505 505
query80 700 357 352 352
query81 438 206 215 206
query82 1238 86 85 85
query83 239 124 115 115
query84 223 79 78 78
query85 1204 346 350 346
query86 313 310 321 310
query87 3442 3222 3252 3222
query88 2760 2297 2316 2297
query89 435 348 362 348
query90 2159 167 166 166
query91 157 127 132 127
query92 56 47 48 47
query93 1030 524 502 502
query94 1181 175 179 175
query95 435 342 341 341
query96 564 265 265 265
query97 4521 4260 4308 4260
query98 220 212 190 190
query99 1097 703 723 703
Total cold run time: 267564 ms
Total hot run time: 175961 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 oss hongkong for cloud pipeline [doris]
Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #31353:
URL: https://github.com/apache/doris/pull/31353#issuecomment-1961475919
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 oss hongkong for cloud pipeline [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31353:
URL: https://github.com/apache/doris/pull/31353#issuecomment-1961533803
<details>
<summary>TPC-H: <b>Total hot run time: 41688 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 44c4d7ce5e9dfc928813cc7e7b9587cb890982df, data reload: false
------ Round 1 ----------------------------------
q1 18341 5246 5163 5163
q2 2777 146 141 141
q3 12657 1031 1044 1031
q4 5179 1025 1033 1025
q5 7722 3207 3218 3207
q6 194 137 140 137
q7 1272 776 769 769
q8 9260 2096 2085 2085
q9 7478 6646 6609 6609
q10 8326 2644 2629 2629
q11 420 214 221 214
q12 727 331 346 331
q13 17936 3624 3664 3624
q14 293 264 263 263
q15 629 507 504 504
q16 472 400 423 400
q17 934 856 866 856
q18 7283 6660 6603 6603
q19 1579 1506 1509 1506
q20 550 280 271 271
q21 6598 4033 3976 3976
q22 886 350 344 344
Total cold run time: 111513 ms
Total hot run time: 41688 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4894 4841 4811 4811
q2 315 187 184 184
q3 3606 3612 3618 3612
q4 2542 2537 2540 2537
q5 5765 5765 5774 5765
q6 215 126 136 126
q7 2261 1660 1657 1657
q8 3024 3060 3103 3060
q9 8698 8746 8677 8677
q10 6928 4273 4246 4246
q11 509 375 361 361
q12 786 563 553 553
q13 4236 3414 3402 3402
q14 260 247 228 228
q15 603 538 496 496
q16 481 457 441 441
q17 1692 1607 1623 1607
q18 8344 7669 7698 7669
q19 1648 1647 1652 1647
q20 2111 1859 1841 1841
q21 6707 6277 6260 6260
q22 600 495 513 495
Total cold run time: 66225 ms
Total hot run time: 59675 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 oss hongkong for cloud pipeline [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31353:
URL: https://github.com/apache/doris/pull/31353#issuecomment-1961565500
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 44c4d7ce5e9dfc928813cc7e7b9587cb890982df 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: 17.0 seconds inserted 10000000 Rows, about 588K 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