Re: [PR] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-23 Thread via GitHub


yx-keith commented on PR #53486:
URL: https://github.com/apache/doris/pull/53486#issuecomment-3111587633

   run p0 regression


-- 
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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-23 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 31.99 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit d741b95f407e4a09943b777156c66e3abbd1e3f6, 
data reload: false
   
   query1   0.040.050.04
   query2   0.090.040.04
   query3   0.240.080.07
   query4   1.620.100.10
   query5   0.430.410.40
   query6   1.170.660.66
   query7   0.030.020.01
   query8   0.040.030.04
   query9   0.590.510.52
   query10  0.580.570.57
   query11  0.160.110.11
   query12  0.150.120.11
   query13  0.620.620.61
   query14  0.790.820.82
   query15  0.880.860.88
   query16  0.380.390.40
   query17  1.051.071.00
   query18  0.210.200.20
   query19  1.891.811.89
   query20  0.010.020.01
   query21  15.39   0.910.55
   query22  0.791.130.75
   query23  14.89   1.350.61
   query24  6.671.850.30
   query25  0.280.100.22
   query26  0.540.160.13
   query27  0.070.060.05
   query28  9.860.910.42
   query29  12.53   3.913.29
   query30  3.073.043.01
   query31  2.820.580.38
   query32  3.230.550.46
   query33  3.063.063.09
   query34  15.76   5.454.80
   query35  4.874.904.90
   query36  0.690.520.49
   query37  0.090.080.06
   query38  0.050.050.04
   query39  0.040.030.03
   query40  0.170.140.14
   query41  0.070.030.02
   query42  0.040.020.02
   query43  0.040.030.03
   Total cold run time: 105.99 s
   Total hot run time: 31.99 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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-23 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 187574 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 d741b95f407e4a09943b777156c66e3abbd1e3f6, 
data reload: false
   
   query1   989 405 411 405
   query2   6509174517271727
   query3   6752218 221 218
   query4   26159   23999   23191   23191
   query5   4870644 506 506
   query6   322 234 205 205
   query7   4627510 299 299
   query8   305 248 226 226
   query9   8576286028852860
   query10  485 346 296 296
   query11  15941   15054   14735   14735
   query12  169 121 119 119
   query13  1652551 406 406
   query14  9538601760456017
   query15  205 185 172 172
   query16  7670630 463 463
   query17  1176680 573 573
   query18  2020405 305 305
   query19  189 223 163 163
   query20  128 119 113 113
   query21  215 120 103 103
   query22  3959424940424042
   query23  33957   32980   33180   32980
   query24  8128242824412428
   query25  538 468 430 430
   query26  1242274 164 164
   query27  2733518 344 344
   query28  4315222021812181
   query29  733 579 466 466
   query30  292 223 189 189
   query31  965 828 747 747
   query32  85  78  76  76
   query33  561 383 346 346
   query34  810 847 518 518
   query35  832 836 758 758
   query36  996 1005943 943
   query37  116 107 84  84
   query38  4144414140504050
   query39  1452140914141409
   query40  225 127 142 127
   query41  59  63  53  53
   query42  125 109 110 109
   query43  520 511 478 478
   query44  1409870 865 865
   query45  178 174 172 172
   query46  887 1037672 672
   query47  1754180017701770
   query48  394 443 317 317
   query49  728 486 393 393
   query50  678 714 406 406
   query51  5613555853615361
   query52  116 116 108 108
   query53  235 275 191 191
   query54  608 594 533 533
   query55  91  89  90  89
   query56  320 329 321 321
   query57  1170118811281128
   query58  279 279 298 279
   query59  2690270027102700
   query60  367 349 331 331
   query61  160 128 129 128
   query62  785 724 684 684
   query63  229 199 192 192
   query64  42601008695 695
   query65  4237417241684168
   query66  1084428 345 345
   query67  15730   15313   15249   15249
   query68  6466930 565 565
   query69  472 333 294 294
   query70  1233117611471147
   query71  488 347 316 316
   query72  5558467446364636
   query73  754 584 357 357
   query74  9027882490218824
   query75  3153312926692669
   query76  31341198771 771
   query77  496 408 329 329
   query78  9893996292699269
   query79  2078838 586 586
   query80  718 544 482 482
   query81  495 259 224 224
   query82  190 138 107 107
   query83  256 247 232 232
   query84  247 108 86  86
   query85  753 367 326 326
   query86  381 312 307 307
   query87  4412439143084308
   query88  2900228622702270
   query89  387 313 290 290
   query90  1944228 223 223
   query91  139 141 109 109
   query92  93  78  70  70
   query93  2251973 636 636
   query94  685 397 305 305
   query95  399 318 315 315
   query96  485 588 277 277
   query97  2621270726342634
   query98  240 214 211 211
   query99  1325136912781278
   Total cold run time: 272959 ms
   Total hot run time: 187574 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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-23 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 34302 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit d741b95f407e4a09943b777156c66e3abbd1e3f6, 
data reload: false
   
   -- Round 1 --
   q1   17626   527051175117
   q2   1925272 176 176
   q3   10342   1304733 733
   q4   10241   1056529 529
   q5   7506241523142314
   q6   181 159 129 129
   q7   915 738 610 610
   q8   9301134212321232
   q9   6884510751355107
   q10  6896236619561956
   q11  477 303 280 280
   q12  343 360 222 222
   q13  17779   372431773177
   q14  237 221 229 221
   q15  540 496 479 479
   q16  429 448 379 379
   q17  593 882 368 368
   q18  7764710971927109
   q19  1221931 560 560
   q20  364 360 229 229
   q21  3971323123842384
   q22  10991021991 991
   Total cold run time: 106634 ms
   Total hot run time: 34302 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5223548151495149
   q2   237 323 222 222
   q3   2221266623282328
   q4   1381187913781378
   q5   4235456545364536
   q6   219 174 135 135
   q7   2044200918591859
   q8   2667273326392639
   q9   7382716374077163
   q10  3106329128722872
   q11  611 528 499 499
   q12  698 768 688 688
   q13  3709405634563456
   q14  298 313 279 279
   q15  517 489 485 485
   q16  485 512 515 512
   q17  1219161013881388
   q18  8119777576427642
   q19  857 903 1033903
   q20  2066207318941894
   q21  5222457843174317
   q22  1094102210071007
   Total cold run time: 53610 ms
   Total hot run time: 51351 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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-23 Thread via GitHub


yx-keith commented on PR #53486:
URL: https://github.com/apache/doris/pull/53486#issuecomment-3109137348

   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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-23 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 32.4 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 732db4f4fd5131caf4beef5ec5455c33e821a0b5, 
data reload: false
   
   query1   0.040.030.04
   query2   0.080.040.04
   query3   0.240.080.07
   query4   1.630.110.11
   query5   0.430.430.39
   query6   1.160.650.66
   query7   0.030.020.02
   query8   0.040.030.04
   query9   0.600.530.50
   query10  0.580.580.56
   query11  0.160.100.10
   query12  0.140.120.12
   query13  0.630.620.62
   query14  0.830.820.84
   query15  0.900.860.87
   query16  0.400.390.38
   query17  1.071.061.06
   query18  0.210.210.20
   query19  1.971.861.88
   query20  0.010.020.01
   query21  15.37   0.920.57
   query22  0.781.160.66
   query23  14.97   1.370.65
   query24  6.920.681.72
   query25  0.490.220.07
   query26  0.510.190.15
   query27  0.060.040.05
   query28  9.660.950.43
   query29  12.55   3.923.25
   query30  3.073.043.01
   query31  2.810.590.37
   query32  3.250.540.48
   query33  3.033.073.15
   query34  16.08   5.444.87
   query35  4.844.874.86
   query36  0.680.520.48
   query37  0.090.070.06
   query38  0.050.040.04
   query39  0.040.030.02
   query40  0.170.140.13
   query41  0.070.020.02
   query42  0.030.020.02
   query43  0.040.040.04
   Total cold run time: 106.71 s
   Total hot run time: 32.4 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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-23 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 187537 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 732db4f4fd5131caf4beef5ec5455c33e821a0b5, 
data reload: false
   
   query1   1000402 391 391
   query2   6507172517621725
   query3   6743224 219 219
   query4   27072   23539   23364   23364
   query5   4504618 498 498
   query6   344 225 199 199
   query7   4622501 293 293
   query8   277 240 223 223
   query9   8601287328412841
   query10  490 365 284 284
   query11  15784   15071   14778   14778
   query12  173 114 116 114
   query13  1662542 420 420
   query14  9594588358685868
   query15  211 180 168 168
   query16  7644658 442 442
   query17  1190731 594 594
   query18  2026413 335 335
   query19  205 194 162 162
   query20  126 118 116 116
   query21  213 124 111 111
   query22  4214416240854085
   query23  34329   32916   32999   32916
   query24  8126239324212393
   query25  534 488 419 419
   query26  1216271 159 159
   query27  2691503 347 347
   query28  4371219821662166
   query29  698 577 463 463
   query30  283 218 192 192
   query31  925 814 748 748
   query32  87  80  77  77
   query33  599 381 343 343
   query34  794 905 518 518
   query35  775 801 742 742
   query36  985 1000929 929
   query37  118 107 89  89
   query38  4125408940544054
   query39  1469140714191407
   query40  222 129 117 117
   query41  60  58  56  56
   query42  120 113 114 113
   query43  506 494 463 463
   query44  1397865 854 854
   query45  181 170 171 170
   query46  868 992 628 628
   query47  1743183617071707
   query48  386 427 323 323
   query49  706 480 375 375
   query50  663 692 411 411
   query51  5437573455865586
   query52  121 108 105 105
   query53  237 273 201 201
   query54  613 602 519 519
   query55  91  87  89  87
   query56  315 313 315 313
   query57  1219118611211121
   query58  273 267 274 267
   query59  2626260925282528
   query60  346 341 329 329
   query61  131 122 125 122
   query62  796 724 657 657
   query63  230 198 187 187
   query64  41841066691 691
   query65  4265421441914191
   query66  1072421 325 325
   query67  15810   15362   15382   15362
   query68  8531914 555 555
   query69  470 327 286 286
   query70  1277112311421123
   query71  452 335 321 321
   query72  5315465646174617
   query73  718 566 348 348
   query74  9343901089248924
   query75  3923310526492649
   query76  36301146725 725
   query77  842 397 312 312
   query78  10111   10152   93379337
   query79  2314836 590 590
   query80  606 535 494 494
   query81  511 261 225 225
   query82  468 136 106 106
   query83  250 256 244 244
   query84  249 111 81  81
   query85  796 365 341 341
   query86  391 314 297 297
   query87  4326440443784378
   query88  3371226422652264
   query89  382 323 280 280
   query90  1856222 221 221
   query91  139 149 114 114
   query92  82  73  68  68
   query93  1689974 616 616
   query94  710 398 311 311
   query95  401 317 304 304
   query96  497 586 279 279
   query97  2710275426052605
   query98  254 217 211 211
   query99  1457135113111311
   Total cold run time: 278016 ms
   Total hot run time: 187537 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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-23 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 33929 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 732db4f4fd5131caf4beef5ec5455c33e821a0b5, 
data reload: false
   
   -- Round 1 --
   q1   17573   522351645164
   q2   1947285 179 179
   q3   10308   1282696 696
   q4   10246   1014526 526
   q5   8244240223262326
   q6   190 156 126 126
   q7   880 748 598 598
   q8   9309131511031103
   q9   6953513350455045
   q10  6938237819461946
   q11  480 284 259 259
   q12  341 352 217 217
   q13  18025   362731453145
   q14  238 244 236 236
   q15  555 489 483 483
   q16  423 422 374 374
   q17  598 861 355 355
   q18  7373705271927052
   q19  1222947 563 563
   q20  334 337 220 220
   q21  3828317223342334
   q22  10531030982 982
   Total cold run time: 107058 ms
   Total hot run time: 33929 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5140509250725072
   q2   232 320 215 215
   q3   2175265722842284
   q4   1396176613451345
   q5   4181454444484448
   q6   221 167 127 127
   q7   2067191717831783
   q8   2608254626112546
   q9   7364733872797279
   q10  3038330629022902
   q11  587 504 510 504
   q12  761 799 647 647
   q13  3640400233753375
   q14  305 305 286 286
   q15  521 465 470 465
   q16  494 496 451 451
   q17  1183155313891389
   q18  7847770372657265
   q19  745 719 790 719
   q20  1909190818121812
   q21  4780429942634263
   q22  1057102410081008
   Total cold run time: 52251 ms
   Total hot run time: 50185 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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-23 Thread via GitHub


yx-keith commented on PR #53486:
URL: https://github.com/apache/doris/pull/53486#issuecomment-3106517800

   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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-23 Thread via GitHub


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

   # FE UT Coverage Report
   Increment line coverage `  50.06% (454/907)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/53486_5fc385bcc61b0a2750476a2cacfb00b0f2d93e6e/fe_increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/53486_5fc385bcc61b0a2750476a2cacfb00b0f2d93e6e/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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-23 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 33.08 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 5fc385bcc61b0a2750476a2cacfb00b0f2d93e6e, 
data reload: false
   
   query1   0.040.040.04
   query2   0.080.040.04
   query3   0.260.070.08
   query4   1.620.110.11
   query5   0.460.420.39
   query6   1.180.650.67
   query7   0.030.020.02
   query8   0.050.030.03
   query9   0.600.530.51
   query10  0.570.570.58
   query11  0.160.110.11
   query12  0.150.120.12
   query13  0.630.620.62
   query14  0.790.820.86
   query15  0.900.890.88
   query16  0.390.390.39
   query17  1.051.041.03
   query18  0.210.200.20
   query19  1.931.841.83
   query20  0.010.020.02
   query21  15.40   0.880.55
   query22  0.761.220.73
   query23  14.80   1.380.63
   query24  6.491.581.17
   query25  0.520.180.16
   query26  0.520.160.15
   query27  0.060.060.06
   query28  10.52   0.860.43
   query29  12.54   3.993.27
   query30  3.123.023.00
   query31  2.830.600.38
   query32  3.230.550.48
   query33  3.093.063.11
   query34  15.86   5.414.84
   query35  4.904.934.91
   query36  0.690.510.50
   query37  0.100.070.06
   query38  0.050.050.03
   query39  0.030.020.03
   query40  0.160.140.14
   query41  0.070.030.02
   query42  0.030.030.02
   query43  0.040.030.02
   Total cold run time: 106.92 s
   Total hot run time: 33.08 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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-23 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 187327 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 5fc385bcc61b0a2750476a2cacfb00b0f2d93e6e, 
data reload: false
   
   query1   994 389 404 389
   query2   6518168916831683
   query3   6739229 224 224
   query4   26336   23586   23308   23308
   query5   4347615 489 489
   query6   323 224 210 210
   query7   4637499 291 291
   query8   281 229 218 218
   query9   8634287928932879
   query10  483 321 269 269
   query11  16194   15012   14774   14774
   query12  163 117 110 110
   query13  1661540 412 412
   query14  9394605659315931
   query15  205 186 169 169
   query16  7486643 469 469
   query17  1212730 611 611
   query18  2020432 331 331
   query19  197 184 175 175
   query20  126 118 181 118
   query21  217 120 106 106
   query22  4191407742004077
   query23  33983   33064   33212   33064
   query24  8162236924032369
   query25  569 474 410 410
   query26  1220276 158 158
   query27  2749493 345 345
   query28  4324219721582158
   query29  758 567 454 454
   query30  283 218 193 193
   query31  922 823 747 747
   query32  81  76  70  70
   query33  565 382 336 336
   query34  789 842 521 521
   query35  838 827 746 746
   query36  987 1001908 908
   query37  122 104 90  90
   query38  4169408240404040
   query39  1453140914051405
   query40  247 129 120 120
   query41  59  56  56  56
   query42  126 110 106 106
   query43  480 501 467 467
   query44  1365850 865 850
   query45  175 170 172 170
   query46  833 1077636 636
   query47  1774185717551755
   query48  376 412 306 306
   query49  712 474 385 385
   query50  639 709 403 403
   query51  5535560455685568
   query52  115 118 100 100
   query53  230 263 187 187
   query54  595 591 522 522
   query55  89  84  87  84
   query56  313 308 310 308
   query57  1183120111101110
   query58  277 270 274 270
   query59  2521270625582558
   query60  351 363 329 329
   query61  131 125 125 125
   query62  781 728 640 640
   query63  228 190 183 183
   query64  43761010683 683
   query65  4268417741944177
   query66  1131421 342 342
   query67  16023   15569   15413   15413
   query68  8544908 616 616
   query69  475 333 287 287
   query70  1308111911001100
   query71  501 333 304 304
   query72  5820468448134684
   query73  762 636 354 354
   query74  9285883287338733
   query75  3878311926252625
   query76  37361143722 722
   query77  784 384 323 323
   query78  10150   92939293
   query79  2421798 593 593
   query80  659 556 473 473
   query81  489 252 225 225
   query82  460 197 105 105
   query83  281 247 252 247
   query84  289 106 79  79
   query85  785 371 320 320
   query86  395 307 308 307
   query87  4433447842104210
   query88  3357221922372219
   query89  448 328 286 286
   query90  1899226 219 219
   query91  143 140 113 113
   query92  82  71  68  68
   query93  1746968 631 631
   query94  659 384 305 305
   query95  397 314 305 305
   query96  489 571 275 275
   query97  2748270227002700
   query98  231 217 207 207
   query99  1416140812891289
   Total cold run time: 278184 ms
   Total hot run time: 187327 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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-23 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 34128 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 5fc385bcc61b0a2750476a2cacfb00b0f2d93e6e, 
data reload: false
   
   -- Round 1 --
   q1   17615   529051115111
   q2   1917277 192 192
   q3   10332   1323698 698
   q4   10212   1025522 522
   q5   7503244923482348
   q6   172 158 130 130
   q7   883 725 633 633
   q8   9323134611171117
   q9   7124509251035092
   q10  6954236819841984
   q11  465 290 277 277
   q12  358 354 212 212
   q13  17764   371630903090
   q14  235 222 213 213
   q15  587 492 493 492
   q16  419 420 367 367
   q17  625 877 388 388
   q18  7554711771987117
   q19  1218947 562 562
   q20  340 374 248 248
   q21  4130319323832383
   q22  10441031952 952
   Total cold run time: 106774 ms
   Total hot run time: 34128 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5225513551885135
   q2   243 322 225 225
   q3   2232264523002300
   q4   1399190013351335
   q5   4335464145984598
   q6   219 171 126 126
   q7   2112197118381838
   q8   2675259429122594
   q9   7342718271207120
   q10  3143333428892889
   q11  569 516 505 505
   q12  703 812 652 652
   q13  3739402635313531
   q14  283 305 293 293
   q15  518 512 472 472
   q16  452 489 432 432
   q17  1223155413861386
   q18  8025770377877703
   q19  829 861 918 861
   q20  2009197717951795
   q21  4809437543684368
   q22  10691061987 987
   Total cold run time: 53153 ms
   Total hot run time: 51145 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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-22 Thread via GitHub


yx-keith commented on PR #53486:
URL: https://github.com/apache/doris/pull/53486#issuecomment-3106085552

   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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-22 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 188309 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 990eae93594e22836bfbf6bccfdd1513868bee8d, 
data reload: false
   
   query1   1003386 409 386
   query2   6516167216741672
   query3   6737224 225 224
   query4   26382   24063   23884   23884
   query5   4409652 480 480
   query6   297 225 198 198
   query7   4626502 287 287
   query8   274 232 242 232
   query9   8584287528712871
   query10  490 334 288 288
   query11  15761   15003   14881   14881
   query12  164 125 116 116
   query13  1657552 416 416
   query14  8688594859755948
   query15  205 191 176 176
   query16  7128636 454 454
   query17  954 741 616 616
   query18  1998415 329 329
   query19  196 193 167 167
   query20  124 122 118 118
   query21  214 131 110 110
   query22  4201433539713971
   query23  34089   33014   33095   33014
   query24  8190239524112395
   query25  541 480 405 405
   query26  1237286 162 162
   query27  2736523 350 350
   query28  4338221822122212
   query29  762 581 459 459
   query30  288 218 202 202
   query31  916 835 732 732
   query32  84  78  74  74
   query33  558 386 341 341
   query34  811 862 539 539
   query35  786 829 768 768
   query36  955 1015909 909
   query37  123 108 86  86
   query38  4141424340734073
   query39  1486141514011401
   query40  223 128 122 122
   query41  59  56  56  56
   query42  126 111 108 108
   query43  532 500 464 464
   query44  1379860 854 854
   query45  177 169 165 165
   query46  900 1022641 641
   query47  1775182517031703
   query48  384 438 319 319
   query49  759 492 388 388
   query50  682 714 412 412
   query51  5534545756515457
   query52  121 111 102 102
   query53  240 269 195 195
   query54  595 594 522 522
   query55  92  93  90  90
   query56  334 326 307 307
   query57  1193120811501150
   query58  290 275 275 275
   query59  2630262225512551
   query60  347 377 333 333
   query61  134 129 130 129
   query62  805 732 662 662
   query63  229 195 192 192
   query64  43321017692 692
   query65  4314418142274181
   query66  1180420 322 322
   query67  15719   15517   15585   15517
   query68  8067991 559 559
   query69  475 335 306 306
   query70  1200118611651165
   query71  468 352 310 310
   query72  5667476148484761
   query73  729 637 363 363
   query74  8948915388368836
   query75  3832310326622662
   query76  37011154738 738
   query77  809 415 319 319
   query78  998110095   92919291
   query79  2476852 593 593
   query80  628 558 481 481
   query81  470 262 217 217
   query82  436 135 109 109
   query83  283 256 242 242
   query84  299 103 82  82
   query85  787 377 336 336
   query86  338 313 294 294
   query87  4419439642824282
   query88  3192223922282228
   query89  401 312 279 279
   query90  1917228 221 221
   query91  139 144 116 116
   query92  80  70  74  70
   query93  13731010624 624
   query94  695 402 303 303
   query95  399 319 313 313
   query96  494 591 280 280
   query97  2723275225982598
   query98  234 218 209 209
   query99  1450141812671267
   Total cold run time: 274844 ms
   Total hot run time: 188309 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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-22 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 32.37 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 990eae93594e22836bfbf6bccfdd1513868bee8d, 
data reload: false
   
   query1   0.040.040.04
   query2   0.090.050.04
   query3   0.250.070.07
   query4   1.610.120.11
   query5   0.420.420.40
   query6   1.150.650.67
   query7   0.020.020.02
   query8   0.040.030.03
   query9   0.590.530.51
   query10  0.580.580.56
   query11  0.150.110.11
   query12  0.150.120.12
   query13  0.620.610.61
   query14  0.800.860.85
   query15  0.910.880.87
   query16  0.380.390.39
   query17  1.081.061.06
   query18  0.220.200.20
   query19  1.991.791.84
   query20  0.020.020.02
   query21  15.39   0.880.54
   query22  0.791.240.88
   query23  14.76   1.380.64
   query24  6.482.330.37
   query25  0.380.190.14
   query26  0.650.180.15
   query27  0.060.060.06
   query28  9.400.950.43
   query29  12.52   3.983.27
   query30  3.073.012.98
   query31  2.830.590.37
   query32  3.250.550.50
   query33  3.053.073.13
   query34  15.75   5.464.83
   query35  4.864.904.87
   query36  0.700.500.49
   query37  0.090.060.06
   query38  0.060.050.04
   query39  0.030.020.03
   query40  0.160.140.14
   query41  0.090.020.02
   query42  0.040.020.02
   query43  0.040.030.03
   Total cold run time: 105.56 s
   Total hot run time: 32.37 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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-22 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 34118 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 990eae93594e22836bfbf6bccfdd1513868bee8d, 
data reload: false
   
   -- Round 1 --
   q1   17604   522151415141
   q2   1930275 178 178
   q3   10312   1300734 734
   q4   10214   991 531 531
   q5   7512243923582358
   q6   179 160 129 129
   q7   894 750 614 614
   q8   9295130311071107
   q9   6750515351425142
   q10  6895238719501950
   q11  492 295 281 281
   q12  341 351 215 215
   q13  17765   370730803080
   q14  226 227 213 213
   q15  538 498 474 474
   q16  421 427 377 377
   q17  632 880 387 387
   q18  7682728170417041
   q19  1209948 590 590
   q20  350 336 250 250
   q21  3990315423342334
   q22  10701014992 992
   Total cold run time: 106301 ms
   Total hot run time: 34118 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5322513651135113
   q2   244 317 219 219
   q3   2199279023252325
   q4   1360176013311331
   q5   4255457246904572
   q6   228 174 130 130
   q7   2041195118731873
   q8   2679264425472547
   q9   7350725671747174
   q10  3140332629062906
   q11  597 496 509 496
   q12  744 777 627 627
   q13  3674405934053405
   q14  303 292 304 292
   q15  524 481 480 480
   q16  458 494 454 454
   q17  1224157713731373
   q18  7896765977527659
   q19  824 871 906 871
   q20  1973205818121812
   q21  4954438443134313
   q22  10851062994 994
   Total cold run time: 53074 ms
   Total hot run time: 50966 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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-22 Thread via GitHub


yx-keith commented on PR #53486:
URL: https://github.com/apache/doris/pull/53486#issuecomment-3105842144

   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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-22 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 32.49 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 1f98610be51858f016ed607a75ecfd25da717ead, 
data reload: false
   
   query1   0.040.040.04
   query2   0.080.040.05
   query3   0.240.070.08
   query4   1.630.110.11
   query5   0.440.420.40
   query6   1.160.640.66
   query7   0.030.020.02
   query8   0.050.040.03
   query9   0.610.520.52
   query10  0.580.580.58
   query11  0.150.110.11
   query12  0.150.120.11
   query13  0.610.620.61
   query14  0.790.810.81
   query15  0.880.880.89
   query16  0.390.380.39
   query17  1.031.031.07
   query18  0.210.200.20
   query19  1.981.801.78
   query20  0.010.010.01
   query21  15.39   0.880.53
   query22  0.821.050.66
   query23  15.00   1.380.64
   query24  6.781.260.99
   query25  0.440.180.10
   query26  0.670.190.14
   query27  0.060.060.05
   query28  8.900.930.44
   query29  12.56   3.903.22
   query30  3.083.062.94
   query31  2.820.590.38
   query32  3.230.550.46
   query33  3.053.153.10
   query34  16.13   5.434.79
   query35  4.884.874.83
   query36  0.680.530.49
   query37  0.100.070.07
   query38  0.050.050.04
   query39  0.030.030.03
   query40  0.170.150.14
   query41  0.070.030.03
   query42  0.040.030.02
   query43  0.040.030.03
   Total cold run time: 106.05 s
   Total hot run time: 32.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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-22 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 187550 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 1f98610be51858f016ed607a75ecfd25da717ead, 
data reload: false
   
   query1   1027375 396 375
   query2   6511175017001700
   query3   6734215 219 215
   query4   26294   23618   23408   23408
   query5   4352600 507 507
   query6   322 221 213 213
   query7   4633476 294 294
   query8   270 233 220 220
   query9   8610281528112811
   query10  483 326 281 281
   query11  15777   15033   14741   14741
   query12  168 113 114 113
   query13  1666513 428 428
   query14  9507583658395836
   query15  204 197 172 172
   query16  7601636 473 473
   query17  1196733 597 597
   query18  2047412 314 314
   query19  202 191 165 165
   query20  127 119 123 119
   query21  209 123 111 111
   query22  4192433542344234
   query23  33791   33136   33194   33136
   query24  8153235523572355
   query25  532 478 432 432
   query26  1231264 157 157
   query27  2751498 340 340
   query28  4322216721432143
   query29  717 576 450 450
   query30  292 214 185 185
   query31  902 862 727 727
   query32  79  74  75  74
   query33  544 377 359 359
   query34  823 827 521 521
   query35  823 834 736 736
   query36  979 966 922 922
   query37  119 106 86  86
   query38  4127408040604060
   query39  1497142513931393
   query40  221 128 111 111
   query41  59  57  54  54
   query42  119 103 112 103
   query43  498 501 454 454
   query44  1311833 833 833
   query45  174 167 160 160
   query46  851 995 630 630
   query47  1840187918031803
   query48  377 436 314 314
   query49  692 479 389 389
   query50  636 698 389 389
   query51  5621554555895545
   query52  116 109 101 101
   query53  227 259 187 187
   query54  587 572 519 519
   query55  91  89  87  87
   query56  317 312 315 312
   query57  1212121411461146
   query58  281 264 274 264
   query59  2516270026072607
   query60  344 336 323 323
   query61  129 128 124 124
   query62  807 710 661 661
   query63  220 192 192 192
   query64  42631072684 684
   query65  4318415542294155
   query66  1076412 332 332
   query67  15669   15673   15434   15434
   query68  8925903 543 543
   query69  466 309 288 288
   query70  1285116911931169
   query71  445 323 314 314
   query72  5638471348244713
   query73  739 618 359 359
   query74  9315908287388738
   query75  4132309427112711
   query76  36681139730 730
   query77  823 396 312 312
   query78  10015   10076   92989298
   query79  6066801 570 570
   query80  682 532 480 480
   query81  465 251 224 224
   query82  611 136 108 108
   query83  283 259 234 234
   query84  295 119 89  89
   query85  772 368 329 329
   query86  338 324 291 291
   query87  4394438142504250
   query88  2845222122232221
   query89  438 319 286 286
   query90  2026220 215 215
   query91  183 136 110 110
   query92  84  68  65  65
   query93  3600950 612 612
   query94  680 393 303 303
   query95  400 311 309 309
   query96  482 597 272 272
   query97  2691271926092609
   query98  226 218 206 206
   query99  1444141612761276
   Total cold run time: 282842 ms
   Total hot run time: 187550 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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-22 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 33811 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 1f98610be51858f016ed607a75ecfd25da717ead, 
data reload: false
   
   -- Round 1 --
   q1   17587   519650565056
   q2   1942285 180 180
   q3   10296   1275700 700
   q4   10215   995 517 517
   q5   7508238623242324
   q6   173 156 128 128
   q7   886 742 595 595
   q8   9298131010661066
   q9   7247512851485128
   q10  6872238719531953
   q11  466 301 285 285
   q12  339 348 216 216
   q13  17774   365930873087
   q14  235 229 216 216
   q15  536 478 471 471
   q16  425 424 374 374
   q17  616 860 381 381
   q18  7587714070597059
   q19  1217925 553 553
   q20  334 328 221 221
   q21  4188308422942294
   q22  1080105010071007
   Total cold run time: 106821 ms
   Total hot run time: 33811 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5110509652075096
   q2   237 339 218 218
   q3   2151264822432243
   q4   1343174113001300
   q5   4158446244504450
   q6   208 168 130 130
   q7   2066197618281828
   q8   2680260425842584
   q9   7332726773287267
   q10  3093328229332933
   q11  582 521 487 487
   q12  778 795 652 652
   q13  3564395334063406
   q14  273 314 281 281
   q15  518 466 475 466
   q16  449 474 437 437
   q17  1173159913541354
   q18  7793774375377537
   q19  788 790 828 790
   q20  1905193618431843
   q21  4740451142614261
   q22  10461055995 995
   Total cold run time: 51987 ms
   Total hot run time: 50558 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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-22 Thread via GitHub


yx-keith commented on PR #53486:
URL: https://github.com/apache/doris/pull/53486#issuecomment-3105469635

   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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-22 Thread via GitHub


yx-keith commented on PR #53486:
URL: https://github.com/apache/doris/pull/53486#issuecomment-3105379779

   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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-22 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 188221 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 82aff44e8ec92d0e3c2933572aa10b723bdaed30, 
data reload: false
   
   query1   985 385 420 385
   query2   6512177016871687
   query3   6739219 228 219
   query4   26443   23748   23886   23748
   query5   4783620 479 479
   query6   313 220 206 206
   query7   4639502 293 293
   query8   271 248 225 225
   query9   8629288628442844
   query10  509 341 282 282
   query11  15808   14927   14752   14752
   query12  178 114 112 112
   query13  1660527 425 425
   query14  9343592059135913
   query15  209 194 169 169
   query16  7416636 448 448
   query17  1163723 609 609
   query18  1998409 326 326
   query19  199 191 162 162
   query20  132 125 112 112
   query21  217 123 113 113
   query22  4291412340444044
   query23  33956   33128   33171   33128
   query24  8154238623352335
   query25  538 509 418 418
   query26  1235274 153 153
   query27  2731506 342 342
   query28  4305219521622162
   query29  735 593 454 454
   query30  286 221 189 189
   query31  917 828 783 783
   query32  84  73  79  73
   query33  544 367 334 334
   query34  781 830 523 523
   query35  776 840 782 782
   query36  10061001922 922
   query37  122 103 86  86
   query38  4161408339753975
   query39  1497142714021402
   query40  217 129 114 114
   query41  61  59  52  52
   query42  119 108 107 107
   query43  507 518 473 473
   query44  1346856 847 847
   query45  184 169 168 168
   query46  836 994 637 637
   query47  1799183117671767
   query48  380 424 312 312
   query49  743 479 376 376
   query50  663 704 408 408
   query51  5592566255195519
   query52  117 109 104 104
   query53  234 262 192 192
   query54  595 596 530 530
   query55  84  87  90  87
   query56  327 318 306 306
   query57  1171121911401140
   query58  281 263 270 263
   query59  2637261824512451
   query60  363 389 351 351
   query61  122 120 123 120
   query62  796 714 685 685
   query63  227 192 190 190
   query64  4277995 665 665
   query65  4274424942394239
   query66  1135421 348 348
   query67  15856   15540   15477   15477
   query68  8460914 567 567
   query69  472 323 290 290
   query70  1237115611121112
   query71  470 337 314 314
   query72  5543470048024700
   query73  745 629 356 356
   query74  9124912689168916
   query75  3862308926532653
   query76  37311128724 724
   query77  793 388 316 316
   query78  997110176   93789378
   query79  2678802 602 602
   query80  630 536 473 473
   query81  473 254 223 223
   query82  456 137 113 113
   query83  278 246 244 244
   query84  290 103 88  88
   query85  850 352 327 327
   query86  344 331 279 279
   query87  4371447643624362
   query88  3107226822782268
   query89  393 319 296 296
   query90  1947241 234 234
   query91  137 219 111 111
   query92  85  74  66  66
   query93  1163960 620 620
   query94  663 403 306 306
   query95  392 318 313 313
   query96  482 588 280 280
   query97  2685274826702670
   query98  240 220 208 208
   query99  1463138812701270
   Total cold run time: 276743 ms
   Total hot run time: 188221 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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-22 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 33898 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 82aff44e8ec92d0e3c2933572aa10b723bdaed30, 
data reload: false
   
   -- Round 1 --
   q1   17561   530250925092
   q2   1947276 175 175
   q3   10328   1303721 721
   q4   10237   982 506 506
   q5   7845243322742274
   q6   187 155 128 128
   q7   892 741 616 616
   q8   9305129010791079
   q9   6857510350835083
   q10  6884240419681968
   q11  477 306 276 276
   q12  332 356 214 214
   q13  17770   367830993099
   q14  237 221 216 216
   q15  545 488 478 478
   q16  412 429 379 379
   q17  606 857 384 384
   q18  7524712270927092
   q19  1358941 556 556
   q20  344 332 229 229
   q21  3714310723532353
   q22  10301028980 980
   Total cold run time: 106392 ms
   Total hot run time: 33898 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5168513451295129
   q2   251 322 215 215
   q3   2175266123252325
   q4   1332175513471347
   q5   4173448545714485
   q6   216 172 134 134
   q7   2062196917601760
   q8   2675258625692569
   q9   7307737773857377
   q10  3123334029952995
   q11  584 529 506 506
   q12  744 999 658 658
   q13  3616412835223522
   q14  295 309 291 291
   q15  552 482 480 480
   q16  441 503 441 441
   q17  1172155315061506
   q18  7969776973837383
   q19  760 758 753 753
   q20  1953200018021802
   q21  4765439043424342
   q22  10661045976 976
   Total cold run time: 52399 ms
   Total hot run time: 50996 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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-22 Thread via GitHub


yx-keith commented on PR #53486:
URL: https://github.com/apache/doris/pull/53486#issuecomment-3105300539

   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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-22 Thread via GitHub


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

   # FE UT Coverage Report
   Increment line coverage `  50.06% (454/907)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/53486_d509d55af48e679aae5f5a9a6a3426d5d6e3043e/fe_increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/53486_d509d55af48e679aae5f5a9a6a3426d5d6e3043e/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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-22 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 32.24 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit d509d55af48e679aae5f5a9a6a3426d5d6e3043e, 
data reload: false
   
   query1   0.040.030.04
   query2   0.090.040.04
   query3   0.250.070.07
   query4   1.640.110.11
   query5   0.440.410.41
   query6   1.170.660.67
   query7   0.030.020.01
   query8   0.050.040.04
   query9   0.610.530.51
   query10  0.590.580.57
   query11  0.160.110.10
   query12  0.160.120.11
   query13  0.630.610.61
   query14  0.800.840.84
   query15  0.890.870.86
   query16  0.400.400.39
   query17  1.031.061.05
   query18  0.220.200.21
   query19  1.931.881.84
   query20  0.020.010.01
   query21  15.43   0.900.55
   query22  0.791.160.71
   query23  14.91   1.340.65
   query24  7.100.700.50
   query25  0.550.240.12
   query26  0.600.170.14
   query27  0.050.060.06
   query28  9.670.970.42
   query29  12.54   3.923.25
   query30  3.103.042.93
   query31  2.840.610.38
   query32  3.230.550.46
   query33  3.063.103.06
   query34  15.96   5.384.83
   query35  4.834.874.92
   query36  0.680.520.49
   query37  0.090.070.07
   query38  0.060.040.04
   query39  0.030.030.02
   query40  0.180.150.14
   query41  0.080.030.03
   query42  0.030.020.02
   query43  0.040.040.04
   Total cold run time: 107 s
   Total hot run time: 32.24 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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-22 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 187484 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 d509d55af48e679aae5f5a9a6a3426d5d6e3043e, 
data reload: false
   
   query1   1015393 409 393
   query2   6529168816981688
   query3   6745218 218 218
   query4   26855   23797   23372   23372
   query5   4343606 503 503
   query6   319 239 201 201
   query7   4621504 296 296
   query8   287 227 217 217
   query9   8572283328362833
   query10  494 337 291 291
   query11  15840   15059   14884   14884
   query12  164 118 111 111
   query13  1662533 415 415
   query14  9168590558285828
   query15  206 186 163 163
   query16  7515613 464 464
   query17  1176700 575 575
   query18  1996404 313 313
   query19  197 183 163 163
   query20  129 115 120 115
   query21  211 119 108 108
   query22  4299418641264126
   query23  34107   7   33073   33073
   query24  8156234423602344
   query25  532 472 413 413
   query26  1216269 157 157
   query27  2734489 348 348
   query28  4326217621572157
   query29  707 556 458 458
   query30  286 218 189 189
   query31  934 839 757 757
   query32  79  82  74  74
   query33  554 370 331 331
   query34  782 847 512 512
   query35  800 801 749 749
   query36  990 1022889 889
   query37  117 107 81  81
   query38  4086409740454045
   query39  1475143214011401
   query40  227 126 117 117
   query41  65  59  85  59
   query42  124 113 112 112
   query43  492 472 458 458
   query44  1319841 839 839
   query45  177 165 168 165
   query46  839 994 625 625
   query47  1786183317461746
   query48  382 416 312 312
   query49  726 473 379 379
   query50  639 673 395 395
   query51  5554564654025402
   query52  115 110 98  98
   query53  226 265 191 191
   query54  593 587 555 555
   query55  89  84  88  84
   query56  327 319 313 313
   query57  1167118811181118
   query58  274 274 274 274
   query59  2591270325392539
   query60  352 361 349 349
   query61  132 126 133 126
   query62  790 716 655 655
   query63  230 194 186 186
   query64  42461020689 689
   query65  4298419241784178
   query66  1120418 355 355
   query67  15838   15533   15578   15533
   query68  7854905 555 555
   query69  505 334 286 286
   query70  1207115011461146
   query71  421 375 316 316
   query72  6024476547134713
   query73  642 577 357 357
   query74  9255909889118911
   query75  3153311226362636
   query76  32321148718 718
   query77  510 390 319 319
   query78  10021   10033   92409240
   query79  2589807 593 593
   query80  739 544 470 470
   query81  466 255 222 222
   query82  482 134 110 110
   query83  256 250 242 242
   query84  267 111 83  83
   query85  787 368 372 368
   query86  383 331 290 290
   query87  4345444542664266
   query88  3639222622072207
   query89  389 319 278 278
   query90  1898217 225 217
   query91  137 151 109 109
   query92  93  72  63  63
   query93  2114957 625 625
   query94  711 390 307 307
   query95  405 316 310 310
   query96  479 574 269 269
   query97  2724273526252625
   query98  254 214 208 208
   query99  1600138613181318
   Total cold run time: 276523 ms
   Total hot run time: 187484 ms
   ```
   
   


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

Re: [PR] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-22 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 33875 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit d509d55af48e679aae5f5a9a6a3426d5d6e3043e, 
data reload: false
   
   -- Round 1 --
   q1   17571   518750215021
   q2   1943309 187 187
   q3   10274   1286700 700
   q4   10231   1010534 534
   q5   7486245223442344
   q6   178 159 128 128
   q7   880 728 598 598
   q8   9319128610911091
   q9   6980510250825082
   q10  6972238819621962
   q11  503 294 274 274
   q12  377 346 218 218
   q13  17766   366731013101
   q14  225 230 211 211
   q15  572 475 486 475
   q16  411 426 380 380
   q17  623 870 386 386
   q18  7717710971797109
   q19  1295968 540 540
   q20  346 335 225 225
   q21  3899312023352335
   q22  10421039974 974
   Total cold run time: 106610 ms
   Total hot run time: 33875 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5301509551035095
   q2   242 316 215 215
   q3   2177269723172317
   q4   1313178313621362
   q5   4185457346174573
   q6   222 172 128 128
   q7   2022194718081808
   q8   2775263826602638
   q9   7318731271927192
   q10  3123334928502850
   q11  584 521 495 495
   q12  670 805 638 638
   q13  3727409033503350
   q14  299 296 274 274
   q15  524 481 475 475
   q16  464 507 469 469
   q17  1219154713671367
   q18  7955767274657465
   q19  777 872 1018872
   q20  2000196518021802
   q21  4794427643424276
   q22  10711037982 982
   Total cold run time: 52762 ms
   Total hot run time: 50643 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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-22 Thread via GitHub


yx-keith commented on PR #53486:
URL: https://github.com/apache/doris/pull/53486#issuecomment-3103552699

   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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-22 Thread via GitHub


yx-keith commented on PR #53486:
URL: https://github.com/apache/doris/pull/53486#issuecomment-3103422998

   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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-22 Thread via GitHub


yx-keith commented on PR #53486:
URL: https://github.com/apache/doris/pull/53486#issuecomment-3103324466

   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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-17 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 33.13 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 4736e4814ea4a50faa23fc93a278eb972279d514, 
data reload: false
   
   query1   0.030.040.04
   query2   0.080.040.04
   query3   0.240.070.07
   query4   1.640.110.11
   query5   0.440.430.42
   query6   1.170.680.68
   query7   0.030.020.01
   query8   0.050.040.03
   query9   0.600.540.51
   query10  0.580.570.59
   query11  0.150.110.11
   query12  0.150.120.12
   query13  0.630.610.61
   query14  0.800.810.82
   query15  0.900.890.90
   query16  0.390.400.40
   query17  1.081.061.10
   query18  0.230.210.21
   query19  1.971.901.90
   query20  0.010.010.01
   query21  15.38   0.940.53
   query22  0.761.200.65
   query23  14.93   1.390.64
   query24  7.041.741.42
   query25  0.500.130.21
   query26  0.660.170.14
   query27  0.070.060.05
   query28  9.700.840.44
   query29  12.54   3.903.22
   query30  3.042.972.93
   query31  2.820.580.38
   query32  3.220.550.47
   query33  3.113.103.08
   query34  16.05   5.384.78
   query35  4.814.824.86
   query36  0.670.500.50
   query37  0.090.070.07
   query38  0.050.040.04
   query39  0.030.030.02
   query40  0.160.150.14
   query41  0.080.030.03
   query42  0.040.020.02
   query43  0.040.030.04
   Total cold run time: 106.96 s
   Total hot run time: 33.13 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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-17 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 187145 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 4736e4814ea4a50faa23fc93a278eb972279d514, 
data reload: false
   
   query1   978 389 391 389
   query2   6496167917021679
   query3   6744216 214 214
   query4   26497   23378   23543   23378
   query5   4318583 474 474
   query6   316 205 186 186
   query7   4625475 283 283
   query8   254 209 208 208
   query9   8624259626282596
   query10  473 340 273 273
   query11  15988   15063   14831   14831
   query12  153 109 109 109
   query13  1653524 401 401
   query14  9216584558105810
   query15  205 201 169 169
   query16  7312623 498 498
   query17  1198700 589 589
   query18  2021404 301 301
   query19  202 205 165 165
   query20  122 121 114 114
   query21  218 132 108 108
   query22  4339439941994199
   query23  34361   33299   33245   33245
   query24  8482242823672367
   query25  539 462 401 401
   query26  1229267 145 145
   query27  2765507 346 346
   query28  4310214221212121
   query29  749 550 483 483
   query30  280 221 183 183
   query31  926 843 746 746
   query32  72  62  59  59
   query33  548 367 305 305
   query34  802 860 520 520
   query35  810 794 736 736
   query36  978 1012895 895
   query37  107 95  76  76
   query38  4255413641824136
   query39  1500143114201420
   query40  210 120 104 104
   query41  58  54  50  50
   query42  121 104 110 104
   query43  508 503 466 466
   query44  1317818 823 818
   query45  181 169 169 169
   query46  848 1004631 631
   query47  1798184717721772
   query48  375 425 306 306
   query49  737 471 396 396
   query50  656 686 405 405
   query51  5414552054335433
   query52  114 110 103 103
   query53  219 254 177 177
   query54  581 571 501 501
   query55  85  80  85  80
   query56  318 293 293 293
   query57  1185120811441144
   query58  260 252 258 252
   query59  2596259125262526
   query60  328 313 305 305
   query61  125 122 158 122
   query62  809 714 672 672
   query63  229 185 183 183
   query64  43641032657 657
   query65  4252417242254172
   query66  1138408 344 344
   query67  15904   15838   15559   15559
   query68  8250883 529 529
   query69  460 306 266 266
   query70  1227115711171117
   query71  454 325 316 316
   query72  5808474247494742
   query73  718 610 357 357
   query74  9126914987148714
   query75  3828319626632663
   query76  36201136727 727
   query77  812 388 288 288
   query78  10010   10168   93689368
   query79  2270824 587 587
   query80  617 514 526 514
   query81  499 277 227 227
   query82  462 127 98  98
   query83  292 257 237 237
   query84  293 109 87  87
   query85  785 353 321 321
   query86  387 298 318 298
   query87  4487446143094309
   query88  3364230722972297
   query89  396 317 283 283
   query90  1893205 203 203
   query91  140 143 112 112
   query92  78  60  57  57
   query93  1707927 585 585
   query94  657 410 291 291
   query95  375 298 284 284
   query96  493 573 280 280
   query97  2705276626172617
   query98  230 212 206 206
   query99  1416139912631263
   Total cold run time: 277254 ms
   Total hot run time: 187145 ms
   ```
   
   


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

Re: [PR] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-17 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 33928 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 4736e4814ea4a50faa23fc93a278eb972279d514, 
data reload: false
   
   -- Round 1 --
   q1   17563   524050705070
   q2   1937288 190 190
   q3   10507   1305710 710
   q4   10259   1004529 529
   q5   7970241923162316
   q6   178 164 127 127
   q7   901 726 613 613
   q8   9299131510861086
   q9   7471509650925092
   q10  6897238919711971
   q11  497 297 273 273
   q12  338 350 207 207
   q13  17772   368330823082
   q14  234 229 214 214
   q15  540 471 486 471
   q16  425 429 361 361
   q17  588 853 356 356
   q18  7568718272347182
   q19  1209951 569 569
   q20  333 333 222 222
   q21  3883254423112311
   q22  1043994 976 976
   Total cold run time: 107412 ms
   Total hot run time: 33928 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5168511551195115
   q2   246 323 222 222
   q3   2180268523132313
   q4   1322177613431343
   q5   4215451745354517
   q6   208 166 143 143
   q7   2047188318021802
   q8   2694254225762542
   q9   7330736472297229
   q10  3153331329552955
   q11  590 522 539 522
   q12  665 809 646 646
   q13  3597394733103310
   q14  293 292 290 290
   q15  546 494 477 477
   q16  438 504 471 471
   q17  1161155613461346
   q18  8053781574097409
   q19  764 822 863 822
   q20  1905200418341834
   q21  4725441943864386
   q22  10821024977 977
   Total cold run time: 52382 ms
   Total hot run time: 50671 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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-17 Thread via GitHub


yx-keith commented on PR #53486:
URL: https://github.com/apache/doris/pull/53486#issuecomment-3086500332

   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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-17 Thread via GitHub


yx-keith commented on PR #53486:
URL: https://github.com/apache/doris/pull/53486#issuecomment-3086459221

   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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-17 Thread via GitHub


yx-keith commented on PR #53486:
URL: https://github.com/apache/doris/pull/53486#issuecomment-3086192125

   run 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: [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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-17 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 32.72 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit e91b1e08c1f284039c5d8af2ac208464be4d0cfb, 
data reload: false
   
   query1   0.050.030.03
   query2   0.070.040.04
   query3   0.240.070.07
   query4   1.630.100.11
   query5   0.430.440.41
   query6   1.160.650.68
   query7   0.030.020.01
   query8   0.040.040.04
   query9   0.590.520.51
   query10  0.580.560.58
   query11  0.150.100.11
   query12  0.140.110.12
   query13  0.630.610.60
   query14  0.840.840.80
   query15  0.900.870.88
   query16  0.400.380.40
   query17  1.051.031.06
   query18  0.230.220.21
   query19  1.911.911.90
   query20  0.020.010.01
   query21  15.40   0.900.55
   query22  0.761.290.65
   query23  14.87   1.340.62
   query24  6.741.171.03
   query25  0.490.180.09
   query26  0.560.180.15
   query27  0.070.060.05
   query28  9.550.890.44
   query29  12.57   4.003.33
   query30  3.062.982.98
   query31  2.820.580.38
   query32  3.230.540.49
   query33  3.053.103.07
   query34  16.12   5.414.79
   query35  4.904.864.90
   query36  0.700.500.50
   query37  0.080.060.06
   query38  0.050.040.04
   query39  0.030.020.03
   query40  0.180.150.13
   query41  0.090.020.03
   query42  0.030.020.03
   query43  0.040.030.02
   Total cold run time: 106.48 s
   Total hot run time: 32.72 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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-17 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 185459 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 e91b1e08c1f284039c5d8af2ac208464be4d0cfb, 
data reload: false
   
   query1   975 385 400 385
   query2   6497169816011601
   query3   6748210 220 210
   query4   26584   23601   23005   23005
   query5   4376586 422 422
   query6   293 222 194 194
   query7   4632481 284 284
   query8   264 216 207 207
   query9   8637256425632563
   query10  461 324 270 270
   query11  15586   14932   14823   14823
   query12  155 103 101 101
   query13  1654508 391 391
   query14  8710580157385738
   query15  203 186 170 170
   query16  7615638 473 473
   query17  1214729 583 583
   query18  2024404 312 312
   query19  186 188 158 158
   query20  119 116 116 116
   query21  219 127 108 108
   query22  4309446441204120
   query23  34107   33197   32981   32981
   query24  8401232823432328
   query25  503 461 395 395
   query26  1236268 143 143
   query27  2750504 334 334
   query28  4312210820662066
   query29  717 541 425 425
   query30  284 232 184 184
   query31  912 831 753 753
   query32  71  65  60  60
   query33  548 367 301 301
   query34  780 826 507 507
   query35  762 826 722 722
   query36  974 986 906 906
   query37  114 96  76  76
   query38  4070407840144014
   query39  1659142914131413
   query40  213 116 113 113
   query41  60  57  52  52
   query42  119 105 104 104
   query43  496 496 454 454
   query44  1291812 800 800
   query45  192 166 161 161
   query46  827 991 621 621
   query47  1783184317921792
   query48  376 421 301 301
   query49  722 469 392 392
   query50  614 687 404 404
   query51  5441548154465446
   query52  104 106 95  95
   query53  214 255 180 180
   query54  558 555 490 490
   query55  84  83  75  75
   query56  300 281 275 275
   query57  1178118911431143
   query58  257 246 249 246
   query59  2516259325252525
   query60  323 309 305 305
   query61  128 122 127 122
   query62  784 725 660 660
   query63  218 182 182 182
   query64  42441041673 673
   query65  4279416041364136
   query66  1094405 306 306
   query67  15856   15518   15460   15460
   query68  8226888 516 516
   query69  477 296 270 270
   query70  1264113710951095
   query71  493 309 292 292
   query72  5760474949164749
   query73  705 656 345 345
   query74  9104912488228822
   query75  3946315026472647
   query76  37561152748 748
   query77  809 366 284 284
   query78  10039   10067   92649264
   query79  2566776 594 594
   query80  620 506 446 446
   query81  465 255 222 222
   query82  446 129 94  94
   query83  280 254 230 230
   query84  292 101 87  87
   query85  786 350 314 314
   query86  331 326 295 295
   query87  4439436542714271
   query88  3179228922702270
   query89  382 319 291 291
   query90  1944207 210 207
   query91  149 142 117 117
   query92  75  60  57  57
   query93  1118917 579 579
   query94  666 426 286 286
   query95  374 290 286 286
   query96  494 561 286 286
   query97  2790275026692669
   query98  233 212 213 212
   query99  1446144212591259
   Total cold run time: 275586 ms
   Total hot run time: 185459 ms
   ```
   
   


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

Re: [PR] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-17 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 33487 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit e91b1e08c1f284039c5d8af2ac208464be4d0cfb, 
data reload: false
   
   -- Round 1 --
   q1   17607   514549974997
   q2   1918277 179 179
   q3   10317   1277691 691
   q4   10218   979 525 525
   q5   7602240323272327
   q6   169 154 124 124
   q7   867 741 586 586
   q8   9299124210721072
   q9   6743512251195119
   q10  6868238819851985
   q11  466 276 262 262
   q12  326 343 205 205
   q13  17771   362829762976
   q14  242 224 217 217
   q15  555 479 482 479
   q16  419 419 371 371
   q17  587 836 351 351
   q18  7486702469786978
   q19  1209952 552 552
   q20  330 349 232 232
   q21  3602250623012301
   q22  10581029958 958
   Total cold run time: 105659 ms
   Total hot run time: 33487 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5093509650865086
   q2   236 320 225 225
   q3   2145262322622262
   q4   1332175713021302
   q5   4161416544334165
   q6   224 175 130 130
   q7   1991193618631863
   q8   2582268125722572
   q9   7276735773197319
   q10  3149328028442844
   q11  623 507 496 496
   q12  700 803 637 637
   q13  3482391435983598
   q14  299 312 268 268
   q15  521 486 482 482
   q16  437 489 434 434
   q17  1182166913921392
   q18  8074787676977697
   q19  782 751 808 751
   q20  1975201918781878
   q21  4875435942214221
   q22  10921031988 988
   Total cold run time: 52231 ms
   Total hot run time: 50610 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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-17 Thread via GitHub


yx-keith commented on PR #53486:
URL: https://github.com/apache/doris/pull/53486#issuecomment-3084544738

   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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-17 Thread via GitHub


yx-keith commented on PR #53486:
URL: https://github.com/apache/doris/pull/53486#issuecomment-3084436586

   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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-17 Thread via GitHub


yx-keith commented on PR #53486:
URL: https://github.com/apache/doris/pull/53486#issuecomment-3084357819

   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] [Enhancement](nereids) optimize translateToLegacy in CreateTableCommand [doris]

2025-07-17 Thread via GitHub


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

   
   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]