Re: [PR] branch-3.0: [fix](mtmv) Fix mv rewrite fail when base table add column #44867 [doris]

2024-12-05 Thread via GitHub


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


-- 
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](mtmv) Fix mv rewrite fail when base table add column #44867 [doris]

2024-12-03 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 194136 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 b2560c93d4b29cfa584b0bbb33e8345a5b135b0e, 
data reload: false
   
   query1   1226928 926 926
   query2   6252209020442044
   query3   10871   416841034103
   query4   66679   28129   23569   23569
   query5   5762456 442 442
   query6   485 188 178 178
   query7   6085324 313 313
   query8   327 232 230 230
   query9   9393271727042704
   query10  528 274 263 263
   query11  17859   15208   15856   15208
   query12  159 99  107 99
   query13  1583465 419 419
   query14  11557   675573116755
   query15  213 187 177 177
   query16  7352490 472 472
   query17  1316581 602 581
   query18  1899335 337 335
   query19  214 163 160 160
   query20  124 112 110 110
   query21  208 104 108 104
   query22  4622460844144414
   query23  34672   33956   33978   33956
   query24  5839295729522952
   query25  547 431 416 416
   query26  684 185 171 171
   query27  2062303 305 303
   query28  4518261425272527
   query29  706 448 433 433
   query30  239 164 164 164
   query31  1004811 856 811
   query32  70  54  53  53
   query33  461 283 271 271
   query34  910 519 538 519
   query35  858 731 724 724
   query36  1092957 922 922
   query37  118 66  80  66
   query38  4067400339923992
   query39  1505149914391439
   query40  202 99  99  99
   query41  47  48  47  47
   query42  115 100 95  95
   query43  534 492 480 480
   query44  1180800 810 800
   query45  181 165 167 165
   query46  1159757 746 746
   query47  1985189718641864
   query48  462 361 384 361
   query49  714 388 380 380
   query50  843 416 432 416
   query51  7258719173327191
   query52  99  92  88  88
   query53  261 186 183 183
   query54  558 458 448 448
   query55  74  72  73  72
   query56  248 229 227 227
   query57  1188110310911091
   query58  200 202 192 192
   query59  3093293728062806
   query60  273 254 257 254
   query61  132 105 102 102
   query62  761 647 662 647
   query63  204 191 192 191
   query64  1764650 634 634
   query65  3246314931663149
   query66  744 317 308 308
   query67  16000   15301   15415   15301
   query68  4573557 537 537
   query69  426 268 254 254
   query70  1160107510991075
   query71  392 253 255 253
   query72  6548243238462432
   query73  747 341 337 337
   query74  10302   883588758835
   query75  3316261626442616
   query76  2844110610851085
   query77  463 258 265 258
   query78  10722   969194919491
   query79  8764582 572 572
   query80  1941425 410 410
   query81  542 247 239 239
   query82  1404119 118 118
   query83  253 142 139 139
   query84  297 86  75  75
   query85  1745297 286 286
   query86  479 255 298 255
   query87  4607428542354235
   query88  5756240224022402
   query89  548 287 289 287
   query90  2071185 174 174
   query91  192 145 143 143
   query92  59  46  46  46
   query93  6612524 534 524
   query94  905 296 257 257
   query95  348 237 245 237
   query96  623 280 291 280
   query97  3283313531423135
   query98  222 205 207 205
   query99  1860128312821282
   Total cold run time: 341595 ms
   Total hot run time: 194136 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] branch-3.0: [fix](mtmv) Fix mv rewrite fail when base table add column #44867 [doris]

2024-12-03 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 40764 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit b2560c93d4b29cfa584b0bbb33e8345a5b135b0e, 
data reload: false
   
   -- Round 1 --
   q1   17566   739080747390
   q2   2053175 192 175
   q3   10669   190811421142
   q4   10565   834 730 730
   q5   7729283428282828
   q6   234 148 147 147
   q7   967 615 610 610
   q8   9599196220611962
   q9   7885642263846384
   q10  6999232023382320
   q11  462 269 258 258
   q12  406 224 207 207
   q13  17763   294430062944
   q14  232 205 198 198
   q15  559 520 513 513
   q16  692 612 598 598
   q17  981 549 540 540
   q18  7149645965506459
   q19  39091063988 988
   q20  502 202 200 200
   q21  3910321532093209
   q22  1072962 976 962
   Total cold run time: 111903 ms
   Total hot run time: 40764 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   7340726372847263
   q2   342 240 237 237
   q3   3027283929252839
   q4   2055175117021702
   q5   5626566757185667
   q6   224 146 147 146
   q7   2212174817871748
   q8   3288337634733376
   q9   8853880487708770
   q10  3547351134833483
   q11  584 507 504 504
   q12  788 586 599 586
   q13  16480   312131103110
   q14  312 282 296 282
   q15  576 517 522 517
   q16  711 656 670 656
   q17  1814162416071607
   q18  7972792974557455
   q19  2551151615771516
   q20  2039184518411841
   q21  9020513552815135
   q22  1087101910331019
   Total cold run time: 80448 ms
   Total hot run time: 59459 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](mtmv) Fix mv rewrite fail when base table add column #44867 [doris]

2024-12-03 Thread via GitHub


dataroaring closed pull request #44955: branch-3.0: [fix](mtmv) Fix mv rewrite 
fail when base table add column #44867
URL: https://github.com/apache/doris/pull/44955


-- 
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](mtmv) Fix mv rewrite fail when base table add column #44867 [doris]

2024-12-03 Thread via GitHub


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

   
   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](mtmv) Fix mv rewrite fail when base table add column #44867 [doris]

2024-12-03 Thread via GitHub


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

   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