Re: [PR] branch-3.0: [fix](mtmv) Fix data wrong when query with table operator such as TABLESAMPLE or tablet and so on #43030 [doris]

2024-12-05 Thread via GitHub


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


-- 
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 data wrong when query with table operator such as TABLESAMPLE or tablet and so on #43030 [doris]

2024-12-02 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 197085 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 e0fe887c5b5c7fb93e79ad1d45189eb1d218aaa6, 
data reload: false
   
   query1   1252924 919 919
   query2   6246211420312031
   query3   10836   411541164115
   query4   68705   28880   23492   23492
   query5   5016438 452 438
   query6   413 173 193 173
   query7   5664312 336 312
   query8   310 223 228 223
   query9   9334266926582658
   query10  490 291 273 273
   query11  17531   15320   15603   15320
   query12  166 107 104 104
   query13  1550435 437 435
   query14  10646   742875227428
   query15  215 176 172 172
   query16  7346487 483 483
   query17  1147598 592 592
   query18  1841329 337 329
   query19  246 144 145 144
   query20  121 114 109 109
   query21  217 99  107 99
   query22  4746455644734473
   query23  34560   34071   34111   34071
   query24  6130287629272876
   query25  503 396 393 393
   query26  675 163 165 163
   query27  1853305 300 300
   query28  4124257425452545
   query29  665 448 446 446
   query30  240 161 162 161
   query31  992 819 825 819
   query32  68  56  51  51
   query33  460 308 270 270
   query34  905 510 505 505
   query35  859 755 723 723
   query36  1101966 961 961
   query37  124 69  77  69
   query38  4094404639683968
   query39  1508149114961491
   query40  209 103 96  96
   query41  54  51  53  51
   query42  108 102 99  99
   query43  539 510 513 510
   query44  1135793 817 793
   query45  187 174 169 169
   query46  1177751 735 735
   query47  1999185919101859
   query48  459 382 374 374
   query49  747 392 400 392
   query50  828 417 425 417
   query51  7435729471497149
   query52  105 92  96  92
   query53  255 178 182 178
   query54  579 465 457 457
   query55  76  77  74  74
   query56  258 244 251 244
   query57  1203110310991099
   query58  219 209 210 209
   query59  3168317731013101
   query60  287 259 260 259
   query61  129 129 127 127
   query62  781 647 648 647
   query63  206 189 188 188
   query64  1540672 670 670
   query65  3254315931743159
   query66  706 297 296 296
   query67  15793   15442   15418   15418
   query68  5053589 569 569
   query69  429 248 255 248
   query70  1142113511061106
   query71  403 250 247 247
   query72  6451405338733873
   query73  766 343 344 343
   query74  10204   899789088908
   query75  3342265226322632
   query76  2124108210421042
   query77  552 281 273 273
   query78  10682   978794699469
   query79  8326587 587 587
   query80  1918436 430 430
   query81  564 242 240 240
   query82  1029111 120 111
   query83  277 139 140 139
   query84  290 80  79  79
   query85  1653297 328 297
   query86  447 300 299 299
   query87  4451423542214221
   query88  5460237924242379
   query89  540 295 289 289
   query90  2194182 183 182
   query91  184 143 143 143
   query92  61  47  46  46
   query93  6555558 550 550
   query94  918 280 286 280
   query95  340 255 250 250
   query96  629 281 275 275
   query97  3388311731613117
   query98  212 200 204 200
   query99  1634127612651265
   Total cold run time: 338553 ms
   Total hot run time: 197085 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 data wrong when query with table operator such as TABLESAMPLE or tablet and so on #43030 [doris]

2024-12-02 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 40352 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit e0fe887c5b5c7fb93e79ad1d45189eb1d218aaa6, 
data reload: false
   
   -- Round 1 --
   q1   17581   732072397239
   q2   2056171 162 162
   q3   10672   107211281072
   q4   10562   785 660 660
   q5   7724285328172817
   q6   230 145 144 144
   q7   945 611 603 603
   q8   9562189619731896
   q9   7250637764186377
   q10  7000225323292253
   q11  452 266 255 255
   q12  403 209 204 204
   q13  17798   310731093107
   q14  243 213 215 213
   q15  575 520 527 520
   q16  653 619 620 619
   q17  985 605 500 500
   q18  7248655365346534
   q19  1668973 993 973
   q20  489 199 209 199
   q21  3998304130843041
   q22  1049993 964 964
   Total cold run time: 109143 ms
   Total hot run time: 40352 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   7279720471907190
   q2   323 230 232 230
   q3   2859284328392839
   q4   2023182417281728
   q5   5653569756575657
   q6   223 136 137 136
   q7   2190176617961766
   q8   3304349734873487
   q9   8733890088428842
   q10  3513351934893489
   q11  602 507 488 488
   q12  805 630 604 604
   q13  16477   313631403136
   q14  310 271 264 264
   q15  569 518 525 518
   q16  714 668 670 668
   q17  1855161315721572
   q18  8186794174127412
   q19  5507153316111533
   q20  2066182318321823
   q21  5427519753875197
   q22  10611018989 989
   Total cold run time: 79679 ms
   Total hot run time: 59568 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 data wrong when query with table operator such as TABLESAMPLE or tablet and so on #43030 [doris]

2024-12-02 Thread via GitHub


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

   
   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 data wrong when query with table operator such as TABLESAMPLE or tablet and so on #43030 [doris]

2024-12-02 Thread via GitHub


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

   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](mtmv) Fix data wrong when query with table operator such as TABLESAMPLE or tablet and so on #43030 [doris]

2024-12-02 Thread via GitHub


dataroaring closed pull request #44873: branch-3.0: [fix](mtmv) Fix data wrong 
when query with table operator such as TABLESAMPLE or tablet and so on #43030
URL: https://github.com/apache/doris/pull/44873


-- 
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