You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "zzzxl1993 (via GitHub)" <gi...@apache.org> on 2024/03/27 12:19:52 UTC
[PR] [fix](inverted index) Clear the index cache corresponding to the tabl… [doris]
zzzxl1993 opened a new pull request, #32921:
URL: https://github.com/apache/doris/pull/32921
…e after deleting the table.
## 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] [fix](inverted index) Clear the index cache corresponding to the tabl… [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #32921:
URL: https://github.com/apache/doris/pull/32921#issuecomment-2022799146
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] [fix](inverted index) Clear the index cache corresponding to the tabl… [doris]
Posted by "zzzxl1993 (via GitHub)" <gi...@apache.org>.
zzzxl1993 commented on PR #32921:
URL: https://github.com/apache/doris/pull/32921#issuecomment-2026589801
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](inverted index) Clear the index cache corresponding to the tabl… [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #32921:
URL: https://github.com/apache/doris/pull/32921#issuecomment-2026724819
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] [fix](inverted index) Clear the index cache corresponding to the tabl… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32921:
URL: https://github.com/apache/doris/pull/32921#issuecomment-2026784605
<details>
<summary>TPC-H: <b>Total hot run time: 37387 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 c34c22a0e0fac2b4d70b65294cb6f75824d61502, data reload: false
------ Round 1 ----------------------------------
q1 17630 4203 4065 4065
q2 2107 155 146 146
q3 10601 1101 1193 1101
q4 10230 799 797 797
q5 7444 2875 2870 2870
q6 199 122 123 122
q7 1031 587 575 575
q8 9323 2008 1972 1972
q9 6788 6306 6305 6305
q10 8425 3450 3561 3450
q11 434 223 233 223
q12 433 200 196 196
q13 17804 2870 2863 2863
q14 235 197 222 197
q15 511 447 453 447
q16 477 353 354 353
q17 937 530 543 530
q18 7051 6421 6381 6381
q19 2131 1434 1479 1434
q20 543 264 248 248
q21 3589 2931 2831 2831
q22 326 281 301 281
Total cold run time: 108249 ms
Total hot run time: 37387 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4113 4040 4051 4040
q2 320 220 226 220
q3 2946 2826 2839 2826
q4 1833 1594 1600 1594
q5 5131 5194 5220 5194
q6 188 114 116 114
q7 2190 1844 1823 1823
q8 3132 3271 3274 3271
q9 8375 8401 8423 8401
q10 3767 3758 3880 3758
q11 555 458 452 452
q12 748 605 608 605
q13 17133 3157 3054 3054
q14 299 283 269 269
q15 501 471 461 461
q16 501 422 437 422
q17 1792 1532 1537 1532
q18 8129 7666 7568 7568
q19 1692 1537 1600 1537
q20 1985 1841 1805 1805
q21 5111 4740 4705 4705
q22 525 472 470 470
Total cold run time: 70966 ms
Total hot run time: 54121 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](inverted index) Clear the index cache corresponding to the tabl… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32921:
URL: https://github.com/apache/doris/pull/32921#issuecomment-2026635762
<details>
<summary>TPC-H: <b>Total hot run time: 37981 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 48ed10648ce7929b711e1c8ebb98b3fc2c0b4978, data reload: false
------ Round 1 ----------------------------------
q1 17937 4548 4221 4221
q2 2676 178 158 158
q3 11064 1167 1232 1167
q4 10911 757 838 757
q5 7831 3078 3000 3000
q6 210 127 127 127
q7 1051 592 572 572
q8 9335 1958 2028 1958
q9 7465 6366 6316 6316
q10 8463 3487 3633 3487
q11 427 222 211 211
q12 364 198 192 192
q13 17807 2862 2857 2857
q14 258 204 218 204
q15 516 456 455 455
q16 498 369 365 365
q17 963 501 616 501
q18 7230 6576 6546 6546
q19 1834 1488 1427 1427
q20 570 266 258 258
q21 3551 2914 2948 2914
q22 337 291 288 288
Total cold run time: 111298 ms
Total hot run time: 37981 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4098 4057 4092 4057
q2 326 232 230 230
q3 2976 2882 2837 2837
q4 1855 1595 1591 1591
q5 5241 5249 5276 5249
q6 195 118 117 117
q7 2191 1851 1803 1803
q8 3185 3331 3292 3292
q9 8508 8497 8468 8468
q10 3843 3780 3772 3772
q11 545 447 445 445
q12 725 546 556 546
q13 16925 2873 2870 2870
q14 286 252 247 247
q15 498 469 464 464
q16 481 418 437 418
q17 1734 1599 1485 1485
q18 7442 7265 7172 7172
q19 1651 1561 1540 1540
q20 1931 1729 1701 1701
q21 4864 4550 4635 4550
q22 530 458 449 449
Total cold run time: 70030 ms
Total hot run time: 53303 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](inverted index) Clear the index cache corresponding to the tabl… [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #32921:
URL: https://github.com/apache/doris/pull/32921#issuecomment-2026760234
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] [fix](inverted index) Clear the index cache corresponding to the tabl… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32921:
URL: https://github.com/apache/doris/pull/32921#issuecomment-2026650628
<details>
<summary>ClickBench: <b>Total hot run time: 29.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 48ed10648ce7929b711e1c8ebb98b3fc2c0b4978, data reload: false
query1 0.04 0.03 0.03
query2 0.06 0.03 0.03
query3 0.23 0.07 0.06
query4 1.64 0.10 0.09
query5 0.51 0.50 0.50
query6 1.12 0.66 0.65
query7 0.02 0.01 0.01
query8 0.04 0.03 0.03
query9 0.54 0.51 0.50
query10 0.55 0.54 0.54
query11 0.13 0.09 0.09
query12 0.12 0.09 0.10
query13 0.57 0.58 0.58
query14 0.76 0.78 0.76
query15 0.82 0.80 0.79
query16 0.38 0.38 0.37
query17 0.95 0.97 0.95
query18 0.22 0.24 0.22
query19 1.75 1.65 1.67
query20 0.02 0.01 0.01
query21 15.55 0.56 0.56
query22 2.22 2.04 1.62
query23 17.30 0.75 0.82
query24 3.58 1.42 2.71
query25 0.24 0.20 0.22
query26 0.58 0.13 0.13
query27 0.03 0.03 0.04
query28 8.69 0.90 0.89
query29 12.54 3.16 3.23
query30 0.28 0.10 0.08
query31 2.81 0.34 0.34
query32 3.38 0.45 0.43
query33 2.80 2.79 2.79
query34 16.20 4.33 4.43
query35 4.41 4.44 4.42
query36 0.66 0.47 0.48
query37 0.07 0.06 0.05
query38 0.05 0.03 0.03
query39 0.03 0.02 0.01
query40 0.16 0.14 0.15
query41 0.07 0.02 0.02
query42 0.03 0.02 0.02
query43 0.03 0.03 0.02
Total cold run time: 102.18 s
Total hot run time: 29.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] [fix](inverted index) Clear the index cache corresponding to the tabl… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32921:
URL: https://github.com/apache/doris/pull/32921#issuecomment-2026801765
<details>
<summary>ClickBench: <b>Total hot run time: 29.74 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 c34c22a0e0fac2b4d70b65294cb6f75824d61502, data reload: false
query1 0.04 0.04 0.03
query2 0.06 0.02 0.02
query3 0.23 0.06 0.06
query4 1.66 0.10 0.10
query5 0.50 0.47 0.48
query6 1.14 0.63 0.64
query7 0.02 0.01 0.02
query8 0.05 0.03 0.02
query9 0.55 0.51 0.51
query10 0.55 0.54 0.54
query11 0.13 0.10 0.10
query12 0.11 0.10 0.09
query13 0.60 0.57 0.57
query14 0.77 0.76 0.76
query15 0.81 0.80 0.78
query16 0.40 0.37 0.37
query17 0.97 0.97 0.99
query18 0.21 0.25 0.22
query19 1.78 1.68 1.78
query20 0.02 0.01 0.01
query21 15.54 0.59 0.55
query22 2.47 1.89 1.95
query23 17.02 1.00 0.73
query24 3.27 2.07 1.00
query25 0.32 0.03 0.04
query26 0.71 0.13 0.13
query27 0.04 0.04 0.03
query28 9.90 0.92 0.91
query29 12.67 3.35 3.33
query30 0.28 0.09 0.09
query31 2.82 0.36 0.36
query32 3.32 0.45 0.43
query33 2.81 2.74 2.86
query34 16.22 4.42 4.39
query35 4.44 4.44 4.45
query36 0.65 0.48 0.46
query37 0.08 0.05 0.05
query38 0.05 0.03 0.04
query39 0.03 0.03 0.02
query40 0.18 0.13 0.14
query41 0.07 0.02 0.02
query42 0.04 0.02 0.02
query43 0.03 0.02 0.03
Total cold run time: 103.56 s
Total hot run time: 29.74 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](inverted index) Clear the index cache corresponding to the tabl… [doris]
Posted by "zzzxl1993 (via GitHub)" <gi...@apache.org>.
zzzxl1993 commented on PR #32921:
URL: https://github.com/apache/doris/pull/32921#issuecomment-2026724279
run p0
--
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](inverted index) Clear the index cache corresponding to the tabl… [doris]
Posted by "zzzxl1993 (via GitHub)" <gi...@apache.org>.
zzzxl1993 commented on PR #32921:
URL: https://github.com/apache/doris/pull/32921#issuecomment-2026755016
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](inverted index) Clear the index cache corresponding to the tabl… [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #32921:
URL: https://github.com/apache/doris/pull/32921#issuecomment-2022643158
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] [fix](inverted index) Clear the index cache corresponding to the tabl… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32921:
URL: https://github.com/apache/doris/pull/32921#issuecomment-2022632328
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](inverted index) Clear the index cache corresponding to the tabl… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32921:
URL: https://github.com/apache/doris/pull/32921#issuecomment-2026659334
TeamCity be ut coverage result:
Function Coverage: 35.58% (8839/24841)
Line Coverage: 27.32% (72492/265364)
Region Coverage: 26.52% (37527/141502)
Branch Coverage: 23.33% (19136/82018)
Coverage Report: http://coverage.selectdb-in.cc/coverage/48ed10648ce7929b711e1c8ebb98b3fc2c0b4978_48ed10648ce7929b711e1c8ebb98b3fc2c0b4978/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] [fix](inverted index) Clear the index cache corresponding to the tabl… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32921:
URL: https://github.com/apache/doris/pull/32921#issuecomment-2026804481
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit c34c22a0e0fac2b4d70b65294cb6f75824d61502 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: 32 seconds loaded 861443392 Bytes, about 25 MB/s
Insert into select: 13.4 seconds inserted 10000000 Rows, about 746K 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](inverted index) Clear the index cache corresponding to the tabl… [doris]
Posted by "qidaye (via GitHub)" <gi...@apache.org>.
qidaye merged PR #32921:
URL: https://github.com/apache/doris/pull/32921
--
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](inverted index) Clear the index cache corresponding to the tabl… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32921:
URL: https://github.com/apache/doris/pull/32921#issuecomment-2026646733
<details>
<summary>TPC-DS: <b>Total hot run time: 182090 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 48ed10648ce7929b711e1c8ebb98b3fc2c0b4978, data reload: false
query1 940 377 350 350
query2 6529 1995 1846 1846
query3 6715 224 213 213
query4 31658 21338 21373 21338
query5 4328 420 410 410
query6 283 192 169 169
query7 4628 287 294 287
query8 235 188 181 181
query9 9206 2282 2215 2215
query10 530 268 283 268
query11 14740 14237 14327 14237
query12 136 95 93 93
query13 1648 425 437 425
query14 9370 7756 7825 7756
query15 254 195 179 179
query16 8181 281 272 272
query17 1915 577 557 557
query18 2099 291 280 280
query19 342 156 162 156
query20 92 95 87 87
query21 205 127 130 127
query22 5024 4839 4762 4762
query23 33403 32844 32738 32738
query24 12082 2873 2904 2873
query25 663 402 394 394
query26 1825 169 155 155
query27 3084 315 336 315
query28 8124 1830 1857 1830
query29 1042 649 624 624
query30 308 152 149 149
query31 981 719 743 719
query32 94 59 57 57
query33 772 264 267 264
query34 1062 481 496 481
query35 947 703 730 703
query36 1042 895 881 881
query37 273 70 65 65
query38 3612 3443 3405 3405
query39 1590 1558 1577 1558
query40 290 111 116 111
query41 53 50 48 48
query42 105 99 99 99
query43 499 446 439 439
query44 1170 733 727 727
query45 286 266 265 265
query46 1096 700 689 689
query47 1915 1851 1855 1851
query48 451 359 365 359
query49 1245 342 342 342
query50 763 386 378 378
query51 6881 6723 6758 6723
query52 104 97 87 87
query53 344 274 279 274
query54 322 254 242 242
query55 86 79 83 79
query56 260 240 240 240
query57 1207 1158 1099 1099
query58 242 220 224 220
query59 2829 2684 2630 2630
query60 267 253 252 252
query61 127 118 116 116
query62 682 443 443 443
query63 307 279 279 279
query64 6856 4134 4046 4046
query65 3096 3041 3048 3041
query66 1396 377 368 368
query67 15700 14987 15171 14987
query68 8933 527 533 527
query69 624 373 379 373
query70 1266 1140 1144 1140
query71 524 261 260 260
query72 6353 2537 2374 2374
query73 1110 323 320 320
query74 6928 6416 6360 6360
query75 3819 2179 2217 2179
query76 5398 883 853 853
query77 644 265 261 261
query78 11123 10240 10205 10205
query79 11318 518 534 518
query80 1750 374 365 365
query81 511 213 218 213
query82 233 84 88 84
query83 209 146 146 146
query84 292 83 76 76
query85 1081 316 298 298
query86 359 287 292 287
query87 3754 3526 3547 3526
query88 5301 2364 2359 2359
query89 496 363 365 363
query90 2076 172 173 172
query91 194 136 137 136
query92 62 48 49 48
query93 6352 492 472 472
query94 1325 172 173 172
query95 407 310 301 301
query96 615 277 273 273
query97 2629 2508 2494 2494
query98 232 217 216 216
query99 1099 869 866 866
Total cold run time: 315558 ms
Total hot run time: 182090 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](inverted index) Clear the index cache corresponding to the tabl… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32921:
URL: https://github.com/apache/doris/pull/32921#issuecomment-2026796429
<details>
<summary>TPC-DS: <b>Total hot run time: 182303 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 c34c22a0e0fac2b4d70b65294cb6f75824d61502, data reload: false
query1 1214 1108 1116 1108
query2 6796 2035 1923 1923
query3 6695 218 218 218
query4 33598 21251 21314 21251
query5 4281 383 374 374
query6 288 181 191 181
query7 4629 292 303 292
query8 221 177 168 168
query9 9837 2222 2227 2222
query10 448 245 265 245
query11 14733 14232 14231 14231
query12 128 87 83 83
query13 1626 446 431 431
query14 9661 7023 7023 7023
query15 199 181 184 181
query16 6887 276 263 263
query17 1745 617 556 556
query18 1419 301 285 285
query19 223 164 158 158
query20 92 84 93 84
query21 202 125 125 125
query22 5006 4812 4831 4812
query23 33210 32898 33014 32898
query24 10937 2914 2889 2889
query25 593 402 406 402
query26 804 164 157 157
query27 3040 367 374 367
query28 6744 1893 1900 1893
query29 891 635 621 621
query30 297 152 150 150
query31 978 742 717 717
query32 81 57 50 50
query33 586 230 239 230
query34 1064 509 522 509
query35 879 746 714 714
query36 1054 904 919 904
query37 96 65 62 62
query38 3778 3602 3625 3602
query39 1660 1602 1588 1588
query40 190 110 106 106
query41 49 47 48 47
query42 104 97 97 97
query43 480 478 455 455
query44 1172 755 750 750
query45 284 266 262 262
query46 1119 713 746 713
query47 2049 1945 1975 1945
query48 448 373 382 373
query49 876 315 329 315
query50 791 394 387 387
query51 6885 6768 6756 6756
query52 112 103 105 103
query53 345 280 277 277
query54 295 249 244 244
query55 90 79 87 79
query56 253 242 227 227
query57 1290 1271 1183 1183
query58 239 210 209 209
query59 2973 2685 2604 2604
query60 250 236 260 236
query61 112 111 112 111
query62 618 431 427 427
query63 300 276 274 274
query64 4793 4023 4009 4009
query65 3114 3051 3012 3012
query66 793 332 332 332
query67 15686 14718 14772 14718
query68 9716 525 537 525
query69 679 381 390 381
query70 1404 1149 1168 1149
query71 557 265 263 263
query72 6717 2507 2355 2355
query73 1585 320 323 320
query74 6838 6353 6444 6353
query75 4155 2267 2238 2238
query76 5599 887 956 887
query77 582 243 233 233
query78 10781 10390 10170 10170
query79 11393 538 521 521
query80 2405 368 346 346
query81 490 211 201 201
query82 164 83 86 83
query83 221 137 138 137
query84 281 76 71 71
query85 1035 310 306 306
query86 353 283 305 283
query87 3733 3515 3520 3515
query88 5355 2401 2303 2303
query89 468 368 360 360
query90 2409 175 167 167
query91 167 130 129 129
query92 57 44 49 44
query93 6862 499 493 493
query94 1535 172 172 172
query95 404 299 298 298
query96 613 267 273 267
query97 2623 2491 2457 2457
query98 239 210 207 207
query99 1027 851 860 851
Total cold run time: 312777 ms
Total hot run time: 182303 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](inverted index) Clear the index cache corresponding to the tabl… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32921:
URL: https://github.com/apache/doris/pull/32921#issuecomment-2026653085
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 48ed10648ce7929b711e1c8ebb98b3fc2c0b4978 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.7 seconds inserted 10000000 Rows, about 729K 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](inverted index) Clear the index cache corresponding to the tabl… [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #32921:
URL: https://github.com/apache/doris/pull/32921#issuecomment-2026779365
TeamCity be ut coverage result:
Function Coverage: 35.58% (8840/24843)
Line Coverage: 27.31% (72491/265406)
Region Coverage: 26.52% (37536/141515)
Branch Coverage: 23.33% (19138/82026)
Coverage Report: http://coverage.selectdb-in.cc/coverage/c34c22a0e0fac2b4d70b65294cb6f75824d61502_c34c22a0e0fac2b4d70b65294cb6f75824d61502/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