Re: [PR] [fix](nereids) fix can not prune dereference expression [doris]

2025-12-03 Thread via GitHub


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

   # FE Regression Coverage Report
   Increment line coverage `  100.00% (3/3)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/58657_31421a8699316a7afde5865295e15c6f9fc17c34_merge_fe/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/58657_31421a8699316a7afde5865295e15c6f9fc17c34_merge_fe/report/index.html)
   


-- 
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] [fix](nereids) fix can not prune dereference expression [doris]

2025-12-03 Thread via GitHub


924060929 merged PR #58657:
URL: https://github.com/apache/doris/pull/58657


-- 
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] [fix](nereids) fix can not prune dereference expression [doris]

2025-12-03 Thread via GitHub


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

   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: [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] [fix](nereids) fix can not prune dereference expression [doris]

2025-12-02 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 27.55 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 31421a8699316a7afde5865295e15c6f9fc17c34, 
data reload: false
   
   query1   0.050.050.05
   query2   0.100.050.05
   query3   0.250.090.08
   query4   1.610.110.11
   query5   0.280.260.25
   query6   1.180.650.65
   query7   0.040.030.02
   query8   0.060.040.05
   query9   0.570.520.50
   query10  0.560.550.56
   query11  0.160.100.11
   query12  0.150.110.12
   query13  0.620.610.61
   query14  0.991.000.99
   query15  0.810.800.80
   query16  0.420.420.40
   query17  1.001.031.08
   query18  0.230.220.21
   query19  1.871.941.78
   query20  0.010.010.01
   query21  15.44   0.300.14
   query22  4.850.050.05
   query23  16.02   0.280.10
   query24  0.950.460.40
   query25  0.090.080.04
   query26  0.140.130.13
   query27  0.060.040.06
   query28  4.091.231.04
   query29  12.66   4.093.25
   query30  0.280.140.12
   query31  2.820.620.41
   query32  3.230.580.46
   query33  3.103.053.05
   query34  16.85   5.234.57
   query35  4.534.554.56
   query36  0.680.500.49
   query37  0.100.070.07
   query38  0.080.040.04
   query39  0.050.030.04
   query40  0.190.160.14
   query41  0.080.030.04
   query42  0.050.030.03
   query43  0.050.040.03
   Total cold run time: 97.35 s
   Total hot run time: 27.55 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] [fix](nereids) fix can not prune dereference expression [doris]

2025-12-02 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 182710 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 31421a8699316a7afde5865295e15c6f9fc17c34, 
data reload: false
   
   query1   1050411 402 402
   query2   6611118611911186
   query3   6741237 226 226
   query4   25575   23401   22773   22773
   query5   4463678 522 522
   query6   346 255 237 237
   query7   4647546 320 320
   query8   323 253 237 237
   query9   8695267426702670
   query10  557 353 313 313
   query11  15143   15109   14963   14963
   query12  188 126 119 119
   query13  1711586 443 443
   query14  9775610060676067
   query15  210 198 191 191
   query16  7691710 547 547
   query17  1257791 660 660
   query18  2048442 354 354
   query19  224 218 193 193
   query20  128 126 125 125
   query21  222 140 112 112
   query22  3982391737663766
   query23  33161   32180   32138   32138
   query24  8498248625032486
   query25  648 562 505 505
   query26  1251289 179 179
   query27  2702526 353 353
   query28  4355222321992199
   query29  835 661 552 552
   query30  326 246 217 217
   query31  874 723 632 632
   query32  94  78  77  77
   query33  626 407 394 394
   query34  832 897 567 567
   query35  808 836 739 739
   query36  886 941 838 838
   query37  126 114 91  91
   query38  3890392737763776
   query39  1464142214051405
   query40  238 140 121 121
   query41  76  63  62  62
   query42  126 120 121 120
   query43  447 461 422 422
   query44  1352780 771 771
   query45  202 200 183 183
   query46  906 1019656 656
   query47  1667171516181618
   query48  412 437 337 337
   query49  782 495 422 422
   query50  687 695 427 427
   query51  3878394839283928
   query52  114 119 107 107
   query53  264 271 199 199
   query54  320 305 302 302
   query55  98  95  95  95
   query56  333 318 340 318
   query57  1128115010961096
   query58  292 281 267 267
   query59  2292242222822282
   query60  351 388 329 329
   query61  160 154 159 154
   query62  778 731 667 667
   query63  240 199 204 199
   query64  44601281937 937
   query65  4086394739553947
   query66  1107456 349 349
   query67  15126   15154   14797   14797
   query68  8589995 648 648
   query69  524 371 314 314
   query70  1109976 981 976
   query71  505 349 322 322
   query72  5813509148734873
   query73  737 584 349 349
   query74  8967889086548654
   query75  3666307325482548
   query76  37831148767 767
   query77  818 415 318 318
   query78  9581960989488948
   query79  2224836 588 588
   query80  668 621 488 488
   query81  513 273 245 245
   query82  467 148 113 113
   query83  274 264 267 264
   query84  258 116 96  96
   query85  953 497 445 445
   query86  401 331 277 277
   query87  4102415639713971
   query88  4049226922532253
   query89  390 338 295 295
   query90  1952220 215 215
   query91  175 171 141 141
   query92  85  70  68  68
   query93  18101040677 677
   query94  730 459 354 354
   query95  506 406 413 406
   query96  546 564 285 285
   query97  2638268426272627
   query98  249 214 220 214
   query99  1432141512851285
   Total cold run time: 273399 ms
   Total hot run time: 182710 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] [fix](nereids) fix can not prune dereference expression [doris]

2025-12-02 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 34462 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 31421a8699316a7afde5865295e15c6f9fc17c34, 
data reload: false
   
   -- Round 1 --
   q1   17647   514348604860
   q2   2065313 212 212
   q3   10249   1346754 754
   q4   10224   870 319 319
   q5   7545252222002200
   q6   191 177 139 139
   q7   972 805 645 645
   q8   9361145411021102
   q9   7196537053305330
   q10  6859224218171817
   q11  535 309 300 300
   q12  355 382 242 242
   q13  17769   370530593059
   q14  230 236 218 218
   q15  586 519 511 511
   q16  902 858 822 822
   q17  675 764 543 543
   q18  8136712570057005
   q19  1098956 608 608
   q20  363 357 237 237
   q21  3990350225842584
   q22  10481033955 955
   Total cold run time: 107996 ms
   Total hot run time: 34462 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5028499449714971
   q2   338 401 320 320
   q3   2184267422832283
   q4   1362180513421342
   q5   4269472145964596
   q6   217 180 130 130
   q7   2100202918931893
   q8   2713260325572557
   q9   7591749274967492
   q10  3097327228992899
   q11  590 536 506 506
   q12  853 743 614 614
   q13  3541392733573357
   q14  300 323 279 279
   q15  563 514 502 502
   q16  934 947 905 905
   q17  1204138414571384
   q18  7928769775817581
   q19  908 858 896 858
   q20  2079207119571957
   q21  5000440142384238
   q22  10901028978 978
   Total cold run time: 53889 ms
   Total hot run time: 51642 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] [fix](nereids) fix can not prune dereference expression [doris]

2025-12-02 Thread via GitHub


924060929 commented on PR #58657:
URL: https://github.com/apache/doris/pull/58657#issuecomment-3605330870

   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] [fix](nereids) fix can not prune dereference expression [doris]

2025-12-02 Thread via GitHub


924060929 commented on PR #58657:
URL: https://github.com/apache/doris/pull/58657#issuecomment-3605270382

   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] [fix](nereids) fix can not prune dereference expression [doris]

2025-12-02 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 27.54 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 986f8cf76bda729871a12d51c3b95fdcaf8c2d0c, 
data reload: false
   
   query1   0.050.050.05
   query2   0.100.060.05
   query3   0.260.090.09
   query4   1.620.110.11
   query5   0.260.240.25
   query6   1.170.650.63
   query7   0.030.030.02
   query8   0.050.040.04
   query9   0.590.500.50
   query10  0.560.560.55
   query11  0.170.110.11
   query12  0.150.110.13
   query13  0.620.590.60
   query14  0.990.980.99
   query15  0.830.790.79
   query16  0.400.410.39
   query17  1.041.041.08
   query18  0.230.210.21
   query19  1.911.841.78
   query20  0.010.020.01
   query21  15.45   0.280.14
   query22  4.980.050.05
   query23  16.08   0.270.10
   query24  1.270.660.71
   query25  0.090.100.04
   query26  0.140.150.12
   query27  0.060.060.05
   query28  5.061.191.01
   query29  12.56   4.023.20
   query30  0.290.140.12
   query31  2.810.620.38
   query32  3.240.550.46
   query33  3.043.043.01
   query34  16.90   5.224.56
   query35  4.594.504.52
   query36  0.670.500.48
   query37  0.110.070.07
   query38  0.070.050.04
   query39  0.040.030.03
   query40  0.170.140.15
   query41  0.090.040.03
   query42  0.050.030.03
   query43  0.040.040.03
   Total cold run time: 98.84 s
   Total hot run time: 27.54 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] [fix](nereids) fix can not prune dereference expression [doris]

2025-12-02 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 34099 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 986f8cf76bda729871a12d51c3b95fdcaf8c2d0c, 
data reload: false
   
   -- Round 1 --
   q1   17626   498448894889
   q2   2084321 204 204
   q3   10195   1311741 741
   q4   10242   871 312 312
   q5   7514240721162116
   q6   183 168 136 136
   q7   958 785 625 625
   q8   9358144110851085
   q9   6951534553245324
   q10  6780217917831783
   q11  528 312 284 284
   q12  341 369 218 218
   q13  17756   365929982998
   q14  243 236 208 208
   q15  574 515 510 510
   q16  887 865 809 809
   q17  666 791 545 545
   q18  7425708770277027
   q19  1091965 602 602
   q20  366 364 226 226
   q21  3932338225042504
   q22  10571014953 953
   Total cold run time: 106757 ms
   Total hot run time: 34099 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4962491849034903
   q2   338 400 328 328
   q3   2142263822762276
   q4   1300175112771277
   q5   4178436646484366
   q6   219 184 129 129
   q7   2043197918631863
   q8   2665258025412541
   q9   7452751174637463
   q10  3044327628112811
   q11  595 520 505 505
   q12  706 773 633 633
   q13  3447388233493349
   q14  310 322 302 302
   q15  555 491 535 491
   q16  925 910 869 869
   q17  1207147214341434
   q18  8160770874947494
   q19  882 885 903 885
   q20  2041208619191919
   q21  4891435641254125
   q22  10951076975 975
   Total cold run time: 53157 ms
   Total hot run time: 50938 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] [fix](nereids) fix can not prune dereference expression [doris]

2025-12-02 Thread via GitHub


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

   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: [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] [fix](nereids) fix can not prune dereference expression [doris]

2025-12-02 Thread via GitHub


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

   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: [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] [fix](nereids) fix can not prune dereference expression [doris]

2025-12-02 Thread via GitHub


Thearas commented on PR #58657:
URL: https://github.com/apache/doris/pull/58657#issuecomment-3604966926

   
   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]



Re: [PR] [fix](nereids) fix can not prune dereference expression [doris]

2025-12-02 Thread via GitHub


924060929 commented on PR #58657:
URL: https://github.com/apache/doris/pull/58657#issuecomment-3604967030

   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]