You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "HappenLee (via GitHub)" <gi...@apache.org> on 2024/02/05 09:52:33 UTC
[PR] opt the rf code and remove rf unless code [doris]
HappenLee opened a new pull request, #30861:
URL: https://github.com/apache/doris/pull/30861
## 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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1927350732
<details>
<summary>ClickBench: <b>Total hot run time: 30.67 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 d8a93af361cbbe37c635736262c9d230d25c080c, data reload: false
query1 0.03 0.03 0.03
query2 0.06 0.02 0.02
query3 0.22 0.06 0.06
query4 1.68 0.09 0.10
query5 0.53 0.51 0.51
query6 1.26 0.64 0.62
query7 0.02 0.01 0.01
query8 0.04 0.02 0.02
query9 0.53 0.50 0.51
query10 0.56 0.54 0.56
query11 0.12 0.09 0.09
query12 0.11 0.09 0.09
query13 0.62 0.61 0.60
query14 0.77 0.80 0.79
query15 0.81 0.78 0.78
query16 0.39 0.38 0.38
query17 1.01 1.00 1.03
query18 0.25 0.22 0.25
query19 1.90 1.82 1.81
query20 0.02 0.01 0.01
query21 15.42 0.58 0.56
query22 2.97 2.37 1.74
query23 17.21 0.83 0.93
query24 2.50 1.53 0.71
query25 0.32 0.26 0.04
query26 0.65 0.13 0.13
query27 0.05 0.05 0.04
query28 12.17 0.84 0.82
query29 12.52 3.19 3.22
query30 0.57 0.53 0.53
query31 2.78 0.34 0.35
query32 3.36 0.48 0.47
query33 3.24 3.18 3.20
query34 15.81 4.36 4.30
query35 4.38 4.30 4.31
query36 1.12 1.06 1.06
query37 0.07 0.05 0.05
query38 0.04 0.03 0.03
query39 0.02 0.01 0.02
query40 0.19 0.13 0.12
query41 0.08 0.02 0.02
query42 0.02 0.02 0.01
query43 0.03 0.02 0.02
Total cold run time: 106.45 s
Total hot run time: 30.67 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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1927341109
TeamCity be ut coverage result:
Function Coverage: 36.18% (8627/23843)
Line Coverage: 28.21% (70549/250123)
Region Coverage: 27.22% (36419/133792)
Branch Coverage: 24.00% (18654/77716)
Coverage Report: http://coverage.selectdb-in.cc/coverage/d8a93af361cbbe37c635736262c9d230d25c080c_d8a93af361cbbe37c635736262c9d230d25c080c/report/index.html
--
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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1931747685
<details>
<summary>TPC-DS: <b>Total hot run time: 173569 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 910fdc9e3eb09006dc3225629e871ffaf108a79d, data reload: false
query1 929 338 340 338
query2 6552 1961 1955 1955
query3 6704 207 203 203
query4 31607 21928 22041 21928
query5 4240 365 361 361
query6 260 170 163 163
query7 4605 285 279 279
query8 236 185 185 185
query9 9177 2281 2232 2232
query10 416 222 223 222
query11 17678 15309 15319 15309
query12 135 79 76 76
query13 1610 423 418 418
query14 9457 6825 6690 6690
query15 229 178 184 178
query16 8156 257 263 257
query17 1859 538 503 503
query18 2107 275 257 257
query19 366 146 141 141
query20 81 77 77 77
query21 194 122 129 122
query22 4800 4702 4636 4636
query23 30889 29985 30009 29985
query24 6588 2756 2768 2756
query25 543 346 339 339
query26 705 148 147 147
query27 2123 308 309 308
query28 4618 1817 1818 1817
query29 869 611 601 601
query30 284 135 141 135
query31 920 691 708 691
query32 91 55 54 54
query33 457 223 214 214
query34 817 468 462 462
query35 850 777 742 742
query36 1060 921 911 911
query37 98 59 57 57
query38 3279 3100 3088 3088
query39 1302 1261 1251 1251
query40 183 95 93 93
query41 39 36 34 34
query42 99 93 90 90
query43 506 466 481 466
query44 1025 684 694 684
query45 195 177 173 173
query46 1060 649 658 649
query47 1629 1427 1504 1427
query48 444 353 356 353
query49 1055 296 292 292
query50 767 377 391 377
query51 5280 5168 5080 5080
query52 93 88 90 88
query53 344 284 261 261
query54 256 215 221 215
query55 83 79 76 76
query56 223 201 194 194
query57 982 906 855 855
query58 202 184 191 184
query59 2338 2228 2343 2228
query60 250 226 214 214
query61 86 85 84 84
query62 607 331 349 331
query63 295 271 265 265
query64 4628 3685 3414 3414
query65 3287 3214 3217 3214
query66 805 350 304 304
query67 14233 14049 13924 13924
query68 5507 537 549 537
query69 503 320 317 317
query70 1308 1190 1223 1190
query71 346 248 257 248
query72 6220 2830 2679 2679
query73 707 331 332 331
query74 6651 6323 6177 6177
query75 3047 2387 2298 2298
query76 3033 916 908 908
query77 364 230 225 225
query78 9219 8796 8539 8539
query79 3934 489 494 489
query80 1711 342 358 342
query81 711 197 201 197
query82 1467 84 81 81
query83 247 130 122 122
query84 278 88 75 75
query85 1905 325 327 325
query86 501 289 296 289
query87 3353 3189 3164 3164
query88 4550 2373 2376 2373
query89 443 385 380 380
query90 1963 165 167 165
query91 150 123 121 121
query92 58 46 44 44
query93 5746 513 500 500
query94 1170 173 173 173
query95 7967 356 7760 356
query96 623 276 270 270
query97 4245 4142 4142 4142
query98 220 206 191 191
query99 1164 664 707 664
Total cold run time: 287196 ms
Total hot run time: 173569 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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1933004355
<details>
<summary>TPC-H: <b>Total hot run time: 41576 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 02922fd30e7eb56660bd5c5a2f764c28270f0469, data reload: false
------ Round 1 ----------------------------------
q1 17621 4997 4885 4885
q2 2051 145 134 134
q3 10612 1054 1001 1001
q4 4738 970 985 970
q5 7704 3276 3286 3276
q6 196 135 129 129
q7 1295 782 777 777
q8 9346 2088 2090 2088
q9 7584 6738 6701 6701
q10 8325 2666 2638 2638
q11 419 221 218 218
q12 793 326 327 326
q13 18005 3703 3723 3703
q14 292 260 259 259
q15 620 511 523 511
q16 487 413 415 413
q17 931 855 865 855
q18 7538 6763 6606 6606
q19 1536 1493 1499 1493
q20 616 325 338 325
q21 6527 3936 3984 3936
q22 879 349 332 332
Total cold run time: 108115 ms
Total hot run time: 41576 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4865 4854 4839 4839
q2 295 188 183 183
q3 3597 3589 3560 3560
q4 2524 2525 2525 2525
q5 5770 5747 5760 5747
q6 207 126 126 126
q7 2245 1673 1662 1662
q8 3044 3141 3135 3135
q9 8738 8763 8750 8750
q10 6793 4251 4241 4241
q11 527 378 369 369
q12 772 545 551 545
q13 4233 3407 3370 3370
q14 268 229 247 229
q15 630 504 508 504
q16 478 425 428 425
q17 1692 1623 1610 1610
q18 8340 7817 7561 7561
q19 1641 1639 1642 1639
q20 2116 1843 1833 1833
q21 6622 6210 6203 6203
q22 568 519 495 495
Total cold run time: 65965 ms
Total hot run time: 59551 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] opt the rf code and remove rf unless code [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1926631513
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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1926596211
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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1927916149
<details>
<summary>ClickBench: <b>Total hot run time: 30.49 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 e616552029f30518b3f89ade4ea527698a40ef65, data reload: false
query1 0.03 0.03 0.03
query2 0.05 0.02 0.02
query3 0.22 0.06 0.06
query4 1.67 0.10 0.11
query5 0.53 0.52 0.52
query6 1.20 0.67 0.69
query7 0.02 0.02 0.01
query8 0.04 0.02 0.02
query9 0.54 0.48 0.50
query10 0.56 0.57 0.56
query11 0.11 0.09 0.08
query12 0.11 0.09 0.10
query13 0.60 0.59 0.59
query14 0.80 0.80 0.80
query15 0.78 0.77 0.78
query16 0.38 0.37 0.39
query17 1.06 0.98 1.02
query18 0.22 0.28 0.24
query19 1.79 1.78 1.69
query20 0.02 0.01 0.01
query21 15.40 0.58 0.59
query22 2.52 1.81 1.80
query23 17.49 0.91 0.77
query24 2.40 1.16 0.45
query25 0.35 0.22 0.20
query26 0.47 0.13 0.12
query27 0.06 0.05 0.05
query28 11.57 0.84 0.82
query29 12.59 3.27 3.34
query30 0.60 0.54 0.53
query31 2.78 0.35 0.37
query32 3.35 0.48 0.47
query33 3.23 3.17 3.24
query34 15.94 4.26 4.29
query35 4.33 4.25 4.25
query36 1.10 1.06 1.06
query37 0.06 0.05 0.05
query38 0.04 0.03 0.03
query39 0.02 0.01 0.02
query40 0.16 0.13 0.13
query41 0.07 0.02 0.01
query42 0.02 0.01 0.01
query43 0.02 0.02 0.01
Total cold run time: 105.3 s
Total hot run time: 30.49 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] opt the rf code and remove rf unless code [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1926631450
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] opt the rf code and remove rf unless code [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1931224354
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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1927357168
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit d8a93af361cbbe37c635736262c9d230d25c080c 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: 13.6 seconds inserted 10000000 Rows, about 735K 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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1931761922
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 910fdc9e3eb09006dc3225629e871ffaf108a79d with default session variables
Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 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: 13.6 seconds inserted 10000000 Rows, about 735K 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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1931756823
<details>
<summary>ClickBench: <b>Total hot run time: 30.86 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 910fdc9e3eb09006dc3225629e871ffaf108a79d, data reload: false
query1 0.04 0.03 0.03
query2 0.05 0.02 0.02
query3 0.23 0.06 0.06
query4 1.68 0.10 0.10
query5 0.53 0.51 0.52
query6 1.19 0.65 0.63
query7 0.02 0.01 0.01
query8 0.03 0.02 0.02
query9 0.55 0.50 0.51
query10 0.56 0.56 0.57
query11 0.11 0.09 0.08
query12 0.12 0.09 0.09
query13 0.60 0.61 0.61
query14 0.80 0.80 0.80
query15 0.79 0.78 0.78
query16 0.39 0.38 0.39
query17 1.02 1.01 1.01
query18 0.23 0.25 0.25
query19 1.87 1.76 1.78
query20 0.01 0.01 0.01
query21 15.43 0.57 0.56
query22 2.51 2.44 1.73
query23 17.43 0.89 0.82
query24 2.45 0.87 0.86
query25 0.39 0.34 0.06
query26 0.38 0.14 0.14
query27 0.05 0.05 0.04
query28 11.99 0.83 0.87
query29 12.55 3.22 3.24
query30 0.63 0.48 0.53
query31 2.79 0.35 0.34
query32 3.36 0.48 0.50
query33 3.22 3.21 3.22
query34 15.76 4.30 4.32
query35 4.32 4.28 4.27
query36 1.11 1.05 1.06
query37 0.07 0.05 0.05
query38 0.03 0.03 0.03
query39 0.02 0.02 0.01
query40 0.15 0.13 0.14
query41 0.07 0.01 0.02
query42 0.02 0.02 0.01
query43 0.02 0.02 0.02
Total cold run time: 105.57 s
Total hot run time: 30.86 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] opt the rf code and remove rf unless code [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1931655114
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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1933028538
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 02922fd30e7eb56660bd5c5a2f764c28270f0469 with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc: 60 seconds loaded 1101869774 Bytes, about 17 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 13.5 seconds inserted 10000000 Rows, about 740K 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] opt the rf code and remove rf unless code [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1933143158
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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1928709815
<details>
<summary>TPC-H: <b>Total hot run time: 37187 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 f976c3369fbcc13617fe295a12b56a308f548058, data reload: false
------ Round 1 ----------------------------------
q1 17649 4835 4464 4464
q2 2049 146 135 135
q3 10669 940 908 908
q4 4689 775 701 701
q5 7696 2856 2830 2830
q6 184 120 120 120
q7 1180 743 742 742
q8 9283 2039 2043 2039
q9 7268 6329 6355 6329
q10 8127 2455 2427 2427
q11 417 199 204 199
q12 792 278 285 278
q13 18010 3301 3331 3301
q14 282 256 249 249
q15 539 503 488 488
q16 473 410 400 400
q17 935 537 533 533
q18 6812 6025 5914 5914
q19 1567 1388 1390 1388
q20 620 339 351 339
q21 6820 3134 3111 3111
q22 800 315 292 292
Total cold run time: 106861 ms
Total hot run time: 37187 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4452 4393 4370 4370
q2 332 241 231 231
q3 3024 2824 2826 2824
q4 1830 1603 1661 1603
q5 5151 5273 5266 5266
q6 190 114 126 114
q7 2174 1815 1802 1802
q8 3122 3248 3216 3216
q9 8411 8381 8269 8269
q10 5830 3510 3509 3509
q11 527 469 478 469
q12 728 564 557 557
q13 11902 3078 3053 3053
q14 289 260 263 260
q15 540 502 495 495
q16 523 477 460 460
q17 1836 1694 1658 1658
q18 8000 7755 7644 7644
q19 8433 1534 1483 1483
q20 2129 1920 1906 1906
q21 4846 4560 4576 4560
q22 555 462 475 462
Total cold run time: 74824 ms
Total hot run time: 54211 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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1928722779
<details>
<summary>ClickBench: <b>Total hot run time: 29.96 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 f976c3369fbcc13617fe295a12b56a308f548058, data reload: false
query1 0.04 0.03 0.03
query2 0.06 0.02 0.03
query3 0.23 0.06 0.06
query4 1.67 0.10 0.10
query5 0.53 0.52 0.52
query6 1.19 0.67 0.65
query7 0.02 0.01 0.01
query8 0.04 0.03 0.03
query9 0.56 0.51 0.49
query10 0.57 0.56 0.55
query11 0.11 0.08 0.09
query12 0.11 0.09 0.09
query13 0.60 0.62 0.61
query14 0.80 0.78 0.80
query15 0.80 0.76 0.78
query16 0.39 0.36 0.38
query17 1.03 1.06 0.98
query18 0.23 0.25 0.24
query19 1.81 1.73 1.72
query20 0.01 0.01 0.01
query21 15.40 0.58 0.55
query22 2.70 2.41 1.68
query23 17.20 0.94 0.71
query24 2.33 1.80 0.44
query25 0.35 0.05 0.28
query26 0.52 0.13 0.14
query27 0.05 0.06 0.04
query28 11.55 0.85 0.84
query29 12.53 3.08 3.08
query30 0.62 0.53 0.49
query31 2.78 0.36 0.35
query32 3.36 0.48 0.48
query33 3.22 3.18 3.26
query34 15.73 4.31 4.27
query35 4.29 4.29 4.26
query36 1.11 1.06 1.05
query37 0.07 0.05 0.05
query38 0.04 0.03 0.03
query39 0.03 0.02 0.01
query40 0.17 0.13 0.13
query41 0.07 0.01 0.02
query42 0.03 0.02 0.02
query43 0.03 0.02 0.02
Total cold run time: 104.98 s
Total hot run time: 29.96 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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1931722899
TeamCity be ut coverage result:
Function Coverage: 36.17% (8637/23880)
Line Coverage: 28.20% (70622/250466)
Region Coverage: 27.18% (36437/134038)
Branch Coverage: 23.97% (18660/77850)
Coverage Report: http://coverage.selectdb-in.cc/coverage/910fdc9e3eb09006dc3225629e871ffaf108a79d_910fdc9e3eb09006dc3225629e871ffaf108a79d/report/index.html
--
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] opt the rf code and remove rf unless code [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1926616155
clang-tidy review says "All clean, LGTM! :+1:"
--
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] opt the rf code and remove rf unless code [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on code in PR #30861:
URL: https://github.com/apache/doris/pull/30861#discussion_r1478338263
##########
be/src/exprs/runtime_filter_slots.h:
##########
@@ -48,11 +48,11 @@ class VRuntimeFilterSlots {
std::map<int, bool> has_in_filter;
auto ignore_local_filter = [&](int filter_id) {
- if (_is_global) {
- return Status::OK();
- }
+ auto runtime_filter_mgr = _is_global ? state->get_query_ctx()->runtime_filter_mgr()
Review Comment:
warning: 'auto runtime_filter_mgr' can be declared as 'auto *runtime_filter_mgr' [readability-qualified-auto]
```suggestion
auto *runtime_filter_mgr = _is_global ? state->get_query_ctx()->runtime_filter_mgr()
```
--
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] opt the rf code and remove rf unless code [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1927253250
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] opt the rf code and remove rf unless code [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1926619088
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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1933024708
<details>
<summary>ClickBench: <b>Total hot run time: 31.49 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 02922fd30e7eb56660bd5c5a2f764c28270f0469, data reload: false
query1 0.04 0.03 0.02
query2 0.06 0.03 0.02
query3 0.24 0.08 0.08
query4 1.63 0.11 0.10
query5 0.48 0.48 0.48
query6 1.34 0.61 0.62
query7 0.02 0.01 0.01
query8 0.04 0.02 0.02
query9 0.52 0.45 0.44
query10 0.48 0.49 0.51
query11 0.13 0.10 0.10
query12 0.12 0.09 0.10
query13 0.59 0.60 0.59
query14 0.76 0.80 0.79
query15 0.81 0.81 0.79
query16 0.32 0.33 0.34
query17 0.90 0.91 0.90
query18 0.19 0.18 0.17
query19 1.74 1.63 1.65
query20 0.02 0.01 0.01
query21 15.42 0.67 0.59
query22 2.77 4.23 2.81
query23 17.50 1.08 0.98
query24 2.04 0.71 0.36
query25 0.62 0.08 0.05
query26 0.17 0.14 0.14
query27 0.06 0.05 0.06
query28 11.80 0.84 0.83
query29 12.53 3.42 3.37
query30 0.52 0.49 0.49
query31 2.77 0.36 0.37
query32 3.33 0.47 0.47
query33 3.13 3.11 3.16
query34 15.36 4.50 4.49
query35 4.51 4.53 4.51
query36 1.07 0.94 0.96
query37 0.07 0.05 0.06
query38 0.04 0.03 0.03
query39 0.02 0.01 0.02
query40 0.18 0.14 0.14
query41 0.08 0.02 0.01
query42 0.02 0.02 0.01
query43 0.02 0.02 0.02
Total cold run time: 104.46 s
Total hot run time: 31.49 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] opt the rf code and remove rf unless code [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on code in PR #30861:
URL: https://github.com/apache/doris/pull/30861#discussion_r1481209829
##########
be/src/exprs/runtime_filter_slots.h:
##########
@@ -48,11 +48,14 @@ class VRuntimeFilterSlots {
std::map<int, bool> has_in_filter;
auto ignore_local_filter = [&](int filter_id) {
+ // Now pipeline x have bug in ignore, after fix the problem enable ignore logic in pipeline x
if (_is_global) {
return Status::OK();
}
+ auto runtime_filter_mgr = state->runtime_filter_mgr();
Review Comment:
warning: 'auto runtime_filter_mgr' can be declared as 'auto *runtime_filter_mgr' [readability-qualified-auto]
```suggestion
auto *runtime_filter_mgr = state->runtime_filter_mgr();
```
--
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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1931723062
<details>
<summary>TPC-H: <b>Total hot run time: 36853 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 910fdc9e3eb09006dc3225629e871ffaf108a79d, data reload: false
------ Round 1 ----------------------------------
q1 17669 4458 4461 4458
q2 2040 140 141 140
q3 10596 922 942 922
q4 4643 698 729 698
q5 7701 2813 2764 2764
q6 182 121 117 117
q7 1163 727 715 715
q8 9292 2002 2016 2002
q9 7297 6329 6359 6329
q10 8072 2442 2432 2432
q11 417 212 211 211
q12 761 262 275 262
q13 18000 3332 3262 3262
q14 271 251 252 251
q15 527 500 483 483
q16 465 410 417 410
q17 930 563 526 526
q18 6753 5900 5905 5900
q19 1571 1342 1362 1342
q20 619 339 318 318
q21 6879 3015 3106 3015
q22 787 296 304 296
Total cold run time: 106635 ms
Total hot run time: 36853 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4452 4484 4510 4484
q2 334 221 233 221
q3 2974 2840 2825 2825
q4 1877 1643 1708 1643
q5 5166 5234 5179 5179
q6 191 113 113 113
q7 2168 1782 1768 1768
q8 3079 3240 3243 3240
q9 8294 8272 8248 8248
q10 5839 3521 3549 3521
q11 527 454 464 454
q12 789 576 580 576
q13 12577 3050 3072 3050
q14 273 245 264 245
q15 532 493 490 490
q16 500 460 468 460
q17 1799 1642 1662 1642
q18 8021 7740 7566 7566
q19 6412 1522 1557 1522
q20 2117 1897 1892 1892
q21 4816 4550 4435 4435
q22 551 446 441 441
Total cold run time: 73288 ms
Total hot run time: 54015 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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1933018361
<details>
<summary>TPC-DS: <b>Total hot run time: 181102 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 02922fd30e7eb56660bd5c5a2f764c28270f0469, data reload: false
query1 914 352 359 352
query2 6522 1851 1683 1683
query3 6696 207 203 203
query4 24509 22866 22771 22771
query5 4288 470 369 369
query6 262 162 162 162
query7 4600 302 296 296
query8 243 195 193 193
query9 8441 2844 2819 2819
query10 412 226 216 216
query11 16114 15663 15735 15663
query12 140 86 81 81
query13 1704 407 416 407
query14 10081 7596 7567 7567
query15 214 182 190 182
query16 7635 250 252 250
query17 1410 558 539 539
query18 1959 259 254 254
query19 187 141 146 141
query20 85 81 84 81
query21 185 129 110 110
query22 4852 4820 4914 4820
query23 32666 31727 31773 31727
query24 12711 3423 3390 3390
query25 650 367 359 359
query26 1858 158 147 147
query27 3063 310 308 308
query28 6517 1850 1844 1844
query29 1105 616 601 601
query30 280 132 148 132
query31 934 772 775 772
query32 97 57 56 56
query33 733 238 236 236
query34 1064 470 495 470
query35 925 814 838 814
query36 1044 931 859 859
query37 163 60 63 60
query38 3473 3277 3294 3277
query39 1349 1343 1312 1312
query40 278 104 101 101
query41 37 37 34 34
query42 101 99 97 97
query43 467 446 445 445
query44 1073 685 705 685
query45 201 185 176 176
query46 1048 775 750 750
query47 1693 1633 1611 1611
query48 406 340 351 340
query49 1195 302 303 302
query50 779 369 365 365
query51 5307 5214 5169 5169
query52 111 93 92 92
query53 395 299 304 299
query54 297 222 220 220
query55 84 78 78 78
query56 225 200 194 194
query57 1052 1021 960 960
query58 218 199 198 198
query59 2337 2136 2079 2079
query60 244 230 231 230
query61 81 87 81 81
query62 582 383 384 383
query63 321 295 291 291
query64 6178 3057 3146 3057
query65 3272 3285 3238 3238
query66 1337 328 315 315
query67 15044 14543 14359 14359
query68 5058 537 540 537
query69 520 353 355 353
query70 1247 1215 1217 1215
query71 446 249 262 249
query72 6321 2764 2588 2588
query73 690 305 302 302
query74 7100 6721 6669 6669
query75 3240 2577 2532 2532
query76 3359 1123 1211 1123
query77 345 237 235 235
query78 9379 8910 8734 8734
query79 970 504 507 504
query80 501 344 343 343
query81 442 205 210 205
query82 159 85 89 85
query83 147 117 119 117
query84 228 78 75 75
query85 934 336 331 331
query86 305 311 312 311
query87 3634 3438 3473 3438
query88 2759 2274 2266 2266
query89 436 356 357 356
query90 1880 167 161 161
query91 151 128 125 125
query92 51 48 46 46
query93 994 513 493 493
query94 1133 180 181 180
query95 8758 8585 381 381
query96 576 266 266 266
query97 4486 4269 4279 4269
query98 217 199 196 196
query99 1052 745 773 745
Total cold run time: 281966 ms
Total hot run time: 181102 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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1931250508
<details>
<summary>TPC-H: <b>Total hot run time: 37616 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 41d13513a509ab756a06d3d3610e549508186e00, data reload: false
------ Round 1 ----------------------------------
q1 17763 6593 4600 4600
q2 2902 151 140 140
q3 11985 962 946 946
q4 4795 798 770 770
q5 8044 2902 2943 2902
q6 191 126 122 122
q7 1189 774 769 769
q8 9589 2063 2078 2063
q9 7439 6418 6351 6351
q10 8105 2438 2437 2437
q11 412 210 204 204
q12 771 283 293 283
q13 18033 3357 3324 3324
q14 284 256 250 250
q15 532 499 496 496
q16 498 410 423 410
q17 943 577 525 525
q18 6779 6015 5934 5934
q19 1582 1383 1359 1359
q20 629 344 335 335
q21 6561 3164 3085 3085
q22 822 311 319 311
Total cold run time: 109848 ms
Total hot run time: 37616 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4524 4540 4409 4409
q2 339 237 234 234
q3 3002 2893 2849 2849
q4 1817 1692 1675 1675
q5 5228 5225 5233 5225
q6 192 113 112 112
q7 2137 1791 1799 1791
q8 3120 3230 3244 3230
q9 8465 8306 8338 8306
q10 5912 3598 3592 3592
q11 536 470 470 470
q12 790 572 587 572
q13 4808 3152 3125 3125
q14 262 256 258 256
q15 547 486 485 485
q16 536 462 461 461
q17 1800 1674 1742 1674
q18 8100 7891 7386 7386
q19 8033 1562 1546 1546
q20 2149 1917 1921 1917
q21 4798 4651 4656 4651
q22 558 507 486 486
Total cold run time: 67653 ms
Total hot run time: 54452 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] opt the rf code and remove rf unless code [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1928645753
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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1928668908
<details>
<summary>TPC-H: <b>Total hot run time: 36782 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 d9cb4bd36206bc6dd10e7963ab92ac1860bbbf73, data reload: false
------ Round 1 ----------------------------------
q1 17681 4625 4389 4389
q2 2061 141 137 137
q3 10667 915 896 896
q4 4678 745 674 674
q5 7705 2777 2793 2777
q6 184 118 122 118
q7 1137 726 720 720
q8 9304 1990 2015 1990
q9 7260 6351 6384 6351
q10 8100 2432 2419 2419
q11 408 199 204 199
q12 732 265 288 265
q13 18022 3326 3289 3289
q14 271 248 247 247
q15 523 498 481 481
q16 495 426 420 420
q17 942 524 509 509
q18 6778 6012 5850 5850
q19 1536 1412 1335 1335
q20 568 336 356 336
q21 6950 3080 3114 3080
q22 795 300 300 300
Total cold run time: 106797 ms
Total hot run time: 36782 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4434 4410 4399 4399
q2 333 226 245 226
q3 2975 2810 2755 2755
q4 1864 1705 1653 1653
q5 5191 5223 5219 5219
q6 190 115 117 115
q7 2155 1746 1767 1746
q8 3119 3273 3225 3225
q9 8281 8299 8301 8299
q10 5793 3606 3589 3589
q11 545 460 465 460
q12 757 552 574 552
q13 11697 3084 3103 3084
q14 280 257 270 257
q15 528 491 491 491
q16 517 470 443 443
q17 1824 1641 1691 1641
q18 7919 7834 7443 7443
q19 9354 1540 1529 1529
q20 2108 1901 1927 1901
q21 4915 4649 4559 4559
q22 553 485 490 485
Total cold run time: 75332 ms
Total hot run time: 54071 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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1928666253
TeamCity be ut coverage result:
Function Coverage: 36.19% (8628/23844)
Line Coverage: 28.21% (70561/250133)
Region Coverage: 27.22% (36416/133796)
Branch Coverage: 24.01% (18657/77718)
Coverage Report: http://coverage.selectdb-in.cc/coverage/d9cb4bd36206bc6dd10e7963ab92ac1860bbbf73_d9cb4bd36206bc6dd10e7963ab92ac1860bbbf73/report/index.html
--
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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1927339654
<details>
<summary>TPC-DS: <b>Total hot run time: 173842 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 d8a93af361cbbe37c635736262c9d230d25c080c, data reload: false
query1 929 364 349 349
query2 6513 2016 2042 2016
query3 6717 217 219 217
query4 31825 22014 21972 21972
query5 4330 441 429 429
query6 256 164 165 164
query7 4600 287 286 286
query8 237 178 187 178
query9 9089 2283 2276 2276
query10 416 209 219 209
query11 18956 15524 15392 15392
query12 130 76 75 75
query13 1617 415 414 414
query14 9540 6914 6491 6491
query15 214 184 180 180
query16 8048 262 250 250
query17 1845 535 514 514
query18 2120 262 261 261
query19 191 144 143 143
query20 81 78 79 78
query21 191 127 116 116
query22 4817 4653 4718 4653
query23 31041 30048 29975 29975
query24 11604 2788 2760 2760
query25 617 343 336 336
query26 1796 150 150 150
query27 3215 310 309 309
query28 7714 1849 1852 1849
query29 994 652 629 629
query30 282 131 139 131
query31 929 703 710 703
query32 91 56 52 52
query33 740 217 224 217
query34 1289 473 487 473
query35 955 758 795 758
query36 1050 951 942 942
query37 253 57 64 57
query38 3229 3105 3145 3105
query39 1317 1264 1250 1250
query40 266 94 93 93
query41 37 35 34 34
query42 101 92 90 90
query43 522 474 495 474
query44 1066 688 705 688
query45 196 181 171 171
query46 1068 639 673 639
query47 1615 1544 1445 1445
query48 436 357 360 357
query49 1258 293 284 284
query50 756 386 402 386
query51 5366 5206 5198 5198
query52 107 81 89 81
query53 340 273 276 273
query54 295 219 224 219
query55 79 78 77 77
query56 232 197 202 197
query57 1055 915 922 915
query58 203 180 182 180
query59 2554 2269 2338 2269
query60 242 217 216 216
query61 82 81 86 81
query62 644 363 362 362
query63 296 268 269 268
query64 6332 3654 3170 3170
query65 3268 3257 3209 3209
query66 1358 307 299 299
query67 14100 13991 14119 13991
query68 3796 539 538 538
query69 462 315 313 313
query70 1272 1215 1217 1215
query71 313 249 273 249
query72 6017 2835 2624 2624
query73 698 317 327 317
query74 6601 6104 6251 6104
query75 3051 2373 2305 2305
query76 2490 969 982 969
query77 448 233 228 228
query78 9128 8862 8585 8585
query79 2744 500 491 491
query80 1800 355 333 333
query81 518 195 200 195
query82 785 81 80 80
query83 298 120 122 120
query84 283 85 81 81
query85 2352 333 320 320
query86 497 315 301 301
query87 3377 3230 3316 3230
query88 3904 2304 2304 2304
query89 446 375 372 372
query90 2133 164 164 164
query91 146 123 122 122
query92 57 42 41 41
query93 2726 473 489 473
query94 1442 179 174 174
query95 8065 7773 359 359
query96 594 266 277 266
query97 4254 4062 4143 4062
query98 227 201 195 195
query99 1081 696 687 687
Total cold run time: 295657 ms
Total hot run time: 173842 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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1927877127
<details>
<summary>TPC-H: <b>Total hot run time: 37142 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 e616552029f30518b3f89ade4ea527698a40ef65, data reload: false
------ Round 1 ----------------------------------
q1 17689 4809 4375 4375
q2 2050 148 136 136
q3 10601 928 956 928
q4 4647 772 732 732
q5 7701 2881 2971 2881
q6 183 121 122 121
q7 1120 731 725 725
q8 9256 2040 2006 2006
q9 7264 6401 6366 6366
q10 8106 2385 2427 2385
q11 412 211 212 211
q12 804 276 263 263
q13 18012 3315 3316 3315
q14 276 252 253 252
q15 539 502 488 488
q16 495 415 397 397
q17 947 538 595 538
q18 6818 5963 5980 5963
q19 1570 1422 1440 1422
q20 607 348 322 322
q21 7011 3006 3193 3006
q22 813 313 310 310
Total cold run time: 106921 ms
Total hot run time: 37142 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4427 4376 4380 4376
q2 340 231 235 231
q3 2995 2848 2797 2797
q4 1855 1694 1639 1639
q5 5139 5216 5223 5216
q6 191 113 116 113
q7 2168 1766 1705 1705
q8 3097 3267 3240 3240
q9 8342 8304 8353 8304
q10 5983 3615 3541 3541
q11 558 461 461 461
q12 731 580 609 580
q13 10635 3139 3072 3072
q14 275 265 272 265
q15 541 493 496 493
q16 503 479 455 455
q17 1806 1674 1720 1674
q18 8052 7734 7573 7573
q19 8891 1516 1494 1494
q20 2120 1926 1896 1896
q21 4716 4575 4535 4535
q22 559 492 503 492
Total cold run time: 73924 ms
Total hot run time: 54152 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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1931259369
<details>
<summary>TPC-DS: <b>Total hot run time: 174732 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 41d13513a509ab756a06d3d3610e549508186e00, data reload: false
query1 928 348 339 339
query2 6528 1971 1946 1946
query3 6701 210 202 202
query4 32252 22072 22113 22072
query5 4336 364 354 354
query6 250 166 158 158
query7 4611 289 284 284
query8 242 177 179 177
query9 8923 2252 2240 2240
query10 419 214 215 214
query11 18191 15424 15309 15309
query12 132 76 77 76
query13 1617 417 415 415
query14 9331 6949 7085 6949
query15 230 181 185 181
query16 8117 265 249 249
query17 1878 552 506 506
query18 2106 267 260 260
query19 341 141 155 141
query20 81 80 80 80
query21 207 130 117 117
query22 4807 4627 4572 4572
query23 30996 30001 29987 29987
query24 11442 2746 2749 2746
query25 611 340 337 337
query26 1741 145 145 145
query27 2893 303 304 303
query28 7560 1834 1835 1834
query29 956 626 599 599
query30 289 139 141 139
query31 912 720 734 720
query32 89 56 51 51
query33 739 224 244 224
query34 1071 454 461 454
query35 862 768 770 768
query36 1049 945 873 873
query37 137 57 56 56
query38 3202 3094 3103 3094
query39 1324 1239 1257 1239
query40 262 94 92 92
query41 36 35 35 35
query42 99 93 89 89
query43 502 478 476 476
query44 1145 682 698 682
query45 198 178 171 171
query46 1055 655 658 655
query47 1633 1516 1487 1487
query48 446 381 358 358
query49 1201 285 278 278
query50 763 382 392 382
query51 5267 5135 5211 5135
query52 101 86 86 86
query53 330 274 279 274
query54 280 215 214 214
query55 78 74 79 74
query56 216 202 203 202
query57 1020 920 905 905
query58 198 179 175 175
query59 2448 2366 2383 2366
query60 241 215 203 203
query61 84 84 90 84
query62 656 365 360 360
query63 282 276 274 274
query64 6400 3375 3376 3375
query65 3275 3244 3221 3221
query66 1150 311 312 311
query67 14550 14310 14298 14298
query68 4298 535 562 535
query69 452 322 310 310
query70 1286 1228 1239 1228
query71 318 246 242 242
query72 6015 2845 2671 2671
query73 703 327 330 327
query74 6642 6168 6120 6120
query75 3027 2313 2382 2313
query76 2509 965 947 947
query77 413 226 221 221
query78 9175 8818 8702 8702
query79 2483 507 496 496
query80 1181 355 336 336
query81 508 195 198 195
query82 624 84 78 78
query83 215 123 128 123
query84 231 81 78 78
query85 2047 335 330 330
query86 490 291 291 291
query87 3379 3247 3178 3178
query88 3769 2402 2386 2386
query89 450 352 360 352
query90 2050 170 165 165
query91 150 122 140 122
query92 63 44 44 44
query93 1884 487 501 487
query94 1346 179 176 176
query95 471 351 363 351
query96 594 277 276 276
query97 4246 4109 4138 4109
query98 227 210 194 194
query99 982 691 677 677
Total cold run time: 284245 ms
Total hot run time: 174732 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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1933004437
TeamCity be ut coverage result:
Function Coverage: 35.86% (8557/23862)
Line Coverage: 27.79% (69458/249973)
Region Coverage: 26.91% (36006/133821)
Branch Coverage: 23.69% (18409/77704)
Coverage Report: http://coverage.selectdb-in.cc/coverage/02922fd30e7eb56660bd5c5a2f764c28270f0469_02922fd30e7eb56660bd5c5a2f764c28270f0469/report/index.html
--
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] opt the rf code and remove rf unless code [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1927105545
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] opt the rf code and remove rf unless code [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1927237160
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] opt the rf code and remove rf unless code [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1927782988
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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1927893505
<details>
<summary>TPC-DS: <b>Total hot run time: 174155 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 e616552029f30518b3f89ade4ea527698a40ef65, data reload: false
query1 904 351 331 331
query2 6542 1941 2059 1941
query3 6706 238 203 203
query4 32019 21865 22079 21865
query5 4244 360 405 360
query6 263 162 170 162
query7 4618 281 286 281
query8 235 187 175 175
query9 9172 2292 2283 2283
query10 422 206 227 206
query11 17913 15352 15301 15301
query12 137 82 80 80
query13 1612 420 410 410
query14 9435 6988 6849 6849
query15 241 178 181 178
query16 8144 259 255 255
query17 1919 534 493 493
query18 2095 262 261 261
query19 353 136 142 136
query20 81 75 76 75
query21 197 126 129 126
query22 4875 4654 4677 4654
query23 31805 30079 29976 29976
query24 10274 2747 2734 2734
query25 535 358 348 348
query26 709 139 143 139
query27 2215 303 303 303
query28 6016 1846 1830 1830
query29 885 607 612 607
query30 274 128 131 128
query31 917 694 724 694
query32 91 51 51 51
query33 658 212 218 212
query34 1006 453 462 453
query35 880 787 753 753
query36 1064 896 881 881
query37 95 59 56 56
query38 3252 3121 3098 3098
query39 1322 1239 1244 1239
query40 186 94 89 89
query41 38 35 34 34
query42 95 89 93 89
query43 554 487 516 487
query44 1076 692 708 692
query45 189 183 172 172
query46 1036 661 654 654
query47 1594 1509 1476 1476
query48 422 346 344 344
query49 1045 292 285 285
query50 762 362 368 362
query51 5292 5107 5131 5107
query52 92 84 84 84
query53 334 269 260 260
query54 296 208 218 208
query55 77 80 72 72
query56 217 193 193 193
query57 975 902 917 902
query58 194 173 179 173
query59 2375 2366 2501 2366
query60 246 220 205 205
query61 84 83 85 83
query62 637 359 354 354
query63 292 274 258 258
query64 5041 3561 3608 3561
query65 3256 3220 3211 3211
query66 823 317 315 315
query67 14511 14050 14224 14050
query68 4425 536 525 525
query69 463 328 328 328
query70 1258 1233 1267 1233
query71 313 240 257 240
query72 5953 2847 2667 2667
query73 704 329 318 318
query74 6669 6228 6286 6228
query75 3022 2329 2303 2303
query76 2895 983 978 978
query77 350 235 229 229
query78 9323 8713 8567 8567
query79 3808 510 484 484
query80 1942 356 339 339
query81 534 190 197 190
query82 1202 76 79 76
query83 237 127 121 121
query84 291 97 79 79
query85 2247 331 324 324
query86 485 301 292 292
query87 3407 3254 3197 3197
query88 4630 2301 2298 2298
query89 454 351 358 351
query90 2050 160 161 160
query91 147 127 139 127
query92 55 42 44 42
query93 5297 478 484 478
query94 1270 171 172 171
query95 456 349 339 339
query96 600 273 263 263
query97 4213 4145 4120 4120
query98 211 210 191 191
query99 1138 684 693 684
Total cold run time: 285913 ms
Total hot run time: 174155 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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1927879461
TeamCity be ut coverage result:
Function Coverage: 36.19% (8628/23844)
Line Coverage: 28.20% (70550/250133)
Region Coverage: 27.22% (36417/133796)
Branch Coverage: 24.00% (18649/77718)
Coverage Report: http://coverage.selectdb-in.cc/coverage/e616552029f30518b3f89ade4ea527698a40ef65_e616552029f30518b3f89ade4ea527698a40ef65/report/index.html
--
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] opt the rf code and remove rf unless code [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1926636528
clang-tidy review says "All clean, LGTM! :+1:"
--
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] opt the rf code and remove rf unless code [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1926596358
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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1927214451
<details>
<summary>TPC-H: <b>Total hot run time: 37484 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 abc91c440750c760f59799e71085f2e3ca60a339, data reload: false
------ Round 1 ----------------------------------
q1 17792 4910 4538 4538
q2 2506 147 153 147
q3 11441 954 964 954
q4 5100 826 805 805
q5 7834 3051 2882 2882
q6 190 123 128 123
q7 1196 751 754 751
q8 9431 2057 2057 2057
q9 7537 6425 6376 6376
q10 8100 2470 2460 2460
q11 412 213 209 209
q12 746 276 281 276
q13 18016 3333 3282 3282
q14 326 250 246 246
q15 524 500 483 483
q16 466 400 410 400
q17 943 475 529 475
q18 6813 5974 6066 5974
q19 1556 1486 1378 1378
q20 617 331 322 322
q21 6859 3056 3102 3056
q22 796 290 296 290
Total cold run time: 109201 ms
Total hot run time: 37484 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4493 4385 4433 4385
q2 324 221 248 221
q3 3003 2829 2864 2829
q4 1849 1677 1679 1677
q5 5218 5287 5209 5209
q6 191 115 114 114
q7 2147 1758 1763 1758
q8 3115 3279 3252 3252
q9 8371 8292 8298 8292
q10 5945 3584 3510 3510
q11 538 469 459 459
q12 755 573 579 573
q13 8397 3144 3076 3076
q14 285 249 255 249
q15 537 485 496 485
q16 530 479 466 466
q17 1831 1662 1703 1662
q18 8107 7888 7557 7557
q19 8618 1505 1532 1505
q20 2126 1909 1915 1909
q21 4843 4606 4750 4606
q22 534 455 462 455
Total cold run time: 71757 ms
Total hot run time: 54249 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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1927315659
<details>
<summary>TPC-H: <b>Total hot run time: 37516 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 d8a93af361cbbe37c635736262c9d230d25c080c, data reload: false
------ Round 1 ----------------------------------
q1 18289 6501 4606 4606
q2 2552 159 141 141
q3 11601 958 960 958
q4 5538 789 723 723
q5 7888 3009 2916 2916
q6 191 124 126 124
q7 1220 760 754 754
q8 9732 2070 2067 2067
q9 7989 6466 6374 6374
q10 8177 2463 2417 2417
q11 424 198 206 198
q12 809 281 283 281
q13 18030 3345 3323 3323
q14 288 257 255 255
q15 541 491 495 491
q16 492 417 405 405
q17 949 522 480 480
q18 6468 5995 5890 5890
q19 1582 1380 1410 1380
q20 566 338 347 338
q21 6962 3098 3117 3098
q22 793 297 307 297
Total cold run time: 111081 ms
Total hot run time: 37516 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4508 4371 4520 4371
q2 328 238 230 230
q3 3012 2897 2807 2807
q4 1821 1651 1675 1651
q5 5240 5296 5232 5232
q6 193 115 113 113
q7 2198 1811 1785 1785
q8 3130 3250 3248 3248
q9 8393 8343 8282 8282
q10 5962 3588 3535 3535
q11 538 465 450 450
q12 744 573 600 573
q13 3676 3139 3119 3119
q14 299 255 266 255
q15 536 502 490 490
q16 518 463 462 462
q17 1784 1696 1705 1696
q18 7956 7834 7558 7558
q19 7317 1538 1531 1531
q20 2139 1913 1928 1913
q21 4856 4628 4506 4506
q22 579 457 466 457
Total cold run time: 65727 ms
Total hot run time: 54264 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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1927929835
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit e616552029f30518b3f89ade4ea527698a40ef65 with default session variables
Stream load json: 18 seconds loaded 2358488459 Bytes, about 124 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: 14.6 seconds inserted 10000000 Rows, about 684K 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] opt the rf code and remove rf unless code [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1929132334
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] opt the rf code and remove rf unless code [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1932920918
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] opt the rf code and remove rf unless code [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1928935263
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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1931263445
<details>
<summary>ClickBench: <b>Total hot run time: 30.87 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 41d13513a509ab756a06d3d3610e549508186e00, data reload: false
query1 0.04 0.03 0.03
query2 0.06 0.02 0.02
query3 0.23 0.06 0.07
query4 1.67 0.11 0.11
query5 0.53 0.51 0.53
query6 1.18 0.65 0.64
query7 0.01 0.01 0.01
query8 0.03 0.02 0.02
query9 0.56 0.51 0.51
query10 0.55 0.55 0.54
query11 0.11 0.08 0.08
query12 0.12 0.09 0.10
query13 0.60 0.61 0.61
query14 0.80 0.79 0.80
query15 0.80 0.77 0.78
query16 0.37 0.40 0.39
query17 1.04 0.99 1.01
query18 0.23 0.28 0.25
query19 1.93 1.75 1.78
query20 0.01 0.01 0.01
query21 15.40 0.58 0.59
query22 2.65 2.22 1.70
query23 17.33 0.77 0.83
query24 2.62 1.15 0.91
query25 0.34 0.18 0.21
query26 0.50 0.15 0.14
query27 0.04 0.04 0.06
query28 11.63 0.84 0.85
query29 12.56 3.23 3.12
query30 0.62 0.55 0.49
query31 2.79 0.35 0.35
query32 3.33 0.47 0.48
query33 3.19 3.20 3.22
query34 16.12 4.34 4.27
query35 4.29 4.31 4.31
query36 1.11 1.06 1.07
query37 0.07 0.05 0.05
query38 0.03 0.03 0.03
query39 0.03 0.01 0.02
query40 0.16 0.13 0.14
query41 0.08 0.01 0.01
query42 0.03 0.01 0.02
query43 0.03 0.02 0.02
Total cold run time: 105.82 s
Total hot run time: 30.87 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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1931257139
TeamCity be ut coverage result:
Function Coverage: 36.17% (8638/23880)
Line Coverage: 28.20% (70618/250452)
Region Coverage: 27.19% (36439/134032)
Branch Coverage: 23.97% (18663/77846)
Coverage Report: http://coverage.selectdb-in.cc/coverage/41d13513a509ab756a06d3d3610e549508186e00_41d13513a509ab756a06d3d3610e549508186e00/report/index.html
--
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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1928747413
TeamCity be ut coverage result:
Function Coverage: 36.19% (8629/23844)
Line Coverage: 28.21% (70556/250140)
Region Coverage: 27.21% (36412/133798)
Branch Coverage: 24.00% (18654/77720)
Coverage Report: http://coverage.selectdb-in.cc/coverage/f976c3369fbcc13617fe295a12b56a308f548058_f976c3369fbcc13617fe295a12b56a308f548058/report/index.html
--
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] opt the rf code and remove rf unless code [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee merged PR #30861:
URL: https://github.com/apache/doris/pull/30861
--
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] opt the rf code and remove rf unless code [doris]
Posted by "HappenLee (via GitHub)" <gi...@apache.org>.
HappenLee commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1928677081
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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1928718304
<details>
<summary>TPC-DS: <b>Total hot run time: 174728 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 f976c3369fbcc13617fe295a12b56a308f548058, data reload: false
query1 940 346 338 338
query2 6535 1940 1892 1892
query3 6697 214 212 212
query4 31783 21934 22193 21934
query5 4313 367 362 362
query6 257 172 168 168
query7 4608 284 276 276
query8 248 176 178 176
query9 8993 2284 2299 2284
query10 421 213 224 213
query11 18073 15287 15508 15287
query12 132 75 76 75
query13 1619 416 419 416
query14 9410 7005 7113 7005
query15 255 188 179 179
query16 8153 253 248 248
query17 2019 533 510 510
query18 2123 270 261 261
query19 360 146 141 141
query20 79 78 80 78
query21 197 128 126 126
query22 4945 4582 4735 4582
query23 31233 30066 29991 29991
query24 7411 2723 2717 2717
query25 557 346 338 338
query26 709 145 146 145
query27 2152 289 303 289
query28 5099 1862 1850 1850
query29 885 624 614 614
query30 280 129 138 129
query31 929 706 693 693
query32 92 52 48 48
query33 480 218 214 214
query34 838 452 458 452
query35 857 747 782 747
query36 978 924 916 916
query37 91 59 59 59
query38 3222 3096 3158 3096
query39 1304 1253 1251 1251
query40 182 99 96 96
query41 40 34 39 34
query42 96 95 96 95
query43 525 487 472 472
query44 1049 683 715 683
query45 191 178 173 173
query46 1046 657 634 634
query47 1585 1448 1530 1448
query48 431 351 350 350
query49 1039 299 284 284
query50 756 377 372 372
query51 5251 5147 5158 5147
query52 103 85 84 84
query53 329 263 265 263
query54 258 223 229 223
query55 82 74 79 74
query56 213 204 196 196
query57 961 925 899 899
query58 196 178 179 178
query59 2371 2271 2295 2271
query60 241 209 208 208
query61 87 86 84 84
query62 596 367 348 348
query63 297 269 270 269
query64 4702 3540 3737 3540
query65 3255 3242 3249 3242
query66 826 324 306 306
query67 14546 14524 14382 14382
query68 4060 532 518 518
query69 468 330 335 330
query70 1278 1210 1205 1205
query71 308 243 256 243
query72 5985 2836 2692 2692
query73 704 321 318 318
query74 6580 6214 6217 6214
query75 3069 2339 2328 2328
query76 2563 1015 902 902
query77 358 231 227 227
query78 9222 8859 8697 8697
query79 2743 488 492 488
query80 1272 377 350 350
query81 532 193 191 191
query82 679 80 84 80
query83 252 128 124 124
query84 234 84 82 82
query85 1525 340 337 337
query86 480 303 306 303
query87 3358 3229 3230 3229
query88 3642 2379 2331 2331
query89 434 379 345 345
query90 1913 168 165 165
query91 172 121 124 121
query92 60 44 43 43
query93 2403 468 482 468
query94 1305 181 177 177
query95 463 359 343 343
query96 600 272 277 272
query97 4247 4087 4101 4087
query98 213 197 189 189
query99 1041 671 662 662
Total cold run time: 272694 ms
Total hot run time: 174728 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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1927341378
TeamCity be ut coverage result:
Function Coverage: 36.18% (8627/23843)
Line Coverage: 28.20% (70528/250123)
Region Coverage: 27.21% (36405/133792)
Branch Coverage: 23.99% (18642/77716)
Coverage Report: http://coverage.selectdb-in.cc/coverage/d8a93af361cbbe37c635736262c9d230d25c080c_d8a93af361cbbe37c635736262c9d230d25c080c/report/index.html
--
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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1928725188
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit f976c3369fbcc13617fe295a12b56a308f548058 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: 14.2 seconds inserted 10000000 Rows, about 704K 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] opt the rf code and remove rf unless code [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #30861:
URL: https://github.com/apache/doris/pull/30861#issuecomment-1931265963
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 41d13513a509ab756a06d3d3610e549508186e00 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: 13.6 seconds inserted 10000000 Rows, about 735K 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