Re: [PR] [chore](conf) Set enable_advance_next_id=true by default [doris]

2025-01-03 Thread via GitHub


gavinchou merged PR #44790:
URL: https://github.com/apache/doris/pull/44790


-- 
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] [chore](conf) Set enable_advance_next_id=true by default [doris]

2025-01-03 Thread via GitHub


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

   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] [chore](conf) Set enable_advance_next_id=true by default [doris]

2025-01-02 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 31.5 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit d1fd50c56f1a39902b3616a33edde28de3a4352d, 
data reload: false
   
   query1   0.030.030.03
   query2   0.070.030.03
   query3   0.240.060.07
   query4   1.620.110.10
   query5   0.400.410.42
   query6   1.170.650.65
   query7   0.030.020.01
   query8   0.040.030.03
   query9   0.580.500.52
   query10  0.550.570.56
   query11  0.140.100.10
   query12  0.130.110.11
   query13  0.600.610.59
   query14  2.852.832.80
   query15  0.890.830.83
   query16  0.380.380.37
   query17  1.061.021.06
   query18  0.240.200.21
   query19  1.991.822.00
   query20  0.020.010.01
   query21  15.35   0.940.59
   query22  0.740.780.68
   query23  15.32   1.460.59
   query24  2.961.121.14
   query25  0.280.080.06
   query26  0.280.150.13
   query27  0.060.070.05
   query28  13.46   1.531.04
   query29  12.58   3.973.33
   query30  0.240.080.06
   query31  2.820.600.38
   query32  3.230.550.47
   query33  3.093.123.07
   query34  17.19   5.074.48
   query35  4.484.454.50
   query36  0.670.480.48
   query37  0.090.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.02
   query43  0.030.020.03
   Total cold run time: 106.27 s
   Total hot run time: 31.5 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] [chore](conf) Set enable_advance_next_id=true by default [doris]

2025-01-02 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 190741 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 d1fd50c56f1a39902b3616a33edde28de3a4352d, 
data reload: false
   
   query1   987 372 359 359
   query2   6516244122862286
   query3   6710213 214 213
   query4   34238   23694   23618   23618
   query5   4362607 446 446
   query6   272 201 199 199
   query7   4619497 306 306
   query8   301 255 243 243
   query9   9692265826402640
   query10  452 318 246 246
   query11  18467   15440   15341   15341
   query12  157 106 103 103
   query13  1643532 383 383
   query14  11748   713277917132
   query15  266 208 205 205
   query16  8749604 424 424
   query17  1611743 556 556
   query18  2132393 289 289
   query19  219 172 147 147
   query20  115 114 111 111
   query21  210 120 102 102
   query22  4351447942464246
   query23  34932   33315   33424   33315
   query24  6388233322922292
   query25  462 435 384 384
   query26  1080250 153 153
   query27  2037434 332 332
   query28  5000245024092409
   query29  537 516 415 415
   query30  227 179 148 148
   query31  1012908 847 847
   query32  86  61  61  61
   query33  501 346 295 295
   query34  784 811 505 505
   query35  805 834 745 745
   query36  10171025957 957
   query37  117 95  73  73
   query38  4143414442404144
   query39  1474142314321423
   query40  206 118 100 100
   query41  48  45  50  45
   query42  124 105 105 105
   query43  537 565 511 511
   query44  1299804 824 804
   query45  182 175 181 175
   query46  862 1049656 656
   query47  1909190918921892
   query48  390 430 315 315
   query49  809 492 434 434
   query50  610 644 399 399
   query51  7168716871467146
   query52  107 102 96  96
   query53  224 264 187 187
   query54  484 488 407 407
   query55  85  79  85  79
   query56  257 301 253 253
   query57  1172117311311131
   query58  242 233 226 226
   query59  3114319929142914
   query60  286 296 255 255
   query61  112 106 106 106
   query62  869 786 771 771
   query63  223 190 198 190
   query64  4246988 632 632
   query65  3268321632853216
   query66  1040432 306 306
   query67  16027   15912   15517   15517
   query68  7647692 520 520
   query69  477 283 263 263
   query70  1205116211191119
   query71  441 289 257 257
   query72  6199393937973797
   query73  663 749 360 360
   query74  10335   918190229022
   query75  4021317226772677
   query76  36931196783 783
   query77  765 362 284 284
   query78  10127   10534   94379437
   query79  3191818 605 605
   query80  728 519 436 436
   query81  475 278 229 229
   query82  628 162 123 123
   query83  162 163 144 144
   query84  238 90  76  76
   query85  784 360 295 295
   query86  361 320 297 297
   query87  4411455043944394
   query88  4553218221642164
   query89  410 341 302 302
   query90  1943186 196 186
   query91  134 138 102 102
   query92  73  63  52  52
   query93  1445882 544 544
   query94  653 394 298 298
   query95  341 257 242 242
   query96  493 618 280 280
   query97  2876295228512851
   query98  235 249 198 198
   query99  1684156014431443
   Total cold run time: 295710 ms
   Total hot run time: 190741 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] [chore](conf) Set enable_advance_next_id=true by default [doris]

2025-01-02 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 32733 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit d1fd50c56f1a39902b3616a33edde28de3a4352d, 
data reload: false
   
   -- Round 1 --
   q1   17620   618660176017
   q2   2044301 166 166
   q3   10423   1290731 731
   q4   10216   873 443 443
   q5   7522219019681968
   q6   204 181 153 153
   q7   889 739 639 639
   q8   9250138511731173
   q9   5300495448914891
   q10  6764231418491849
   q11  473 281 266 266
   q12  344 354 220 220
   q13  17762   364030843084
   q14  228 241 224 224
   q15  563 509 499 499
   q16  625 626 592 592
   q17  573 863 338 338
   q18  7210636763726367
   q19  4501977 556 556
   q20  310 313 184 184
   q21  2804226020552055
   q22  378 334 318 318
   Total cold run time: 106003 ms
   Total hot run time: 32733 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   6448623662376236
   q2   238 327 234 234
   q3   2234265223092309
   q4   1386180713411341
   q5   4389474849394748
   q6   194 189 150 150
   q7   2105199517871787
   q8   2608280426972697
   q9   7295715972107159
   q10  3041331628292829
   q11  597 535 501 501
   q12  651 775 591 591
   q13  3497381032323232
   q14  289 328 314 314
   q15  561 516 516 516
   q16  663 685 628 628
   q17  1208172012471247
   q18  7764746769646964
   q19  831 115410261026
   q20  1884198018731873
   q21  5524509848614861
   q22  614 605 596 596
   Total cold run time: 54021 ms
   Total hot run time: 51839 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] [chore](conf) Set enable_advance_next_id=true by default [doris]

2025-01-02 Thread via GitHub


gavinchou commented on PR #44790:
URL: https://github.com/apache/doris/pull/44790#issuecomment-2568765656

   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] [chore](conf) Set enable_advance_next_id=true by default [doris]

2025-01-02 Thread via GitHub


gavinchou commented on PR #44790:
URL: https://github.com/apache/doris/pull/44790#issuecomment-2567569454

   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] [chore](conf) Set enable_advance_next_id=true by default [doris]

2025-01-01 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 31.58 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 22ad903d48cf9d041257953ccc2c66f0035c5141, 
data reload: false
   
   query1   0.030.030.03
   query2   0.070.030.03
   query3   0.240.070.07
   query4   1.600.100.11
   query5   0.420.410.41
   query6   1.190.650.65
   query7   0.020.020.01
   query8   0.040.040.03
   query9   0.590.500.50
   query10  0.550.570.54
   query11  0.140.100.10
   query12  0.140.110.11
   query13  0.600.600.59
   query14  2.702.862.75
   query15  0.890.830.82
   query16  0.390.410.38
   query17  1.061.081.03
   query18  0.230.210.22
   query19  1.991.821.97
   query20  0.010.010.02
   query21  15.36   0.910.57
   query22  0.750.720.65
   query23  15.41   1.350.57
   query24  3.151.361.48
   query25  0.210.120.14
   query26  0.240.150.14
   query27  0.060.040.04
   query28  14.25   1.501.04
   query29  12.57   3.963.21
   query30  0.240.080.06
   query31  2.820.590.38
   query32  3.220.530.46
   query33  3.103.163.11
   query34  16.64   5.074.45
   query35  4.444.434.46
   query36  0.630.500.49
   query37  0.090.060.06
   query38  0.040.040.03
   query39  0.040.030.02
   query40  0.180.130.14
   query41  0.080.030.02
   query42  0.040.030.02
   query43  0.030.040.03
   Total cold run time: 106.49 s
   Total hot run time: 31.58 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] [chore](conf) Set enable_advance_next_id=true by default [doris]

2025-01-01 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 189872 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 22ad903d48cf9d041257953ccc2c66f0035c5141, 
data reload: false
   
   query1   979 375 366 366
   query2   6515236523172317
   query3   6725221 210 210
   query4   33618   23674   23924   23674
   query5   4781633 448 448
   query6   285 207 194 194
   query7   4640490 311 311
   query8   307 244 243 243
   query9   9399266126152615
   query10  487 302 243 243
   query11  18238   15436   15244   15244
   query12  164 104 103 103
   query13  1649515 395 395
   query14  10472   676870076768
   query15  235 197 183 183
   query16  8300599 445 445
   query17  1509713 540 540
   query18  2119394 293 293
   query19  216 187 164 164
   query20  118 112 111 111
   query21  212 124 108 108
   query22  4326451441634163
   query23  34902   2   33192   33192
   query24  6466229823762298
   query25  537 467 408 408
   query26  1222268 156 156
   query27  1995453 353 353
   query28  5461242024032403
   query29  762 564 492 492
   query30  225 179 147 147
   query31  1002950 837 837
   query32  89  59  57  57
   query33  528 347 297 297
   query34  742 842 538 538
   query35  788 815 735 735
   query36  976 1041949 949
   query37  110 98  77  77
   query38  4170421143034211
   query39  1479144814311431
   query40  207 109 95  95
   query41  49  102 45  45
   query42  117 101 104 101
   query43  514 524 482 482
   query44  1287814 820 814
   query45  177 169 170 169
   query46  849 1041651 651
   query47  1921193918461846
   query48  375 407 323 323
   query49  770 472 401 401
   query50  607 649 390 390
   query51  7183718869306930
   query52  99  96  91  91
   query53  220 254 182 182
   query54  471 481 406 406
   query55  85  75  75  75
   query56  247 267 246 246
   query57  1199117211231123
   query58  240 220 257 220
   query59  3014322228942894
   query60  279 261 254 254
   query61  109 103 105 103
   query62  856 788 736 736
   query63  234 186 193 186
   query64  4573973 636 636
   query65  3265318332333183
   query66  914 414 305 305
   query67  16034   15874   15564   15564
   query68  9650755 527 527
   query69  484 285 252 252
   query70  1213111811371118
   query71  449 273 267 267
   query72  5836377138423771
   query73  950 759 360 360
   query74  10416   928492279227
   query75  4641315526332633
   query76  56611192776 776
   query77  965 373 270 270
   query78  10163   10174   93239323
   query79  6133864 582 582
   query80  681 508 433 433
   query81  462 264 228 228
   query82  211 152 179 152
   query83  287 175 147 147
   query84  283 91  72  72
   query85  732 357 300 300
   query86  362 294 308 294
   query87  4607445443904390
   query88  3997225222142214
   query89  428 334 302 302
   query90  2082192 193 192
   query91  130 132 105 105
   query92  72  56  114 56
   query93  3368859 533 533
   query94  676 380 281 281
   query95  335 266 254 254
   query96  487 602 287 287
   query97  2713283027272727
   query98  222 212 195 195
   query99  1669155914341434
   Total cold run time: 303008 ms
   Total hot run time: 189872 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] [chore](conf) Set enable_advance_next_id=true by default [doris]

2025-01-01 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 32474 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 22ad903d48cf9d041257953ccc2c66f0035c5141, 
data reload: false
   
   -- Round 1 --
   q1   17612   616860746074
   q2   2058312 166 166
   q3   10408   1229712 712
   q4   10198   866 441 441
   q5   7514216019621962
   q6   205 177 148 148
   q7   916 752 607 607
   q8   9223131111731173
   q9   5198485448894854
   q10  6723229818661866
   q11  469 272 267 267
   q12  344 355 221 221
   q13  17773   353230293029
   q14  240 230 218 218
   q15  557 511 500 500
   q16  626 602 591 591
   q17  556 847 337 337
   q18  7278651262986298
   q19  2864954 536 536
   q20  290 310 197 197
   q21  2812217419691969
   q22  355 323 308 308
   Total cold run time: 104219 ms
   Total hot run time: 32474 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   6322620462746204
   q2   237 327 231 231
   q3   2207261822982298
   q4   1377181513171317
   q5   4332469848184698
   q6   183 170 141 141
   q7   2070197518621862
   q8   2599278526362636
   q9   7281716971127112
   q10  3069330528132813
   q11  582 505 515 505
   q12  676 753 635 635
   q13  3313384631733173
   q14  281 296 289 289
   q15  570 509 497 497
   q16  642 674 634 634
   q17  1197174312451245
   q18  7749734469446944
   q19  775 10251025
   q20  1885194118761876
   q21  5356501248834883
   q22  590 616 606 606
   Total cold run time: 53293 ms
   Total hot run time: 51624 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] [chore](conf) Set enable_advance_next_id=true by default [doris]

2025-01-01 Thread via GitHub


gavinchou commented on PR #44790:
URL: https://github.com/apache/doris/pull/44790#issuecomment-2567093894

   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] [chore](conf) Set enable_advance_next_id=true by default [doris]

2025-01-01 Thread via GitHub


gavinchou commented on PR #44790:
URL: https://github.com/apache/doris/pull/44790#issuecomment-2567065999

   run feut


-- 
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] [chore](conf) Set enable_advance_next_id=true by default [doris]

2024-12-31 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 191130 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 b1471f56cadad949401fc864428060347932afec, 
data reload: false
   
   query1   974 398 361 361
   query2   6530241224302412
   query3   6709215 215 215
   query4   33910   23553   23827   23553
   query5   4380611 473 473
   query6   282 206 213 206
   query7   4617491 302 302
   query8   303 251 247 247
   query9   9568273627202720
   query10  471 314 254 254
   query11  18140   15449   15154   15154
   query12  157 104 103 103
   query13  1649526 385 385
   query14  10523   803370367036
   query15  259 201 199 199
   query16  8274584 426 426
   query17  1550715 551 551
   query18  2117408 309 309
   query19  217 183 152 152
   query20  116 112 111 111
   query21  207 124 103 103
   query22  4262453643914391
   query23  34177   33507   33527   33507
   query24  6472225022552250
   query25  522 481 389 389
   query26  1207267 152 152
   query27  2042465 357 357
   query28  5131241923982398
   query29  730 535 413 413
   query30  230 178 152 152
   query31  967 889 821 821
   query32  89  63  66  63
   query33  500 397 289 289
   query34  746 836 507 507
   query35  779 813 740 740
   query36  10481063950 950
   query37  104 100 75  75
   query38  4204421342784213
   query39  1512142014231420
   query40  216 134 103 103
   query41  47  48  48  48
   query42  118 100 107 100
   query43  528 536 499 499
   query44  1272799 803 799
   query45  180 171 166 166
   query46  868 1040633 633
   query47  1913194118741874
   query48  376 402 323 323
   query49  775 478 378 378
   query50  632 653 386 386
   query51  7046712270587058
   query52  99  102 90  90
   query53  219 257 186 186
   query54  471 486 394 394
   query55  77  76  81  76
   query56  256 266 235 235
   query57  1201117811001100
   query58  238 221 242 221
   query59  3123329230873087
   query60  284 278 281 278
   query61  151 131 140 131
   query62  872 818 744 744
   query63  227 194 196 194
   query64  45961035648 648
   query65  3268319032113190
   query66  1045420 315 315
   query67  15941   15755   15682   15682
   query68  8901743 517 517
   query69  461 340 248 248
   query70  1249116311821163
   query71  426 289 252 252
   query72  6097384738523847
   query73  651 747 361 361
   query74  10440   906789448944
   query75  4348317926512651
   query76  50441175835 835
   query77  950 375 267 267
   query78  10319   10200   93869386
   query79  3124885 613 613
   query80  724 519 437 437
   query81  466 287 237 237
   query82  593 158 122 122
   query83  192 162 145 145
   query84  280 89  82  82
   query85  764 369 373 369
   query86  344 326 300 300
   query87  4751448746354487
   query88  3267225522332233
   query89  424 323 307 307
   query90  1957189 191 189
   query91  132 132 107 107
   query92  68  57  53  53
   query93  1666837 533 533
   query94  670 412 298 298
   query95  328 265 250 250
   query96  494 608 279 279
   query97  2716280426752675
   query98  221 200 216 200
   query99  1645159614461446
   Total cold run time: 295426 ms
   Total hot run time: 191130 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] [chore](conf) Set enable_advance_next_id=true by default [doris]

2024-12-31 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 32.02 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit b1471f56cadad949401fc864428060347932afec, 
data reload: false
   
   query1   0.040.030.03
   query2   0.070.030.04
   query3   0.230.080.07
   query4   1.620.100.10
   query5   0.440.400.40
   query6   1.160.640.65
   query7   0.020.020.02
   query8   0.040.020.03
   query9   0.550.520.52
   query10  0.550.560.57
   query11  0.140.100.11
   query12  0.140.110.11
   query13  0.620.600.59
   query14  2.832.902.75
   query15  0.880.820.81
   query16  0.380.370.38
   query17  1.021.061.03
   query18  0.220.200.20
   query19  1.961.871.95
   query20  0.010.020.01
   query21  15.38   0.900.57
   query22  0.750.710.62
   query23  15.41   1.440.55
   query24  3.421.602.17
   query25  0.150.170.06
   query26  0.230.160.14
   query27  0.050.050.06
   query28  14.96   1.441.05
   query29  12.66   4.043.31
   query30  0.250.090.06
   query31  2.820.610.38
   query32  3.230.550.46
   query33  3.133.063.08
   query34  16.97   5.034.55
   query35  4.524.534.56
   query36  0.640.480.50
   query37  0.090.060.06
   query38  0.040.040.04
   query39  0.040.020.02
   query40  0.160.130.13
   query41  0.080.030.03
   query42  0.040.030.02
   query43  0.030.020.02
   Total cold run time: 107.97 s
   Total hot run time: 32.02 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] [chore](conf) Set enable_advance_next_id=true by default [doris]

2024-12-31 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 32515 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit b1471f56cadad949401fc864428060347932afec, 
data reload: false
   
   -- Round 1 --
   q1   17611   618060536053
   q2   2054302 171 171
   q3   10417   1253700 700
   q4   10221   866 428 428
   q5   7512211519781978
   q6   199 181 149 149
   q7   914 759 608 608
   q8   9229133211631163
   q9   5258500549264926
   q10  6787233418541854
   q11  481 279 268 268
   q12  349 364 215 215
   q13  17770   353829642964
   q14  230 231 212 212
   q15  560 498 495 495
   q16  626 612 582 582
   q17  564 836 339 339
   q18  7126648064106410
   q19  4503974 551 551
   q20  285 310 180 180
   q21  2683210419391939
   q22  362 333 330 330
   Total cold run time: 105741 ms
   Total hot run time: 32515 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   6459632962906290
   q2   235 330 230 230
   q3   2210257822692269
   q4   1450185913731373
   q5   4353474550074745
   q6   187 179 142 142
   q7   2093197518101810
   q8   2585279126952695
   q9   7355729771977197
   q10  3055333928672867
   q11  606 523 501 501
   q12  647 763 639 639
   q13  3327383031243124
   q14  285 290 288 288
   q15  551 516 504 504
   q16  677 698 672 672
   q17  1212172012461246
   q18  7549733268286828
   q19  784 113011711130
   q20  1871198617911791
   q21  5505521348314831
   q22  606 602 563 563
   Total cold run time: 53602 ms
   Total hot run time: 51735 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] [chore](conf) Set enable_advance_next_id=true by default [doris]

2024-12-31 Thread via GitHub


gavinchou commented on PR #44790:
URL: https://github.com/apache/doris/pull/44790#issuecomment-2566389478

   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] [chore](conf) Set enable_advance_next_id=true by default [doris]

2024-12-31 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 31.12 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 83249b0079280144085e8e9c5a27165567e0b8fd, 
data reload: false
   
   query1   0.040.040.04
   query2   0.070.030.03
   query3   0.230.070.07
   query4   1.610.100.10
   query5   0.450.420.42
   query6   1.160.660.65
   query7   0.020.020.02
   query8   0.040.030.03
   query9   0.560.530.52
   query10  0.570.580.56
   query11  0.150.110.11
   query12  0.140.120.12
   query13  0.610.610.60
   query14  2.862.722.77
   query15  0.890.820.82
   query16  0.370.360.38
   query17  1.051.061.06
   query18  0.230.200.20
   query19  1.831.772.00
   query20  0.020.020.01
   query21  15.38   0.940.59
   query22  0.750.750.69
   query23  15.34   1.460.56
   query24  3.281.400.64
   query25  0.250.100.15
   query26  0.350.140.13
   query27  0.050.050.05
   query28  13.81   1.531.04
   query29  12.63   3.993.28
   query30  0.260.080.06
   query31  2.810.590.38
   query32  3.220.530.46
   query33  3.083.143.14
   query34  16.77   5.124.50
   query35  4.464.504.54
   query36  0.660.490.48
   query37  0.100.060.05
   query38  0.050.040.04
   query39  0.030.020.03
   query40  0.170.130.13
   query41  0.070.020.02
   query42  0.040.030.02
   query43  0.040.030.03
   Total cold run time: 106.5 s
   Total hot run time: 31.12 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] [chore](conf) Set enable_advance_next_id=true by default [doris]

2024-12-31 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 190868 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 83249b0079280144085e8e9c5a27165567e0b8fd, 
data reload: false
   
   query1   968 389 406 389
   query2   6516241224392412
   query3   6706213 214 213
   query4   33840   23916   23374   23374
   query5   4374636 493 493
   query6   278 201 195 195
   query7   4630501 306 306
   query8   289 241 234 234
   query9   9365272227232722
   query10  474 319 257 257
   query11  18034   15871   15173   15173
   query12  163 106 104 104
   query13  1649536 451 451
   query14  10992   702476627024
   query15  238 196 194 194
   query16  8132622 442 442
   query17  1601772 608 608
   query18  2117407 313 313
   query19  241 184 167 167
   query20  123 114 116 114
   query21  207 127 112 112
   query22  4347442642574257
   query23  34408   0   33363   0
   query24  6441230922862286
   query25  496 463 385 385
   query26  1196279 163 163
   query27  1982481 335 335
   query28  5327244123962396
   query29  763 550 419 419
   query30  228 196 153 153
   query31  987 913 803 803
   query32  87  60  58  58
   query33  513 366 312 312
   query34  767 852 519 519
   query35  804 853 771 771
   query36  10621030949 949
   query37  121 101 77  77
   query38  4154414540094009
   query39  1513143914711439
   query40  207 129 106 106
   query41  50  47  44  44
   query42  121 99  102 99
   query43  527 545 501 501
   query44  1321806 802 802
   query45  180 182 174 174
   query46  907 1046676 676
   query47  1897191118601860
   query48  385 408 322 322
   query49  785 490 399 399
   query50  677 647 398 398
   query51  7322713671917136
   query52  103 103 92  92
   query53  229 271 189 189
   query54  482 500 412 412
   query55  82  77  82  77
   query56  259 273 249 249
   query57  1233116711201120
   query58  240 254 244 244
   query59  3108318130563056
   query60  269 266 262 262
   query61  115 109 146 109
   query62  872 803 740 740
   query63  234 202 202 202
   query64  44181005688 688
   query65  3335323832663238
   query66  1060426 323 323
   query67  15901   15803   15534   15534
   query68  9104777 520 520
   query69  477 295 256 256
   query70  1292119111681168
   query71  427 295 257 257
   query72  5916393438653865
   query73  683 797 376 376
   query74  10071   906588688868
   query75  4610320426562656
   query76  51001199803 803
   query77  925 382 284 284
   query78  11039   10758   94679467
   query79  6752999 591 591
   query80  700 554 436 436
   query81  489 291 244 244
   query82  665 166 127 127
   query83  203 170 152 152
   query84  285 101 77  77
   query85  780 361 307 307
   query86  355 333 308 308
   query87  4667459745344534
   query88  5015224222132213
   query89  449 336 308 308
   query90  1964192 191 191
   query91  139 141 104 104
   query92  73  59  56  56
   query93  4127889 528 528
   query94  665 404 310 310
   query95  338 279 259 259
   query96  495 651 276 276
   query97  2745283326592659
   query98  242 208 199 199
   query99  1680151714591459
   Total cold run time: 304924 ms
   Total hot run time: 190868 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] [chore](conf) Set enable_advance_next_id=true by default [doris]

2024-12-31 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 32466 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 83249b0079280144085e8e9c5a27165567e0b8fd, 
data reload: false
   
   -- Round 1 --
   q1   17633   607060736070
   q2   2048301 179 179
   q3   10533   1257701 701
   q4   10218   866 439 439
   q5   7623217919201920
   q6   212 182 147 147
   q7   891 750 606 606
   q8   9236128611191119
   q9   5354500149144914
   q10  6766233218711871
   q11  477 272 262 262
   q12  339 354 214 214
   q13  17784   360430223022
   q14  227 224 212 212
   q15  556 509 496 496
   q16  634 608 591 591
   q17  565 837 327 327
   q18  7123638665246386
   q19  1816974 550 550
   q20  303 324 187 187
   q21  2859218119461946
   q22  358 320 307 307
   Total cold run time: 103555 ms
   Total hot run time: 32466 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   6219619862306198
   q2   232 332 228 228
   q3   2196260222922292
   q4   1427179614311431
   q5   4362474048044740
   q6   185 180 146 146
   q7   2066198418751875
   q8   2623278726672667
   q9   7290716573107165
   q10  3034331528002800
   q11  607 508 513 508
   q12  661 753 619 619
   q13  3346367731573157
   q14  279 301 278 278
   q15  557 514 510 510
   q16  644 684 649 649
   q17  1221173312291229
   q18  7829755469736973
   q19  780 109810411041
   q20  1929196618141814
   q21  5439501348564856
   q22  606 608 592 592
   Total cold run time: 53532 ms
   Total hot run time: 51768 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] [chore](conf) Set enable_advance_next_id=true by default [doris]

2024-12-31 Thread via GitHub


gavinchou commented on PR #44790:
URL: https://github.com/apache/doris/pull/44790#issuecomment-2566271486

   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] [chore](conf) Set enable_advance_next_id=true by default [doris]

2024-12-31 Thread via GitHub


gavinchou commented on PR #44790:
URL: https://github.com/apache/doris/pull/44790#issuecomment-2566225867

   run feut


-- 
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] [chore](conf) Set enable_advance_next_id=true by default [doris]

2024-11-29 Thread via GitHub


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

   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] [chore](conf) Set enable_advance_next_id=true by default [doris]

2024-11-29 Thread via GitHub


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

   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] [chore](conf) Set enable_advance_next_id=true by default [doris]

2024-11-29 Thread via GitHub


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

   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] [chore](conf) Set enable_advance_next_id=true by default [doris]

2024-11-29 Thread via GitHub


gavinchou commented on PR #44790:
URL: https://github.com/apache/doris/pull/44790#issuecomment-2507683518

   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] [chore](conf) Set enable_advance_next_id=true by default [doris]

2024-11-29 Thread via GitHub


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

   
   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



[PR] [chore](conf) Set enable_advance_next_id=true by default [doris]

2024-11-29 Thread via GitHub


gavinchou opened a new pull request, #44790:
URL: https://github.com/apache/doris/pull/44790

   Bind the generation of next_id to physical time to ensure its generation is 
monotonically increasing, even if we directly overwrite the FE metadata and 
then restart. This way, it supports a lossy cluster rollback in scenarios where 
major version upgrades are incompatible.
   
   ### What problem does this PR solve?
   
   Problem Summary:
   
   ### Release note
   
   None
   
   ### Check List (For Author)
   
   - Test 
   - [ ] Regression test
   - [ ] Unit Test
   - [ ] Manual test (add detailed scripts or steps below)
   - [x] No need to test or manual test. Explain why:
   - [ ] This is a refactor/code format and no logic has been changed.
   - [ ] Previous test can cover this change.
   - [x] No code files have been changed.
   - [ ] Other reason 
   
   - Behavior changed:
   - [x No.
   - [ ] Yes. 
   
   - Does this need documentation?
   - [x] No.
   - [ ] Yes. 
   
   ### Check List (For Reviewer who merge this PR)
   
   - [ ] Confirm the release note
   - [ ] Confirm test cases
   - [ ] Confirm document
   - [x] Add branch pick label 
   
   


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