Re: [PR] branch-3.0: [fix](Nereids) Use the schema saved during planning as the schema of the original target table #47337 [doris]

2025-01-25 Thread via GitHub


dataroaring merged PR #47402:
URL: https://github.com/apache/doris/pull/47402


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

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org



Re: [PR] branch-3.0: [fix](Nereids) Use the schema saved during planning as the schema of the original target table #47337 [doris]

2025-01-24 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 32.13 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit baa63dc577609b61b58ee9297c89143393c81e5e, 
data reload: false
   
   query1   0.040.030.02
   query2   0.060.030.03
   query3   0.240.070.06
   query4   1.630.100.10
   query5   0.530.500.53
   query6   1.130.730.72
   query7   0.030.020.01
   query8   0.040.030.05
   query9   0.570.500.49
   query10  0.550.560.55
   query11  0.140.100.10
   query12  0.150.100.10
   query13  0.600.610.60
   query14  2.722.852.88
   query15  0.900.830.82
   query16  0.390.370.39
   query17  1.061.050.97
   query18  0.240.220.23
   query19  1.982.071.77
   query20  0.020.010.00
   query21  15.37   0.580.57
   query22  2.992.391.30
   query23  16.97   1.190.75
   query24  2.951.640.87
   query25  0.260.100.03
   query26  0.500.150.15
   query27  0.040.050.04
   query28  10.17   1.121.09
   query29  12.59   3.283.28
   query30  0.240.060.06
   query31  2.860.390.40
   query32  3.250.460.45
   query33  3.003.063.00
   query34  16.83   4.494.55
   query35  4.584.564.55
   query36  0.650.490.49
   query37  0.100.060.06
   query38  0.050.030.04
   query39  0.030.020.03
   query40  0.150.130.13
   query41  0.080.030.02
   query42  0.030.020.02
   query43  0.040.030.03
   Total cold run time: 106.75 s
   Total hot run time: 32.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: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org



Re: [PR] branch-3.0: [fix](Nereids) Use the schema saved during planning as the schema of the original target table #47337 [doris]

2025-01-24 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 192605 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 baa63dc577609b61b58ee9297c89143393c81e5e, 
data reload: false
   
   query1   989 382 364 364
   query2   6511221221392139
   query3   6702220 219 219
   query4   34068   23580   23717   23580
   query5   4399470 470 470
   query6   268 186 179 179
   query7   4630305 317 305
   query8   281 221 223 221
   query9   9724269426922692
   query10  501 268 278 268
   query11  18189   15186   15225   15186
   query12  156 103 104 103
   query13  1648436 433 433
   query14  9711704671217046
   query15  251 177 175 175
   query16  8101469 499 469
   query17  1634591 572 572
   query18  2131302 311 302
   query19  237 159 155 155
   query20  117 108 111 108
   query21  209 107 105 105
   query22  4594433043634330
   query23  34715   33991   33861   33861
   query24  11863   289629182896
   query25  736 435 412 412
   query26  1888174 175 174
   query27  2939349 340 340
   query28  8054241124092409
   query29  1109476 455 455
   query30  342 175 162 162
   query31  1019797 797 797
   query32  99  58  60  58
   query33  808 318 306 306
   query34  919 504 543 504
   query35  850 741 744 741
   query36  1142929 948 929
   query37  290 77  79  77
   query38  3949385439453854
   query39  1467143114421431
   query40  293 105 104 104
   query41  56  53  52  52
   query42  117 108 105 105
   query43  572 517 516 516
   query44  1289802 804 802
   query45  191 173 172 172
   query46  1158733 730 730
   query47  1931184318181818
   query48  474 384 391 384
   query49  1316416 417 416
   query50  829 418 418 418
   query51  7283722770947094
   query52  108 100 96  96
   query53  276 189 198 189
   query54  1126480 471 471
   query55  86  82  81  81
   query56  296 265 274 265
   query57  1234111811031103
   query58  249 216 218 216
   query59  3447309030953090
   query60  291 250 247 247
   query61  146 110 118 110
   query62  879 692 650 650
   query63  221 201 196 196
   query64  5151677 653 653
   query65  3270318032543180
   query66  1422342 323 323
   query67  16065   15673   15676   15673
   query68  4657587 564 564
   query69  437 267 310 267
   query70  1186111311691113
   query71  404 271 258 258
   query72  6332409039803980
   query73  783 351 351 351
   query74  10222   911490869086
   query75  3393263426802634
   query76  2978109810211021
   query77  415 295 276 276
   query78  10446   958995369536
   query79  1336616 604 604
   query80  962 455 436 436
   query81  549 235 238 235
   query82  1089123 116 116
   query83  222 150 145 145
   query84  234 83  88  83
   query85  1290307 305 305
   query86  356 302 266 266
   query87  4503434542734273
   query88  3546239723512351
   query89  401 297 298 297
   query90  1943190 191 190
   query91  189 148 160 148
   query92  64  52  51  51
   query93  1096551 539 539
   query94  892 308 310 308
   query95  369 260 261 260
   query96  611 288 284 284
   query97  3341317832263178
   query98  209 207 195 195
   query99  1524134912741274
   Total cold run time: 302995 ms
   Total hot run time: 192605 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] branch-3.0: [fix](Nereids) Use the schema saved during planning as the schema of the original target table #47337 [doris]

2025-01-24 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 41243 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit baa63dc577609b61b58ee9297c89143393c81e5e, 
data reload: false
   
   -- Round 1 --
   q1   17591   742472877287
   q2   2063166 158 158
   q3   10858   117712051177
   q4   10275   749 724 724
   q5   8095297428902890
   q6   240 156 147 147
   q7   996 631 610 610
   q8   9888202420362024
   q9   6812652465546524
   q10  7531233823222322
   q11  457 270 263 263
   q12  400 211 209 209
   q13  17768   303330063006
   q14  253 213 213 213
   q15  592 548 540 540
   q16  655 579 585 579
   q17  984 569 594 569
   q18  7348662666896626
   q19  1262113210091009
   q20  482 199 194 194
   q21  4244318831833183
   q22  1117989 1005989
   Total cold run time: 109911 ms
   Total hot run time: 41243 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   7256719772247197
   q2   327 239 230 230
   q3   3177302331213023
   q4   2132179318881793
   q5   5719573656715671
   q6   218 137 138 137
   q7   2193182118221821
   q8   3358353734883488
   q9   8802891788508850
   q10  3617355435413541
   q11  581 496 492 492
   q12  778 612 597 597
   q13  3842311631843116
   q14  307 280 281 280
   q15  579 528 524 524
   q16  687 637 647 637
   q17  1830160715751575
   q18  8204768972347234
   q19  1661155314641464
   q20  2063180818271808
   q21  5262515852525158
   q22  11081011981 981
   Total cold run time: 63701 ms
   Total hot run time: 59617 ms
   ```
   
   


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

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org



Re: [PR] branch-3.0: [fix](Nereids) Use the schema saved during planning as the schema of the original target table #47337 [doris]

2025-01-24 Thread via GitHub


morrySnow commented on PR #47402:
URL: https://github.com/apache/doris/pull/47402#issuecomment-2612086490

   run buildall


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

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org



Re: [PR] branch-3.0: [fix](Nereids) Use the schema saved during planning as the schema of the original target table #47337 [doris]

2025-01-23 Thread via GitHub


dataroaring closed pull request #47402: branch-3.0: [fix](Nereids) Use the 
schema saved during planning as the schema of the original target table #47337
URL: https://github.com/apache/doris/pull/47402


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

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org



Re: [PR] branch-3.0: [fix](Nereids) Use the schema saved during planning as the schema of the original target table #47337 [doris]

2025-01-23 Thread via GitHub


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

   
   Thank you for your contribution to Apache Doris.
   Don't know what should be done next? See [How to process your 
PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR).
   
   Please clearly describe your PR:
   1. What problem was fixed (it's best to include specific error reporting 
information). How it was fixed.
   2. Which behaviors were modified. What was the previous behavior, what is it 
now, why was it modified, and what possible impacts might there be.
   3. What features were added. Why was this function added?
   4. Which code was refactored and why was this part of the code refactored?
   5. Which functions were optimized and what is the difference before and 
after the optimization?
   


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

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org



Re: [PR] branch-3.0: [fix](Nereids) Use the schema saved during planning as the schema of the original target table #47337 [doris]

2025-01-23 Thread via GitHub


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

   run buildall


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

To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


-
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org