Re: [PR] branch-3.0: [bugfix](nerids) align locate function behavior with BE side #50797 [doris]

2025-05-12 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 31.88 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 4b77982392aad69c351bc8121ba46abb864aa2c9, 
data reload: false
   
   query1   0.030.030.03
   query2   0.060.030.03
   query3   0.230.070.07
   query4   1.630.100.10
   query5   0.510.500.54
   query6   1.140.720.73
   query7   0.020.010.02
   query8   0.040.030.05
   query9   0.550.500.51
   query10  0.550.560.56
   query11  0.140.100.10
   query12  0.140.120.12
   query13  0.600.600.60
   query14  2.872.732.76
   query15  0.880.830.83
   query16  0.370.380.37
   query17  0.991.091.00
   query18  0.240.200.22
   query19  1.941.872.03
   query20  0.010.020.01
   query21  15.37   0.580.57
   query22  2.372.812.18
   query23  16.93   1.000.92
   query24  2.570.340.86
   query25  0.380.060.15
   query26  0.270.140.14
   query27  0.060.050.04
   query28  11.76   0.510.46
   query29  12.62   3.183.16
   query30  0.250.060.06
   query31  2.850.390.40
   query32  3.240.470.45
   query33  2.983.023.06
   query34  17.07   4.464.40
   query35  4.524.534.54
   query36  0.660.490.47
   query37  0.090.060.06
   query38  0.040.030.04
   query39  0.040.020.02
   query40  0.150.130.13
   query41  0.090.030.02
   query42  0.040.020.02
   query43  0.050.030.03
   Total cold run time: 107.34 s
   Total hot run time: 31.88 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] branch-3.0: [bugfix](nerids) align locate function behavior with BE side #50797 [doris]

2025-05-12 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 196712 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 4b77982392aad69c351bc8121ba46abb864aa2c9, 
data reload: false
   
   query1   1293903 885 885
   query2   6319198719471947
   query3   10859   433742874287
   query4   61619   29239   23459   23459
   query5   5215458 465 458
   query6   401 171 178 171
   query7   5406314 304 304
   query8   293 211 210 210
   query9   8088259025702570
   query10  431 267 256 256
   query11  17311   15220   15623   15220
   query12  167 107 103 103
   query13  1345456 451 451
   query14  10742   687171686871
   query15  203 185 178 178
   query16  7104510 483 483
   query17  1167577 586 577
   query18  1838328 308 308
   query19  198 154 148 148
   query20  114 107 107 107
   query21  203 98  104 98
   query22  4862464845434543
   query23  34486   34023   34266   34023
   query24  6351295428862886
   query25  541 406 412 406
   query26  649 170 172 170
   query27  1714362 362 362
   query28  4432243924032403
   query29  692 466 448 448
   query30  242 170 166 166
   query31  984 880 824 824
   query32  77  58  60  58
   query33  444 293 297 293
   query34  921 512 539 512
   query35  894 740 740 740
   query36  1102955 927 927
   query37  118 66  74  66
   query38  4037394339933943
   query39  1497148914691469
   query40  214 112 102 102
   query41  51  51  49  49
   query42  120 102 106 102
   query43  526 476 480 476
   query44  1162835 807 807
   query45  202 170 176 170
   query46  1146741 742 741
   query47  2001191219051905
   query48  483 380 380 380
   query49  734 413 407 407
   query50  830 428 436 428
   query51  7436732370807080
   query52  107 94  94  94
   query53  261 196 188 188
   query54  580 476 460 460
   query55  78  79  79  79
   query56  275 248 239 239
   query57  1268119211481148
   query58  214 225 216 216
   query59  3173309129752975
   query60  291 270 269 269
   query61  112 110 107 107
   query62  784 692 680 680
   query63  215 185 190 185
   query64  1374688 638 638
   query65  3280320732043204
   query66  728 289 288 288
   query67  15887   15641   15583   15583
   query68  3206589 587 587
   query69  421 266 257 257
   query70  1177113011151115
   query71  400 271 258 258
   query72  6358416740094009
   query73  771 336 353 336
   query74  10147   912888118811
   query75  3415266326412641
   query76  2040113511691135
   query77  560 273 273 273
   query78  10709   966096409640
   query79  1672599 600 599
   query80  1295413 418 413
   query81  530 247 240 240
   query82  125494  88  88
   query83  264 144 140 140
   query84  285 78  80  78
   query85  1050299 291 291
   query86  381 284 295 284
   query87  4396419542404195
   query88  3860236523452345
   query89  414 290 291 290
   query90  2020186 187 186
   query91  182 150 148 148
   query92  59  50  50  50
   query93  2303547 552 547
   query94  788 300 298 298
   query95  359 258 259 258
   query96  610 275 283 275
   query97  3318313231243124
   query98  221 206 200 200
   query99  1587128512711271
   Total cold run time: 313943 ms
   Total hot run time: 196712 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] branch-3.0: [bugfix](nerids) align locate function behavior with BE side #50797 [doris]

2025-05-12 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 4 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 4b77982392aad69c351bc8121ba46abb864aa2c9, 
data reload: false
   
   -- Round 1 --
   q1   17578   670666046604
   q2   2063169 173 169
   q3   10642   103811461038
   q4   10582   730 798 730
   q5   7769286828452845
   q6   223 134 131 131
   q7   967 615 606 606
   q8   9365193620441936
   q9   6538637763826377
   q10  7039227122842271
   q11  454 256 266 256
   q12  405 217 210 210
   q13  17768   299930082999
   q14  245 206 216 206
   q15  516 472 479 472
   q16  670 590 572 572
   q17  974 606 603 603
   q18  7075670266156615
   q19  1382107610461046
   q20  456 203 200 200
   q21  4019320631423142
   q22  1120972 998 972
   Total cold run time: 107850 ms
   Total hot run time: 4 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   6584658165286528
   q2   335 235 226 226
   q3   2924279528752795
   q4   2079180317811781
   q5   5781577757365736
   q6   214 127 133 127
   q7   2261180418881804
   q8   3400358635253525
   q9   8973882188958821
   q10  3563352235363522
   q11  588 497 514 497
   q12  800 626 641 626
   q13  10071   319231583158
   q14  298 278 269 269
   q15  511 468 466 466
   q16  681 648 647 647
   q17  1841164316171617
   q18  8175782077327732
   q19  1713154914551455
   q20  2080183918851839
   q21  5537535053675350
   q22  1061109510471047
   Total cold run time: 69470 ms
   Total hot run time: 59568 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] branch-3.0: [bugfix](nerids) align locate function behavior with BE side #50797 [doris]

2025-05-12 Thread via GitHub


Thearas commented on PR #50831:
URL: https://github.com/apache/doris/pull/50831#issuecomment-2874713216

   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] branch-3.0: [bugfix](nerids) align locate function behavior with BE side #50797 [doris]

2025-05-12 Thread via GitHub


Thearas commented on PR #50831:
URL: https://github.com/apache/doris/pull/50831#issuecomment-2874713135

   
   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



Re: [PR] branch-3.0: [bugfix](nerids) align locate function behavior with BE side #50797 [doris]

2025-05-12 Thread via GitHub


dataroaring closed pull request #50831: branch-3.0: [bugfix](nerids) align 
locate function behavior with BE side #50797
URL: https://github.com/apache/doris/pull/50831


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