You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "airborne12 (via GitHub)" <gi...@apache.org> on 2024/02/18 14:36:24 UTC
[PR] [Pick 2.0](inverted index) fix inverted index read data opt not work on MOW [doris]
airborne12 opened a new pull request, #31076:
URL: https://github.com/apache/doris/pull/31076
## Proposed changes
Issue Number: close #xxx
Pick from #31075
## 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] [Pick 2.0](inverted index) fix inverted index read data opt not work on MOW [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31076:
URL: https://github.com/apache/doris/pull/31076#issuecomment-1951356476
<details>
<summary>TPC-DS: <b>Total hot run time: 239295 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 f750c43a63e79fbaf5cbff2ae6d34d7ff736a9dc, data reload: false
query1 924 386 378 378
query2 6515 2142 2259 2142
query3 6911 207 201 201
query4 20143 17909 17956 17909
query5 19721 6523 6467 6467
query6 283 207 235 207
query7 4150 294 299 294
query8 244 218 235 218
query9 3187 2759 2657 2657
query10 412 315 308 308
query11 11410 10791 10668 10668
query12 127 74 76 74
query13 5587 642 625 625
query14 17695 13893 13275 13275
query15 383 244 237 237
query16 6439 266 262 262
query17 1724 1465 860 860
query18 2330 413 396 396
query19 206 138 140 138
query20 77 80 75 75
query21 184 99 96 96
query22 5315 5085 5136 5085
query23 32844 31916 32066 31916
query24 6993 6490 6465 6465
query25 531 433 414 414
query26 532 170 157 157
query27 1876 291 295 291
query28 6099 2241 2212 2212
query29 2988 2822 2697 2697
query30 240 166 160 160
query31 889 733 723 723
query32 60 61 60 60
query33 392 258 248 248
query34 869 484 472 472
query35 1128 912 871 871
query36 1706 1670 1689 1670
query37 91 61 58 58
query38 3090 2893 2929 2893
query39 1375 1318 1333 1318
query40 205 101 96 96
query41 33 31 35 31
query42 90 83 81 81
query43 645 590 706 590
query44 1154 712 719 712
query45 250 230 224 224
query46 1235 999 994 994
query47 1893 1728 1606 1606
query48 990 693 673 673
query49 617 367 375 367
query50 869 642 615 615
query51 5620 5448 5399 5399
query52 85 88 77 77
query53 441 319 313 313
query54 2672 2474 2461 2461
query55 95 77 88 77
query56 221 216 209 209
query57 1177 1173 1135 1135
query58 200 209 189 189
query59 3478 3301 3275 3275
query60 199 213 194 194
query61 96 83 80 80
query62 862 480 506 480
query63 474 331 332 331
query64 2416 1489 1428 1428
query65 3666 3552 3581 3552
query66 770 376 353 353
query67 16922 16528 15831 15831
query68 8373 670 686 670
query69 580 346 339 339
query70 1897 1818 1660 1660
query71 406 294 300 294
query72 6450 3372 3398 3372
query73 735 330 327 327
query74 6361 5901 5808 5808
query75 4661 3798 3762 3762
query76 4653 1162 1188 1162
query77 537 244 242 242
query78 32055 51333 47248 47248
query79 14671 639 648 639
query80 4414 373 380 373
query81 566 230 233 230
query82 908 96 94 94
query83 331 138 131 131
query84 256 68 66 66
query85 2125 282 273 273
query86 456 365 376 365
query87 3234 3021 3033 3021
query88 6839 2354 2334 2334
query89 388 311 289 289
query90 2509 218 216 216
query91 156 115 124 115
query92 57 55 54 54
query93 4889 601 564 564
query94 1657 204 207 204
query95 1119 1068 1051 1051
query96 658 331 331 331
query97 6491 6393 6381 6381
query98 195 161 162 161
query99 3699 979 949 949
Total cold run time: 345371 ms
Total hot run time: 239295 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] [Pick 2.0](inverted index) fix inverted index read data opt not work on MOW [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31076:
URL: https://github.com/apache/doris/pull/31076#issuecomment-1951352609
<details>
<summary>TPC-H: <b>Total hot run time: 49929 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 f750c43a63e79fbaf5cbff2ae6d34d7ff736a9dc, data reload: false
------ Round 1 ----------------------------------
q1 17873 4353 4306 4306
q2 2050 153 137 137
q3 10319 1895 1956 1895
q4 10098 1253 1314 1253
q5 8399 4004 4001 4001
q6 230 124 125 124
q7 2075 1624 1614 1614
q8 9308 2702 2698 2698
q9 10887 10491 10442 10442
q10 8642 3538 3506 3506
q11 429 237 248 237
q12 464 302 308 302
q13 18356 3997 3992 3992
q14 352 320 329 320
q15 517 446 468 446
q16 697 597 585 585
q17 1123 965 979 965
q18 7259 6846 6980 6846
q19 1679 1589 1513 1513
q20 516 310 323 310
q21 4454 4135 4054 4054
q22 500 383 401 383
Total cold run time: 116227 ms
Total hot run time: 49929 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4320 4308 4316 4308
q2 318 221 225 221
q3 4189 4152 4142 4142
q4 2754 2746 2744 2744
q5 7281 7221 7194 7194
q6 235 117 116 116
q7 3239 2878 2824 2824
q8 4344 4472 4454 4454
q9 17128 17083 16880 16880
q10 4259 4311 4266 4266
q11 757 675 697 675
q12 1018 862 850 850
q13 6805 3756 3746 3746
q14 462 428 404 404
q15 498 460 455 455
q16 761 717 711 711
q17 3798 3815 3906 3815
q18 8739 8773 8674 8674
q19 1722 1705 1657 1657
q20 2402 2156 2132 2132
q21 8577 8582 8655 8582
q22 1021 965 948 948
Total cold run time: 84627 ms
Total hot run time: 79798 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] [Pick 2.0](inverted index) fix inverted index read data opt not work on MOW [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #31076:
URL: https://github.com/apache/doris/pull/31076#issuecomment-1952285038
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] [Pick 2.0](inverted index) fix inverted index read data opt not work on MOW [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #31076:
URL: https://github.com/apache/doris/pull/31076#issuecomment-1951353976
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] [Pick 2.0](inverted index) fix inverted index read data opt not work on MOW [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31076:
URL: https://github.com/apache/doris/pull/31076#issuecomment-1951344846
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] [Pick 2.0](inverted index) fix inverted index read data opt not work on MOW [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31076:
URL: https://github.com/apache/doris/pull/31076#issuecomment-1951357916
<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 f750c43a63e79fbaf5cbff2ae6d34d7ff736a9dc, data reload: false
query1 0.02 0.02 0.02
query2 0.06 0.02 0.02
query3 0.24 0.05 0.04
query4 1.83 0.06 0.07
query5 0.53 0.53 0.53
query6 1.26 0.64 0.62
query7 0.02 0.02 0.01
query8 0.03 0.02 0.02
query9 0.52 0.48 0.48
query10 0.54 0.52 0.54
query11 0.11 0.08 0.09
query12 0.11 0.09 0.09
query13 0.62 0.62 0.62
query14 0.78 0.79 0.79
query15 0.77 0.77 0.77
query16 0.35 0.36 0.38
query17 1.01 1.00 1.03
query18 0.22 0.27 0.25
query19 1.93 1.80 1.79
query20 0.01 0.01 0.01
query21 15.48 0.61 0.55
query22 2.15 2.35 1.27
query23 17.64 1.09 0.92
query24 6.66 1.12 1.38
query25 1.44 0.11 0.11
query26 0.29 0.14 0.13
query27 0.11 0.12 0.11
query28 7.58 0.74 0.73
query29 12.74 2.39 2.30
query30 0.60 0.56 0.52
query31 2.82 0.37 0.39
query32 3.45 0.50 0.49
query33 3.08 3.06 3.11
query34 15.27 4.79 4.80
query35 4.84 4.87 4.84
query36 1.05 1.03 1.03
query37 0.06 0.04 0.04
query38 0.04 0.02 0.02
query39 0.01 0.02 0.02
query40 0.16 0.14 0.14
query41 0.06 0.01 0.02
query42 0.01 0.02 0.01
query43 0.03 0.01 0.02
Total cold run time: 106.53 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] [Pick 2.0](inverted index) fix inverted index read data opt not work on MOW [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31076:
URL: https://github.com/apache/doris/pull/31076#issuecomment-1952345962
<details>
<summary>TPC-DS: <b>Total hot run time: 241309 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 4641cb30e81062eee9d5fe58618e612da44685f7, data reload: false
query1 901 388 385 385
query2 6516 2230 2000 2000
query3 6920 206 201 201
query4 20822 18081 18098 18081
query5 19719 6477 6469 6469
query6 292 207 223 207
query7 4154 294 293 293
query8 260 238 231 231
query9 3110 2685 2620 2620
query10 428 277 301 277
query11 11340 10831 10795 10795
query12 121 80 75 75
query13 5576 656 622 622
query14 17876 13821 13291 13291
query15 355 234 246 234
query16 6434 275 265 265
query17 1698 1470 866 866
query18 2317 409 397 397
query19 208 144 142 142
query20 70 77 80 77
query21 179 93 93 93
query22 5317 5138 5149 5138
query23 32398 31984 31971 31971
query24 6943 6442 6483 6442
query25 498 445 412 412
query26 605 159 160 159
query27 2031 285 290 285
query28 6126 2203 2177 2177
query29 2963 2625 2877 2625
query30 240 163 159 159
query31 894 727 728 727
query32 65 60 56 56
query33 374 250 248 248
query34 856 479 478 478
query35 1092 921 904 904
query36 1546 1466 1381 1381
query37 90 58 63 58
query38 3068 2897 2868 2868
query39 1371 1317 1331 1317
query40 203 93 96 93
query41 33 30 35 30
query42 83 84 79 79
query43 668 607 592 592
query44 1085 709 728 709
query45 235 232 224 224
query46 1221 965 970 965
query47 1800 1645 1718 1645
query48 971 674 664 664
query49 611 372 363 363
query50 873 646 610 610
query51 5509 5493 5464 5464
query52 94 77 83 77
query53 435 320 318 318
query54 2662 2469 2482 2469
query55 102 79 91 79
query56 225 191 205 191
query57 1229 1072 1231 1072
query58 214 193 208 193
query59 3414 3299 3279 3279
query60 206 208 189 189
query61 82 83 81 81
query62 786 510 493 493
query63 475 335 348 335
query64 2322 1500 1365 1365
query65 3584 3541 3538 3538
query66 773 375 356 356
query67 15348 14775 15723 14775
query68 8668 639 661 639
query69 565 321 350 321
query70 1864 1606 1502 1502
query71 414 298 296 296
query72 6644 3388 3389 3388
query73 722 317 324 317
query74 6334 5920 5860 5860
query75 5132 3645 3693 3645
query76 5253 1133 1004 1004
query77 887 255 250 250
query78 32472 51159 53102 51159
query79 15296 644 618 618
query80 4757 373 379 373
query81 566 225 230 225
query82 1305 100 94 94
query83 332 135 135 135
query84 265 69 69 69
query85 1875 280 274 274
query86 442 364 364 364
query87 3247 2987 2986 2986
query88 7151 2307 2304 2304
query89 424 285 286 285
query90 2562 206 214 206
query91 153 124 119 119
query92 62 52 49 49
query93 6132 563 569 563
query94 1652 203 204 203
query95 1103 1063 1072 1063
query96 645 325 318 318
query97 6537 6422 6289 6289
query98 186 179 172 172
query99 3708 955 945 945
Total cold run time: 348371 ms
Total hot run time: 241309 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] [Pick 2.0](inverted index) fix inverted index read data opt not work on MOW [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31076:
URL: https://github.com/apache/doris/pull/31076#issuecomment-1952322173
<details>
<summary>TPC-H: <b>Total hot run time: 49697 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 4641cb30e81062eee9d5fe58618e612da44685f7, data reload: false
------ Round 1 ----------------------------------
q1 17823 4369 4391 4369
q2 2020 151 144 144
q3 10455 1873 1888 1873
q4 10347 1212 1319 1212
q5 8893 3931 3932 3931
q6 223 121 123 121
q7 1984 1578 1607 1578
q8 9284 2694 2716 2694
q9 10730 10592 10303 10303
q10 8614 3521 3531 3521
q11 415 249 243 243
q12 460 292 302 292
q13 18339 4002 3971 3971
q14 343 328 327 327
q15 496 459 467 459
q16 696 587 586 586
q17 1123 964 946 946
q18 7350 6893 6976 6893
q19 1660 1544 1476 1476
q20 537 297 312 297
q21 4465 4109 4065 4065
q22 496 413 396 396
Total cold run time: 116753 ms
Total hot run time: 49697 ms
----- Round 2, with runtime_filter_mode=off -----
q1 4277 4280 4267 4267
q2 314 218 220 218
q3 4172 4140 4122 4122
q4 2771 2727 2743 2727
q5 7252 7139 7227 7139
q6 232 115 118 115
q7 3198 2843 2820 2820
q8 4412 4406 4476 4406
q9 17070 16938 16950 16938
q10 4245 4237 4278 4237
q11 776 662 692 662
q12 1029 866 860 860
q13 6815 3743 3742 3742
q14 450 420 417 417
q15 497 455 449 449
q16 776 696 712 696
q17 3903 3896 3863 3863
q18 8771 8647 8700 8647
q19 1690 1680 1631 1631
q20 2355 2165 2090 2090
q21 8644 8494 8530 8494
q22 1042 977 936 936
Total cold run time: 84691 ms
Total hot run time: 79476 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] [Pick 2.0](inverted index) fix inverted index read data opt not work on MOW [doris]
Posted by "airborne12 (via GitHub)" <gi...@apache.org>.
airborne12 commented on PR #31076:
URL: https://github.com/apache/doris/pull/31076#issuecomment-1952275975
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] [Pick 2.0](inverted index) fix inverted index read data opt not work on MOW [doris]
Posted by "airborne12 (via GitHub)" <gi...@apache.org>.
airborne12 commented on PR #31076:
URL: https://github.com/apache/doris/pull/31076#issuecomment-1951344917
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] [Pick 2.0](inverted index) fix inverted index read data opt not work on MOW [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #31076:
URL: https://github.com/apache/doris/pull/31076#issuecomment-1951353966
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] [Pick 2.0](inverted index) fix inverted index read data opt not work on MOW [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31076:
URL: https://github.com/apache/doris/pull/31076#issuecomment-1952325126
TeamCity be ut coverage result:
Function Coverage: 37.83% (8035/21240)
Line Coverage: 29.49% (65494/222118)
Region Coverage: 28.96% (33698/116376)
Branch Coverage: 24.81% (17295/69716)
Coverage Report: http://coverage.selectdb-in.cc/coverage/4641cb30e81062eee9d5fe58618e612da44685f7_4641cb30e81062eee9d5fe58618e612da44685f7/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] [Pick 2.0](inverted index) fix inverted index read data opt not work on MOW [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31076:
URL: https://github.com/apache/doris/pull/31076#issuecomment-1952355016
<details>
<summary>ClickBench: <b>Total hot run time: 30.34 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 4641cb30e81062eee9d5fe58618e612da44685f7, data reload: false
query1 0.03 0.03 0.02
query2 0.06 0.02 0.02
query3 0.25 0.04 0.04
query4 1.84 0.08 0.08
query5 0.53 0.52 0.51
query6 1.25 0.61 0.60
query7 0.01 0.01 0.01
query8 0.03 0.02 0.02
query9 0.52 0.48 0.48
query10 0.53 0.53 0.53
query11 0.12 0.08 0.09
query12 0.12 0.09 0.10
query13 0.63 0.61 0.62
query14 0.78 0.79 0.78
query15 0.78 0.75 0.76
query16 0.38 0.36 0.37
query17 1.02 1.02 1.00
query18 0.22 0.26 0.26
query19 1.91 1.88 1.84
query20 0.01 0.01 0.01
query21 15.48 0.54 0.55
query22 1.99 2.27 1.62
query23 17.40 1.08 0.96
query24 6.56 0.60 1.57
query25 1.60 0.11 0.12
query26 0.30 0.14 0.13
query27 0.11 0.11 0.11
query28 6.35 0.71 0.70
query29 12.66 2.27 2.19
query30 0.66 0.54 0.49
query31 2.81 0.37 0.38
query32 3.42 0.49 0.49
query33 3.05 3.06 3.05
query34 15.52 4.80 4.80
query35 4.87 4.84 4.86
query36 1.05 1.01 1.02
query37 0.06 0.04 0.05
query38 0.04 0.02 0.02
query39 0.01 0.02 0.01
query40 0.15 0.14 0.15
query41 0.07 0.01 0.01
query42 0.02 0.02 0.01
query43 0.02 0.02 0.01
Total cold run time: 105.22 s
Total hot run time: 30.34 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] [Pick 2.0](inverted index) fix inverted index read data opt not work on MOW [doris]
Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #31076:
URL: https://github.com/apache/doris/pull/31076#issuecomment-1951346506
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] [Pick 2.0](inverted index) fix inverted index read data opt not work on MOW [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31076:
URL: https://github.com/apache/doris/pull/31076#issuecomment-1951352370
TeamCity be ut coverage result:
Function Coverage: 37.82% (8033/21240)
Line Coverage: 29.48% (65476/222115)
Region Coverage: 28.95% (33687/116373)
Branch Coverage: 24.80% (17290/69714)
Coverage Report: http://coverage.selectdb-in.cc/coverage/f750c43a63e79fbaf5cbff2ae6d34d7ff736a9dc_f750c43a63e79fbaf5cbff2ae6d34d7ff736a9dc/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] [Pick 2.0](inverted index) fix inverted index read data opt not work on MOW [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31076:
URL: https://github.com/apache/doris/pull/31076#issuecomment-1951358772
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit f750c43a63e79fbaf5cbff2ae6d34d7ff736a9dc with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 21.5 seconds inserted 10000000 Rows, about 465K ops/s
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org
Re: [PR] [Pick 2.0](inverted index) fix inverted index read data opt not work on MOW [doris]
Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #31076:
URL: https://github.com/apache/doris/pull/31076#issuecomment-1952360700
Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
```
Load test result on commit 4641cb30e81062eee9d5fe58618e612da44685f7 with default session variables
Stream load json: 19 seconds loaded 2358488459 Bytes, about 118 MB/s
Stream load orc: 58 seconds loaded 1101869774 Bytes, about 18 MB/s
Stream load parquet: 31 seconds loaded 861443392 Bytes, about 26 MB/s
Insert into select: 21.6 seconds inserted 10000000 Rows, about 462K 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] [Pick 2.0](inverted index) fix inverted index read data opt not work on MOW [doris]
Posted by "xiaokang (via GitHub)" <gi...@apache.org>.
xiaokang merged PR #31076:
URL: https://github.com/apache/doris/pull/31076
--
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