Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2026-06-02 Thread via GitHub


github-actions[bot] closed pull request #58138: [feat](schema change) enforce 
key keyword when add key column on AGG table
URL: https://github.com/apache/doris/pull/58138


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2026-05-23 Thread via GitHub


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

   We're closing this PR because it hasn't been updated in a while.
   This isn't a judgement on the merit of the PR in any way. It's just a way of 
keeping the PR queue manageable.
   If you'd like to revive this PR, please reopen it and feel free a maintainer 
to remove the Stale tag!


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-23 Thread via GitHub


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

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-23 Thread via GitHub


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

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-19 Thread via GitHub


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

   # FE Regression Coverage Report
   Increment line coverage `  0.00% (0/7)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/58138_a20f6d8a7d2bdfacedc5f8cb212aa4fe27359db2_merge_fe/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/58138_a20f6d8a7d2bdfacedc5f8cb212aa4fe27359db2_merge_fe/report/index.html)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-19 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 27.58 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit a20f6d8a7d2bdfacedc5f8cb212aa4fe27359db2, 
data reload: false
   
   query1   0.050.050.05
   query2   0.090.050.06
   query3   0.250.090.08
   query4   1.610.120.11
   query5   0.270.240.25
   query6   1.170.640.63
   query7   0.030.020.02
   query8   0.050.040.04
   query9   0.590.530.53
   query10  0.590.570.56
   query11  0.160.120.11
   query12  0.150.120.12
   query13  0.620.600.60
   query14  1.011.000.99
   query15  0.840.830.82
   query16  0.390.390.39
   query17  1.071.021.05
   query18  0.220.200.20
   query19  1.851.831.83
   query20  0.020.010.02
   query21  15.44   0.210.13
   query22  4.980.080.05
   query23  15.67   0.260.10
   query24  2.630.790.58
   query25  0.080.050.07
   query26  0.150.130.13
   query27  0.050.060.06
   query28  4.691.150.95
   query29  12.62   3.843.16
   query30  0.310.140.12
   query31  2.810.620.38
   query32  3.230.550.48
   query33  2.993.033.09
   query34  15.73   5.124.55
   query35  4.574.594.56
   query36  0.680.500.49
   query37  0.100.070.07
   query38  0.060.040.03
   query39  0.030.030.03
   query40  0.170.150.14
   query41  0.080.040.03
   query42  0.040.030.03
   query43  0.040.040.03
   Total cold run time: 98.18 s
   Total hot run time: 27.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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-19 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 188303 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 a20f6d8a7d2bdfacedc5f8cb212aa4fe27359db2, 
data reload: false
   
   query1   1051412 402 402
   query2   6592170416851685
   query3   6761224 223 223
   query4   26101   23488   22810   22810
   query5   4399665 554 554
   query6   351 250 238 238
   query7   4643498 304 304
   query8   337 254 245 245
   query9   8656293329202920
   query10  495 354 306 306
   query11  15980   15002   14799   14799
   query12  195 135 117 117
   query13  1668569 451 451
   query14  11125   922392369223
   query15  200 189 171 171
   query16  7450667 503 503
   query17  1215763 627 627
   query18  2015425 369 369
   query19  205 202 180 180
   query20  133 125 123 123
   query21  216 140 118 118
   query22  4089392639443926
   query23  33941   33112   33085   33085
   query24  8131242724222422
   query25  625 525 466 466
   query26  1248285 172 172
   query27  2740501 367 367
   query28  4370225922402240
   query29  820 655 495 495
   query30  290 224 198 198
   query31  901 811 718 718
   query32  97  86  91  86
   query33  612 407 350 350
   query34  785 857 514 514
   query35  814 833 762 762
   query36  953 1013945 945
   query37  136 120 100 100
   query38  3604357034563456
   query39  1479147014001400
   query40  234 141 126 126
   query41  66  61  62  61
   query42  132 121 120 120
   query43  468 491 460 460
   query44  1267802 804 802
   query45  188 183 175 175
   query46  887 985 659 659
   query47  1765179317141714
   query48  416 430 334 334
   query49  765 498 423 423
   query50  647 675 403 403
   query51  3909390138953895
   query52  118 115 106 106
   query53  269 270 208 208
   query54  333 319 315 315
   query55  101 97  96  96
   query56  374 372 347 347
   query57  1182120611021102
   query58  313 301 294 294
   query59  2506270024582458
   query60  393 390 358 358
   query61  200 189 195 189
   query62  773 725 655 655
   query63  242 205 200 200
   query64  4645128810101010
   query65  4013394139653941
   query66  1168458 366 366
   query67  15246   15128   14636   14636
   query68  8144952 635 635
   query69  498 350 310 310
   query70  1394121712431217
   query71  451 355 338 338
   query72  5877495849664958
   query73  661 600 372 372
   query74  8940896289988962
   query75  3516325727382738
   query76  33961120744 744
   query77  746 426 356 356
   query78  9478954688628862
   query79  2457852 609 609
   query80  659 609 532 532
   query81  506 263 232 232
   query82  381 164 139 139
   query83  266 271 256 256
   query84  265 119 88  88
   query85  935 498 464 464
   query86  389 305 314 305
   query87  3693378236523652
   query88  3708226722502250
   query89  403 322 300 300
   query90  1985246 238 238
   query91  183 177 137 137
   query92  94  82  73  73
   query93  1940985 683 683
   query94  718 433 338 338
   query95  433 369 358 358
   query96  496 576 284 284
   query97  2922295328522852
   query98  243 227 221 221
   query99  1354142312771277
   Total cold run time: 275174 ms
   Total hot run time: 188303 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 

Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-19 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 34398 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit a20f6d8a7d2bdfacedc5f8cb212aa4fe27359db2, 
data reload: false
   
   -- Round 1 --
   q1   17633   508150165016
   q2   2024351 200 200
   q3   10229   1296696 696
   q4   10241   1013393 393
   q5   7504247522682268
   q6   197 172 141 141
   q7   915 773 625 625
   q8   9340138210961096
   q9   7209542254135413
   q10  6815220317981798
   q11  500 295 287 287
   q12  338 363 229 229
   q13  17767   372130273027
   q14  234 229 214 214
   q15  580 508 491 491
   q16  997 984 942 942
   q17  591 897 366 366
   q18  7868716272297162
   q19  1072977 543 543
   q20  352 344 229 229
   q21  3765253922872287
   q22  10781043975 975
   Total cold run time: 107249 ms
   Total hot run time: 34398 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4950492349454923
   q2   320 419 319 319
   q3   2176270022592259
   q4   1320180413071307
   q5   4199445445864454
   q6   225 179 139 139
   q7   2108194818771877
   q8   2629275525902590
   q9   7597749275677492
   q10  3055323028262826
   q11  583 529 509 509
   q12  692 769 612 612
   q13  3611391733933393
   q14  277 304 295 295
   q15  548 496 526 496
   q16  1138113510701070
   q17  1231159214401440
   q18  7930779074947494
   q19  776 787 828 787
   q20  2063209019151915
   q21  5027461243164316
   q22  10981055989 989
   Total cold run time: 53553 ms
   Total hot run time: 51502 ms
   ```
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-19 Thread via GitHub


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

   # FE UT Coverage Report
   Increment line coverage `  57.14% (4/7)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/58138_a20f6d8a7d2bdfacedc5f8cb212aa4fe27359db2/fe_increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/58138_a20f6d8a7d2bdfacedc5f8cb212aa4fe27359db2/fe_report/index.html)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-19 Thread via GitHub


TsukiokaKogane commented on PR #58138:
URL: https://github.com/apache/doris/pull/58138#issuecomment-352229

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-19 Thread via GitHub


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

   # FE Regression Coverage Report
   Increment line coverage `  57.14% (4/7)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/58138_efb592d9629402538a7e99d97d891327c924805d_merge_fe/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/58138_efb592d9629402538a7e99d97d891327c924805d_merge_fe/report/index.html)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-19 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 27.66 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit efb592d9629402538a7e99d97d891327c924805d, 
data reload: false
   
   query1   0.060.050.05
   query2   0.090.050.05
   query3   0.260.080.08
   query4   1.600.100.10
   query5   0.270.250.25
   query6   1.160.650.63
   query7   0.030.030.02
   query8   0.050.040.05
   query9   0.560.520.52
   query10  0.570.560.56
   query11  0.160.110.11
   query12  0.150.120.11
   query13  0.620.600.62
   query14  0.981.000.99
   query15  0.840.820.82
   query16  0.390.380.39
   query17  1.011.001.01
   query18  0.220.200.20
   query19  1.881.841.78
   query20  0.020.010.02
   query21  15.43   0.200.12
   query22  5.010.070.05
   query23  15.68   0.260.10
   query24  2.860.751.37
   query25  0.090.060.05
   query26  0.130.140.12
   query27  0.080.060.05
   query28  5.451.200.96
   query29  12.57   3.933.23
   query30  0.290.130.14
   query31  2.820.590.39
   query32  3.220.540.48
   query33  3.033.153.03
   query34  15.62   5.184.56
   query35  4.574.604.50
   query36  0.670.510.49
   query37  0.100.070.06
   query38  0.070.040.04
   query39  0.030.030.03
   query40  0.170.150.13
   query41  0.090.030.03
   query42  0.040.030.03
   query43  0.040.040.03
   Total cold run time: 98.98 s
   Total hot run time: 27.66 s
   ```
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-19 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 187772 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 efb592d9629402538a7e99d97d891327c924805d, 
data reload: false
   
   query1   1018436 394 394
   query2   6578167316811673
   query3   6752232 221 221
   query4   25824   23531   22826   22826
   query5   4370652 519 519
   query6   332 255 227 227
   query7   4647503 306 306
   query8   313 249 244 244
   query9   8693288529122885
   query10  503 347 305 305
   query11  15588   14981   14765   14765
   query12  197 125 123 123
   query13  1692575 459 459
   query14  10251   924691669166
   query15  206 190 180 180
   query16  7303683 489 489
   query17  1277787 664 664
   query18  2034440 350 350
   query19  218 213 193 193
   query20  131 129 124 124
   query21  217 141 120 120
   query22  3971394839163916
   query23  34166   32971   33084   32971
   query24  8150241124032403
   query25  640 573 520 520
   query26  1246273 178 178
   query27  2739520 377 377
   query28  4421225622372237
   query29  863 646 536 536
   query30  295 229 196 196
   query31  906 811 733 733
   query32  94  81  90  81
   query33  609 408 368 368
   query34  788 852 529 529
   query35  828 827 776 776
   query36  952 1001915 915
   query37  132 121 98  98
   query38  3504353335003500
   query39  1495141214131412
   query40  227 133 123 123
   query41  64  58  62  58
   query42  133 116 116 116
   query43  481 482 434 434
   query44  1266805 813 805
   query45  188 184 173 173
   query46  888 985 645 645
   query47  1739178017181718
   query48  395 427 326 326
   query49  743 496 422 422
   query50  648 682 416 416
   query51  3893393338683868
   query52  120 113 107 107
   query53  249 267 198 198
   query54  326 327 293 293
   query55  97  91  89  89
   query56  338 327 340 327
   query57  1206117711411141
   query58  304 288 284 284
   query59  2499264424182418
   query60  365 357 351 351
   query61  162 153 159 153
   query62  796 694 674 674
   query63  233 196 193 193
   query64  45621217885 885
   query65  4032393339633933
   query66  1184432 364 364
   query67  15303   14975   14951   14951
   query68  8261968 633 633
   query69  497 331 284 284
   query70  1375129512891289
   query71  492 361 326 326
   query72  6043484248814842
   query73  682 578 373 373
   query74  9070891787418741
   query75  3832326627382738
   query76  36721124754 754
   query77  819 411 331 331
   query78  9406979087958795
   query79  1819845 609 609
   query80  668 605 514 514
   query81  479 257 222 222
   query82  427 170 144 144
   query83  273 265 258 258
   query84  253 105 93  93
   query85  930 494 459 459
   query86  344 337 313 313
   query87  3762366036063606
   query88  2902228822592259
   query89  393 321 309 309
   query90  1925240 233 233
   query91  167 168 137 137
   query92  93  77  75  75
   query93  11031004690 690
   query94  727 446 335 335
   query95  432 344 345 344
   query96  504 665 288 288
   query97  2944297328632863
   query98  247 223 216 216
   query99  1395137812551255
   Total cold run time: 272320 ms
   Total hot run time: 187772 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] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-19 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 33857 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit efb592d9629402538a7e99d97d891327c924805d, 
data reload: false
   
   -- Round 1 --
   q1   17610   503948964896
   q2   2022307 200 200
   q3   10289   1244705 705
   q4   10238   889 364 364
   q5   7584248322552255
   q6   184 171 134 134
   q7   988 752 606 606
   q8   9341132011081108
   q9   7026528852675267
   q10  6843219318051805
   q11  498 281 283 281
   q12  328 369 228 228
   q13  17789   367029772977
   q14  235 232 215 215
   q15  578 512 496 496
   q16  988 1000933 933
   q17  577 859 365 365
   q18  7456718370387038
   q19  1196930 535 535
   q20  347 354 225 225
   q21  3669311322512251
   q22  10591051973 973
   Total cold run time: 106845 ms
   Total hot run time: 33857 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4924519849124912
   q2   326 395 310 310
   q3   2182264523292329
   q4   1295175013311331
   q5   4153434644624346
   q6   219 175 138 138
   q7   2081198718041804
   q8   2703262025172517
   q9   7611757276087572
   q10  3015322828432843
   q11  585 533 511 511
   q12  705 780 768 768
   q13  3424386432283228
   q14  287 300 295 295
   q15  540 491 529 491
   q16  1070111710541054
   q17  1361155613841384
   q18  7899772976407640
   q19  751 762 798 762
   q20  1993203819401940
   q21  4914422842634228
   q22  1079104910201020
   Total cold run time: 53117 ms
   Total hot run time: 51423 ms
   ```
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-19 Thread via GitHub


TsukiokaKogane commented on PR #58138:
URL: https://github.com/apache/doris/pull/58138#issuecomment-3553001924

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-19 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 27.42 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 340116dd248838a42e9482a6e431aa3e718ebcc0, 
data reload: false
   
   query1   0.060.060.05
   query2   0.090.050.05
   query3   0.250.080.08
   query4   1.600.120.11
   query5   0.270.250.25
   query6   1.190.650.65
   query7   0.030.030.03
   query8   0.050.040.04
   query9   0.580.520.52
   query10  0.580.580.57
   query11  0.160.110.11
   query12  0.160.120.12
   query13  0.620.600.60
   query14  1.000.990.99
   query15  0.840.820.83
   query16  0.390.390.39
   query17  1.031.051.02
   query18  0.210.200.19
   query19  1.881.821.87
   query20  0.020.010.02
   query21  15.44   0.220.13
   query22  4.930.070.05
   query23  15.66   0.250.10
   query24  3.020.880.31
   query25  0.060.050.06
   query26  0.130.130.13
   query27  0.060.060.05
   query28  3.631.130.95
   query29  12.56   3.853.23
   query30  0.280.140.14
   query31  2.810.560.40
   query32  3.220.550.47
   query33  3.063.123.05
   query34  15.75   5.174.58
   query35  4.634.544.60
   query36  0.670.500.48
   query37  0.090.070.07
   query38  0.060.040.04
   query39  0.030.020.02
   query40  0.170.140.13
   query41  0.080.020.02
   query42  0.040.030.03
   query43  0.040.030.04
   Total cold run time: 97.43 s
   Total hot run time: 27.42 s
   ```
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-19 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 188717 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 340116dd248838a42e9482a6e431aa3e718ebcc0, 
data reload: false
   
   query1   1021409 393 393
   query2   6564170416501650
   query3   6747237 224 224
   query4   26411   23310   23504   23310
   query5   4859664 509 509
   query6   328 254 234 234
   query7   4653497 315 315
   query8   302 257 261 257
   query9   8686294829172917
   query10  519 333 305 305
   query11  16067   15045   14873   14873
   query12  186 120 120 120
   query13  1696604 456 456
   query14  10695   934992179217
   query15  203 197 180 180
   query16  7355660 505 505
   query17  1229803 626 626
   query18  2036440 345 345
   query19  217 214 192 192
   query20  140 131 127 127
   query21  222 137 122 122
   query22  3985415539913991
   query23  34166   33300   32879   32879
   query24  8135241724272417
   query25  642 577 485 485
   query26  1247284 175 175
   query27  2730497 366 366
   query28  4377226622562256
   query29  875 647 538 538
   query30  308 225 197 197
   query31  900 811 727 727
   query32  96  87  87  87
   query33  619 423 355 355
   query34  794 881 533 533
   query35  813 830 761 761
   query36  938 988 896 896
   query37  136 119 152 119
   query38  3560348334413441
   query39  1469140914281409
   query40  230 141 131 131
   query41  67  60  59  59
   query42  129 125 122 122
   query43  486 497 458 458
   query44  1305797 795 795
   query45  189 201 181 181
   query46  903 997 652 652
   query47  1740175617091709
   query48  400 442 342 342
   query49  777 515 421 421
   query50  674 715 436 436
   query51  3902389539393895
   query52  127 118 117 117
   query53  257 284 202 202
   query54  346 332 320 320
   query55  98  94  92  92
   query56  369 358 346 346
   query57  1185119111181118
   query58  299 293 282 282
   query59  2531255524862486
   query60  364 381 368 368
   query61  164 159 161 159
   query62  771 716 669 669
   query63  230 203 203 203
   query64  45931155925 925
   query65  4031392039283920
   query66  1183457 344 344
   query67  15383   15173   15044   15044
   query68  8374961 645 645
   query69  503 328 304 304
   query70  1386133012631263
   query71  486 357 326 326
   query72  5854493748644864
   query73  691 595 378 378
   query74  9204893386328632
   query75  3912323127952795
   query76  37351150753 753
   query77  830 423 348 348
   query78  9372979287998799
   query79  2183855 629 629
   query80  679 598 529 529
   query81  494 276 237 237
   query82  428 165 141 141
   query83  270 268 257 257
   query84  271 113 116 113
   query85  916 494 449 449
   query86  343 309 308 308
   query87  3776370936443644
   query88  3184225222282228
   query89  396 349 296 296
   query90  1978242 236 236
   query91  167 171 140 140
   query92  91  82  73  73
   query93  11821031695 695
   query94  709 433 337 337
   query95  414 350 343 343
   query96  485 581 285 285
   query97  2919301128802880
   query98  252 224 224 224
   query99  1478138612611261
   Total cold run time: 275621 ms
   Total hot run time: 188717 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 

Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-19 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 34170 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 340116dd248838a42e9482a6e431aa3e718ebcc0, 
data reload: false
   
   -- Round 1 --
   q1   17622   503549494949
   q2   2013320 205 205
   q3   10243   1280748 748
   q4   10231   894 370 370
   q5   7478249222432243
   q6   187 173 137 137
   q7   954 759 626 626
   q8   9364133510851085
   q9   7257535153125312
   q10  6815223217951795
   q11  495 299 283 283
   q12  337 359 236 236
   q13  1   364230493049
   q14  232 225 224 224
   q15  578 509 512 509
   q16  10121000941 941
   q17  575 858 360 360
   q18  7374730970357035
   q19  1220948 533 533
   q20  351 360 234 234
   q21  3818319323022302
   q22  10761042994 994
   Total cold run time: 107009 ms
   Total hot run time: 34170 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4971491849104910
   q2   338 398 322 322
   q3   2155268423152315
   q4   1363173913171317
   q5   4187439546064395
   q6   208 172 135 135
   q7   2070200318311831
   q8   2615261126622611
   q9   7567757878087578
   q10  3077320828722872
   q11  596 620 512 512
   q12  667 785 589 589
   q13  3432412533523352
   q14  288 299 269 269
   q15  536 505 502 502
   q16  1079113810841084
   q17  1156175513641364
   q18  7837763276127612
   q19  821 802 929 802
   q20  2060213819451945
   q21  5087462244744474
   q22  1147114010161016
   Total cold run time: 53257 ms
   Total hot run time: 51807 ms
   ```
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-19 Thread via GitHub


TsukiokaKogane commented on PR #58138:
URL: https://github.com/apache/doris/pull/58138#issuecomment-3551552865

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-19 Thread via GitHub


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

   # FE UT Coverage Report
   Increment line coverage `  57.14% (4/7)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/58138_abdd799ee1e55a3e2a2a02cba8330472b75f7511/fe_increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/58138_abdd799ee1e55a3e2a2a02cba8330472b75f7511/fe_report/index.html)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-19 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 27.49 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit abdd799ee1e55a3e2a2a02cba8330472b75f7511, 
data reload: false
   
   query1   0.050.050.04
   query2   0.100.060.05
   query3   0.250.080.08
   query4   1.620.110.10
   query5   0.270.250.25
   query6   1.180.630.65
   query7   0.040.030.02
   query8   0.050.040.04
   query9   0.570.530.52
   query10  0.580.570.58
   query11  0.150.110.11
   query12  0.150.120.12
   query13  0.630.600.59
   query14  1.001.001.01
   query15  0.860.830.82
   query16  0.400.380.39
   query17  1.050.991.03
   query18  0.210.190.20
   query19  1.881.781.82
   query20  0.020.010.01
   query21  15.44   0.210.13
   query22  5.010.070.05
   query23  15.67   0.270.10
   query24  2.240.520.48
   query25  0.060.080.06
   query26  0.140.140.14
   query27  0.070.060.06
   query28  4.281.140.94
   query29  12.59   3.843.29
   query30  0.270.130.11
   query31  2.810.590.39
   query32  3.230.560.48
   query33  3.083.073.08
   query34  15.78   5.164.53
   query35  4.594.604.54
   query36  0.680.510.48
   query37  0.090.070.07
   query38  0.070.040.04
   query39  0.040.020.02
   query40  0.180.140.15
   query41  0.080.040.03
   query42  0.030.030.02
   query43  0.040.040.03
   Total cold run time: 97.53 s
   Total hot run time: 27.49 s
   ```
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-19 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 187753 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 abdd799ee1e55a3e2a2a02cba8330472b75f7511, 
data reload: false
   
   query1   1028412 456 412
   query2   6550166416621662
   query3   6751235 226 226
   query4   25921   23194   22517   22517
   query5   4329637 500 500
   query6   325 234 229 229
   query7   4653488 298 298
   query8   301 255 246 246
   query9   8695293628972897
   query10  488 352 300 300
   query11  15745   15202   14738   14738
   query12  179 121 114 114
   query13  1673563 456 456
   query14  11055   914790039003
   query15  203 187 174 174
   query16  7427662 528 528
   query17  1228745 618 618
   query18  2005431 329 329
   query19  209 205 181 181
   query20  134 128 118 118
   query21  217 135 121 121
   query22  4099408241564082
   query23  33850   33059   33072   33059
   query24  8213237823782378
   query25  619 539 521 521
   query26  1240270 164 164
   query27  2763500 359 359
   query28  4395223922102210
   query29  792 616 509 509
   query30  303 218 196 196
   query31  927 791 709 709
   query32  97  79  81  79
   query33  589 386 348 348
   query34  789 836 515 515
   query35  825 833 749 749
   query36  984 1017900 900
   query37  130 111 103 103
   query38  3479356634553455
   query39  1451143114311431
   query40  245 134 122 122
   query41  63  60  60  60
   query42  130 115 117 115
   query43  475 500 455 455
   query44  1239800 792 792
   query45  183 179 172 172
   query46  882 997 646 646
   query47  1744180217741774
   query48  408 428 328 328
   query49  751 499 463 463
   query50  649 681 398 398
   query51  3892391139113911
   query52  119 115 107 107
   query53  251 278 200 200
   query54  324 309 310 309
   query55  90  91  90  90
   query56  358 344 356 344
   query57  1176119011251125
   query58  295 281 289 281
   query59  2474262324852485
   query60  353 363 337 337
   query61  160 155 161 155
   query62  782 702 663 663
   query63  230 195 196 195
   query64  44861168910 910
   query65  4021394539303930
   query66  1154453 369 369
   query67  15295   15145   14900   14900
   query68  3468982 653 653
   query69  496 357 311 311
   query70  1312125113011251
   query71  428 359 327 327
   query72  6224508551085085
   query73  645 583 360 360
   query74  8837903687858785
   query75  3203326127392739
   query76  32671114735 735
   query77  499 403 359 359
   query78  9595992689718971
   query79  2309800 622 622
   query80  1750603 538 538
   query81  559 260 238 238
   query82  419 161 142 142
   query83  355 261 255 255
   query84  249 116 98  98
   query85  927 489 450 450
   query86  386 301 326 301
   query87  3693370135783578
   query88  2799223822002200
   query89  416 328 291 291
   query90  1747231 221 221
   query91  174 163 134 134
   query92  85  75  79  75
   query93  12091015687 687
   query94  698 426 335 335
   query95  429 348 333 333
   query96  476 600 286 286
   query97  2943296028432843
   query98  233 215 213 213
   query99  1277137712671267
   Total cold run time: 267997 ms
   Total hot run time: 187753 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] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-18 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 35405 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit abdd799ee1e55a3e2a2a02cba8330472b75f7511, 
data reload: false
   
   -- Round 1 --
   q1   17637   499848644864
   q2   1991312 212 212
   q3   10277   1279700 700
   q4   10228   879 350 350
   q5   7521246422612261
   q6   185 172 136 136
   q7   929 747 626 626
   q8   9358135111351135
   q9   7018542254625422
   q10  6904218318211821
   q11  509 300 289 289
   q12  343 377 232 232
   q13  17833   366430313031
   q14  229 234 211 211
   q15  575 530 502 502
   q16  1035982 934 934
   q17  582 869 353 353
   q18  7335742375307423
   q19  14981021603 603
   q20  386 343 223 223
   q21  4175329930313031
   q22  1124108510461046
   Total cold run time: 107672 ms
   Total hot run time: 35405 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5120525651555155
   q2   325 392 299 299
   q3   2382291724422442
   q4   1447184014771477
   q5   4518437644264376
   q6   207 173 121 121
   q7   1937194717771777
   q8   2616259725442544
   q9   7450734869396939
   q10  2881312026662666
   q11  562 494 479 479
   q12  636 710 559 559
   q13  3282360130333033
   q14  290 289 272 272
   q15  527 482 483 482
   q16  10261052986 986
   q17  1090141413231323
   q18  7177715270187018
   q19  757 739 905 739
   q20  1925195218381838
   q21  4697423843134238
   q22  10951018991 991
   Total cold run time: 51947 ms
   Total hot run time: 49754 ms
   ```
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-18 Thread via GitHub


TsukiokaKogane commented on PR #58138:
URL: https://github.com/apache/doris/pull/58138#issuecomment-3551162596

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-18 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 27.39 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 72d8bc6af0c5a3c36b769358bc163e213ce4cfd0, 
data reload: false
   
   query1   0.050.050.05
   query2   0.090.050.04
   query3   0.260.080.08
   query4   1.610.110.11
   query5   0.260.250.27
   query6   1.160.640.63
   query7   0.030.030.02
   query8   0.050.040.04
   query9   0.580.540.51
   query10  0.590.570.57
   query11  0.160.120.11
   query12  0.150.110.11
   query13  0.620.600.61
   query14  1.011.000.98
   query15  0.850.820.84
   query16  0.400.390.39
   query17  1.030.991.02
   query18  0.210.200.20
   query19  1.901.821.77
   query20  0.020.010.02
   query21  15.45   0.220.12
   query22  5.010.070.04
   query23  15.71   0.260.09
   query24  3.230.560.96
   query25  0.070.070.06
   query26  0.150.120.12
   query27  0.080.050.05
   query28  5.631.180.96
   query29  12.55   3.853.20
   query30  0.280.140.13
   query31  2.820.580.39
   query32  3.220.550.48
   query33  2.993.023.20
   query34  15.65   5.194.53
   query35  4.544.604.54
   query36  0.670.490.48
   query37  0.090.060.06
   query38  0.060.040.04
   query39  0.030.020.03
   query40  0.160.140.13
   query41  0.090.030.03
   query42  0.040.030.03
   query43  0.040.030.03
   Total cold run time: 99.59 s
   Total hot run time: 27.39 s
   ```
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-18 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 188685 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 72d8bc6af0c5a3c36b769358bc163e213ce4cfd0, 
data reload: false
   
   query1   1011417 426 417
   query2   6565169417231694
   query3   6754226 221 221
   query4   26295   23013   22793   22793
   query5   4430655 531 531
   query6   335 251 231 231
   query7   4644502 300 300
   query8   300 267 254 254
   query9   8689292629032903
   query10  514 352 319 319
   query11  15900   15040   15197   15040
   query12  196 130 127 127
   query13  1699567 473 473
   query14  11605   939693029302
   query15  206 188 180 180
   query16  7684683 528 528
   query17  1400845 646 646
   query18  2053440 347 347
   query19  215 214 189 189
   query20  144 131 135 131
   query21  224 134 116 116
   query22  3964404839323932
   query23  33727   33087   32939   32939
   query24  8054247024342434
   query25  647 579 510 510
   query26  1250283 179 179
   query27  2731526 366 366
   query28  4442226322522252
   query29  843 660 564 564
   query30  304 230 201 201
   query31  960 803 772 772
   query32  94  90  86  86
   query33  608 425 371 371
   query34  853 855 536 536
   query35  827 831 767 767
   query36  953 985 897 897
   query37  128 116 96  96
   query38  3626358734473447
   query39  1479141814001400
   query40  239 143 130 130
   query41  65  60  59  59
   query42  137 124 120 120
   query43  496 487 470 470
   query44  1276799 816 799
   query45  189 187 175 175
   query46  895 1000660 660
   query47  1741183017061706
   query48  396 427 328 328
   query49  760 506 415 415
   query50  643 681 405 405
   query51  3906387939823879
   query52  123 128 112 112
   query53  256 283 210 210
   query54  349 335 307 307
   query55  99  99  94  94
   query56  350 340 336 336
   query57  1157116411201120
   query58  310 320 289 289
   query59  2569275325092509
   query60  376 371 361 361
   query61  166 173 162 162
   query62  781 703 655 655
   query63  233 206 204 204
   query64  45081193904 904
   query65  4056392339473923
   query66  1109440 350 350
   query67  15348   14974   14742   14742
   query68  8386962 635 635
   query69  474 351 300 300
   query70  1359130112311231
   query71  515 364 333 333
   query72  5833494450164944
   query73  697 604 367 367
   query74  9155915789318931
   query75  4010321228132813
   query76  37161140746 746
   query77  814 421 343 343
   query78  9463968688388838
   query79  2292875 611 611
   query80  689 606 532 532
   query81  531 262 237 237
   query82  462 174 139 139
   query83  265 267 253 253
   query84  256 120 99  99
   query85  912 518 467 467
   query86  401 319 287 287
   query87  3694374436293629
   query88  3754225022692250
   query89  407 329 296 296
   query90  2001247 241 241
   query91  169 166 139 139
   query92  96  83  76  76
   query93  1859986 683 683
   query94  703 443 331 331
   query95  430 358 333 333
   query96  481 577 284 284
   query97  2920294928742874
   query98  258 229 213 213
   query99  1660142313151315
   Total cold run time: 277548 ms
   Total hot run time: 188685 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] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-18 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 35190 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 72d8bc6af0c5a3c36b769358bc163e213ce4cfd0, 
data reload: false
   
   -- Round 1 --
   q1   17660   508450075007
   q2   2034327 209 209
   q3   10200   1281754 754
   q4   10230   944 374 374
   q5   7548248322752275
   q6   199 166 138 138
   q7   928 784 639 639
   q8   9373133111881188
   q9   7151544453925392
   q10  6843223218141814
   q11  476 298 284 284
   q12  342 371 229 229
   q13  17781   365730143014
   q14  249 232 214 214
   q15  572 516 506 506
   q16  10381009937 937
   q17  592 891 381 381
   q18  7488751179517511
   q19  13531015582 582
   q20  405 348 238 238
   q21  4574351724742474
   q22  1109109810301030
   Total cold run time: 108145 ms
   Total hot run time: 35190 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5223515650985098
   q2   333 412 304 304
   q3   2461294324722472
   q4   1460191314331433
   q5   4610440744744407
   q6   221 162 133 133
   q7   2016192317991799
   q8   2599267525182518
   q9   7593757475387538
   q10  3117331828262826
   q11  564 499 503 499
   q12  636 732 584 584
   q13  3295370831053105
   q14  268 276 262 262
   q15  543 485 486 485
   q16  10081041991 991
   q17  1110152513151315
   q18  7350705970387038
   q19  818 833 924 833
   q20  1917195818651865
   q21  4899439342004200
   q22  10941034990 990
   Total cold run time: 53135 ms
   Total hot run time: 50695 ms
   ```
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-18 Thread via GitHub


TsukiokaKogane commented on PR #58138:
URL: https://github.com/apache/doris/pull/58138#issuecomment-3551000927

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-18 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 27.68 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 017f267c41d4f9940f768eb321dfc77c010d605b, 
data reload: false
   
   query1   0.050.050.05
   query2   0.100.050.05
   query3   0.260.080.08
   query4   1.610.120.11
   query5   0.260.240.25
   query6   1.160.650.65
   query7   0.030.020.03
   query8   0.060.040.05
   query9   0.590.520.52
   query10  0.570.570.58
   query11  0.160.110.11
   query12  0.150.120.12
   query13  0.620.610.61
   query14  1.000.990.99
   query15  0.850.830.84
   query16  0.380.390.39
   query17  1.051.040.98
   query18  0.220.200.20
   query19  1.961.821.78
   query20  0.020.020.01
   query21  15.44   0.170.13
   query22  5.210.060.05
   query23  15.76   0.260.11
   query24  2.930.700.86
   query25  0.090.060.05
   query26  0.140.140.13
   query27  0.070.050.05
   query28  4.341.170.94
   query29  12.55   3.833.21
   query30  0.290.140.12
   query31  2.820.590.39
   query32  3.240.550.48
   query33  3.053.173.08
   query34  15.86   5.214.50
   query35  4.634.604.57
   query36  0.690.500.48
   query37  0.090.060.07
   query38  0.060.040.03
   query39  0.040.030.03
   query40  0.170.140.13
   query41  0.090.040.03
   query42  0.040.030.03
   query43  0.050.040.03
   Total cold run time: 98.75 s
   Total hot run time: 27.68 s
   ```
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-18 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 188738 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 017f267c41d4f9940f768eb321dfc77c010d605b, 
data reload: false
   
   query1   1025414 410 410
   query2   6570168716741674
   query3   6749237 223 223
   query4   26230   23108   23245   23108
   query5   4724655 497 497
   query6   331 242 220 220
   query7   4661498 313 313
   query8   295 267 250 250
   query9   8671294329372937
   query10  517 349 316 316
   query11  16115   15076   14892   14892
   query12  197 136 123 123
   query13  1694578 456 456
   query14  11286   933092439243
   query15  202 190 166 166
   query16  7699670 502 502
   query17  1232809 638 638
   query18  2087420 325 325
   query19  207 192 178 178
   query20  132 125 129 125
   query21  216 133 115 115
   query22  4024426440394039
   query23  34208   32991   33098   32991
   query24  8123236623572357
   query25  605 511 459 459
   query26  1236272 172 172
   query27  2736495 367 367
   query28  4404225322402240
   query29  786 625 495 495
   query30  305 223 197 197
   query31  927 801 684 684
   query32  90  89  78  78
   query33  595 402 345 345
   query34  799 866 564 564
   query35  818 820 740 740
   query36  969 1019908 908
   query37  125 119 95  95
   query38  3584351034733473
   query39  1481141214281412
   query40  232 139 125 125
   query41  64  60  60  60
   query42  129 122 118 118
   query43  495 484 468 468
   query44  1253814 809 809
   query45  192 179 173 173
   query46  881 981 647 647
   query47  1744179617501750
   query48  417 419 326 326
   query49  759 502 409 409
   query50  660 678 414 414
   query51  3843403938283828
   query52  121 115 112 112
   query53  241 279 212 212
   query54  341 318 303 303
   query55  95  94  91  91
   query56  346 349 338 338
   query57  1187119211221122
   query58  297 294 290 290
   query59  2504260625942594
   query60  367 370 343 343
   query61  168 161 159 159
   query62  792 727 654 654
   query63  255 201 196 196
   query64  44641178890 890
   query65  4032394639403940
   query66  1116460 340 340
   query67  15430   15156   14915   14915
   query68  4875968 647 647
   query69  487 330 298 298
   query70  1319129212021202
   query71  449 359 332 332
   query72  6018506252235062
   query73  654 621 363 363
   query74  9316888190598881
   query75  3274323228032803
   query76  33431143746 746
   query77  514 414 349 349
   query78  9536967489228922
   query79  1581842 616 616
   query80  1145643 552 552
   query81  522 267 233 233
   query82  427 170 139 139
   query83  274 278 251 251
   query84  262 122 100 100
   query85  952 506 458 458
   query86  334 305 320 305
   query87  3687373035853585
   query88  2841223022312230
   query89  394 330 290 290
   query90  1747240 218 218
   query91  167 177 144 144
   query92  86  77  75  75
   query93  11931024682 682
   query94  748 436 324 324
   query95  429 339 340 339
   query96  480 588 281 281
   query97  2895297128492849
   query98  249 220 224 220
   query99  1300139412891289
   Total cold run time: 270578 ms
   Total hot run time: 188738 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] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-18 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 34615 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 017f267c41d4f9940f768eb321dfc77c010d605b, 
data reload: false
   
   -- Round 1 --
   q1   17614   502448914891
   q2   2080318 206 206
   q3   10178   1316740 740
   q4   10247   972 378 378
   q5   7483237623602360
   q6   187 167 138 138
   q7   913 776 637 637
   q8   9356133511161116
   q9   6893509151055091
   q10  6812223018231823
   q11  462 296 285 285
   q12  345 371 235 235
   q13  17804   366330633063
   q14  233 238 217 217
   q15  552 514 496 496
   q16  10341003942 942
   q17  580 883 363 363
   q18  7413736179717361
   q19  1424979 569 569
   q20  360 355 231 231
   q21  4327363424392439
   q22  1272110910341034
   Total cold run time: 107569 ms
   Total hot run time: 34615 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5166516052595160
   q2   241 321 230 230
   q3   2377282427032703
   q4   1444182614851485
   q5   4596445245264452
   q6   216 167 125 125
   q7   2005192217881788
   q8   2638251725832517
   q9   7364710672087106
   q10  3103327528252825
   q11  583 538 510 510
   q12  703 772 646 646
   q13  3580382230113011
   q14  285 275 260 260
   q15  528 480 480 480
   q16  1011105510101010
   q17  1085149013141314
   q18  7315728771837183
   q19  759 739 831 739
   q20  1909193318321832
   q21  4855445143774377
   q22  1133103910251025
   Total cold run time: 52896 ms
   Total hot run time: 50778 ms
   ```
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-18 Thread via GitHub


TsukiokaKogane commented on PR #58138:
URL: https://github.com/apache/doris/pull/58138#issuecomment-3550594417

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-18 Thread via GitHub


TsukiokaKogane commented on PR #58138:
URL: https://github.com/apache/doris/pull/58138#issuecomment-3547771826

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] [feat](schema change) enforce key keyword when add key column on AGG table [doris]

2025-11-18 Thread via GitHub


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

   
   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]