Re: [PR] branch-3.0: [bugfix](query) Fix for incorrect query results of variant type #51651 [doris]

2025-06-17 Thread via GitHub


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


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] branch-3.0: [bugfix](query) Fix for incorrect query results of variant type #51651 [doris]

2025-06-13 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 30.23 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 0cae7869751b69c366d8bb9ac9c10228e273a5c1, 
data reload: false
   
   query1   0.040.040.03
   query2   0.070.020.03
   query3   0.230.070.06
   query4   1.630.100.10
   query5   0.510.500.52
   query6   1.130.720.71
   query7   0.020.010.01
   query8   0.040.040.03
   query9   0.560.490.50
   query10  0.550.550.58
   query11  0.130.100.11
   query12  0.140.100.11
   query13  0.600.600.60
   query14  0.770.770.82
   query15  0.850.830.81
   query16  0.370.360.38
   query17  0.991.061.03
   query18  0.230.210.21
   query19  1.971.831.88
   query20  0.020.010.01
   query21  15.42   0.610.60
   query22  2.552.061.97
   query23  17.36   0.980.78
   query24  3.660.791.12
   query25  0.200.110.10
   query26  0.600.140.13
   query27  0.060.040.04
   query28  10.33   0.540.46
   query29  12.57   3.263.26
   query30  0.250.070.06
   query31  2.860.390.37
   query32  3.240.450.45
   query33  2.973.013.02
   query34  17.00   4.574.55
   query35  4.564.594.57
   query36  0.670.470.47
   query37  0.090.060.06
   query38  0.040.030.03
   query39  0.030.030.02
   query40  0.160.120.12
   query41  0.070.020.03
   query42  0.040.020.02
   query43  0.040.030.04
   Total cold run time: 105.62 s
   Total hot run time: 30.23 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] branch-3.0: [bugfix](query) Fix for incorrect query results of variant type #51651 [doris]

2025-06-13 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 197172 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 0cae7869751b69c366d8bb9ac9c10228e273a5c1, 
data reload: false
   
   query1   1293900 885 885
   query2   6345195618361836
   query3   11056   457845234523
   query4   61628   33588   23831   23831
   query5   5160447 436 436
   query6   305 173 171 171
   query7   4921312 308 308
   query8   266 210 230 210
   query9   6748257925642564
   query10  437 263 260 260
   query11  15589   15211   15663   15211
   query12  161 105 108 105
   query13  1043429 433 429
   query14  10072   723767816781
   query15  204 186 187 186
   query16  7195489 482 482
   query17  1087568 564 564
   query18  1853328 296 296
   query19  201 154 147 147
   query20  124 109 118 109
   query21  209 103 107 103
   query22  4570449847384498
   query23  34506   33987   34035   33987
   query24  6156292429592924
   query25  552 417 426 417
   query26  663 205 170 170
   query27  1866355 361 355
   query28  4054218321642164
   query29  717 460 450 450
   query30  237 154 153 153
   query31  973 803 810 803
   query32  68  58  60  58
   query33  437 305 309 305
   query34  932 498 515 498
   query35  839 713 742 713
   query36  1070954 959 954
   query37  104 69  76  69
   query38  4041401640334016
   query39  1509149714671467
   query40  204 106 102 102
   query41  52  49  49  49
   query42  116 104 108 104
   query43  552 493 457 457
   query44  1200815 827 815
   query45  190 173 174 173
   query46  1147738 731 731
   query47  2040195119511951
   query48  480 382 391 382
   query49  753 421 407 407
   query50  849 437 439 437
   query51  7386722771997199
   query52  100 88  89  88
   query53  253 178 184 178
   query54  596 468 459 459
   query55  82  81  75  75
   query56  256 256 242 242
   query57  1322120612141206
   query58  229 201 226 201
   query59  3196305030813050
   query60  281 254 257 254
   query61  113 108 111 108
   query62  829 694 703 694
   query63  219 188 186 186
   query64  1349651 615 615
   query65  3242317031643164
   query66  721 301 293 293
   query67  15972   15724   15556   15556
   query68  3656597 589 589
   query69  437 259 268 259
   query70  1130106210931062
   query71  373 279 250 250
   query72  6410397040263970
   query73  768 339 354 339
   query74  9981927892549254
   query75  3309261826322618
   query76  1799100110811001
   query77  476 276 272 272
   query78  10689   959896189598
   query79  1299595 586 586
   query80  786 417 414 414
   query81  492 216 215 215
   query82  266 88  83  83
   query83  159 142 153 142
   query84  295 77  75  75
   query85  990 308 295 295
   query86  344 278 298 278
   query87  4426430343224303
   query88  4155237923762376
   query89  409 298 283 283
   query90  2020178 183 178
   query91  175 146 144 144
   query92  60  48  52  48
   query93  1696548 546 546
   query94  758 266 287 266
   query95  361 264 255 255
   query96  622 276 276 276
   query97  3277316531113111
   query98  217 198 205 198
   query99  1578127412891274
   Total cold run time: 306333 ms
   Total hot run time: 197172 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: [bugfix](query) Fix for incorrect query results of variant type #51651 [doris]

2025-06-13 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 39727 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 0cae7869751b69c366d8bb9ac9c10228e273a5c1, 
data reload: false
   
   -- Round 1 --
   q1   17572   670665336533
   q2   2074166 166 166
   q3   10579   106811381068
   q4   10206   748 728 728
   q5   7717283127782778
   q6   210 132 131 131
   q7   953 615 615 615
   q8   9365197920051979
   q9   6543640164136401
   q10  7019231622922292
   q11  461 272 263 263
   q12  393 216 214 214
   q13  17784   300629732973
   q14  233 209 213 209
   q15  520 458 464 458
   q16  479 387 375 375
   q17  972 545 544 544
   q18  7411663966146614
   q19  1403109510371037
   q20  489 204 204 204
   q21  3925313831993138
   q22  1132103410071007
   Total cold run time: 107440 ms
   Total hot run time: 39727 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   6520651165136511
   q2   331 237 240 237
   q3   2850275627692756
   q4   2042174818111748
   q5   5723579957645764
   q6   209 130 126 126
   q7   2183179517771777
   q8   3374352435373524
   q9   8869879889098798
   q10  3622350335493503
   q11  584 486 505 486
   q12  794 590 579 579
   q13  10541   312631653126
   q14  306 283 286 283
   q15  525 459 460 459
   q16  479 441 445 441
   q17  1821162015881588
   q18  8300785977837783
   q19  1673157016371570
   q20  2160185618111811
   q21  5011506149884988
   q22  1156107310741073
   Total cold run time: 69073 ms
   Total hot run time: 58931 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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] branch-3.0: [bugfix](query) Fix for incorrect query results of variant type #51651 [doris]

2025-06-13 Thread via GitHub


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

   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] branch-3.0: [bugfix](query) Fix for incorrect query results of variant type #51651 [doris]

2025-06-13 Thread via GitHub


dataroaring closed pull request #51705: branch-3.0: [bugfix](query) Fix for 
incorrect query results of variant type #51651
URL: https://github.com/apache/doris/pull/51705


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]



Re: [PR] branch-3.0: [bugfix](query) Fix for incorrect query results of variant type #51651 [doris]

2025-06-13 Thread via GitHub


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

   
   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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


-
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]