Re: [PR] [fix](auto bucket) Configurable parameters for partition size estimat… [doris]

2025-05-13 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 34409 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 2734b57956cec0e838dc6d6ebe64cca384281258, 
data reload: false
   
   -- Round 1 --
   q1   27253   506152795061
   q2   2087287 193 193
   q3   11243   1274740 740
   q4   11120   1028538 538
   q5   7530242723602360
   q6   186 169 139 139
   q7   937 739 617 617
   q8   9418129511541154
   q9   7602529752405240
   q10  6968240419481948
   q11  502 304 284 284
   q12  369 362 222 222
   q13  19022   385231733173
   q14  246 232 231 231
   q15  596 508 497 497
   q16  497 447 382 382
   q17  983 856 363 363
   q18  7529720170537053
   q19  30691233554 554
   q20  319 339 231 231
   q21  4161267524532453
   q22  1068982 976 976
   Total cold run time: 122705 ms
   Total hot run time: 34409 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5290509250535053
   q2   232 321 223 223
   q3   2158275624022402
   q4   1459192514571457
   q5   4484440343844384
   q6   219 164 130 130
   q7   2011192617541754
   q8   2642263625842584
   q9   7075722871417141
   q10  3030320927802780
   q11  577 531 496 496
   q12  677 755 641 641
   q13  3657393733663366
   q14  308 311 274 274
   q15  521 483 487 483
   q16  440 482 457 457
   q17  1170162813461346
   q18  7737760071807180
   q19  828 854 930 854
   q20  2033201918851885
   q21  5330481147184718
   q22  1033103910491039
   Total cold run time: 52911 ms
   Total hot run time: 50647 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] [fix](auto bucket) Configurable parameters for partition size estimat… [doris]

2025-05-13 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 195346 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 2734b57956cec0e838dc6d6ebe64cca384281258, 
data reload: false
   
   query1   1379111010931093
   query2   5996187818521852
   query3   11005   450045634500
   query4   58070   24229   23456   23456
   query5   4803490 469 469
   query6   350 221 215 215
   query7   4911534 299 299
   query8   333 271 246 246
   query9   6267269327162693
   query10  469 339 294 294
   query11  15040   15122   15425   15122
   query12  181 113 107 107
   query13  1082572 418 418
   query14  10135   634764606347
   query15  208 204 188 188
   query16  7037654 483 483
   query17  1088735 630 630
   query18  1565413 320 320
   query19  201 203 162 162
   query20  124 122 118 118
   query21  216 123 108 108
   query22  4520458842644264
   query23  34230   33811   33872   33811
   query24  7146248124652465
   query25  464 475 399 399
   query26  657 272 156 156
   query27  2362512 351 351
   query28  3351218421782178
   query29  584 565 472 472
   query30  272 220 193 193
   query31  879 907 793 793
   query32  68  63  64  63
   query33  450 392 324 324
   query34  805 867 568 568
   query35  794 842 775 775
   query36  957 1030898 898
   query37  117 104 77  77
   query38  4253430142394239
   query39  1502150414511451
   query40  222 130 109 109
   query41  63  56  53  53
   query42  134 120 119 119
   query43  522 531 489 489
   query44  1355841 852 841
   query45  194 177 167 167
   query46  869 1045673 673
   query47  1826188417831783
   query48  399 463 334 334
   query49  714 516 437 437
   query50  685 706 422 422
   query51  4258430842794279
   query52  108 116 101 101
   query53  232 268 188 188
   query54  597 596 529 529
   query55  89  87  87  87
   query56  312 325 330 325
   query57  1179116311041104
   query58  278 255 255 255
   query59  2648276626652665
   query60  324 308 305 305
   query61  123 144 152 144
   query62  735 739 654 654
   query63  227 198 195 195
   query64  15121145677 677
   query65  4294425642344234
   query66  698 403 309 309
   query67  16200   15875   15504   15504
   query68  6479917 549 549
   query69  564 314 271 271
   query70  1199110811441108
   query71  537 322 294 294
   query72  5898488150044881
   query73  1399708 454 454
   query74  9026930791019101
   query75  3999324427502750
   query76  44111222752 752
   query77  625 374 297 297
   query78  10274   10332   94759475
   query79  2290830 581 581
   query80  621 521 467 467
   query81  473 253 221 221
   query82  241 129 98  98
   query83  270 249 241 241
   query84  298 115 95  95
   query85  806 369 318 318
   query86  386 309 277 277
   query87  4425453044794479
   query88  3541229022902290
   query89  408 312 284 284
   query90  1816206 209 206
   query91  140 141 112 112
   query92  72  58  53  53
   query93  2172954 585 585
   query94  653 425 300 300
   query95  371 289 281 281
   query96  496 577 279 279
   query97  3185326631883188
   query98  257 204 209 204
   query99  1334144712761276
   Total cold run time: 303334 ms
   Total hot run time: 195346 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] [fix](auto bucket) Configurable parameters for partition size estimat… [doris]

2025-05-13 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 28.98 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 2734b57956cec0e838dc6d6ebe64cca384281258, 
data reload: false
   
   query1   0.040.040.03
   query2   0.120.110.11
   query3   0.250.190.19
   query4   1.590.190.20
   query5   0.610.580.60
   query6   1.180.720.73
   query7   0.020.020.02
   query8   0.040.040.03
   query9   0.580.520.52
   query10  0.560.590.58
   query11  0.150.110.11
   query12  0.150.120.13
   query13  0.620.600.60
   query14  0.780.810.81
   query15  0.890.850.86
   query16  0.370.390.40
   query17  1.041.021.02
   query18  0.220.220.21
   query19  2.001.821.78
   query20  0.020.020.01
   query21  15.41   0.890.53
   query22  0.751.250.78
   query23  14.73   1.400.61
   query24  7.831.660.39
   query25  0.300.180.08
   query26  0.600.160.14
   query27  0.050.050.05
   query28  9.090.890.44
   query29  12.56   4.013.27
   query30  0.260.090.07
   query31  2.820.590.39
   query32  3.230.560.47
   query33  3.013.123.09
   query34  15.79   5.114.54
   query35  4.514.524.45
   query36  0.660.500.48
   query37  0.090.060.06
   query38  0.050.040.04
   query39  0.040.030.02
   query40  0.180.140.13
   query41  0.080.030.03
   query42  0.030.020.03
   query43  0.040.040.03
   Total cold run time: 103.34 s
   Total hot run time: 28.98 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] [fix](auto bucket) Configurable parameters for partition size estimat… [doris]

2025-05-12 Thread via GitHub


deardeng commented on PR #50566:
URL: https://github.com/apache/doris/pull/50566#issuecomment-2875208525

   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] [fix](auto bucket) Configurable parameters for partition size estimat… [doris]

2025-05-12 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 29.79 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 1117e92875114dd030a76e7c7dcac99f447340b9, 
data reload: false
   
   query1   0.040.040.03
   query2   0.120.100.12
   query3   0.250.200.20
   query4   1.590.190.11
   query5   0.560.550.54
   query6   1.190.720.73
   query7   0.030.020.02
   query8   0.040.040.03
   query9   0.580.530.52
   query10  0.570.580.57
   query11  0.150.110.11
   query12  0.150.110.11
   query13  0.630.610.61
   query14  0.800.800.81
   query15  0.890.880.86
   query16  0.380.380.40
   query17  1.031.041.02
   query18  0.220.210.20
   query19  1.931.861.84
   query20  0.020.010.01
   query21  15.41   0.870.53
   query22  0.771.160.77
   query23  14.74   1.380.61
   query24  6.871.451.20
   query25  0.490.200.08
   query26  0.640.170.14
   query27  0.050.050.05
   query28  10.12   0.940.46
   query29  12.53   3.903.37
   query30  0.250.100.06
   query31  2.830.590.39
   query32  3.230.560.47
   query33  3.043.063.05
   query34  15.92   5.074.51
   query35  4.484.614.51
   query36  0.670.500.49
   query37  0.080.070.06
   query38  0.050.040.04
   query39  0.040.030.02
   query40  0.170.140.12
   query41  0.090.030.03
   query42  0.030.020.02
   query43  0.040.040.03
   Total cold run time: 103.71 s
   Total hot run time: 29.79 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] [fix](auto bucket) Configurable parameters for partition size estimat… [doris]

2025-05-12 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 193795 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 1117e92875114dd030a76e7c7dcac99f447340b9, 
data reload: false
   
   query1   1409109510561056
   query2   6333179918361799
   query3   11021   428744924287
   query4   53229   25051   23620   23620
   query5   5225540 455 455
   query6   369 222 209 209
   query7   4927524 296 296
   query8   313 257 236 236
   query9   5793265526622655
   query10  451 332 267 267
   query11  15134   15043   14831   14831
   query12  160 111 107 107
   query13  1074543 413 413
   query14  10217   633564986335
   query15  206 194 193 193
   query16  7126655 492 492
   query17  1096740 615 615
   query18  1622412 330 330
   query19  205 205 180 180
   query20  136 140 119 119
   query21  221 131 109 109
   query22  4515448342994299
   query23  34576   33492   33845   33492
   query24  6653243424872434
   query25  470 478 407 407
   query26  703 282 154 154
   query27  2421515 358 358
   query28  3169218921802180
   query29  567 577 459 459
   query30  270 222 190 190
   query31  864 871 787 787
   query32  81  65  63  63
   query33  463 364 299 299
   query34  798 877 549 549
   query35  812 825 771 771
   query36  948 1003900 900
   query37  116 99  77  77
   query38  4242442342854285
   query39  1503145914771459
   query40  212 120 107 107
   query41  59  55  51  51
   query42  132 114 110 110
   query43  516 550 505 505
   query44  1335832 823 823
   query45  186 173 168 168
   query46  849 1026659 659
   query47  1879189218301830
   query48  391 431 333 333
   query49  704 513 436 436
   query50  682 694 413 413
   query51  4237430742084208
   query52  113 117 101 101
   query53  235 258 186 186
   query54  604 593 530 530
   query55  91  93  89  89
   query56  309 300 286 286
   query57  1227125411651165
   query58  270 266 257 257
   query59  2750281426972697
   query60  328 332 314 314
   query61  122 121 127 121
   query62  763 756 685 685
   query63  233 192 188 188
   query64  18331080697 697
   query65  4334426142084208
   query66  719 397 302 302
   query67  16125   15938   15832   15832
   query68  6846891 525 525
   query69  537 304 272 272
   query70  1236116711511151
   query71  502 326 295 295
   query72  5710488648794879
   query73  1479682 357 357
   query74  8974894987498749
   query75  3862322127422742
   query76  42571183748 748
   query77  643 371 292 292
   query78  9455949789658965
   query79  1942878 639 639
   query80  591 508 436 436
   query81  471 269 226 226
   query82  425 130 99  99
   query83  263 250 239 239
   query84  283 109 90  90
   query85  806 370 306 306
   query86  346 307 314 307
   query87  4516465543884388
   query88  3330231722922292
   query89  396 358 293 293
   query90  2000200 204 200
   query91  147 138 114 114
   query92  69  58  54  54
   query93  10931002579 579
   query94  685 426 310 310
   query95  369 284 285 284
   query96  507 609 283 283
   query97  3257322631223122
   query98  239 217 205 205
   query99  1426139912861286
   Total cold run time: 297338 ms
   Total hot run time: 193795 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] [fix](auto bucket) Configurable parameters for partition size estimat… [doris]

2025-05-12 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 34003 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 1117e92875114dd030a76e7c7dcac99f447340b9, 
data reload: false
   
   -- Round 1 --
   q1   26591   505850835058
   q2   2107298 197 197
   q3   10365   1236704 704
   q4   10218   1014565 565
   q5   7555238923412341
   q6   176 163 133 133
   q7   925 757 626 626
   q8   9349130911071107
   q9   6765503452155034
   q10  6849230519161916
   q11  504 282 270 270
   q12  348 360 216 216
   q13  17790   369430803080
   q14  229 229 204 204
   q15  529 487 494 487
   q16  404 437 379 379
   q17  616 866 379 379
   q18  7729726071087108
   q19  1831968 568 568
   q20  332 342 227 227
   q21  4157334424372437
   q22  10531031967 967
   Total cold run time: 116422 ms
   Total hot run time: 34003 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5212505050875050
   q2   239 320 235 235
   q3   2164270023022302
   q4   1344178914291429
   q5   4459442343874387
   q6   224 171 128 128
   q7   2000196517671767
   q8   2615272625242524
   q9   7292713970797079
   q10  2986320727372737
   q11  588 530 499 499
   q12  674 811 632 632
   q13  3576393233143314
   q14  301 307 297 297
   q15  559 511 502 502
   q16  438 496 454 454
   q17  1153154613931393
   q18  7848771174677467
   q19  821 913 840 840
   q20  1993196018341834
   q21  5170481947394739
   q22  1072108310041004
   Total cold run time: 52728 ms
   Total hot run time: 50613 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] [fix](auto bucket) Configurable parameters for partition size estimat… [doris]

2025-05-12 Thread via GitHub


deardeng commented on PR #50566:
URL: https://github.com/apache/doris/pull/50566#issuecomment-2874938376

   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] [fix](auto bucket) Configurable parameters for partition size estimat… [doris]

2025-05-12 Thread via GitHub


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

   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] [fix](auto bucket) Configurable parameters for partition size estimat… [doris]

2025-05-11 Thread via GitHub


deardeng commented on PR #50566:
URL: https://github.com/apache/doris/pull/50566#issuecomment-2870558262

   run cloud_p0


-- 
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] [fix](auto bucket) Configurable parameters for partition size estimat… [doris]

2025-05-06 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 28.83 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 1acd70aa0a722268eb7b4561d1b56ddb2fecfc27, 
data reload: false
   
   query1   0.040.040.03
   query2   0.130.110.11
   query3   0.250.190.19
   query4   1.590.200.19
   query5   0.600.590.59
   query6   1.200.710.73
   query7   0.020.020.02
   query8   0.040.030.04
   query9   0.560.520.50
   query10  0.570.560.58
   query11  0.160.100.11
   query12  0.150.110.12
   query13  0.610.600.60
   query14  0.780.810.80
   query15  0.880.850.84
   query16  0.380.380.37
   query17  1.011.030.98
   query18  0.220.200.19
   query19  1.881.791.80
   query20  0.010.010.01
   query21  15.39   0.940.57
   query22  0.751.170.75
   query23  14.86   1.390.62
   query24  7.161.710.40
   query25  0.450.220.14
   query26  0.540.160.15
   query27  0.060.050.05
   query28  9.450.920.45
   query29  12.56   3.943.24
   query30  0.260.090.07
   query31  2.820.600.39
   query32  3.220.540.46
   query33  2.993.103.04
   query34  15.69   5.104.48
   query35  4.534.564.49
   query36  0.670.490.48
   query37  0.080.070.06
   query38  0.050.040.04
   query39  0.030.030.03
   query40  0.160.140.13
   query41  0.080.030.03
   query42  0.040.030.02
   query43  0.050.030.02
   Total cold run time: 102.97 s
   Total hot run time: 28.83 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] [fix](auto bucket) Configurable parameters for partition size estimat… [doris]

2025-05-06 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 191755 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 1acd70aa0a722268eb7b4561d1b56ddb2fecfc27, 
data reload: false
   
   query1   1410106810651065
   query2   6240173117661731
   query3   10991   461543274327
   query4   55867   25433   23083   23083
   query5   5075569 445 445
   query6   339 195 188 188
   query7   4916519 286 286
   query8   304 234 232 232
   query9   5613255625602556
   query10  446 328 276 276
   query11  14978   14998   14748   14748
   query12  156 107 104 104
   query13  1071510 387 387
   query14  10237   626563186265
   query15  203 195 177 177
   query16  7114674 508 508
   query17  1084784 618 618
   query18  1582423 329 329
   query19  209 195 166 166
   query20  131 128 128 128
   query21  209 133 110 110
   query22  4423443043334333
   query23  34252   33407   33442   33407
   query24  6669241524482415
   query25  460 476 401 401
   query26  716 275 159 159
   query27  2275500 334 334
   query28  3598209921062099
   query29  586 601 438 438
   query30  271 220 189 189
   query31  848 838 793 793
   query32  69  67  61  61
   query33  458 392 312 312
   query34  766 870 555 555
   query35  805 857 758 758
   query36  969 1018886 886
   query37  109 99  72  72
   query38  4207435041624162
   query39  1481141814031403
   query40  210 119 113 113
   query41  54  53  51  51
   query42  119 114 107 107
   query43  481 492 479 479
   query44  1276793 795 793
   query45  181 178 167 167
   query46  863 1040649 649
   query47  1835183217981798
   query48  393 411 333 333
   query49  682 526 426 426
   query50  662 687 406 406
   query51  4226422642474226
   query52  112 112 98  98
   query53  231 262 184 184
   query54  586 579 528 528
   query55  84  83  78  78
   query56  304 300 322 300
   query57  1170115211091109
   query58  272 268 270 268
   query59  2695272727202720
   query60  323 328 307 307
   query61  130 130 126 126
   query62  717 736 685 685
   query63  221 202 180 180
   query64  21091057682 682
   query65  4309429742294229
   query66  748 404 304 304
   query67  15890   15606   15146   15146
   query68  7249886 508 508
   query69  535 306 273 273
   query70  1181108110511051
   query71  507 319 303 303
   query72  6099483149744831
   query73  1481684 348 348
   query74  9282899289338933
   query75  3927317827392739
   query76  42321190747 747
   query77  656 375 282 282
   query78  10015   996991319131
   query79  2392807 568 568
   query80  622 512 440 440
   query81  470 251 221 221
   query82  448 124 97  97
   query83  350 256 235 235
   query84  292 110 79  79
   query85  774 377 322 322
   query86  374 293 297 293
   query87  4377442944324429
   query88  3642231422212221
   query89  393 320 281 281
   query90  1887207 211 207
   query91  145 147 110 110
   query92  75  60  57  57
   query93  1816946 571 571
   query94  668 407 303 303
   query95  380 301 284 284
   query96  492 552 277 277
   query97  3141322930853085
   query98  237 213 201 201
   query99  1459139913301330
   Total cold run time: 301618 ms
   Total hot run time: 191755 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] [fix](auto bucket) Configurable parameters for partition size estimat… [doris]

2025-05-06 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 33923 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 1acd70aa0a722268eb7b4561d1b56ddb2fecfc27, 
data reload: false
   
   -- Round 1 --
   q1   25780   508949964996
   q2   2063266 182 182
   q3   10399   1241688 688
   q4   10226   992 537 537
   q5   7551233823552338
   q6   188 165 134 134
   q7   933 765 626 626
   q8   9343124910861086
   q9   6839509750805080
   q10  6857233118791879
   q11  487 281 260 260
   q12  350 350 221 221
   q13  17792   369231283128
   q14  236 234 216 216
   q15  535 489 484 484
   q16  420 432 369 369
   q17  594 863 368 368
   q18  7510715871367136
   q19  1487957 580 580
   q20  330 333 223 223
   q21  4088343324302430
   q22  1048989 962 962
   Total cold run time: 115056 ms
   Total hot run time: 33923 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5183535050275027
   q2   229 319 228 228
   q3   2169264622832283
   q4   1326178113831383
   q5   4472439644554396
   q6   223 165 131 131
   q7   1962191317611761
   q8   2729264525622562
   q9   7254712869566956
   q10  3059317527592759
   q11  566 528 507 507
   q12  667 741 596 596
   q13  3529392232343234
   q14  284 298 277 277
   q15  525 477 484 477
   q16  443 498 455 455
   q17  1160157214011401
   q18  7804752973487348
   q19  833 871 942 871
   q20  2018204519211921
   q21  4922462547784625
   q22  1088104310061006
   Total cold run time: 52445 ms
   Total hot run time: 50204 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] [fix](auto bucket) Configurable parameters for partition size estimat… [doris]

2025-05-06 Thread via GitHub


deardeng commented on PR #50566:
URL: https://github.com/apache/doris/pull/50566#issuecomment-2854600226

   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] [fix](auto bucket) Configurable parameters for partition size estimat… [doris]

2025-04-30 Thread via GitHub


deardeng commented on PR #50566:
URL: https://github.com/apache/doris/pull/50566#issuecomment-2841684899

   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] [fix](auto bucket) Configurable parameters for partition size estimat… [doris]

2025-04-30 Thread via GitHub


deardeng commented on PR #50566:
URL: https://github.com/apache/doris/pull/50566#issuecomment-2841679704

   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] [fix](auto bucket) Configurable parameters for partition size estimat… [doris]

2025-04-30 Thread via GitHub


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

   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] [fix](auto bucket) Configurable parameters for partition size estimat… [doris]

2025-04-30 Thread via GitHub


deardeng commented on PR #50566:
URL: https://github.com/apache/doris/pull/50566#issuecomment-2841395012

   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] [fix](auto bucket) Configurable parameters for partition size estimat… [doris]

2025-04-30 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 29.19 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 7182c67050f521b8251d5022b5aa4174761fe0cc, 
data reload: false
   
   query1   0.040.030.03
   query2   0.130.100.11
   query3   0.250.180.20
   query4   1.600.190.11
   query5   0.550.550.55
   query6   1.180.720.71
   query7   0.020.020.02
   query8   0.040.040.04
   query9   0.600.520.51
   query10  0.570.570.56
   query11  0.150.110.12
   query12  0.140.120.12
   query13  0.610.590.59
   query14  0.770.800.80
   query15  0.870.890.86
   query16  0.380.370.40
   query17  1.021.041.01
   query18  0.220.200.20
   query19  1.861.781.84
   query20  0.020.010.01
   query21  15.39   0.930.54
   query22  0.761.160.66
   query23  14.98   1.390.60
   query24  7.221.101.22
   query25  0.700.310.09
   query26  0.580.170.14
   query27  0.060.050.06
   query28  10.10   0.890.43
   query29  12.53   3.953.21
   query30  0.260.100.07
   query31  2.810.610.37
   query32  3.230.550.47
   query33  3.043.073.07
   query34  15.80   5.084.45
   query35  4.544.504.49
   query36  0.700.500.46
   query37  0.090.070.07
   query38  0.050.040.04
   query39  0.040.030.02
   query40  0.170.140.13
   query41  0.080.030.02
   query42  0.040.030.02
   query43  0.050.040.03
   Total cold run time: 104.24 s
   Total hot run time: 29.19 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] [fix](auto bucket) Configurable parameters for partition size estimat… [doris]

2025-04-30 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 193116 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 7182c67050f521b8251d5022b5aa4174761fe0cc, 
data reload: false
   
   query1   1416110010721072
   query2   6407183718251825
   query3   11015   464346054605
   query4   54957   25168   23646   23646
   query5   5015584 472 472
   query6   348 210 205 205
   query7   4902499 289 289
   query8   317 253 235 235
   query9   5339261926262619
   query10  442 321 274 274
   query11  15021   15000   14763   14763
   query12  171 114 107 107
   query13  1030519 398 398
   query14  10221   638463736373
   query15  201 198 195 195
   query16  7089620 511 511
   query17  1099772 625 625
   query18  1535453 308 308
   query19  197 200 167 167
   query20  117 117 115 115
   query21  201 134 101 101
   query22  4461444143754375
   query23  34083   33353   33346   33346
   query24  6634250124552455
   query25  468 460 403 403
   query26  690 284 159 159
   query27  2214501 328 328
   query28  3203211721052105
   query29  573 567 433 433
   query30  270 221 197 197
   query31  860 866 779 779
   query32  74  68  66  66
   query33  436 367 325 325
   query34  755 896 534 534
   query35  779 844 767 767
   query36  934 1001930 930
   query37  111 96  71  71
   query38  4279427041344134
   query39  1507143014331430
   query40  212 121 106 106
   query41  56  56  51  51
   query42  123 105 105 105
   query43  499 506 479 479
   query44  1305814 825 814
   query45  182 180 175 175
   query46  855 1065661 661
   query47  1829186218311831
   query48  389 430 313 313
   query49  727 529 434 434
   query50  670 714 413 413
   query51  4253430542124212
   query52  105 110 99  99
   query53  223 266 190 190
   query54  599 565 520 520
   query55  87  85  84  84
   query56  333 304 307 304
   query57  1150122111611161
   query58  268 261 257 257
   query59  2785278727292729
   query60  332 314 299 299
   query61  146 127 127 127
   query62  729 732 670 670
   query63  229 195 196 195
   query64  16981035697 697
   query65  4363423042434230
   query66  779 408 297 297
   query67  15807   15480   15325   15325
   query68  7346882 514 514
   query69  532 303 265 265
   query70  1187114311021102
   query71  491 310 302 302
   query72  5741477348854773
   query73  1432637 337 337
   query74  8957884489938844
   query75  3948322527222722
   query76  41841194765 765
   query77  646 360 288 288
   query78  10037   10014   92289228
   query79  3441826 550 550
   query80  643 515 448 448
   query81  492 253 215 215
   query82  468 223 96  96
   query83  336 249 233 233
   query84  294 97  87  87
   query85  802 354 314 314
   query86  372 295 293 293
   query87  4422439643064306
   query88  3587217221832172
   query89  404 309 275 275
   query90  1919211 207 207
   query91  139 138 108 108
   query92  78  58  61  58
   query93  2556936 578 578
   query94  664 395 304 304
   query95  359 289 291 289
   query96  484 559 272 272
   query97  3161321731753175
   query98  229 203 204 203
   query99  1438138712731273
   Total cold run time: 300893 ms
   Total hot run time: 193116 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] [fix](auto bucket) Configurable parameters for partition size estimat… [doris]

2025-04-30 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 33872 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 7182c67050f521b8251d5022b5aa4174761fe0cc, 
data reload: false
   
   -- Round 1 --
   q1   26365   505650205020
   q2   2066276 182 182
   q3   10402   1238703 703
   q4   10229   994 519 519
   q5   7525226823882268
   q6   184 165 131 131
   q7   896 754 616 616
   q8   9334129911421142
   q9   6778513351195119
   q10  6850230919131913
   q11  479 294 269 269
   q12  339 349 217 217
   q13  17767   365430673067
   q14  226 227 211 211
   q15  532 484 466 466
   q16  430 433 368 368
   q17  601 857 374 374
   q18  7503723870997099
   q19  1446949 569 569
   q20  331 331 226 226
   q21  3925264324272427
   q22  10151015966 966
   Total cold run time: 115223 ms
   Total hot run time: 33872 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5141509251075092
   q2   240 324 227 227
   q3   2166265923112311
   q4   1364177413401340
   q5   4456441444594414
   q6   216 164 133 133
   q7   1987195218021802
   q8   2606263325332533
   q9   7254721870537053
   q10  2981322927692769
   q11  589 518 503 503
   q12  690 794 641 641
   q13  3591385533323332
   q14  303 287 265 265
   q15  528 484 463 463
   q16  430 496 461 461
   q17  1151158213751375
   q18  7650753074917491
   q19  831 902 1068902
   q20  2011194618371837
   q21  5071478247204720
   q22  1070103410201020
   Total cold run time: 52326 ms
   Total hot run time: 50684 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] [fix](auto bucket) Configurable parameters for partition size estimat… [doris]

2025-04-29 Thread via GitHub


deardeng commented on PR #50566:
URL: https://github.com/apache/doris/pull/50566#issuecomment-2840988485

   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] [fix](auto bucket) Configurable parameters for partition size estimat… [doris]

2025-04-29 Thread via GitHub


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

   
   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