You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "morrySnow (via GitHub)" <gi...@apache.org> on 2024/06/04 11:52:20 UTC
[PR] [fix](Nereids) add one arg truncate [doris]
morrySnow opened a new pull request, #35876:
URL: https://github.com/apache/doris/pull/35876
pick from #29864
--
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] [fix](Nereids) add one arg truncate [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35876:
URL: https://github.com/apache/doris/pull/35876#issuecomment-2147419347
<details>
<summary>ClickBench: <b>Total hot run time: 30.84 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 ca349ef3e1cd0fcec5c03049e32e78211bbc7217, data reload: false
query1 0.02 0.01 0.02
query2 0.07 0.02 0.03
query3 0.25 0.05 0.05
query4 1.79 0.07 0.07
query5 0.55 0.52 0.52
query6 1.23 0.62 0.61
query7 0.01 0.01 0.01
query8 0.03 0.02 0.02
query9 0.52 0.49 0.49
query10 0.54 0.53 0.53
query11 0.12 0.09 0.08
query12 0.12 0.09 0.09
query13 0.62 0.61 0.62
query14 0.77 0.78 0.78
query15 0.79 0.77 0.76
query16 0.35 0.37 0.38
query17 1.00 1.01 1.00
query18 0.23 0.23 0.23
query19 1.86 1.86 1.77
query20 0.01 0.01 0.00
query21 15.46 0.57 0.56
query22 2.35 2.69 1.54
query23 17.24 1.05 0.96
query24 4.68 1.06 1.25
query25 0.42 0.09 0.06
query26 0.58 0.16 0.17
query27 0.04 0.04 0.03
query28 8.09 0.79 0.71
query29 12.68 2.39 2.36
query30 0.55 0.48 0.53
query31 2.80 0.39 0.38
query32 3.38 0.49 0.50
query33 3.09 3.07 3.13
query34 15.26 4.82 4.81
query35 4.88 4.88 4.89
query36 1.04 1.03 1.02
query37 0.06 0.04 0.04
query38 0.04 0.02 0.02
query39 0.02 0.01 0.02
query40 0.16 0.15 0.15
query41 0.07 0.02 0.01
query42 0.02 0.01 0.01
query43 0.03 0.01 0.02
Total cold run time: 103.82 s
Total hot run time: 30.84 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] [fix](Nereids) add one arg truncate [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35876:
URL: https://github.com/apache/doris/pull/35876#issuecomment-2147425778
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit ca349ef3e1cd0fcec5c03049e32e78211bbc7217 with default session variables
Stream load json: 20 seconds loaded 2358488459 Bytes, about 112 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: 21.4 seconds inserted 10000000 Rows, about 467K 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] [fix](Nereids) add one arg truncate [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow commented on PR #35876:
URL: https://github.com/apache/doris/pull/35876#issuecomment-2147339709
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] [fix](Nereids) add one arg truncate [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35876:
URL: https://github.com/apache/doris/pull/35876#issuecomment-2147339635
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] [fix](Nereids) add one arg truncate [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35876:
URL: https://github.com/apache/doris/pull/35876#issuecomment-2147408414
<details>
<summary>TPC-DS: <b>Total hot run time: 203581 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 ca349ef3e1cd0fcec5c03049e32e78211bbc7217, data reload: false
query1 939 426 377 377
query2 6537 2731 2686 2686
query3 6920 214 216 214
query4 20373 17954 17982 17954
query5 19748 6475 6508 6475
query6 282 219 221 219
query7 4163 295 310 295
query8 266 265 246 246
query9 3139 2722 2630 2630
query10 414 315 293 293
query11 11361 10720 10792 10720
query12 128 75 76 75
query13 5589 666 695 666
query14 18002 13698 13569 13569
query15 363 219 228 219
query16 6461 302 266 266
query17 1707 1449 862 862
query18 2327 414 410 410
query19 200 153 150 150
query20 82 76 85 76
query21 191 98 98 98
query22 5311 5030 5189 5030
query23 32402 31713 31840 31713
query24 7049 6565 6552 6552
query25 502 430 409 409
query26 532 161 162 161
query27 1882 300 295 295
query28 6127 2349 2304 2304
query29 2965 2832 2659 2659
query30 239 166 165 165
query31 904 763 711 711
query32 68 68 63 63
query33 404 254 256 254
query34 829 456 476 456
query35 1130 981 974 974
query36 1286 1234 1124 1124
query37 89 62 63 62
query38 3110 2922 2918 2918
query39 1372 1341 1308 1308
query40 215 97 91 91
query41 40 36 37 36
query42 80 83 79 79
query43 668 801 690 690
query44 1126 710 727 710
query45 244 230 231 230
query46 1229 969 977 969
query47 1953 1828 1632 1632
query48 982 710 713 710
query49 605 371 383 371
query50 866 611 604 604
query51 4748 4708 4647 4647
query52 84 81 78 78
query53 441 311 320 311
query54 2641 2464 2446 2446
query55 81 79 82 79
query56 244 192 214 192
query57 1157 1121 1124 1121
query58 220 203 204 203
query59 4232 3791 3935 3791
query60 219 199 202 199
query61 98 93 94 93
query62 824 514 521 514
query63 482 337 337 337
query64 2579 1542 1507 1507
query65 3642 3558 3546 3546
query66 763 371 388 371
query67 16026 15786 15181 15181
query68 8767 635 644 635
query69 587 359 348 348
query70 1564 1440 1431 1431
query71 420 320 329 320
query72 6509 3466 3485 3466
query73 734 328 319 319
query74 6300 5924 5914 5914
query75 5249 3733 3683 3683
query76 5362 1169 1190 1169
query77 910 269 256 256
query78 12815 11805 12748 11805
query79 11291 642 656 642
query80 1156 397 396 396
query81 489 237 236 236
query82 1450 97 98 97
query83 168 132 131 131
query84 259 71 72 71
query85 893 327 322 322
query86 330 295 279 279
query87 3219 3015 3048 3015
query88 5278 2341 2339 2339
query89 475 295 267 267
query90 1944 211 215 211
query91 171 140 140 140
query92 59 53 53 53
query93 6348 607 570 570
query94 717 213 216 213
query95 1091 1052 1076 1052
query96 646 329 337 329
query97 6569 6380 6370 6370
query98 196 178 175 175
query99 2891 949 931 931
Total cold run time: 316739 ms
Total hot run time: 203581 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] [fix](Nereids) add one arg truncate [doris]
Posted by "morrySnow (via GitHub)" <gi...@apache.org>.
morrySnow merged PR #35876:
URL: https://github.com/apache/doris/pull/35876
--
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] [fix](Nereids) add one arg truncate [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #35876:
URL: https://github.com/apache/doris/pull/35876#issuecomment-2147382943
<details>
<summary>TPC-H: <b>Total hot run time: 50042 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 ca349ef3e1cd0fcec5c03049e32e78211bbc7217, data reload: false
------ Round 1 ----------------------------------
q1 17552 4369 4309 4309
q2 2083 165 151 151
q3 10300 1885 1935 1885
q4 10351 1274 1351 1274
q5 8453 3935 3913 3913
q6 230 127 127 127
q7 2054 1614 1587 1587
q8 9558 2719 2734 2719
q9 13972 10956 10581 10581
q10 8656 3561 3500 3500
q11 416 245 241 241
q12 464 295 302 295
q13 18377 3949 4068 3949
q14 357 333 323 323
q15 511 459 457 457
q16 673 568 584 568
q17 1127 934 902 902
q18 7261 6903 6943 6903
q19 1716 1553 1539 1539
q20 549 301 301 301
q21 4353 4121 4121 4121
q22 509 397 397 397
Total cold run time: 119522 ms
Total hot run time: 50042 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4336 4270 4314 4270
q2 320 227 224 224
q3 4189 4161 4136 4136
q4 2766 2734 2742 2734
q5 7212 7090 7105 7090
q6 238 119 121 119
q7 3272 2808 2805 2805
q8 4335 4485 4506 4485
q9 17404 17098 17225 17098
q10 4221 4274 4242 4242
q11 761 708 690 690
q12 1039 865 874 865
q13 6993 3745 3755 3745
q14 448 424 427 424
q15 498 446 456 446
q16 731 687 687 687
q17 3865 3839 3804 3804
q18 8791 8748 8708 8708
q19 1735 1690 1692 1690
q20 2373 2160 2133 2133
q21 8494 8532 8492 8492
q22 1040 915 935 915
Total cold run time: 85061 ms
Total hot run time: 79802 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