Re: [PR] [fix](mtmv) Fix mv rewrite fail when base table add column [doris]

2024-12-03 Thread via GitHub


morrySnow merged PR #44867:
URL: https://github.com/apache/doris/pull/44867


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

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

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


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



Re: [PR] [fix](mtmv) Fix mv rewrite fail when base table add column [doris]

2024-12-02 Thread via GitHub


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

   PR approved by anyone and no changes requested.


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

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

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


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



Re: [PR] [fix](mtmv) Fix mv rewrite fail when base table add column [doris]

2024-12-02 Thread via GitHub


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

   PR approved by at least one committer and no changes requested.


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

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

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


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



Re: [PR] [fix](mtmv) Fix mv rewrite fail when base table add column [doris]

2024-12-02 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 32.8 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 817f076163b0dbf1003b3eb7240e530147b68635, 
data reload: false
   
   query1   0.030.030.02
   query2   0.060.030.03
   query3   0.240.070.07
   query4   1.620.110.10
   query5   0.440.420.39
   query6   1.160.650.66
   query7   0.020.020.01
   query8   0.040.030.02
   query9   0.580.510.52
   query10  0.540.570.56
   query11  0.150.110.10
   query12  0.140.110.12
   query13  0.610.620.60
   query14  2.712.722.73
   query15  0.900.840.83
   query16  0.400.390.37
   query17  1.091.101.06
   query18  0.220.200.22
   query19  1.961.791.99
   query20  0.020.010.01
   query21  15.36   0.590.59
   query22  2.452.531.89
   query23  17.22   0.890.71
   query24  2.761.551.19
   query25  0.210.130.22
   query26  0.410.140.14
   query27  0.030.040.05
   query28  10.21   1.111.08
   query29  12.57   3.243.18
   query30  0.240.080.07
   query31  2.840.400.38
   query32  3.280.460.47
   query33  3.123.033.07
   query34  16.99   4.484.51
   query35  4.564.534.49
   query36  0.640.480.48
   query37  0.100.060.06
   query38  0.050.030.04
   query39  0.030.020.02
   query40  0.160.130.13
   query41  0.080.020.02
   query42  0.030.020.02
   query43  0.040.030.03
   Total cold run time: 106.31 s
   Total hot run time: 32.8 s
   ```
   
   


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

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

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


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



Re: [PR] [fix](mtmv) Fix mv rewrite fail when base table add column [doris]

2024-12-02 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 198802 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 817f076163b0dbf1003b3eb7240e530147b68635, 
data reload: false
   
   query1   1250947 925 925
   query2   6275207520392039
   query3   2   460545614561
   query4   66623   28300   23715   23715
   query5   4907472 457 457
   query6   406 194 178 178
   query7   5469316 301 301
   query8   328 244 246 244
   query9   8672270427002700
   query10  439 277 246 246
   query11  17272   15477   15847   15477
   query12  152 103 113 103
   query13  1448405 429 405
   query14  10956   808474397439
   query15  215 183 205 183
   query16  7162488 472 472
   query17  1025574 556 556
   query18  2053319 305 305
   query19  197 154 149 149
   query20  115 109 116 109
   query21  210 104 105 104
   query22  4707446044184418
   query23  35230   34685   34860   34685
   query24  5552261125752575
   query25  523 412 433 412
   query26  643 160 155 155
   query27  1732295 291 291
   query28  4689247824812478
   query29  699 442 427 427
   query30  218 163 155 155
   query31  1034839 913 839
   query32  64  58  58  58
   query33  434 288 292 288
   query34  933 514 529 514
   query35  877 771 744 744
   query36  1113963 965 963
   query37  123 77  70  70
   query38  4554447445564474
   query39  1524147414781474
   query40  201 101 100 100
   query41  44  44  39  39
   query42  107 96  101 96
   query43  540 504 506 504
   query44  1215800 810 800
   query45  187 179 168 168
   query46  1184716 750 716
   query47  2019193219341932
   query48  406 318 318 318
   query49  727 397 377 377
   query50  863 397 397 397
   query51  7335728372467246
   query52  101 86  86  86
   query53  255 185 177 177
   query54  499 408 393 393
   query55  79  75  77  75
   query56  246 233 221 221
   query57  1276112211301122
   query58  215 205 216 205
   query59  3325306130403040
   query60  265 241 236 236
   query61  111 106 104 104
   query62  779 672 677 672
   query63  226 197 196 196
   query64  1420646 660 646
   query65  3319321332413213
   query66  691 299 300 299
   query67  16046   15848   15660   15660
   query68  3878574 608 574
   query69  448 259 251 251
   query70  1180117011701170
   query71  341 248 249 248
   query72  6357411239863986
   query73  760 365 371 365
   query74  10271   906791449067
   query75  3429270726222622
   query76  1902100710991007
   query77  500 283 292 283
   query78  10377   952695119511
   query79  1381594 643 594
   query80  879 419 439 419
   query81  504 231 236 231
   query82  1306117 120 117
   query83  248 143 146 143
   query84  286 65  74  65
   query85  949 302 297 297
   query86  336 291 305 291
   query87  4726462445394539
   query88  3547220121722172
   query89  421 294 291 291
   query90  2012190 192 190
   query91  134 105 101 101
   query92  69  49  47  47
   query93  1871555 541 541
   query94  780 290 297 290
   query95  354 251 249 249
   query96  618 273 279 273
   query97  2888276726532653
   query98  215 199 194 194
   query99  1804132812951295
   Total cold run time: 319387 ms
   Total hot run time: 198802 ms
   ```
   
   


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

Re: [PR] [fix](mtmv) Fix mv rewrite fail when base table add column [doris]

2024-12-02 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 40095 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 817f076163b0dbf1003b3eb7240e530147b68635, 
data reload: false
   
   -- Round 1 --
   q1   17621   740672457245
   q2   2040179 169 169
   q3   10551   107712241077
   q4   10442   809 750 750
   q5   7602273627352735
   q6   237 147 149 147
   q7   992 641 592 592
   q8   9248183119241831
   q9   6676642965316429
   q10  7044231123082308
   q11  461 258 264 258
   q12  429 223 220 220
   q13  17803   303930363036
   q14  247 223 211 211
   q15  577 539 503 503
   q16  675 616 589 589
   q17  964 605 573 573
   q18  7242674767196719
   q19  1337996 1017996
   q20  456 178 183 178
   q21  4010321132143211
   q22  378 323 318 318
   Total cold run time: 107032 ms
   Total hot run time: 40095 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   7216720272297202
   q2   322 235 236 235
   q3   2888281829252818
   q4   2114186319101863
   q5   5673568356665666
   q6   235 145 149 145
   q7   2230186118191819
   q8   3430352334723472
   q9   9005900490199004
   q10  3634359435413541
   q11  593 509 502 502
   q12  816 609 595 595
   q13  10539   327832653265
   q14  302 290 288 288
   q15  575 519 539 519
   q16  681 652 660 652
   q17  1839161815931593
   q18  8385768376587658
   q19  1691159415581558
   q20  2144187618801876
   q21  5754562455545554
   q22  674 572 584 572
   Total cold run time: 70740 ms
   Total hot run time: 60397 ms
   ```
   
   


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

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

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


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



Re: [PR] [fix](mtmv) Fix mv rewrite fail when base table add column [doris]

2024-12-02 Thread via GitHub


seawinde commented on PR #44867:
URL: https://github.com/apache/doris/pull/44867#issuecomment-2511039298

   run buildall


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

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

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


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



Re: [PR] [fix](mtmv) Fix mv rewrite fail when base table add column [doris]

2024-12-02 Thread via GitHub


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

   
   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