Re: [PR] [opt](inverted index) optimize inverted index parameter validation [doris]

2025-05-29 Thread via GitHub


airborne12 merged PR #51090:
URL: https://github.com/apache/doris/pull/51090


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [opt](inverted index) optimize inverted index parameter validation [doris]

2025-05-26 Thread via GitHub


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

   # BE UT Coverage Report
   Increment line coverage ` ` :tada:
   
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/e5074201566ba6e551269883fc15643d282f9129_e5074201566ba6e551269883fc15643d282f9129/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/e5074201566ba6e551269883fc15643d282f9129_e5074201566ba6e551269883fc15643d282f9129/report/index.html)
   | Category  | Coverage   |
   |---||
   | Function Coverage | 56.01% (14922/26644) |
   | Line Coverage | 44.83% (132863/296391) |
   | Region Coverage   | 43.90% (66782/152132) |
   | Branch Coverage   | 38.53% (34273/88948) |


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [opt](inverted index) optimize inverted index parameter validation [doris]

2025-05-25 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 29.77 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit e5074201566ba6e551269883fc15643d282f9129, 
data reload: false
   
   query1   0.030.040.03
   query2   0.130.100.11
   query3   0.270.190.19
   query4   1.600.190.10
   query5   0.450.430.41
   query6   1.170.660.66
   query7   0.030.010.02
   query8   0.040.030.04
   query9   0.570.520.52
   query10  0.570.580.56
   query11  0.160.100.11
   query12  0.150.120.12
   query13  0.620.600.60
   query14  0.820.800.82
   query15  0.870.860.87
   query16  0.400.380.38
   query17  1.041.061.07
   query18  0.230.210.21
   query19  1.941.861.88
   query20  0.010.010.02
   query21  15.40   0.930.53
   query22  0.761.210.75
   query23  14.84   1.410.66
   query24  6.731.751.49
   query25  0.520.200.08
   query26  0.600.160.14
   query27  0.060.050.05
   query28  9.800.880.45
   query29  12.53   4.073.28
   query30  0.250.100.06
   query31  2.820.610.38
   query32  3.230.560.48
   query33  3.093.183.05
   query34  15.84   5.154.48
   query35  4.514.514.50
   query36  0.670.520.49
   query37  0.090.060.06
   query38  0.050.040.03
   query39  0.030.020.03
   query40  0.170.130.12
   query41  0.080.020.02
   query42  0.030.030.02
   query43  0.040.040.02
   Total cold run time: 103.24 s
   Total hot run time: 29.77 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [opt](inverted index) optimize inverted index parameter validation [doris]

2025-05-25 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 193909 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 e5074201566ba6e551269883fc15643d282f9129, 
data reload: false
   
   query1   1430111510631063
   query2   6234178618131786
   query3   11016   475845814581
   query4   52428   26180   23803   23803
   query5   5239578 479 479
   query6   375 212 212 212
   query7   4942544 310 310
   query8   347 259 242 242
   query9   6487266926212621
   query10  442 354 280 280
   query11  15240   15123   14879   14879
   query12  159 113 108 108
   query13  1101534 429 429
   query14  10200   643665966436
   query15  216 197 176 176
   query16  7151641 438 438
   query17  1061752 583 583
   query18  1599418 317 317
   query19  204 204 171 171
   query20  141 127 128 127
   query21  210 129 113 113
   query22  4427446342794279
   query23  34500   33612   33704   33612
   query24  6590247324932473
   query25  470 472 410 410
   query26  702 283 161 161
   query27  2589547 352 352
   query28  3271217721502150
   query29  592 583 438 438
   query30  278 223 202 202
   query31  901 845 779 779
   query32  77  68  63  63
   query33  471 456 332 332
   query34  812 906 553 553
   query35  824 820 778 778
   query36  954 1018927 927
   query37  120 106 82  82
   query38  4311438542654265
   query39  1534151215121512
   query40  209 133 107 107
   query41  59  55  53  53
   query42  137 123 112 112
   query43  509 520 474 474
   query44  1413842 848 842
   query45  181 182 178 178
   query46  929 1073676 676
   query47  1878184917911791
   query48  439 446 329 329
   query49  710 534 432 432
   query50  719 725 426 426
   query51  4301425342814253
   query52  118 121 108 108
   query53  238 275 195 195
   query54  614 601 520 520
   query55  93  87  87  87
   query56  332 319 326 319
   query57  1130115611131113
   query58  280 277 270 270
   query59  2545259625552555
   query60  366 343 332 332
   query61  176 148 143 143
   query62  708 745 668 668
   query63  234 195 197 195
   query64  1856737 737
   query65  4388423542014201
   query66  742 399 310 310
   query67  15967   15443   15517   15443
   query68  6587910 523 523
   query69  545 308 271 271
   query70  1143114911151115
   query71  533 328 303 303
   query72  5724495750054957
   query73  1351712 356 356
   query74  9337909486098609
   query75  3986323627112711
   query76  43091206793 793
   query77  678 381 304 304
   query78  10030   10111   93819381
   query79  5019793 561 561
   query80  707 516 458 458
   query81  499 258 226 226
   query82  552 130 113 113
   query83  317 265 233 233
   query84  297 113 87  87
   query85  796 357 320 320
   query86  369 320 260 260
   query87  4468447643514351
   query88  3512233023172317
   query89  447 323 282 282
   query90  1941215 214 214
   query91  142 145 114 114
   query92  73  63  54  54
   query93  2719951 573 573
   query94  665 452 287 287
   query95  376 294 285 285
   query96  499 586 280 280
   query97  2737274426942694
   query98  237 213 212 212
   query99  1424140112741274
   Total cold run time: 302935 ms
   Total hot run time: 193909 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

Re: [PR] [opt](inverted index) optimize inverted index parameter validation [doris]

2025-05-25 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 34174 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit e5074201566ba6e551269883fc15643d282f9129, 
data reload: false
   
   -- Round 1 --
   q1   26664   516051515151
   q2   2097294 195 195
   q3   10479   1318733 733
   q4   10233   1086536 536
   q5   7586242323622362
   q6   183 169 134 134
   q7   888 734 615 615
   q8   9308129411081108
   q9   6815513750695069
   q10  6871232818991899
   q11  514 298 278 278
   q12  364 376 225 225
   q13  17805   371731003100
   q14  222 229 219 219
   q15  542 474 483 474
   q16  437 432 381 381
   q17  587 865 373 373
   q18  7793720271747174
   q19  1778953 559 559
   q20  336 338 219 219
   q21  3934325223942394
   q22  10281029976 976
   Total cold run time: 116464 ms
   Total hot run time: 34174 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5292512751645127
   q2   245 327 229 229
   q3   2131267922562256
   q4   1406183215081508
   q5   4439450243824382
   q6   221 174 131 131
   q7   1978200317511751
   q8   2622255625202520
   q9   7236719370777077
   q10  2993319427612761
   q11  565 519 475 475
   q12  712 766 627 627
   q13  3551394733723372
   q14  309 313 269 269
   q15  511 475 473 473
   q16  432 483 446 446
   q17  1165156014091409
   q18  7706762974417441
   q19  811 842 943 842
   q20  2055202418461846
   q21  4957461544394439
   q22  1100111010271027
   Total cold run time: 52437 ms
   Total hot run time: 50408 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [opt](inverted index) optimize inverted index parameter validation [doris]

2025-05-25 Thread via GitHub


zzzxl1993 commented on PR #51090:
URL: https://github.com/apache/doris/pull/51090#issuecomment-2908385712

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [opt](inverted index) optimize inverted index parameter validation [doris]

2025-05-22 Thread via GitHub


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

   # BE Regression && UT Coverage Report
   Increment line coverage ` ` :tada:
   
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/51090_72b650eba869e4223e2b26386fda108732ac368f_merge/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/51090_72b650eba869e4223e2b26386fda108732ac368f_merge/report/index.html)
   | Category  | Coverage   |
   |---||
   | Function Coverage | 79.62% (20879/26223) |
   | Line Coverage | 72.82% (215739/296263) |
   | Region Coverage   | 70.97% (126795/178653) |
   | Branch Coverage   | 64.80% (65809/101558) |


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [opt](inverted index) optimize inverted index parameter validation [doris]

2025-05-22 Thread via GitHub


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

   # BE Regression && UT Coverage Report
   Increment line coverage ` ` :tada:
   
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/51090_72b650eba869e4223e2b26386fda108732ac368f_merge/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/51090_72b650eba869e4223e2b26386fda108732ac368f_merge/report/index.html)
   | Category  | Coverage   |
   |---||
   | Function Coverage | 79.62% (20879/26223) |
   | Line Coverage | 72.82% (215739/296263) |
   | Region Coverage   | 70.97% (126795/178653) |
   | Branch Coverage   | 64.80% (65809/101558) |


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [opt](inverted index) optimize inverted index parameter validation [doris]

2025-05-22 Thread via GitHub


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

   # BE Regression && UT Coverage Report
   Increment line coverage ` ` :tada:
   
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/51090_72b650eba869e4223e2b26386fda108732ac368f_merge/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/51090_72b650eba869e4223e2b26386fda108732ac368f_merge/report/index.html)
   | Category  | Coverage   |
   |---||
   | Function Coverage | 79.54% (20858/26223) |
   | Line Coverage | 72.69% (215357/296263) |
   | Region Coverage   | 70.82% (126527/178653) |
   | Branch Coverage   | 64.59% (65593/101558) |


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [opt](inverted index) optimize inverted index parameter validation [doris]

2025-05-22 Thread via GitHub


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

   # BE UT Coverage Report
   Increment line coverage ` ` :tada:
   
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/72b650eba869e4223e2b26386fda108732ac368f_72b650eba869e4223e2b26386fda108732ac368f/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/72b650eba869e4223e2b26386fda108732ac368f_72b650eba869e4223e2b26386fda108732ac368f/report/index.html)
   | Category  | Coverage   |
   |---||
   | Function Coverage | 56.01% (14920/26640) |
   | Line Coverage | 44.80% (132734/296276) |
   | Region Coverage   | 43.87% (66723/152109) |
   | Branch Coverage   | 38.50% (34234/88920) |


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [opt](inverted index) optimize inverted index parameter validation [doris]

2025-05-22 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 29.8 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 72b650eba869e4223e2b26386fda108732ac368f, 
data reload: false
   
   query1   0.030.040.03
   query2   0.120.120.11
   query3   0.250.200.20
   query4   1.600.190.19
   query5   0.450.440.44
   query6   1.170.660.66
   query7   0.030.020.02
   query8   0.040.030.03
   query9   0.590.520.51
   query10  0.570.570.58
   query11  0.160.110.11
   query12  0.150.120.11
   query13  0.620.600.60
   query14  0.780.810.81
   query15  0.870.870.85
   query16  0.380.380.40
   query17  1.031.071.01
   query18  0.230.210.20
   query19  1.921.811.80
   query20  0.010.020.01
   query21  15.41   0.910.53
   query22  0.751.340.99
   query23  14.70   1.350.63
   query24  6.641.731.07
   query25  0.520.150.14
   query26  0.670.170.13
   query27  0.060.040.05
   query28  10.12   0.850.47
   query29  12.61   3.913.31
   query30  0.250.090.07
   query31  2.820.580.39
   query32  3.240.550.48
   query33  3.103.093.03
   query34  15.75   5.144.54
   query35  4.594.544.56
   query36  0.670.490.48
   query37  0.080.060.07
   query38  0.050.040.04
   query39  0.030.020.02
   query40  0.170.150.13
   query41  0.080.020.02
   query42  0.030.020.02
   query43  0.030.030.03
   Total cold run time: 103.37 s
   Total hot run time: 29.8 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [opt](inverted index) optimize inverted index parameter validation [doris]

2025-05-22 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 192445 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 72b650eba869e4223e2b26386fda108732ac368f, 
data reload: false
   
   query1   1388110710491049
   query2   6431175918391759
   query3   11058   458446784584
   query4   26039   23996   23089   23089
   query5   4635636 450 450
   query6   305 207 206 206
   query7   3994503 293 293
   query8   298 257 243 243
   query9   8502266226752662
   query10  483 335 269 269
   query11  15381   15123   14792   14792
   query12  161 112 108 108
   query13  1572533 405 405
   query14  9058622261136113
   query15  202 190 172 172
   query16  7597653 459 459
   query17  1166729 600 600
   query18  2003414 336 336
   query19  198 191 163 163
   query20  127 123 122 122
   query21  213 126 113 113
   query22  4520457243584358
   query23  34682   33793   33482   33482
   query24  8380241724172417
   query25  499 483 425 425
   query26  990 269 149 149
   query27  2777510 342 342
   query28  4575219021942190
   query29  629 579 461 461
   query30  273 223 197 197
   query31  884 876 788 788
   query32  74  64  68  64
   query33  540 374 312 312
   query34  801 879 537 537
   query35  813 824 740 740
   query36  953 1038903 903
   query37  108 98  76  76
   query38  4278428842404240
   query39  1495146414351435
   query40  207 122 105 105
   query41  59  88  53  53
   query42  123 113 121 113
   query43  514 508 485 485
   query44  1349868 841 841
   query45  194 170 166 166
   query46  854 1022645 645
   query47  1855191418021802
   query48  400 427 340 340
   query49  727 511 430 430
   query50  678 721 418 418
   query51  4384426242514251
   query52  116 110 111 110
   query53  233 273 184 184
   query54  590 591 501 501
   query55  89  85  88  85
   query56  308 293 307 293
   query57  1209120011761176
   query58  269 270 272 270
   query59  2639278326972697
   query60  349 338 334 334
   query61  153 145 170 145
   query62  792 740 685 685
   query63  231 189 193 189
   query64  33091088704 704
   query65  4441429442564256
   query66  807 395 303 303
   query67  15832   15589   15402   15402
   query68  8219895 530 530
   query69  498 309 275 275
   query70  1201110911341109
   query71  468 328 303 303
   query72  5671485550384855
   query73  726 676 361 361
   query74  8996923886788678
   query75  3966321026702670
   query76  37421192756 756
   query77  788 364 278 278
   query78  995510191   93709370
   query79  2020815 573 573
   query80  602 513 444 444
   query81  477 254 212 212
   query82  412 128 94  94
   query83  248 255 227 227
   query84  241 98  82  82
   query85  871 356 312 312
   query86  325 303 274 274
   query87  4380444143384338
   query88  3556234023042304
   query89  406 327 284 284
   query90  1912210 209 209
   query91  160 148 112 112
   query92  80  58  54  54
   query93  1397946 585 585
   query94  663 417 298 298
   query95  369 293 285 285
   query96  508 599 283 283
   query97  2783279627082708
   query98  240 219 200 200
   query99  1607138512961296
   Total cold run time: 278280 ms
   Total hot run time: 192445 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 

Re: [PR] [opt](inverted index) optimize inverted index parameter validation [doris]

2025-05-22 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 33810 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 72b650eba869e4223e2b26386fda108732ac368f, 
data reload: false
   
   -- Round 1 --
   q1   26125   511249984998
   q2   2067278 178 178
   q3   10625   1276718 718
   q4   10256   1008561 561
   q5   7562233523192319
   q6   179 160 130 130
   q7   929 740 619 619
   q8   9780128010601060
   q9   6898511951455119
   q10  6863232118831883
   q11  488 304 274 274
   q12  345 345 214 214
   q13  17781   369030453045
   q14  226 227 208 208
   q15  529 493 476 476
   q16  420 439 372 372
   q17  605 833 390 390
   q18  7402716370827082
   q19  1365975 578 578
   q20  345 358 227 227
   q21  3613320223682368
   q22  10431036991 991
   Total cold run time: 115446 ms
   Total hot run time: 33810 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5120508051005080
   q2   234 325 233 233
   q3   2113263123092309
   q4   1378176213481348
   q5   4398439343554355
   q6   214 169 130 130
   q7   1997192717991799
   q8   2583255826132558
   q9   7211714269346934
   q10  3035317627862786
   q11  582 525 497 497
   q12  664 785 586 586
   q13  3492383233503350
   q14  302 302 266 266
   q15  509 476 478 476
   q16  442 491 458 458
   q17  1167150413681368
   q18  7913746174897461
   q19  815 803 878 803
   q20  2023204218951895
   q21  4688449343874387
   q22  1133102310411023
   Total cold run time: 52013 ms
   Total hot run time: 50102 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [opt](inverted index) optimize inverted index parameter validation [doris]

2025-05-22 Thread via GitHub


zzzxl1993 commented on PR #51090:
URL: https://github.com/apache/doris/pull/51090#issuecomment-2903075135

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [opt](inverted index) optimize inverted index parameter validation [doris]

2025-05-22 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 29.01 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 72b650eba869e4223e2b26386fda108732ac368f, 
data reload: false
   
   query1   0.040.040.04
   query2   0.120.110.11
   query3   0.250.200.19
   query4   1.600.190.11
   query5   0.430.420.43
   query6   1.160.680.66
   query7   0.020.020.01
   query8   0.050.040.03
   query9   0.600.520.51
   query10  0.560.590.57
   query11  0.150.110.11
   query12  0.150.120.12
   query13  0.620.600.60
   query14  0.800.820.81
   query15  0.900.860.88
   query16  0.390.410.36
   query17  1.031.061.07
   query18  0.230.210.21
   query19  1.981.881.89
   query20  0.020.020.01
   query21  15.40   0.880.54
   query22  0.751.130.68
   query23  14.97   1.420.66
   query24  7.820.960.35
   query25  0.490.210.13
   query26  0.730.160.14
   query27  0.050.050.05
   query28  8.810.990.46
   query29  12.54   4.163.48
   query30  0.260.100.06
   query31  2.830.620.40
   query32  3.230.550.46
   query33  3.013.093.11
   query34  15.70   5.194.52
   query35  4.584.584.51
   query36  0.670.490.48
   query37  0.100.070.06
   query38  0.050.030.03
   query39  0.030.030.03
   query40  0.170.140.14
   query41  0.080.030.02
   query42  0.030.030.02
   query43  0.040.040.03
   Total cold run time: 103.44 s
   Total hot run time: 29.01 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [opt](inverted index) optimize inverted index parameter validation [doris]

2025-05-22 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 185688 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 72b650eba869e4223e2b26386fda108732ac368f, 
data reload: false
   
   query1   1008482 501 482
   query2   6574186918521852
   query3   6759231 224 224
   query4   26503   24056   23650   23650
   query5   4360644 460 460
   query6   297 205 198 198
   query7   4639502 292 292
   query8   316 256 258 256
   query9   8636263526572635
   query10  512 363 313 313
   query11  15433   15143   14810   14810
   query12  161 111 104 104
   query13  1640537 407 407
   query14  8689616261316131
   query15  218 196 176 176
   query16  7141665 472 472
   query17  945 760 588 588
   query18  1960396 309 309
   query19  228 193 168 168
   query20  122 121 120 120
   query21  216 132 113 113
   query22  4048411541994115
   query23  34152   33071   33070   33070
   query24  8520235723872357
   query25  562 443 387 387
   query26  1238274 153 153
   query27  2759499 349 349
   query28  4340214521262126
   query29  785 547 449 449
   query30  288 217 188 188
   query31  920 851 761 761
   query32  79  66  64  64
   query33  579 378 312 312
   query34  798 864 530 530
   query35  787 801 727 727
   query36  980 1020887 887
   query37  112 101 78  78
   query38  4084413540464046
   query39  1473143514581435
   query40  212 121 107 107
   query41  56  55  55  55
   query42  129 113 109 109
   query43  510 521 500 500
   query44  1291832 804 804
   query45  176 175 167 167
   query46  858 1048635 635
   query47  1806180517521752
   query48  374 431 332 332
   query49  785 503 433 433
   query50  640 679 412 412
   query51  4192416841294129
   query52  112 107 98  98
   query53  237 256 191 191
   query54  593 569 515 515
   query55  92  94  92  92
   query56  335 339 311 311
   query57  1129115810681068
   query58  276 261 258 258
   query59  2644278327322732
   query60  345 343 331 331
   query61  157 151 155 151
   query62  799 726 699 699
   query63  225 187 218 187
   query64  44691014694 694
   query65  4289425342724253
   query66  1158418 326 326
   query67  15901   15650   15408   15408
   query68  7818886 535 535
   query69  486 302 275 275
   query70  1199119610981098
   query71  420 338 311 311
   query72  5648346651123466
   query73  740 761 344 344
   query74  9177883087208720
   query75  3446321827492749
   query76  32531178757 757
   query77  633 377 284 284
   query78  10033   10259   93589358
   query79  1905828 593 593
   query80  586 529 462 462
   query81  494 262 223 223
   query82  186 130 98  98
   query83  259 249 252 249
   query84  303 109 86  86
   query85  808 360 331 331
   query86  380 302 280 280
   query87  4523441843434343
   query88  3503227222552255
   query89  392 328 286 286
   query90  1978215 213 213
   query91  144 142 116 116
   query92  84  59  57  57
   query93  1932981 583 583
   query94  673 418 306 306
   query95  381 290 291 290
   query96  503 574 285 285
   query97  2730277026742674
   query98  235 222 201 201
   query99  1335141013171317
   Total cold run time: 272838 ms
   Total hot run time: 185688 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] [opt](inverted index) optimize inverted index parameter validation [doris]

2025-05-22 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 34245 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 72b650eba869e4223e2b26386fda108732ac368f, 
data reload: false
   
   -- Round 1 --
   q1   26919   518050785078
   q2   2076284 189 189
   q3   10398   1268727 727
   q4   10251   988 555 555
   q5   8433249023422342
   q6   278 164 135 135
   q7   934 754 622 622
   q8   9337130711371137
   q9   6961509951205099
   q10  6846231118871887
   q11  495 294 287 287
   q12  344 355 223 223
   q13  17765   366231433143
   q14  242 227 214 214
   q15  536 483 486 483
   q16  427 430 384 384
   q17  629 880 368 368
   q18  7670721272097209
   q19  1307962 573 573
   q20  346 344 224 224
   q21  3810318823862386
   q22  10281004980 980
   Total cold run time: 117032 ms
   Total hot run time: 34245 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5177510851285108
   q2   250 330 234 234
   q3   2199266022762276
   q4   1373184215141514
   q5   4530445643844384
   q6   213 166 128 128
   q7   1954202717561756
   q8   2572251725402517
   q9   7139717270857085
   q10  3006318427412741
   q11  583 523 491 491
   q12  687 795 612 612
   q13  3621399632773277
   q14  296 304 296 296
   q15  522 493 467 467
   q16  453 513 462 462
   q17  1173158713771377
   q18  7843764674207420
   q19  824 830 941 830
   q20  1980206419021902
   q21  4863452543814381
   q22  1112105510211021
   Total cold run time: 52370 ms
   Total hot run time: 50279 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [opt](inverted index) optimize inverted index parameter validation [doris]

2025-05-22 Thread via GitHub


zzzxl1993 commented on PR #51090:
URL: https://github.com/apache/doris/pull/51090#issuecomment-2900366988

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [opt](inverted index) optimize inverted index parameter validation [doris]

2025-05-22 Thread via GitHub


zzzxl1993 commented on PR #51090:
URL: https://github.com/apache/doris/pull/51090#issuecomment-2900167773

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [opt](inverted index) optimize inverted index parameter validation [doris]

2025-05-20 Thread via GitHub


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

   # BE UT Coverage Report
   Increment line coverage ` ` :tada:
   
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/d03c4ec06215e9136cd9208f3f14e9e628d0bf0d_d03c4ec06215e9136cd9208f3f14e9e628d0bf0d/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/d03c4ec06215e9136cd9208f3f14e9e628d0bf0d_d03c4ec06215e9136cd9208f3f14e9e628d0bf0d/report/index.html)
   | Category  | Coverage   |
   |---||
   | Function Coverage | 55.95% (14925/26676) |
   | Line Coverage | 44.76% (132406/295784) |
   | Region Coverage   | 43.86% (66614/151883) |
   | Branch Coverage   | 38.45% (34130/88774) |


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [opt](inverted index) optimize inverted index parameter validation [doris]

2025-05-20 Thread via GitHub


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

   
   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [opt](inverted index) optimize inverted index parameter validation [doris]

2025-05-20 Thread via GitHub


zzzxl1993 commented on PR #51090:
URL: https://github.com/apache/doris/pull/51090#issuecomment-2893932627

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]