Re: [PR] [bugfix](nerids) align locate function behavior with BE side [doris]

2025-05-12 Thread via GitHub


yiguolei merged PR #50797:
URL: https://github.com/apache/doris/pull/50797


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

2025-05-12 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 28.97 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 21ba0cf14a68ecfd1aa9ce43ad1a15404443a507, 
data reload: false
   
   query1   0.040.040.03
   query2   0.130.100.12
   query3   0.250.190.19
   query4   1.590.200.10
   query5   0.570.550.55
   query6   1.200.720.73
   query7   0.030.020.01
   query8   0.040.030.03
   query9   0.570.510.50
   query10  0.560.580.57
   query11  0.160.110.11
   query12  0.150.120.12
   query13  0.610.600.59
   query14  0.790.800.81
   query15  0.870.850.85
   query16  0.390.370.39
   query17  1.011.031.07
   query18  0.230.220.23
   query19  1.941.771.83
   query20  0.010.010.01
   query21  15.40   0.930.55
   query22  0.761.200.72
   query23  14.83   1.390.60
   query24  6.872.190.71
   query25  0.530.100.08
   query26  0.550.170.13
   query27  0.050.050.04
   query28  9.720.860.45
   query29  12.57   3.883.26
   query30  0.260.100.07
   query31  2.820.610.38
   query32  3.230.540.48
   query33  3.043.043.17
   query34  15.76   5.114.53
   query35  4.584.544.50
   query36  0.680.490.47
   query37  0.080.060.06
   query38  0.050.040.03
   query39  0.030.020.03
   query40  0.180.130.12
   query41  0.080.030.02
   query42  0.030.020.03
   query43  0.030.030.02
   Total cold run time: 103.27 s
   Total hot run time: 28.97 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] [bugfix](nerids) align locate function behavior with BE side [doris]

2025-05-12 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 194174 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 21ba0cf14a68ecfd1aa9ce43ad1a15404443a507, 
data reload: false
   
   query1   1406109910641064
   query2   6203179318041793
   query3   11151   456846484568
   query4   53970   24388   23244   23244
   query5   4995543 462 462
   query6   338 210 207 207
   query7   4877529 294 294
   query8   321 273 251 251
   query9   5652266926732669
   query10  443 329 273 273
   query11  15019   14986   14921   14921
   query12  159 114 106 106
   query13  1042530 426 426
   query14  10137   647264296429
   query15  216 210 180 180
   query16  7179678 493 493
   query17  1121727 612 612
   query18  1664415 329 329
   query19  208 205 178 178
   query20  130 137 121 121
   query21  208 126 108 108
   query22  4398440943024302
   query23  34405   33515   33498   33498
   query24  6673244424582444
   query25  462 466 420 420
   query26  720 271 161 161
   query27  2249523 343 343
   query28  2968216721722167
   query29  595 578 434 434
   query30  279 226 190 190
   query31  875 867 788 788
   query32  74  64  62  62
   query33  444 359 330 330
   query34  828 898 555 555
   query35  788 836 753 753
   query36  958 1024878 878
   query37  118 107 80  80
   query38  4210420742604207
   query39  1503145114511451
   query40  211 124 116 116
   query41  55  56  50  50
   query42  124 119 115 115
   query43  530 540 481 481
   query44  1398827 845 827
   query45  182 176 169 169
   query46  862 1030657 657
   query47  1856190918011801
   query48  422 435 322 322
   query49  700 502 453 453
   query50  698 717 420 420
   query51  4246421442804214
   query52  116 114 103 103
   query53  231 256 190 190
   query54  601 600 537 537
   query55  93  87  91  87
   query56  354 317 305 305
   query57  1150120511551155
   query58  269 263 262 262
   query59  2721279225942594
   query60  339 332 304 304
   query61  135 138 123 123
   query62  744 765 681 681
   query63  238 199 200 199
   query64  21731078718 718
   query65  4401427342364236
   query66  729 406 313 313
   query67  15971   15770   15651   15651
   query68  7354889 515 515
   query69  535 316 278 278
   query70  1206109311161093
   query71  529 323 301 301
   query72  5788484748624847
   query73  1472647 363 363
   query74  8988901689498949
   query75  3963327927272727
   query76  41961181757 757
   query77  651 374 285 285
   query78  10139   10253   94289428
   query79  2543800 582 582
   query80  577 508 455 455
   query81  501 247 215 215
   query82  438 123 102 102
   query83  344 253 235 235
   query84  292 107 83  83
   query85  785 387 314 314
   query86  374 291 291 291
   query87  4429445944344434
   query88  3477230223062302
   query89  414 311 281 281
   query90  1830210 215 210
   query91  146 152 111 111
   query92  79  63  58  58
   query93  1962934 578 578
   query94  666 419 283 283
   query95  375 298 290 290
   query96  490 577 283 283
   query97  3232340531583158
   query98  244 204 203 203
   query99  1410139612891289
   Total cold run time: 299964 ms
   Total hot run time: 194174 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] [bugfix](nerids) align locate function behavior with BE side [doris]

2025-05-12 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 34766 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 21ba0cf14a68ecfd1aa9ce43ad1a15404443a507, 
data reload: false
   
   -- Round 1 --
   q1   25809   498150124981
   q2   2062282 182 182
   q3   10388   1214685 685
   q4   10228   990 539 539
   q5   7558235123392339
   q6   186 162 133 133
   q7   919 755 622 622
   q8   9324123911731173
   q9   6835506551355065
   q10  7043236719051905
   q11  490 291 273 273
   q12  344 351 212 212
   q13  17798   366630693069
   q14  225 227 224 224
   q15  528 497 491 491
   q16  420 435 369 369
   q17  615 854 375 375
   q18  7594726672267226
   q19  1452939 530 530
   q20  342 336 234 234
   q21  4100329731313131
   q22  1082107110081008
   Total cold run time: 115342 ms
   Total hot run time: 34766 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5089511850385038
   q2   244 330 241 241
   q3   2133264522732273
   q4   1345178213401340
   q5   4464440143484348
   q6   217 173 126 126
   q7   1972194617371737
   q8   2556262325612561
   q9   7239719370347034
   q10  3009318227692769
   q11  575 507 495 495
   q12  697 753 637 637
   q13  3474389732473247
   q14  300 319 295 295
   q15  525 482 477 477
   q16  434 479 434 434
   q17  1147149914211421
   q18  7786756173787378
   q19  787 824 973 824
   q20  2050196618351835
   q21  5101486748664866
   q22  1116108810611061
   Total cold run time: 52260 ms
   Total hot run time: 50437 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] [bugfix](nerids) align locate function behavior with BE side [doris]

2025-05-12 Thread via GitHub


XLPE commented on PR #50797:
URL: https://github.com/apache/doris/pull/50797#issuecomment-2871584435

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

2025-05-12 Thread via GitHub


XLPE commented on PR #50797:
URL: https://github.com/apache/doris/pull/50797#issuecomment-2871488360

   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]