Re: [PR] [improve](load) introduce black list of backend when load job fetch meta [doris]

2025-05-12 Thread via GitHub


sollhui commented on PR #50587:
URL: https://github.com/apache/doris/pull/50587#issuecomment-2874916739

   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] [improve](load) introduce black list of backend when load job fetch meta [doris]

2025-05-12 Thread via GitHub


sollhui commented on PR #50587:
URL: https://github.com/apache/doris/pull/50587#issuecomment-2872821175

   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] [improve](load) introduce black list of backend when load job fetch meta [doris]

2025-05-12 Thread via GitHub


sollhui commented on PR #50587:
URL: https://github.com/apache/doris/pull/50587#issuecomment-2872818162

   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] [improve](load) introduce black list of backend when load job fetch meta [doris]

2025-05-08 Thread via GitHub


github-actions[bot] commented on PR #50587:
URL: https://github.com/apache/doris/pull/50587#issuecomment-2862121217

   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-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] [improve](load) introduce black list of backend when load job fetch meta [doris]

2025-05-08 Thread via GitHub


github-actions[bot] commented on PR #50587:
URL: https://github.com/apache/doris/pull/50587#issuecomment-2862121154

   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-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] [improve](load) introduce black list of backend when load job fetch meta [doris]

2025-05-07 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 29.22 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit b4d9dce7e3747193b2c69c4c3f1ac9851772e8bd, 
data reload: false
   
   query1   0.040.030.03
   query2   0.130.100.12
   query3   0.250.190.18
   query4   1.590.200.11
   query5   0.570.560.55
   query6   1.170.710.71
   query7   0.020.020.01
   query8   0.040.030.03
   query9   0.560.520.51
   query10  0.570.580.55
   query11  0.150.100.11
   query12  0.140.120.12
   query13  0.620.590.59
   query14  0.780.810.80
   query15  0.870.840.89
   query16  0.380.370.40
   query17  1.011.021.00
   query18  0.210.200.19
   query19  1.921.821.82
   query20  0.020.010.01
   query21  15.43   0.890.55
   query22  0.771.170.76
   query23  14.83   1.420.60
   query24  6.951.690.98
   query25  0.500.140.08
   query26  0.710.180.14
   query27  0.050.050.05
   query28  10.12   0.890.44
   query29  12.52   3.893.26
   query30  0.270.090.06
   query31  2.820.590.38
   query32  3.230.550.46
   query33  3.063.053.02
   query34  15.86   5.034.52
   query35  4.494.494.51
   query36  0.690.490.48
   query37  0.080.060.06
   query38  0.060.040.04
   query39  0.030.030.03
   query40  0.170.150.13
   query41  0.080.020.02
   query42  0.040.030.02
   query43  0.040.040.03
   Total cold run time: 103.84 s
   Total hot run time: 29.22 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] [improve](load) introduce black list of backend when load job fetch meta [doris]

2025-05-07 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 192259 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 b4d9dce7e3747193b2c69c4c3f1ac9851772e8bd, 
data reload: false
   
   query1   1403109610581058
   query2   6224178117621762
   query3   10995   473744464446
   query4   53969   24577   23056   23056
   query5   5189582 457 457
   query6   371 208 200 200
   query7   4968501 297 297
   query8   331 256 249 249
   query9   5997258325742574
   query10  454 321 287 287
   query11  15142   15074   14951   14951
   query12  159 111 105 105
   query13  1100511 421 421
   query14  10209   636062166216
   query15  209 216 197 197
   query16  7057671 446 446
   query17  1086746 598 598
   query18  1560417 330 330
   query19  213 196 174 174
   query20  134 125 116 116
   query21  205 172 107 107
   query22  4276446742974297
   query23  34355   33467   33550   33467
   query24  6659246024632460
   query25  476 474 407 407
   query26  709 274 154 154
   query27  2237498 342 342
   query28  2918212421202120
   query29  581 565 425 425
   query30  271 229 184 184
   query31  816 879 791 791
   query32  72  70  64  64
   query33  456 357 305 305
   query34  787 863 527 527
   query35  853 852 730 730
   query36  938 1009921 921
   query37  111 106 77  77
   query38  4227426643424266
   query39  1497142014181418
   query40  210 125 110 110
   query41  56  52  57  52
   query42  135 110 111 110
   query43  476 522 500 500
   query44  1345817 821 817
   query45  179 176 173 173
   query46  843 1030671 671
   query47  1904186518271827
   query48  398 410 300 300
   query49  717 519 414 414
   query50  657 692 414 414
   query51  4274418741664166
   query52  107 111 106 106
   query53  228 254 191 191
   query54  605 584 535 535
   query55  83  96  83  83
   query56  307 323 292 292
   query57  1154118411491149
   query58  260 257 259 257
   query59  2755269926632663
   query60  336 330 308 308
   query61  136 159 133 133
   query62  730 739 687 687
   query63  234 192 191 191
   query64  18751030733 733
   query65  4400424742264226
   query66  722 397 301 301
   query67  15689   15821   15270   15270
   query68  6986895 514 514
   query69  535 303 271 271
   query70  1170108110501050
   query71  507 320 301 301
   query72  5800495948934893
   query73  1376660 351 351
   query74  8867909787008700
   query75  4015319527342734
   query76  42981180741 741
   query77  686 371 292 292
   query78  10028   10078   92349234
   query79  2194860 562 562
   query80  585 502 437 437
   query81  490 258 219 219
   query82  466 123 97  97
   query83  257 251 225 225
   query84  296 108 80  80
   query85  795 374 320 320
   query86  370 304 280 280
   query87  4377441142764276
   query88  3752223322702233
   query89  406 320 271 271
   query90  1853220 213 213
   query91  147 145 124 124
   query92  85  62  58  58
   query93  1734950 581 581
   query94  676 418 305 305
   query95  384 302 290 290
   query96  489 554 270 270
   query97  3170321631903190
   query98  227 204 197 197
   query99  1705139012691269
   Total cold run time: 298755 ms
   Total hot run time: 192259 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] [improve](load) introduce black list of backend when load job fetch meta [doris]

2025-05-07 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 33676 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit b4d9dce7e3747193b2c69c4c3f1ac9851772e8bd, 
data reload: false
   
   -- Round 1 --
   q1   25896   499049864986
   q2   2058286 180 180
   q3   10411   1254695 695
   q4   10226   994 511 511
   q5   7513232922882288
   q6   181 159 132 132
   q7   902 740 637 637
   q8   9324123010851085
   q9   6738505650625056
   q10  6833230718811881
   q11  475 277 277 277
   q12  350 359 211 211
   q13  17785   367730623062
   q14  221 231 221 221
   q15  544 485 481 481
   q16  433 425 372 372
   q17  614 860 362 362
   q18  7393707171857071
   q19  1894933 574 574
   q20  339 330 219 219
   q21  3776346124152415
   q22  10211023960 960
   Total cold run time: 114927 ms
   Total hot run time: 33676 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5155505350645053
   q2   231 316 227 227
   q3   2141266823172317
   q4   1343177413171317
   q5   4499439644264396
   q6   215 170 131 131
   q7   1967193417531753
   q8   2591245424642454
   q9   7212723768536853
   q10  3057318827402740
   q11  560 515 493 493
   q12  701 755 577 577
   q13  3482391932503250
   q14  301 291 272 272
   q15  526 502 476 476
   q16  455 515 442 442
   q17  1133155213831383
   q18  7722759273637363
   q19  798 839 990 839
   q20  1991203918541854
   q21  5050481447124712
   q22  1061104710231023
   Total cold run time: 52191 ms
   Total hot run time: 49925 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] [improve](load) introduce black list of backend when load job fetch meta [doris]

2025-05-07 Thread via GitHub


sollhui commented on PR #50587:
URL: https://github.com/apache/doris/pull/50587#issuecomment-2861613308

   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] [improve](load) introduce black list of backend when load job fetch meta [doris]

2025-05-07 Thread via GitHub


sollhui commented on PR #50587:
URL: https://github.com/apache/doris/pull/50587#issuecomment-2861569562

   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] [improve](load) introduce black list of backend when load job fetch meta [doris]

2025-05-06 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 29.05 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit d0ca34d5f121e0e1cba4ecaa5dcf2d7d14949b15, 
data reload: false
   
   query1   0.040.040.03
   query2   0.120.110.11
   query3   0.250.200.19
   query4   1.590.190.20
   query5   0.600.580.59
   query6   1.210.700.71
   query7   0.020.020.02
   query8   0.040.040.03
   query9   0.590.520.52
   query10  0.570.570.56
   query11  0.160.110.11
   query12  0.140.110.11
   query13  0.610.590.59
   query14  0.770.800.81
   query15  0.870.860.84
   query16  0.390.370.37
   query17  1.071.041.01
   query18  0.200.200.19
   query19  1.881.761.79
   query20  0.010.010.02
   query21  15.39   0.880.55
   query22  0.751.160.84
   query23  14.72   1.390.62
   query24  7.661.180.68
   query25  0.510.120.21
   query26  0.540.160.15
   query27  0.060.050.04
   query28  9.610.880.44
   query29  12.56   4.003.27
   query30  0.260.080.06
   query31  2.830.600.37
   query32  3.210.540.45
   query33  3.082.993.00
   query34  15.77   5.104.45
   query35  4.514.504.49
   query36  0.670.490.48
   query37  0.090.060.06
   query38  0.050.040.04
   query39  0.030.030.02
   query40  0.170.140.13
   query41  0.080.030.03
   query42  0.030.030.02
   query43  0.040.030.03
   Total cold run time: 103.75 s
   Total hot run time: 29.05 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] [improve](load) introduce black list of backend when load job fetch meta [doris]

2025-05-06 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 191777 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 d0ca34d5f121e0e1cba4ecaa5dcf2d7d14949b15, 
data reload: false
   
   query1   1410110810341034
   query2   6344180318261803
   query3   11013   459744004400
   query4   54775   24885   23050   23050
   query5   5061593 472 472
   query6   340 207 200 200
   query7   4879517 287 287
   query8   306 261 239 239
   query9   5219257825782578
   query10  445 330 255 255
   query11  14908   15047   14822   14822
   query12  166 108 99  99
   query13  1022525 411 411
   query14  11004   633364736333
   query15  211 198 166 166
   query16  7182652 529 529
   query17  1097741 611 611
   query18  1629411 343 343
   query19  193 185 166 166
   query20  121 133 122 122
   query21  204 126 108 108
   query22  4298445242374237
   query23  34097   33265   33521   33265
   query24  6025245324802453
   query25  486 477 404 404
   query26  708 291 152 152
   query27  1870488 342 342
   query28  2624212420842084
   query29  580 559 460 460
   query30  269 217 186 186
   query31  831 868 777 777
   query32  71  61  64  61
   query33  446 357 312 312
   query34  790 857 528 528
   query35  789 859 762 762
   query36  934 980 902 902
   query37  122 107 81  81
   query38  4334426542434243
   query39  1478142714841427
   query40  207 119 109 109
   query41  55  55  54  54
   query42  123 109 106 106
   query43  500 509 480 480
   query44  1374818 833 818
   query45  180 173 171 171
   query46  869 1034651 651
   query47  1838187117651765
   query48  387 416 322 322
   query49  675 539 410 410
   query50  684 707 411 411
   query51  4236421241374137
   query52  108 113 101 101
   query53  243 263 181 181
   query54  606 597 514 514
   query55  88  89  85  85
   query56  317 300 321 300
   query57  1155119111021102
   query58  264 264 266 264
   query59  2729282528022802
   query60  337 322 314 314
   query61  130 131 127 127
   query62  731 776 688 688
   query63  232 196 190 190
   query64  19871054727 727
   query65  4373424742124212
   query66  736 397 304 304
   query67  15769   15372   15385   15372
   query68  7181879 509 509
   query69  536 300 264 264
   query70  1140109710561056
   query71  504 373 286 286
   query72  5781473345904590
   query73  1562624 345 345
   query74  9307906389328932
   query75  3958322327212721
   query76  41911218779 779
   query77  667 375 284 284
   query78  10216   999291339133
   query79  2751810 568 568
   query80  663 521 451 451
   query81  482 258 216 216
   query82  525 123 96  96
   query83  252 247 231 231
   query84  302 103 83  83
   query85  770 364 312 312
   query86  370 314 281 281
   query87  4460436143084308
   query88  3501221122172211
   query89  404 326 348 326
   query90  1788204 212 204
   query91  147 143 113 113
   query92  75  64  61  61
   query93  2136956 569 569
   query94  669 417 304 304
   query95  369 288 285 285
   query96  485 559 278 278
   query97  3130319230883088
   query98  226 206 195 195
   query99  1417139712771277
   Total cold run time: 299179 ms
   Total hot run time: 191777 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 t

Re: [PR] [improve](load) introduce black list of backend when load job fetch meta [doris]

2025-05-06 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 33544 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit d0ca34d5f121e0e1cba4ecaa5dcf2d7d14949b15, 
data reload: false
   
   -- Round 1 --
   q1   25797   517350375037
   q2   2075283 181 181
   q3   10391   1238659 659
   q4   10228   1008530 530
   q5   7537223523632235
   q6   180 167 131 131
   q7   898 804 638 638
   q8   9327129010731073
   q9   6890507550165016
   q10  6850227018761876
   q11  470 277 263 263
   q12  345 351 222 222
   q13  1   369230603060
   q14  245 230 210 210
   q15  529 489 483 483
   q16  417 420 365 365
   q17  593 844 359 359
   q18  7450711570127012
   q19  2049985 567 567
   q20  353 343 226 226
   q21  4163324624392439
   q22  1022989 962 962
   Total cold run time: 115586 ms
   Total hot run time: 33544 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5227504650885046
   q2   228 323 228 228
   q3   2129257522572257
   q4   1315177113571357
   q5   4405441144564411
   q6   212 171 127 127
   q7   2005188817871787
   q8   2580252725092509
   q9   7206706970037003
   q10  3056321427302730
   q11  573 505 511 505
   q12  666 777 630 630
   q13  3557389632353235
   q14  285 323 272 272
   q15  515 476 473 473
   q16  430 484 446 446
   q17  1150155913421342
   q18  7677757773557355
   q19  825 787 837 787
   q20  2001204818661866
   q21  4995473346994699
   q22  1078103010061006
   Total cold run time: 52115 ms
   Total hot run time: 50071 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] [improve](load) introduce black list of backend when load job fetch meta [doris]

2025-05-06 Thread via GitHub


sollhui commented on PR #50587:
URL: https://github.com/apache/doris/pull/50587#issuecomment-2853510286

   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] [improve](load) introduce black list of backend when load job fetch meta [doris]

2025-05-04 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 29.15 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 3513a7cf474d7b9d52b99e45ad1e5865006c2ba8, 
data reload: false
   
   query1   0.030.030.03
   query2   0.120.110.10
   query3   0.260.200.19
   query4   1.590.200.10
   query5   0.560.550.59
   query6   1.170.720.72
   query7   0.020.020.02
   query8   0.040.030.04
   query9   0.590.520.52
   query10  0.560.570.56
   query11  0.150.110.11
   query12  0.150.110.12
   query13  0.620.590.60
   query14  0.780.810.79
   query15  0.870.850.84
   query16  0.370.390.38
   query17  0.991.031.06
   query18  0.210.190.20
   query19  1.941.811.76
   query20  0.010.020.01
   query21  15.39   0.910.56
   query22  0.741.240.60
   query23  14.96   1.390.62
   query24  6.971.181.00
   query25  0.500.380.10
   query26  0.510.150.14
   query27  0.050.060.05
   query28  10.18   0.910.45
   query29  12.54   3.963.26
   query30  0.250.100.08
   query31  2.820.600.38
   query32  3.230.550.46
   query33  3.033.123.01
   query34  15.73   5.104.49
   query35  4.484.504.49
   query36  0.680.490.50
   query37  0.090.060.06
   query38  0.050.040.04
   query39  0.030.030.03
   query40  0.160.140.14
   query41  0.080.030.02
   query42  0.040.020.04
   query43  0.040.030.03
   Total cold run time: 103.58 s
   Total hot run time: 29.15 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] [improve](load) introduce black list of backend when load job fetch meta [doris]

2025-05-04 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 192319 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 3513a7cf474d7b9d52b99e45ad1e5865006c2ba8, 
data reload: false
   
   query1   1403110210661066
   query2   6298180418161804
   query3   11002   451945714519
   query4   54574   26187   23345   23345
   query5   5058532 440 440
   query6   323 210 208 208
   query7   4870518 294 294
   query8   314 257 241 241
   query9   5253256525622562
   query10  417 341 260 260
   query11  14922   15147   14848   14848
   query12  162 114 112 112
   query13  1021526 402 402
   query14  10147   637463116311
   query15  214 198 175 175
   query16  7159691 498 498
   query17  1088752 594 594
   query18  1567420 329 329
   query19  202 208 176 176
   query20  132 125 121 121
   query21  210 132 107 107
   query22  4353457442974297
   query23  34264   33494   8   8
   query24  6580247424182418
   query25  474 482 399 399
   query26  719 270 158 158
   query27  2504501 339 339
   query28  2927212121222121
   query29  581 568 446 446
   query30  271 230 192 192
   query31  897 863 778 778
   query32  74  65  64  64
   query33  477 382 324 324
   query34  801 886 532 532
   query35  799 846 766 766
   query36  941 1000879 879
   query37  112 100 85  85
   query38  4213427641434143
   query39  1511145114091409
   query40  215 123 108 108
   query41  53  54  53  53
   query42  134 113 113 113
   query43  499 511 492 492
   query44  1306801 803 801
   query45  181 178 170 170
   query46  853 1034668 668
   query47  1858187917781778
   query48  399 422 314 314
   query49  671 519 432 432
   query50  660 757 408 408
   query51  4191426541624162
   query52  111 103 96  96
   query53  229 261 199 199
   query54  602 629 551 551
   query55  83  79  81  79
   query56  319 296 307 296
   query57  1176120511121112
   query58  268 288 272 272
   query59  2653276326612661
   query60  329 314 307 307
   query61  132 131 130 130
   query62  761 746 703 703
   query63  226 192 188 188
   query64  20661060716 716
   query65  4341427142044204
   query66  737 411 304 304
   query67  15721   15534   15699   15534
   query68  7442877 501 501
   query69  530 299 258 258
   query70  1237109611061096
   query71  480 317 297 297
   query72  5919479948764799
   query73  1339628 351 351
   query74  9294913685958595
   query75  3910320126792679
   query76  41291183753 753
   query77  657 448 284 284
   query78  10132   10188   92549254
   query79  2598806 571 571
   query80  649 511 446 446
   query81  487 259 215 215
   query82  628 129 99  99
   query83  258 246 244 244
   query84  303 110 86  86
   query85  797 354 364 354
   query86  371 290 276 276
   query87  4341436043264326
   query88  3548220521852185
   query89  407 312 274 274
   query90  1804202 208 202
   query91  157 144 115 115
   query92  70  61  58  58
   query93  2343930 579 579
   query94  644 402 304 304
   query95  373 294 286 286
   query96  488 555 275 275
   query97  3173325431163116
   query98  235 206 199 199
   query99  1371140012911291
   Total cold run time: 299722 ms
   Total hot run time: 192319 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 t

Re: [PR] [improve](load) introduce black list of backend when load job fetch meta [doris]

2025-05-04 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 33555 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 3513a7cf474d7b9d52b99e45ad1e5865006c2ba8, 
data reload: false
   
   -- Round 1 --
   q1   26123   498849594959
   q2   2055272 175 175
   q3   10407   1280701 701
   q4   10225   1003517 517
   q5   7507235022762276
   q6   182 160 135 135
   q7   909 741 624 624
   q8   9317126211311131
   q9   6906504950365036
   q10  6843228718831883
   q11  483 281 265 265
   q12  345 379 210 210
   q13  17795   379630433043
   q14  223 223 211 211
   q15  522 472 497 472
   q16  424 433 376 376
   q17  599 853 356 356
   q18  7400724470497049
   q19  1559977 537 537
   q20  333 336 213 213
   q21  3940333824362436
   q22  1023966 950 950
   Total cold run time: 115120 ms
   Total hot run time: 33555 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5092503950165016
   q2   235 324 236 236
   q3   2132263623042304
   q4   1351180513821382
   q5   4368440243794379
   q6   217 167 133 133
   q7   2028194517661766
   q8   2583255925512551
   q9   7275726769456945
   q10  3014318327242724
   q11  579 486 476 476
   q12  679 752 597 597
   q13  3488389832593259
   q14  279 313 271 271
   q15  519 485 479 479
   q16  463 470 433 433
   q17  1134152913731373
   q18  7831759374077407
   q19  827 828 877 828
   q20  1978201518191819
   q21  5042475947804759
   q22  10961024998 998
   Total cold run time: 52210 ms
   Total hot run time: 50135 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] [improve](load) introduce black list of backend when load job fetch meta [doris]

2025-05-03 Thread via GitHub


sollhui commented on PR #50587:
URL: https://github.com/apache/doris/pull/50587#issuecomment-2849037072

   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] [improve](load) introduce black list of backend when load job fetch meta [doris]

2025-05-03 Thread via GitHub


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

   
   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