Re: [PR] [fix](pipelinex) fix null aware left anti join instance num [doris]

2025-05-19 Thread via GitHub


starocean999 merged PR #51053:
URL: https://github.com/apache/doris/pull/51053


-- 
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](pipelinex) fix null aware left anti join instance num [doris]

2025-05-19 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 28.78 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 8c6fd642d08e08ee776f14f6ee87927d95db18d3, 
data reload: false
   
   query1   0.040.040.03
   query2   0.120.100.11
   query3   0.250.190.19
   query4   1.590.190.19
   query5   0.450.420.45
   query6   1.480.660.66
   query7   0.020.010.02
   query8   0.040.030.04
   query9   0.580.510.52
   query10  0.570.580.56
   query11  0.150.100.11
   query12  0.150.120.12
   query13  0.610.610.60
   query14  0.790.820.82
   query15  0.850.860.84
   query16  0.400.400.37
   query17  1.061.011.04
   query18  0.220.220.21
   query19  1.951.801.86
   query20  0.010.010.02
   query21  15.39   0.930.54
   query22  0.741.130.74
   query23  14.95   1.410.65
   query24  7.181.360.49
   query25  0.490.190.06
   query26  0.700.170.13
   query27  0.060.050.04
   query28  8.920.870.45
   query29  12.56   4.053.30
   query30  0.270.100.07
   query31  2.830.590.38
   query32  3.220.540.47
   query33  3.123.063.21
   query34  15.80   5.064.49
   query35  4.514.554.54
   query36  0.670.490.48
   query37  0.090.070.06
   query38  0.050.040.04
   query39  0.030.030.02
   query40  0.170.130.14
   query41  0.080.030.02
   query42  0.030.020.03
   query43  0.030.030.02
   Total cold run time: 103.22 s
   Total hot run time: 28.78 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](pipelinex) fix null aware left anti join instance num [doris]

2025-05-19 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 192808 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 8c6fd642d08e08ee776f14f6ee87927d95db18d3, 
data reload: false
   
   query1   1394106810541054
   query2   6129181718201817
   query3   11008   461146324611
   query4   54721   25912   23285   23285
   query5   4979525 461 461
   query6   334 217 191 191
   query7   4875539 293 293
   query8   309 253 213 213
   query9   5620262326382623
   query10  414 342 280 280
   query11  15106   15056   14759   14759
   query12  157 112 104 104
   query13  1040524 409 409
   query14  10180   643864396438
   query15  204 198 187 187
   query16  7113646 491 491
   query17  1104767 630 630
   query18  1532429 332 332
   query19  201 197 174 174
   query20  134 132 121 121
   query21  215 128 108 108
   query22  4411439741414141
   query23  34362   33749   33545   33545
   query24  6627240824852408
   query25  460 472 417 417
   query26  717 264 149 149
   query27  2440543 345 345
   query28  3306212821482128
   query29  581 588 438 438
   query30  277 212 186 186
   query31  876 847 773 773
   query32  74  62  61  61
   query33  461 400 318 318
   query34  791 863 557 557
   query35  842 839 782 782
   query36  963 977 915 915
   query37  107 104 70  70
   query38  4307418741554155
   query39  1535146714891467
   query40  214 125 110 110
   query41  64  52  53  52
   query42  126 117 105 105
   query43  492 521 484 484
   query44  1342839 853 839
   query45  177 176 167 167
   query46  856 1033647 647
   query47  1812188317731773
   query48  415 444 347 347
   query49  707 526 427 427
   query50  664 696 414 414
   query51  4226428343224283
   query52  110 111 102 102
   query53  231 261 191 191
   query54  581 585 522 522
   query55  90  87  85  85
   query56  317 315 332 315
   query57  1195119611131113
   query58  270 255 268 255
   query59  2688278527192719
   query60  349 318 311 311
   query61  126 116 119 116
   query62  727 709 682 682
   query63  223 186 179 179
   query64  19181018675 675
   query65  4332423742064206
   query66  758 396 304 304
   query67  15849   15605   15434   15434
   query68  7429888 523 523
   query69  529 299 266 266
   query70  1146116111151115
   query71  490 309 299 299
   query72  5447479850354798
   query73  1434696 364 364
   query74  9315893888088808
   query75  3714320726922692
   query76  42671198747 747
   query77  708 375 287 287
   query78  10110   10194   93689368
   query79  2014805 593 593
   query80  596 523 443 443
   query81  481 244 213 213
   query82  464 124 97  97
   query83  248 251 242 242
   query84  290 98  87  87
   query85  782 347 311 311
   query86  404 309 294 294
   query87  4363440942864286
   query88  3612236223322332
   query89  417 329 290 290
   query90  1948209 215 209
   query91  144 149 111 111
   query92  69  58  53  53
   query93  1506922 587 587
   query94  670 408 299 299
   query95  369 291 290 290
   query96  503 561 323 323
   query97  2707271226932693
   query98  243 206 205 205
   query99  1419141112901290
   Total cold run time: 298603 ms
   Total hot run time: 192808 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 

Re: [PR] [fix](pipelinex) fix null aware left anti join instance num [doris]

2025-05-19 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 33819 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 8c6fd642d08e08ee776f14f6ee87927d95db18d3, 
data reload: false
   
   -- Round 1 --
   q1   25791   504050025002
   q2   2067269 180 180
   q3   10395   1238703 703
   q4   10238   1005515 515
   q5   7567228323482283
   q6   177 167 132 132
   q7   912 749 622 622
   q8   9318128910781078
   q9   6791504250405040
   q10  6860230918701870
   q11  493 288 275 275
   q12  346 351 212 212
   q13  17768   367231723172
   q14  228 227 221 221
   q15  549 503 479 479
   q16  407 430 387 387
   q17  574 840 369 369
   q18  7561719271957192
   q19  1363940 572 572
   q20  354 333 219 219
   q21  3669254023202320
   q22  10251039976 976
   Total cold run time: 114453 ms
   Total hot run time: 33819 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5128506750355035
   q2   230 322 225 225
   q3   2157257423062306
   q4   1329179913541354
   q5   4353442244594422
   q6   216 172 123 123
   q7   2038197417791779
   q8   2551265625422542
   q9   7140724869546954
   q10  3047319227992799
   q11  587 516 488 488
   q12  657 759 590 590
   q13  3533395933043304
   q14  295 300 262 262
   q15  534 514 506 506
   q16  467 515 448 448
   q17  1131151813911391
   q18  7699762874547454
   q19  776 818 956 818
   q20  1967204318871887
   q21  4726456044504450
   q22  1116110310261026
   Total cold run time: 51677 ms
   Total hot run time: 50163 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](pipelinex) fix null aware left anti join instance num [doris]

2025-05-19 Thread via GitHub


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

   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](pipelinex) fix null aware left anti join instance num [doris]

2025-05-19 Thread via GitHub


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

   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](pipelinex) fix null aware left anti join instance num [doris]

2025-05-19 Thread via GitHub


yujun777 commented on PR #51053:
URL: https://github.com/apache/doris/pull/51053#issuecomment-2892738369

   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](pipelinex) fix null aware left anti join instance num [doris]

2025-05-19 Thread via GitHub


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

   
   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