You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "wuwenchi (via GitHub)" <gi...@apache.org> on 2024/07/16 14:42:23 UTC
[PR] [bugfix](iceberg)(draft)test ase [doris]
wuwenchi opened a new pull request, #37957:
URL: https://github.com/apache/doris/pull/37957
## Proposed changes
--
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] [bugfix](iceberg)(draft)test case [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37957:
URL: https://github.com/apache/doris/pull/37957#issuecomment-2231245420
<details>
<summary>ClickBench: <b>Total hot run time: 30.83 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 4de2a6abee8d6ee0d39c705188c5ef06ece09d7b, data reload: false
query1 0.02 0.02 0.02
query2 0.07 0.02 0.02
query3 0.25 0.05 0.04
query4 1.80 0.07 0.06
query5 0.53 0.53 0.53
query6 1.23 0.63 0.72
query7 0.02 0.01 0.01
query8 0.03 0.03 0.02
query9 0.52 0.47 0.50
query10 0.53 0.52 0.53
query11 0.12 0.08 0.09
query12 0.12 0.09 0.08
query13 0.63 0.62 0.61
query14 0.77 0.78 0.78
query15 0.78 0.75 0.76
query16 0.38 0.37 0.37
query17 1.02 0.99 1.01
query18 0.23 0.26 0.24
query19 1.89 1.82 1.87
query20 0.02 0.01 0.01
query21 15.46 0.57 0.55
query22 2.42 2.54 1.51
query23 17.10 0.97 0.98
query24 4.89 1.51 1.17
query25 0.38 0.14 0.04
query26 0.58 0.16 0.16
query27 0.05 0.05 0.04
query28 7.66 0.75 0.79
query29 12.70 2.31 2.26
query30 0.61 0.58 0.53
query31 2.79 0.39 0.38
query32 3.39 0.50 0.50
query33 3.10 3.05 3.02
query34 15.26 4.81 4.82
query35 4.82 4.85 4.83
query36 1.04 1.00 1.02
query37 0.06 0.04 0.04
query38 0.03 0.03 0.02
query39 0.02 0.01 0.02
query40 0.16 0.15 0.15
query41 0.08 0.01 0.01
query42 0.02 0.01 0.02
query43 0.02 0.02 0.02
Total cold run time: 103.6 s
Total hot run time: 30.83 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] [bugfix](iceberg)(draft)test case [doris]
Posted by "wuwenchi (via GitHub)" <gi...@apache.org>.
wuwenchi closed pull request #37957: [bugfix](iceberg)(draft)test case
URL: https://github.com/apache/doris/pull/37957
--
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] [bugfix](iceberg)(draft)test case [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37957:
URL: https://github.com/apache/doris/pull/37957#issuecomment-2231231750
<details>
<summary>TPC-DS: <b>Total hot run time: 203373 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 4de2a6abee8d6ee0d39c705188c5ef06ece09d7b, data reload: false
query1 965 426 378 378
query2 6554 2803 2549 2549
query3 6922 213 210 210
query4 20295 18175 17957 17957
query5 19740 6521 6535 6521
query6 281 224 232 224
query7 4157 296 317 296
query8 455 485 442 442
query9 3077 2674 2605 2605
query10 409 315 310 310
query11 11403 10945 10871 10871
query12 127 80 73 73
query13 5606 702 666 666
query14 18078 13327 13316 13316
query15 363 239 257 239
query16 6472 289 263 263
query17 1714 1437 906 906
query18 2303 412 409 409
query19 209 154 156 154
query20 81 81 82 81
query21 190 93 99 93
query22 5327 5151 5055 5055
query23 32681 32096 31941 31941
query24 7130 6579 6504 6504
query25 529 429 425 425
query26 533 167 161 161
query27 1892 294 294 294
query28 6198 2379 2341 2341
query29 2895 2606 2704 2606
query30 247 165 167 165
query31 919 721 749 721
query32 71 62 62 62
query33 408 247 269 247
query34 840 469 488 469
query35 1121 916 957 916
query36 1292 1222 1157 1157
query37 86 58 60 58
query38 3100 2919 2949 2919
query39 1377 1311 1325 1311
query40 205 96 93 93
query41 47 45 44 44
query42 83 74 86 74
query43 700 627 658 627
query44 1109 729 735 729
query45 257 237 239 237
query46 1232 964 974 964
query47 1780 1734 1802 1734
query48 1036 718 693 693
query49 648 376 377 376
query50 874 629 598 598
query51 4779 4689 4694 4689
query52 90 83 92 83
query53 453 323 318 318
query54 2665 2465 2472 2465
query55 83 91 76 76
query56 214 227 217 217
query57 1339 1114 1164 1114
query58 224 201 202 201
query59 4241 3841 3976 3841
query60 237 215 205 205
query61 100 97 95 95
query62 847 478 473 473
query63 490 339 345 339
query64 2315 1519 1410 1410
query65 3676 3561 3622 3561
query66 800 388 379 379
query67 15474 17007 14997 14997
query68 8789 646 678 646
query69 590 369 349 349
query70 1644 1546 1302 1302
query71 421 317 344 317
query72 6482 3499 3489 3489
query73 743 322 326 322
query74 6325 5890 5920 5890
query75 4657 3807 3695 3695
query76 4865 1158 1152 1152
query77 668 253 261 253
query78 12458 11569 11678 11569
query79 8923 644 645 644
query80 1439 408 409 408
query81 504 247 232 232
query82 1708 98 97 97
query83 178 138 128 128
query84 258 72 74 72
query85 1058 328 328 328
query86 339 309 300 300
query87 3234 3015 3103 3015
query88 5192 2324 2322 2322
query89 393 302 289 289
query90 2015 198 191 191
query91 187 161 141 141
query92 58 53 61 53
query93 5654 550 590 550
query94 881 211 215 211
query95 1114 1065 1054 1054
query96 658 327 332 327
query97 6406 6426 6375 6375
query98 190 186 169 169
query99 3014 936 963 936
Total cold run time: 313090 ms
Total hot run time: 203373 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] [bugfix](iceberg)(draft)test ase [doris]
Posted by "wuwenchi (via GitHub)" <gi...@apache.org>.
wuwenchi commented on PR #37957:
URL: https://github.com/apache/doris/pull/37957#issuecomment-2231099310
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] [bugfix](iceberg)(draft)test ase [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37957:
URL: https://github.com/apache/doris/pull/37957#issuecomment-2231098977
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] [bugfix](iceberg)(draft)test case [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37957:
URL: https://github.com/apache/doris/pull/37957#issuecomment-2231193969
<details>
<summary>TPC-H: <b>Total hot run time: 49748 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 4de2a6abee8d6ee0d39c705188c5ef06ece09d7b, data reload: false
------ Round 1 ----------------------------------
q1 17783 4466 4349 4349
q2 2060 151 148 148
q3 10308 1880 1914 1880
q4 10397 1253 1356 1253
q5 8524 3917 3896 3896
q6 235 124 121 121
q7 2053 1589 1594 1589
q8 9279 2742 2696 2696
q9 10557 10354 10237 10237
q10 8677 3483 3513 3483
q11 413 256 251 251
q12 471 304 300 300
q13 18338 3997 4059 3997
q14 361 319 324 319
q15 498 455 459 455
q16 669 585 568 568
q17 1127 970 974 970
q18 7300 6999 6898 6898
q19 1764 1687 1554 1554
q20 520 307 302 302
q21 4450 4122 4044 4044
q22 538 438 469 438
Total cold run time: 116322 ms
Total hot run time: 49748 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4347 4316 4360 4316
q2 322 225 226 225
q3 4195 4172 4139 4139
q4 2768 2751 2745 2745
q5 7153 7115 7062 7062
q6 239 122 119 119
q7 3263 2841 2914 2841
q8 4306 4480 4458 4458
q9 16883 16775 16791 16775
q10 4223 4292 4272 4272
q11 755 670 693 670
q12 1028 857 863 857
q13 6944 3738 3752 3738
q14 466 429 430 429
q15 513 453 450 450
q16 738 680 669 669
q17 3859 3896 3792 3792
q18 8767 8779 8699 8699
q19 1742 1723 1651 1651
q20 2347 2103 2137 2103
q21 8597 8466 8516 8466
q22 1051 955 938 938
Total cold run time: 84506 ms
Total hot run time: 79414 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] [bugfix](iceberg)(draft)test case [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #37957:
URL: https://github.com/apache/doris/pull/37957#issuecomment-2231253340
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 4de2a6abee8d6ee0d39c705188c5ef06ece09d7b 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