Re: [PR] [draft] Collect bloom runtime filter filtering statistics. [doris]

2025-01-21 Thread via GitHub


doris-robot commented on PR #47305:
URL: https://github.com/apache/doris/pull/47305#issuecomment-2606515349

   TeamCity be ut coverage result:
Function Coverage: 41.56% (10835/26069) 
Line Coverage: 31.96% (91573/286554)
Region Coverage: 31.09% (46903/150849)
Branch Coverage: 27.18% (23756/87392)
Coverage Report: 
http://coverage.selectdb-in.cc/coverage/14f578fc2bd97d39702c981ca30003460d247875_14f578fc2bd97d39702c981ca30003460d247875/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-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org



Re: [PR] [draft] Collect bloom runtime filter filtering statistics. [doris]

2025-01-21 Thread via GitHub


doris-robot commented on PR #47305:
URL: https://github.com/apache/doris/pull/47305#issuecomment-2606460967

   
   
   ClickBench: Total hot run time: 30.16 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 14f578fc2bd97d39702c981ca30003460d247875, 
data reload: false
   
   query1   0.040.030.02
   query2   0.070.040.03
   query3   0.240.070.06
   query4   1.610.110.10
   query5   0.420.430.43
   query6   1.160.660.65
   query7   0.030.020.01
   query8   0.040.030.03
   query9   0.590.520.52
   query10  0.540.590.55
   query11  0.130.110.10
   query12  0.130.110.10
   query13  0.610.590.61
   query14  2.802.732.79
   query15  0.890.820.82
   query16  0.380.380.38
   query17  1.081.061.01
   query18  0.240.200.20
   query19  1.911.802.04
   query20  0.010.020.01
   query21  15.37   0.930.58
   query22  0.760.860.74
   query23  15.21   1.420.57
   query24  2.690.341.51
   query25  0.200.170.10
   query26  0.260.150.14
   query27  0.040.060.04
   query28  13.76   1.140.44
   query29  12.59   4.073.33
   query30  0.240.090.07
   query31  2.820.610.38
   query32  3.220.540.45
   query33  3.033.023.03
   query34  16.65   5.164.52
   query35  4.544.494.62
   query36  0.660.490.48
   query37  0.100.060.06
   query38  0.040.040.04
   query39  0.030.030.03
   query40  0.160.130.13
   query41  0.080.020.02
   query42  0.040.020.02
   query43  0.040.030.03
   Total cold run time: 105.45 s
   Total hot run time: 30.16 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-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org



Re: [PR] [draft] Collect bloom runtime filter filtering statistics. [doris]

2025-01-21 Thread via GitHub


doris-robot commented on PR #47305:
URL: https://github.com/apache/doris/pull/47305#issuecomment-2606453712

   
   
   TPC-DS: Total hot run time: 186963 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit 14f578fc2bd97d39702c981ca30003460d247875, 
data reload: false
   
   query1   973 376 382 376
   query2   6529196120101961
   query3   6795214 217 214
   query4   33507   23328   22929   22929
   query5   4359611 449 449
   query6   294 218 183 183
   query7   4600503 327 327
   query8   296 254 228 228
   query9   9673260425812581
   query10  479 331 248 248
   query11  18110   15054   15086   15054
   query12  156 110 112 110
   query13  1668516 400 400
   query14  9501657575086575
   query15  252 195 208 195
   query16  7864579 462 462
   query17  1621694 566 566
   query18  1287350 283 283
   query19  222 175 149 149
   query20  121 109 107 107
   query21  206 122 101 101
   query22  4371445943414341
   query23  34665   33069   33182   33069
   query24  6789223722432237
   query25  498 450 394 394
   query26  1085277 149 149
   query27  2121462 329 329
   query28  5341242123912391
   query29  629 542 406 406
   query30  237 182 158 158
   query31  971 880 773 773
   query32  84  61  67  61
   query33  545 345 329 329
   query34  735 865 498 498
   query35  822 812 731 731
   query36  10181030964 964
   query37  132 104 83  83
   query38  4077421040984098
   query39  1435140813971397
   query40  205 114 100 100
   query41  52  52  54  52
   query42  123 101 102 101
   query43  501 510 476 476
   query44  1352812 810 810
   query45  182 177 167 167
   query46  850 1058642 642
   query47  1838182617691769
   query48  385 394 320 320
   query49  770 501 401 401
   query50  615 645 394 394
   query51  6843690767786778
   query52  100 102 94  94
   query53  217 244 197 197
   query54  480 477 416 416
   query55  80  78  81  78
   query56  265 270 247 247
   query57  1191113710651065
   query58  253 222 232 222
   query59  3004299028042804
   query60  281 277 263 263
   query61  116 120 112 112
   query62  823 726 634 634
   query63  220 191 185 185
   query64  41081026673 673
   query65  3230319731973197
   query66  838 408 303 303
   query67  15864   15586   15373   15373
   query68  4345810 527 527
   query69  446 281 263 263
   query70  1171118911641164
   query71  372 285 268 268
   query72  5979379738923797
   query73  634 757 356 356
   query74  9840920786558655
   query75  3177315726912691
   query76  30721196774 774
   query77  458 355 287 287
   query78  996910115   93769376
   query79  2322816 582 582
   query80  650 521 452 452
   query81  522 271 243 243
   query82  226 154 124 124
   query83  178 173 148 148
   query84  253 97  74  74
   query85  816 440 291 291
   query86  392 318 297 297
   query87  4386448845124488
   query88  3549220821462146
   query89  399 325 296 296
   query90  1724191 190 190
   query91  137 138 109 109
   query92  62  56  52  52
   query93  1258862 526 526
   query94  587 414 309 309
   query95  325 263 250 250
   query96  492 612 284 284
   query97  2768285627012701
   query98  240 197 195 195
   query99  1286138012691269
   Total cold run time: 280889 ms
   Total hot run time: 186963 ms
   ```
   
   


-- 
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

Re: [PR] [draft] Collect bloom runtime filter filtering statistics. [doris]

2025-01-21 Thread via GitHub


doris-robot commented on PR #47305:
URL: https://github.com/apache/doris/pull/47305#issuecomment-2606437627

   
   
   TPC-H: Total hot run time: 32520 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 14f578fc2bd97d39702c981ca30003460d247875, 
data reload: false
   
   -- Round 1 --
   q1   17583   569954135413
   q2   2061312 179 179
   q3   10472   1287735 735
   q4   10218   984 568 568
   q5   7610242222062206
   q6   198 172 137 137
   q7   911 773 627 627
   q8   9257138911421142
   q9   5183507948694869
   q10  6846235018901890
   q11  481 270 263 263
   q12  345 357 223 223
   q13  17783   372631213121
   q14  240 252 212 212
   q15  513 488 475 475
   q16  637 640 587 587
   q17  585 879 330 330
   q18  7466645865866458
   q19  2628950 554 554
   q20  302 317 204 204
   q21  2907219320092009
   q22  368 336 318 318
   Total cold run time: 104594 ms
   Total hot run time: 32520 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5630558055375537
   q2   241 338 235 235
   q3   2263267623612361
   q4   1434185014031403
   q5   4360477848734778
   q6   171 169 131 131
   q7   2128202618971897
   q8   2609285827332733
   q9   7352715472627154
   q10  3015330727942794
   q11  625 510 512 510
   q12  696 815 627 627
   q13  3581390432263226
   q14  289 299 287 287
   q15  521 478 486 478
   q16  637 709 644 644
   q17  1213173612431243
   q18  7732758973437343
   q19  790 120110901090
   q20  2011202319081908
   q21  5705527448774877
   q22  616 632 568 568
   Total cold run time: 53619 ms
   Total hot run time: 51824 ms
   ```
   
   


-- 
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-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org



Re: [PR] [draft] Collect bloom runtime filter filtering statistics. [doris]

2025-01-21 Thread via GitHub


Mryange commented on PR #47305:
URL: https://github.com/apache/doris/pull/47305#issuecomment-2606329898

   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-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org



Re: [PR] [draft] Collect bloom runtime filter filtering statistics. [doris]

2025-01-21 Thread via GitHub


hello-stephen commented on PR #47305:
URL: https://github.com/apache/doris/pull/47305#issuecomment-2606329418

   
   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).
   
   Please clearly describe your PR:
   1. What problem was fixed (it's best to include specific error reporting 
information). How it was fixed.
   2. Which behaviors were modified. What was the previous behavior, what is it 
now, why was it modified, and what possible impacts might there be.
   3. What features were added. Why was this function added?
   4. Which code was refactored and why was this part of the code refactored?
   5. Which functions were optimized and what is the difference before and 
after the optimization?
   


-- 
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-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org