Re: [PR] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2026-01-04 Thread via GitHub


zclllyybb merged PR #57941:
URL: https://github.com/apache/doris/pull/57941


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2026-01-04 Thread via GitHub


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

   # BE Regression && UT Coverage Report
   Increment line coverage `7.06% (6/85)` :tada:
   
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_a01a9a81c33e1c678170c0aca12ff18f31f08fc0_merge/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_a01a9a81c33e1c678170c0aca12ff18f31f08fc0_merge/report/index.html)
   | Category  | Coverage   |
   |---||
   | Function Coverage | 72.39% (25128/34714) |
   | Line Coverage | 59.49% (265687/446605) |
   | Region Coverage   | 54.24% (220389/406353) |
   | Branch Coverage   | 55.86% (94723/169559) |


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2026-01-04 Thread via GitHub


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

   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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-30 Thread via GitHub


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

   # FE Regression Coverage Report
   Increment line coverage `  85.03% (125/147)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_a01a9a81c33e1c678170c0aca12ff18f31f08fc0_merge_fe/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_a01a9a81c33e1c678170c0aca12ff18f31f08fc0_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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-30 Thread via GitHub


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

   # BE Regression && UT Coverage Report
   Increment line coverage `7.06% (6/85)` :tada:
   
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_a01a9a81c33e1c678170c0aca12ff18f31f08fc0_merge/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_a01a9a81c33e1c678170c0aca12ff18f31f08fc0_merge/report/index.html)
   | Category  | Coverage   |
   |---||
   | Function Coverage | 72.39% (25128/34714) |
   | Line Coverage | 59.49% (265687/446605) |
   | Region Coverage   | 54.24% (220389/406353) |
   | Branch Coverage   | 55.86% (94723/169559) |


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-30 Thread via GitHub


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

   # FE Regression Coverage Report
   Increment line coverage `  85.03% (125/147)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_a01a9a81c33e1c678170c0aca12ff18f31f08fc0_merge_fe/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_a01a9a81c33e1c678170c0aca12ff18f31f08fc0_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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-30 Thread via GitHub


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

   # BE Regression && UT Coverage Report
   Increment line coverage `7.06% (6/85)` :tada:
   
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_a01a9a81c33e1c678170c0aca12ff18f31f08fc0_merge/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_a01a9a81c33e1c678170c0aca12ff18f31f08fc0_merge/report/index.html)
   | Category  | Coverage   |
   |---||
   | Function Coverage | 72.39% (25131/34714) |
   | Line Coverage | 59.50% (265728/446605) |
   | Region Coverage   | 54.24% (220401/406353) |
   | Branch Coverage   | 55.88% (94743/169559) |


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-30 Thread via GitHub


linrrzqqq commented on PR #57941:
URL: https://github.com/apache/doris/pull/57941#issuecomment-3698708276

   run p0


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-30 Thread via GitHub


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

   # FE Regression Coverage Report
   Increment line coverage `  85.03% (125/147)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_a01a9a81c33e1c678170c0aca12ff18f31f08fc0_merge_fe/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_a01a9a81c33e1c678170c0aca12ff18f31f08fc0_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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-30 Thread via GitHub


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

   # BE Regression && UT Coverage Report
   Increment line coverage `7.06% (6/85)` :tada:
   
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_a01a9a81c33e1c678170c0aca12ff18f31f08fc0_merge/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_a01a9a81c33e1c678170c0aca12ff18f31f08fc0_merge/report/index.html)
   | Category  | Coverage   |
   |---||
   | Function Coverage | 72.39% (25131/34714) |
   | Line Coverage | 59.50% (265728/446605) |
   | Region Coverage   | 54.24% (220401/406353) |
   | Branch Coverage   | 55.88% (94743/169559) |


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-29 Thread via GitHub


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

   # BE Regression && UT Coverage Report
   Increment line coverage `7.06% (6/85)` :tada:
   
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_a01a9a81c33e1c678170c0aca12ff18f31f08fc0_merge/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_a01a9a81c33e1c678170c0aca12ff18f31f08fc0_merge/report/index.html)
   | Category  | Coverage   |
   |---||
   | Function Coverage | 72.38% (25125/34714) |
   | Line Coverage | 59.49% (265687/446605) |
   | Region Coverage   | 54.24% (220397/406353) |
   | Branch Coverage   | 55.87% (94727/169559) |


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-29 Thread via GitHub


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

   # BE UT Coverage Report
   Increment line coverage `7.06% (6/85)` :tada:
   
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/a01a9a81c33e1c678170c0aca12ff18f31f08fc0_a01a9a81c33e1c678170c0aca12ff18f31f08fc0/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/a01a9a81c33e1c678170c0aca12ff18f31f08fc0_a01a9a81c33e1c678170c0aca12ff18f31f08fc0/report/index.html)
   | Category  | Coverage   |
   |---||
   | Function Coverage | 53.36% (18953/35517) |
   | Line Coverage | 39.24% (175841/448114) |
   | Region Coverage   | 33.78% (135954/402450) |
   | Branch Coverage   | 34.74% (58759/169150) |


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-29 Thread via GitHub


linrrzqqq commented on PR #57941:
URL: https://github.com/apache/doris/pull/57941#issuecomment-3698451229

   run cloud_p0


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-29 Thread via GitHub


linrrzqqq commented on PR #57941:
URL: https://github.com/apache/doris/pull/57941#issuecomment-3698450647

   run p0


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-29 Thread via GitHub


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

   # FE Regression Coverage Report
   Increment line coverage `  85.03% (125/147)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_a01a9a81c33e1c678170c0aca12ff18f31f08fc0_merge_fe/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_a01a9a81c33e1c678170c0aca12ff18f31f08fc0_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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-29 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 26.77 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit a01a9a81c33e1c678170c0aca12ff18f31f08fc0, 
data reload: false
   
   query1   0.060.050.06
   query2   0.100.050.04
   query3   0.250.080.08
   query4   1.600.110.11
   query5   0.270.250.24
   query6   1.140.660.67
   query7   0.040.030.03
   query8   0.060.040.04
   query9   0.560.510.52
   query10  0.540.560.56
   query11  0.150.110.11
   query12  0.160.130.13
   query13  0.620.600.60
   query14  1.001.010.99
   query15  0.810.790.82
   query16  0.390.400.39
   query17  1.071.070.99
   query18  0.230.220.21
   query19  1.961.811.80
   query20  0.020.010.01
   query21  15.44   0.280.15
   query22  4.850.050.04
   query23  16.05   0.290.10
   query24  1.490.270.18
   query25  0.110.080.05
   query26  0.150.130.13
   query27  0.070.050.10
   query28  3.161.070.89
   query29  12.68   3.923.14
   query30  0.270.150.12
   query31  2.810.630.37
   query32  3.230.560.47
   query33  2.963.033.04
   query34  16.75   5.054.41
   query35  4.564.544.47
   query36  0.670.500.48
   query37  0.110.070.06
   query38  0.070.040.04
   query39  0.050.030.03
   query40  0.170.140.13
   query41  0.090.040.03
   query42  0.040.040.03
   query43  0.040.040.03
   Total cold run time: 96.85 s
   Total hot run time: 26.77 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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-29 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 175145 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 a01a9a81c33e1c678170c0aca12ff18f31f08fc0, 
data reload: false
   
   query5   4863580 450 450
   query6   327 214 207 207
   query7   4226459 269 269
   query8   335 255 242 242
   query9   8786260325982598
   query10  539 363 313 313
   query11  15375   15293   14799   14799
   query12  179 116 116 116
   query13  1257472 379 379
   query14  6344298527442744
   query14_12648262826082608
   query15  196 196 169 169
   query16  979 384 445 384
   query17  1036667 562 562
   query18  2535442 329 329
   query19  222 227 192 192
   query20  125 119 114 114
   query21  213 135 117 117
   query22  4088415938273827
   query23  16151   15801   15298   15298
   query23_115613   15470   15430   15430
   query24  7384159212101210
   query24_11227119212161192
   query25  542 445 434 434
   query26  1118267 158 158
   query27  2744448 291 291
   query28  4579217221762172
   query29  822 523 427 427
   query30  310 239 215 215
   query31  798 641 560 560
   query32  79  71  66  66
   query33  566 341 279 279
   query34  900 907 534 534
   query35  753 799 693 693
   query36  862 874 796 796
   query37  136 88  75  75
   query38  2787273326782678
   query39  774 749 730 730
   query39_1716 707 711 707
   query40  219 131 114 114
   query41  68  62  64  62
   query42  105 104 106 104
   query43  444 452 434 434
   query44  1361758 757 757
   query45  194 198 179 179
   query46  899 975 620 620
   query47  1398136113641361
   query48  321 333 244 244
   query49  607 409 319 319
   query50  633 286 210 210
   query51  3953378738173787
   query52  104 111 95  95
   query53  296 323 272 272
   query54  292 253 243 243
   query55  79  81  78  78
   query56  285 285 297 285
   query57  1013999 888 888
   query58  270 256 262 256
   query59  2120214421322132
   query60  327 319 300 300
   query61  168 157 160 157
   query62  407 342 307 307
   query63  299 263 268 263
   query64  4894133911021102
   query65  3782374736473647
   query66  1382453 342 342
   query67  15115   15438   15655   15438
   query68  27471075788 788
   query69  453 353 329 329
   query70  1028982 920 920
   query71  325 319 276 276
   query72  6332496049704960
   query73  527 583 316 316
   query74  8775882285458545
   query75  2842287925432543
   query76  28661051673 673
   query77  335 367 294 294
   query78  984410113   91949194
   query79  1072882 624 624
   query80  1192581 496 496
   query81  547 268 236 236
   query82  592 147 107 107
   query83  374 261 237 237
   query84  258 117 105 105
   query85  961 515 463 463
   query86  398 301 327 301
   query87  2857284627602760
   query88  3306228722552255
   query89  402 359 337 337
   query90  1953159 153 153
   query91  177 172 146 146
   query92  81  72  68  68
   query93  1040943 572 572
   query94  679 343 306 306
   query95  576 332 373 332
   query96  599 462 205 205
   query97  2320236722832283
   query98  221 199 205 199
   query99  610 576 501 501
   Total cold run time: 249450 ms
   Total hot run time: 175145 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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-29 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 36159 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit a01a9a81c33e1c678170c0aca12ff18f31f08fc0, 
data reload: false
   
   -- Round 1 --
   q1   17646   426440514051
   q2   2049367 236 236
   q3   10203   1300752 752
   q4   10247   944 334 334
   q5   8206217919901990
   q6   232 178 143 143
   q7   973 788 678 678
   q8   9295144812361236
   q9   7157517851435143
   q10  6853180814121412
   q11  511 310 281 281
   q12  723 743 611 611
   q13  17769   388731133113
   q14  283 298 289 289
   q15  589 507 507 507
   q16  707 688 635 635
   q17  709 746 617 617
   q18  7483783978997839
   q19  11281017681 681
   q20  435 387 259 259
   q21  4652433743064306
   q22  1198109110461046
   Total cold run time: 109048 ms
   Total hot run time: 36159 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4242424142304230
   q2   340 452 345 345
   q3   2257297724942494
   q4   1421190013761376
   q5   4580426442854264
   q6   222 170 130 130
   q7   2016206817061706
   q8   2509232422942294
   q9   7194711271687112
   q10  2519270621222122
   q11  525 458 440 440
   q12  683 725 631 631
   q13  3373379130543054
   q14  280 295 262 262
   q15  520 496 477 477
   q16  628 667 607 607
   q17  1101128313571283
   q18  7344723572597235
   q19  877 836 876 836
   q20  1900203618071807
   q21  4533429741494149
   q22  1096103910271027
   Total cold run time: 50160 ms
   Total hot run time: 47881 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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-29 Thread via GitHub


linrrzqqq commented on PR #57941:
URL: https://github.com/apache/doris/pull/57941#issuecomment-3698191523

   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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-29 Thread via GitHub


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

   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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-25 Thread via GitHub


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

   # FE Regression Coverage Report
   Increment line coverage `  85.03% (125/147)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_68fe3e8e6ff17ed704282a1f0d206c2e3c311e9a_merge_fe/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_68fe3e8e6ff17ed704282a1f0d206c2e3c311e9a_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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-25 Thread via GitHub


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

   # BE Regression && UT Coverage Report
   Increment line coverage `100.00% (85/85)` :tada:
   
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_68fe3e8e6ff17ed704282a1f0d206c2e3c311e9a_merge/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_68fe3e8e6ff17ed704282a1f0d206c2e3c311e9a_merge/report/index.html)
   | Category  | Coverage   |
   |---||
   | Function Coverage | 72.17% (25047/34704) |
   | Line Coverage | 58.89% (262929/446496) |
   | Region Coverage   | 53.70% (218074/406126) |
   | Branch Coverage   | 55.30% (93735/169491) |


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-25 Thread via GitHub


linrrzqqq commented on PR #57941:
URL: https://github.com/apache/doris/pull/57941#issuecomment-3691559089

   run cloud_p0


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-25 Thread via GitHub


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

   # FE Regression Coverage Report
   Increment line coverage `  85.03% (125/147)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_68fe3e8e6ff17ed704282a1f0d206c2e3c311e9a_merge_fe/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_68fe3e8e6ff17ed704282a1f0d206c2e3c311e9a_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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-25 Thread via GitHub


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

   # BE Regression && UT Coverage Report
   Increment line coverage `100.00% (85/85)` :tada:
   
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_68fe3e8e6ff17ed704282a1f0d206c2e3c311e9a_merge/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_68fe3e8e6ff17ed704282a1f0d206c2e3c311e9a_merge/report/index.html)
   | Category  | Coverage   |
   |---||
   | Function Coverage | 72.17% (25047/34704) |
   | Line Coverage | 58.89% (262929/446496) |
   | Region Coverage   | 53.70% (218074/406126) |
   | Branch Coverage   | 55.30% (93735/169491) |


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-25 Thread via GitHub


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

   # BE UT Coverage Report
   Increment line coverage `7.06% (6/85)` :tada:
   
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/68fe3e8e6ff17ed704282a1f0d206c2e3c311e9a_68fe3e8e6ff17ed704282a1f0d206c2e3c311e9a/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/68fe3e8e6ff17ed704282a1f0d206c2e3c311e9a_68fe3e8e6ff17ed704282a1f0d206c2e3c311e9a/report/index.html)
   | Category  | Coverage   |
   |---||
   | Function Coverage | 53.39% (18953/35499) |
   | Line Coverage | 39.26% (175752/447663) |
   | Region Coverage   | 33.81% (135902/401923) |
   | Branch Coverage   | 34.73% (58671/168911) |


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-25 Thread via GitHub


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

   # FE UT Coverage Report
   Increment line coverage `  58.50% (86/147)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_68fe3e8e6ff17ed704282a1f0d206c2e3c311e9a/fe_increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_68fe3e8e6ff17ed704282a1f0d206c2e3c311e9a/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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-25 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 27.22 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 68fe3e8e6ff17ed704282a1f0d206c2e3c311e9a, 
data reload: false
   
   query1   0.060.050.05
   query2   0.100.060.05
   query3   0.260.090.09
   query4   1.610.110.11
   query5   0.290.240.27
   query6   1.190.640.63
   query7   0.030.020.03
   query8   0.060.040.04
   query9   0.550.510.50
   query10  0.550.550.54
   query11  0.150.100.11
   query12  0.150.110.12
   query13  0.630.600.59
   query14  1.000.990.98
   query15  0.820.800.79
   query16  0.400.420.42
   query17  1.091.071.05
   query18  0.230.220.22
   query19  1.821.791.85
   query20  0.020.010.01
   query21  15.44   0.290.13
   query22  4.770.050.05
   query23  16.13   0.300.11
   query24  0.980.580.24
   query25  0.110.110.06
   query26  0.160.130.13
   query27  0.080.070.06
   query28  4.111.221.02
   query29  12.60   4.003.19
   query30  0.270.150.13
   query31  2.810.620.40
   query32  3.230.550.45
   query33  3.053.032.99
   query34  16.89   5.234.57
   query35  4.554.534.56
   query36  0.650.510.50
   query37  0.100.060.06
   query38  0.070.040.03
   query39  0.040.020.02
   query40  0.170.140.14
   query41  0.080.030.03
   query42  0.040.030.02
   query43  0.040.040.03
   Total cold run time: 97.38 s
   Total hot run time: 27.22 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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-25 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 179306 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 68fe3e8e6ff17ed704282a1f0d206c2e3c311e9a, 
data reload: false
   
   query5   5373602 443 443
   query6   340 235 230 230
   query7   4229463 285 285
   query8   306 260 246 246
   query9   8788254625532546
   query10  516 382 325 325
   query11  15655   15046   15228   15046
   query12  204 120 121 120
   query13  1273502 398 398
   query14  7548302427282728
   query14_12655267225782578
   query15  210 199 172 172
   query16  886 452 408 408
   query17  1194686 567 567
   query18  2687435 333 333
   query19  225 220 196 196
   query20  125 115 113 113
   query21  222 140 118 118
   query22  4169402538093809
   query23  16813   16225   15958   15958
   query23_116112   16089   16029   16029
   query24  7067164512411241
   query24_11246123112121212
   query25  553 482 403 403
   query26  1246265 162 162
   query27  2752472 304 304
   query28  4448212521022102
   query29  834 579 488 488
   query30  317 245 219 219
   query31  838 705 636 636
   query32  87  76  71  71
   query33  575 343 300 300
   query34  896 903 534 534
   query35  774 821 718 718
   query36  908 916 807 807
   query37  124 92  76  76
   query38  2960301229472947
   query39  773 726 738 726
   query39_1691 708 707 707
   query40  221 139 118 118
   query41  66  61  63  61
   query42  112 102 107 102
   query43  426 423 404 404
   query44  1307732 733 732
   query45  196 191 183 183
   query46  873 977 609 609
   query47  1704170216171617
   query48  330 324 248 248
   query49  642 440 352 352
   query50  648 297 228 228
   query51  3747382037533753
   query52  105 109 98  98
   query53  314 345 288 288
   query54  278 252 246 246
   query55  79  76  74  74
   query56  292 287 302 287
   query57  1171115011051105
   query58  270 253 252 252
   query59  2451249324312431
   query60  317 302 292 292
   query61  168 159 160 159
   query62  744 699 697 697
   query63  328 292 296 292
   query64  49361285999 999
   query65  4003394239303930
   query66  1374440 306 306
   query67  15221   14860   15127   14860
   query68  27211028753 753
   query69  448 351 313 313
   query70  1045990 936 936
   query71  326 300 281 281
   query72  5964505250485048
   query73  479 538 311 311
   query74  9010888189688881
   query75  3156318928252825
   query76  29151125731 731
   query77  378 415 309 309
   query78  9504958388648864
   query79  1484933 615 615
   query80  1328638 560 560
   query81  544 265 233 233
   query82  438 132 102 102
   query83  373 255 230 230
   query84  263 118 104 104
   query85  960 494 456 456
   query86  403 282 278 278
   query87  3336320230583058
   query88  3233227322642264
   query89  476 423 388 388
   query90  1954157 155 155
   query91  173 166 143 143
   query92  70  66  67  66
   query93  1085906 548 548
   query94  532 295 288 288
   query95  555 324 358 324
   query96  592 467 212 212
   query97  2258229221992199
   query98  209 193 193 193
   query99  1325132213751322
   Total cold run time: 256511 ms
   Total hot run time: 179306 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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-25 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 36058 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 68fe3e8e6ff17ed704282a1f0d206c2e3c311e9a, 
data reload: false
   
   -- Round 1 --
   q1   17595   427240534053
   q2   2043350 231 231
   q3   10147   1339738 738
   q4   10219   823 313 313
   q5   7508219418691869
   q6   197 180 137 137
   q7   993 870 703 703
   q8   9359142211341134
   q9   7003538755395387
   q10  6792242419901990
   q11  535 336 311 311
   q12  652 735 567 567
   q13  17760   371530333033
   q14  292 306 287 287
   q15  575 516 514 514
   q16  704 682 633 633
   q17  690 792 562 562
   q18  7462762380547623
   q19  956 1044652 652
   q20  437 363 249 249
   q21  4624439641054105
   q22  11501019967 967
   Total cold run time: 107693 ms
   Total hot run time: 36058 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4442425743334257
   q2   324 394 300 300
   q3   2363292725882588
   q4   1470202114031403
   q5   4471445444734454
   q6   216 164 126 126
   q7   2167190618031803
   q8   2616254825932548
   q9   7663756075057505
   q10  3118324928332833
   q11  642 553 516 516
   q12  681 778 634 634
   q13  3351367630173017
   q14  272 282 267 267
   q15  539 491 486 486
   q16  622 649 590 590
   q17  1108139913301330
   q18  7334723770407040
   q19  841 795 817 795
   q20  1924194717971797
   q21  4750434142944294
   q22  1106100810161008
   Total cold run time: 52020 ms
   Total hot run time: 49591 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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-25 Thread via GitHub


linrrzqqq commented on PR #57941:
URL: https://github.com/apache/doris/pull/57941#issuecomment-3691129620

   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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-24 Thread via GitHub


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

   # FE Regression Coverage Report
   Increment line coverage `  85.03% (125/147)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_74cd0133d33b62b8c383c667212164edc12f_merge_fe/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_74cd0133d33b62b8c383c667212164edc12f_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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-24 Thread via GitHub


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

   # BE Regression && UT Coverage Report
   Increment line coverage `100.00% (85/85)` :tada:
   
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_74cd0133d33b62b8c383c667212164edc12f_merge/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_74cd0133d33b62b8c383c667212164edc12f_merge/report/index.html)
   | Category  | Coverage   |
   |---||
   | Function Coverage | 72.24% (25066/34699) |
   | Line Coverage | 58.95% (263131/446344) |
   | Region Coverage   | 53.87% (218683/405963) |
   | Branch Coverage   | 55.36% (93797/169445) |


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-24 Thread via GitHub


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

   # BE UT Coverage Report
   Increment line coverage `7.06% (6/85)` :tada:
   
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/74cd0133d33b62b8c383c667212164edc12f_74cd0133d33b62b8c383c667212164edc12f/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/74cd0133d33b62b8c383c667212164edc12f_74cd0133d33b62b8c383c667212164edc12f/report/index.html)
   | Category  | Coverage   |
   |---||
   | Function Coverage | 53.37% (18944/35496) |
   | Line Coverage | 39.22% (175564/447620) |
   | Region Coverage   | 33.82% (135878/401770) |
   | Branch Coverage   | 34.70% (58604/168867) |


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-24 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 27.24 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 74cd0133d33b62b8c383c667212164edc12f, 
data reload: false
   
   query1   0.050.040.05
   query2   0.100.050.04
   query3   0.250.090.08
   query4   1.600.120.11
   query5   0.260.270.26
   query6   1.160.640.63
   query7   0.030.030.03
   query8   0.060.040.05
   query9   0.550.500.50
   query10  0.550.540.53
   query11  0.160.120.12
   query12  0.140.120.11
   query13  0.610.600.61
   query14  0.980.980.97
   query15  0.830.790.79
   query16  0.370.410.41
   query17  1.001.001.06
   query18  0.230.200.21
   query19  1.901.831.81
   query20  0.020.010.02
   query21  15.52   0.300.14
   query22  4.780.050.04
   query23  16.10   0.290.10
   query24  0.940.310.89
   query25  0.080.070.10
   query26  0.140.140.13
   query27  0.060.090.06
   query28  5.241.231.02
   query29  12.58   3.983.16
   query30  0.300.130.11
   query31  2.820.620.39
   query32  3.240.540.45
   query33  2.973.003.08
   query34  16.88   5.134.57
   query35  4.534.564.60
   query36  0.690.500.49
   query37  0.110.060.06
   query38  0.080.050.04
   query39  0.040.040.04
   query40  0.160.130.13
   query41  0.090.040.03
   query42  0.040.030.03
   query43  0.040.040.03
   Total cold run time: 98.28 s
   Total hot run time: 27.24 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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-24 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 179309 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 74cd0133d33b62b8c383c667212164edc12f, 
data reload: false
   
   query5   5326603 448 448
   query6   346 236 242 236
   query7   4227455 263 263
   query8   310 248 234 234
   query9   8761254825422542
   query10  563 376 317 317
   query11  15569   15281   14710   14710
   query12  181 115 116 115
   query13  1268478 397 397
   query14  6373301127462746
   query14_12705267626252625
   query15  206 194 174 174
   query16  867 454 408 408
   query17  1088686 568 568
   query18  2690423 330 330
   query19  230 223 209 209
   query20  123 118 113 113
   query21  212 140 116 116
   query22  3832398840843988
   query23  16574   16213   16008   16008
   query23_115992   16003   16133   16003
   query24  7329162312411241
   query24_11259126112631261
   query25  543 461 440 440
   query26  1259285 170 170
   query27  2708463 304 304
   query28  4513214321232123
   query29  786 567 448 448
   query30  320 241 208 208
   query31  821 681 627 627
   query32  90  76  65  65
   query33  534 338 288 288
   query34  897 883 546 546
   query35  775 822 713 713
   query36  845 916 801 801
   query37  127 91  79  79
   query38  3058309629172917
   query39  786 739 709 709
   query39_1740 708 702 702
   query40  224 136 132 132
   query41  66  65  64  64
   query42  109 107 117 107
   query43  442 441 394 394
   query44  1345749 752 749
   query45  194 192 185 185
   query46  871 971 624 624
   query47  1670171016361636
   query48  313 327 263 263
   query49  623 445 375 375
   query50  672 299 246 246
   query51  3859380638013801
   query52  101 110 99  99
   query53  320 359 287 287
   query54  287 254 255 254
   query55  88  78  72  72
   query56  294 307 302 302
   query57  1180117110711071
   query58  281 250 263 250
   query59  2371247123882388
   query60  317 309 299 299
   query61  160 157 160 157
   query62  746 714 688 688
   query63  342 299 308 299
   query64  4894130110241024
   query65  4027397839473947
   query66  1377462 334 334
   query67  15335   14973   14716   14716
   query68  32061059751 751
   query69  494 377 326 326
   query70  1067984 1008984
   query71  353 304 286 286
   query72  5910510849394939
   query73  465 541 306 306
   query74  8929881089508810
   query75  3159318828082808
   query76  34831141750 750
   query77  520 407 303 303
   query78  9386977988548854
   query79  1036875 604 604
   query80  1195675 552 552
   query81  565 267 234 234
   query82  682 130 105 105
   query83  365 253 234 234
   query84  253 114 106 106
   query85  932 501 465 465
   query86  405 295 277 277
   query87  3210318231313131
   query88  3283227722712271
   query89  473 414 392 392
   query90  1907160 162 160
   query91  174 167 140 140
   query92  68  69  65  65
   query93  963 931 568 568
   query94  535 305 287 287
   query95  571 388 305 305
   query96  591 461 214 214
   query97  2271231321832183
   query98  213 194 193 193
   query99  1335134512831283
   Total cold run time: 255457 ms
   Total hot run time: 179309 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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-24 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 35373 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 74cd0133d33b62b8c383c667212164edc12f, 
data reload: false
   
   -- Round 1 --
   q1   17616   419441124112
   q2   2055354 237 237
   q3   10181   1300767 767
   q4   10208   854 315 315
   q5   7528212819021902
   q6   190 168 138 138
   q7   994 859 713 713
   q8   9366148812011201
   q9   7038534653205320
   q10  6882238219771977
   q11  525 341 323 323
   q12  706 701 573 573
   q13  17801   370130873087
   q14  287 312 267 267
   q15  599 514 518 514
   q16  723 678 657 657
   q17  710 782 560 560
   q18  8060707771597077
   q19  1112961 612 612
   q20  410 368 254 254
   q21  4310389838183818
   q22  10491012949 949
   Total cold run time: 108350 ms
   Total hot run time: 35373 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4398406240604060
   q2   350 409 331 331
   q3   2153265622952295
   q4   1373174813331333
   q5   4242472046664666
   q6   218 178 130 130
   q7   2140200018181818
   q8   2710248325542483
   q9   7580741574387415
   q10  3120321828842884
   q11  630 548 511 511
   q12  837 783 626 626
   q13  3709385232193219
   q14  315 310 278 278
   q15  556 538 522 522
   q16  696 683 638 638
   q17  1175167114011401
   q18  7803773977647739
   q19  881 915 904 904
   q20  2021207918751875
   q21  4600439642794279
   q22  10791024993 993
   Total cold run time: 52586 ms
   Total hot run time: 50400 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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-24 Thread via GitHub


linrrzqqq commented on PR #57941:
URL: https://github.com/apache/doris/pull/57941#issuecomment-3689018551

   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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-10 Thread via GitHub


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

   # FE Regression Coverage Report
   Increment line coverage `  86.75% (131/151)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_ab2996d1ae98f01b3923e982a7e298008b79fd4e_merge_fe/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_ab2996d1ae98f01b3923e982a7e298008b79fd4e_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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-10 Thread via GitHub


zclllyybb commented on code in PR #57941:
URL: https://github.com/apache/doris/pull/57941#discussion_r2606727875


##
fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/functions/executable/DateTimeExtractAndTransform.java:
##
@@ -1334,4 +1338,81 @@ private static long convertMonthToPeriod(long month) {
 }
 return year * 100 + month % 12 + 1;
 }
+
+/**
+ * date extract function hour_from_unixtime
+ */
+@ExecFunction(name = "hour_from_unixtime")
+public static Expression hourFromUnixtime(BigIntLiteral unixTime) {
+long epochSecond = unixTime.getValue();
+if (epochSecond < 0 || epochSecond > TIMESTAMP_VALID_MAX) {
+return new NullLiteral(IntegerType.INSTANCE);

Review Comment:
   from_unixtime 遇到越界应该是报错行为才对?



##
fe/fe-core/src/test/java/org/apache/doris/nereids/rules/expression/SimplifyTimeFieldFromUnixtimeTest.java:
##
@@ -0,0 +1,74 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements.  See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership.  The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License.  You may obtain a copy of the License at
+//
+//   http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied.  See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+package org.apache.doris.nereids.rules.expression;
+
+import 
org.apache.doris.nereids.rules.expression.rules.SimplifyTimeFieldFromUnixtime;
+import org.apache.doris.nereids.trees.expressions.Expression;
+
+import com.google.common.collect.ImmutableList;
+import com.google.common.collect.Maps;
+import org.junit.jupiter.api.Assertions;
+import org.junit.jupiter.api.Test;
+
+import java.util.Map;
+
+/**
+ * Tests for {@link SimplifyTimeFieldFromUnixtime}.
+ */
+public class SimplifyTimeFieldFromUnixtimeTest extends 
ExpressionRewriteTestHelper {
+public SimplifyTimeFieldFromUnixtimeTest() {
+executor = new ExpressionRuleExecutor(ImmutableList.of(
+bottomUp(SimplifyTimeFieldFromUnixtime.INSTANCE)));
+}
+
+@Test
+public void testRewriteSimple() {
+assertRewriteAfterTypeCoercion("hour(from_unixtime(IA))", 
"cast(hour_from_unixtime(IA) as TINYINT)");
+assertRewriteAfterTypeCoercion("minute(from_unixtime(IA))", 
"cast(minute_from_unixtime(IA) as TINYINT)");

Review Comment:
   why the result is wrapped with a `cast`?



##
fe/fe-core/src/main/java/org/apache/doris/nereids/trees/expressions/functions/scalar/MicrosecondFromUnixtime.java:
##
@@ -0,0 +1,88 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements.  See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership.  The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License.  You may obtain a copy of the License at
+//
+//   http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied.  See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+package org.apache.doris.nereids.trees.expressions.functions.scalar;
+
+import org.apache.doris.catalog.FunctionSignature;
+import org.apache.doris.nereids.trees.expressions.Expression;
+import org.apache.doris.nereids.trees.expressions.functions.AlwaysNullable;
+import 
org.apache.doris.nereids.trees.expressions.functions.ExplicitlyCastableSignature;
+import org.apache.doris.nereids.trees.expressions.shape.UnaryExpression;
+import org.apache.doris.nereids.trees.expressions.visitor.ExpressionVisitor;
+import org.apache.doris.nereids.types.DecimalV3Type;
+import org.apache.doris.nereids.types.IntegerType;
+
+import com.google.common.base.Preconditions;
+import com.google.common.collect.ImmutableList;
+
+import java.util.List;
+
+/**
+ * Scalar Function 'microsecond_from_unixtime'
+ * Optimized version of `MICROSECOND(FROM_UNIXTIME(ts))`
+ */
+public class MicrosecondFromUnixtime extends ScalarFunction
+implements UnaryExpression, ExplicitlyCastableSignature, 
AlwaysNullable {
+public static final List SIGNATURES = ImmutableList.of(
+
FunctionSignature.ret(IntegerType.INSTANCE).args(DecimalV3Type.createDecimalV3Type(

Re: [PR] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-10 Thread via GitHub


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

   # BE Regression && UT Coverage Report
   Increment line coverage `97.53% (79/81)` :tada:
   
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_ab2996d1ae98f01b3923e982a7e298008b79fd4e_merge/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_ab2996d1ae98f01b3923e982a7e298008b79fd4e_merge/report/index.html)
   | Category  | Coverage   |
   |---||
   | Function Coverage | 73.13% (25148/34389) |
   | Line Coverage | 60.26% (266750/442677) |
   | Region Coverage   | 55.94% (225207/402621) |
   | Branch Coverage   | 57.16% (95681/167383) |


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-10 Thread via GitHub


linrrzqqq commented on PR #57941:
URL: https://github.com/apache/doris/pull/57941#issuecomment-3636781365

   run external


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-10 Thread via GitHub


linrrzqqq commented on PR #57941:
URL: https://github.com/apache/doris/pull/57941#issuecomment-3636777137

   run nonConcurrent


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-10 Thread via GitHub


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

   # BE Regression && UT Coverage Report
   Increment line coverage `97.53% (79/81)` :tada:
   
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_ab2996d1ae98f01b3923e982a7e298008b79fd4e_merge/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_ab2996d1ae98f01b3923e982a7e298008b79fd4e_merge/report/index.html)
   | Category  | Coverage   |
   |---||
   | Function Coverage | 72.24% (24841/34389) |
   | Line Coverage | 58.96% (261005/442677) |
   | Region Coverage   | 54.02% (217489/402621) |
   | Branch Coverage   | 55.48% (92862/167383) |


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-10 Thread via GitHub


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

   # FE UT Coverage Report
   Increment line coverage `  60.93% (92/151)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_ab2996d1ae98f01b3923e982a7e298008b79fd4e/fe_increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_ab2996d1ae98f01b3923e982a7e298008b79fd4e/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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-10 Thread via GitHub


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

   # BE UT Coverage Report
   Increment line coverage `7.41% (6/81)` :tada:
   
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/ab2996d1ae98f01b3923e982a7e298008b79fd4e_ab2996d1ae98f01b3923e982a7e298008b79fd4e/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/ab2996d1ae98f01b3923e982a7e298008b79fd4e_ab2996d1ae98f01b3923e982a7e298008b79fd4e/report/index.html)
   | Category  | Coverage   |
   |---||
   | Function Coverage | 53.35% (18719/35087) |
   | Line Coverage | 39.05% (173059/443153) |
   | Region Coverage   | 33.72% (134184/397898) |
   | Branch Coverage   | 34.65% (57695/166508) |


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-10 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 27.17 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit ab2996d1ae98f01b3923e982a7e298008b79fd4e, 
data reload: false
   
   query1   0.050.050.04
   query2   0.100.040.04
   query3   0.260.090.09
   query4   1.610.110.11
   query5   0.280.260.24
   query6   1.190.640.64
   query7   0.030.030.02
   query8   0.050.040.04
   query9   0.560.510.51
   query10  0.570.570.56
   query11  0.160.110.11
   query12  0.140.100.11
   query13  0.640.600.61
   query14  0.980.980.99
   query15  0.810.820.79
   query16  0.420.410.39
   query17  1.051.041.10
   query18  0.230.210.21
   query19  1.861.861.80
   query20  0.010.010.01
   query21  15.45   0.290.14
   query22  5.010.050.05
   query23  16.13   0.300.11
   query24  0.950.700.22
   query25  0.100.090.05
   query26  0.150.140.13
   query27  0.070.060.04
   query28  4.331.231.02
   query29  12.54   4.043.24
   query30  0.270.140.12
   query31  2.810.670.38
   query32  3.230.550.45
   query33  3.083.053.01
   query34  16.89   5.204.51
   query35  4.554.544.60
   query36  0.660.490.50
   query37  0.110.070.07
   query38  0.070.050.04
   query39  0.050.030.04
   query40  0.170.140.12
   query41  0.090.030.03
   query42  0.040.040.03
   query43  0.050.030.03
   Total cold run time: 97.8 s
   Total hot run time: 27.17 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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-10 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 181913 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 ab2996d1ae98f01b3923e982a7e298008b79fd4e, 
data reload: false
   
   query5   4929645 466 466
   query6   328 232 211 211
   query7   4228469 277 277
   query8   302 258 254 254
   query9   8785259325962593
   query10  543 380 344 344
   query11  15294   15486   14885   14885
   query12  192 115 115 115
   query13  1270536 391 391
   query14  6420328030073007
   query14_12881293729592937
   query15  208 193 179 179
   query16  833 452 430 430
   query17  1085690 578 578
   query18  2686436 343 343
   query19  225 224 212 212
   query20  121 116 110 110
   query21  218 137 113 113
   query22  3889387038153815
   query23  16500   16074   15945   15945
   query23_115969   15984   16470   15984
   query24  7368167612781278
   query24_11229123512421235
   query25  543 465 421 421
   query26  1246267 159 159
   query27  2761477 306 306
   query28  4458220921612161
   query29  790 531 453 453
   query30  312 239 218 218
   query31  854 684 630 630
   query32  80  69  70  69
   query33  555 328 274 274
   query34  892 921 542 542
   query35  766 801 740 740
   query36  859 888 801 801
   query37  128 95  77  77
   query38  3894383038193819
   query39  753 716 710 710
   query39_1701 687 692 687
   query40  223 141 125 125
   query41  70  64  62  62
   query42  113 114 108 108
   query43  425 419 409 409
   query44  1363780 747 747
   query45  189 190 187 187
   query46  940 988 635 635
   query47  1636168716241624
   query48  341 344 241 241
   query49  673 457 341 341
   query50  669 301 237 237
   query51  3808380437783778
   query52  107 109 96  96
   query53  325 354 303 303
   query54  285 261 249 249
   query55  78  74  71  71
   query56  290 301 314 301
   query57  1157111710821082
   query58  274 260 260 260
   query59  2352244224192419
   query60  316 311 289 289
   query61  163 158 162 158
   query62  728 682 637 637
   query63  335 297 308 297
   query64  4851132510811081
   query65  4025398239883982
   query66  1414450 351 351
   query67  14934   14795   14986   14795
   query68  27481080789 789
   query69  448 362 326 326
   query70  1077995 1003995
   query71  326 322 291 291
   query72  6377510251865102
   query73  502 587 307 307
   query74  8786881186178617
   query75  3486351931663166
   query76  29081138747 747
   query77  347 391 299 299
   query78  9519967889518951
   query79  1307830 613 613
   query80  1170652 565 565
   query81  569 272 241 241
   query82  554 129 102 102
   query83  360 253 239 239
   query84  252 123 95  95
   query85  950 506 462 462
   query86  382 292 287 287
   query87  4002408439863986
   query88  3252227222572257
   query89  462 420 402 402
   query90  2044162 151 151
   query91  187 170 148 148
   query92  74  68  69  68
   query93  1122915 596 596
   query94  525 293 293 293
   query95  572 383 315 315
   query96  585 463 211 211
   query97  2608267626132613
   query98  210 194 210 194
   query99  1338133011771177
   Total cold run time: 256459 ms
   Total hot run time: 181913 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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-10 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 35262 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit ab2996d1ae98f01b3923e982a7e298008b79fd4e, 
data reload: false
   
   -- Round 1 --
   q1   17594   418440784078
   q2   2018357 239 239
   q3   10194   1300755 755
   q4   10217   842 325 325
   q5   7529211119511951
   q6   187 174 137 137
   q7   996 873 737 737
   q8   9368147811711171
   q9   7035534253905342
   q10  6845237719721972
   q11  521 325 299 299
   q12  664 768 589 589
   q13  17778   376530403040
   q14  288 311 295 295
   q15  600 525 520 520
   q16  971 921 870 870
   q17  741 797 607 607
   q18  7927720769546954
   q19  1222969 631 631
   q20  416 375 249 249
   q21  4206405035413541
   q22  1022992 960 960
   Total cold run time: 108339 ms
   Total hot run time: 35262 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4115404740124012
   q2   329 406 307 307
   q3   2134264222852285
   q4   1316178012621262
   q5   4201474046814681
   q6   244 186 141 141
   q7   2083200318501850
   q8   2660249524962495
   q9   7607759075217521
   q10  3019326128342834
   q11  631 512 477 477
   q12  661 942 675 675
   q13  3691382333853385
   q14  310 320 286 286
   q15  565 527 520 520
   q16  937 937 872 872
   q17  1157143114761431
   q18  7835754978437549
   q19  875 870 887 870
   q20  1939208719421942
   q21  4669425741624162
   q22  11021049964 964
   Total cold run time: 52080 ms
   Total hot run time: 50521 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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-09 Thread via GitHub


linrrzqqq commented on PR #57941:
URL: https://github.com/apache/doris/pull/57941#issuecomment-3635821703

   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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-02 Thread via GitHub


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

   # FE UT Coverage Report
   Increment line coverage `  60.93% (92/151)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_8b6cc38eaa64aa2e9bcaad20735fda7cf8e0ba69/fe_increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_8b6cc38eaa64aa2e9bcaad20735fda7cf8e0ba69/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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-02 Thread via GitHub


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

   # BE Regression && UT Coverage Report
   Increment line coverage `97.53% (79/81)` :tada:
   
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_8b6cc38eaa64aa2e9bcaad20735fda7cf8e0ba69_merge/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_8b6cc38eaa64aa2e9bcaad20735fda7cf8e0ba69_merge/report/index.html)
   | Category  | Coverage   |
   |---||
   | Function Coverage | 72.24% (24803/34335) |
   | Line Coverage | 58.86% (259794/441378) |
   | Region Coverage   | 53.71% (215666/401524) |
   | Branch Coverage   | 55.25% (92268/166991) |


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-02 Thread via GitHub


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

   # BE UT Coverage Report
   Increment line coverage `7.41% (6/81)` :tada:
   
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/8b6cc38eaa64aa2e9bcaad20735fda7cf8e0ba69_8b6cc38eaa64aa2e9bcaad20735fda7cf8e0ba69/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/8b6cc38eaa64aa2e9bcaad20735fda7cf8e0ba69_8b6cc38eaa64aa2e9bcaad20735fda7cf8e0ba69/report/index.html)
   | Category  | Coverage   |
   |---||
   | Function Coverage | 53.50% (18736/35019) |
   | Line Coverage | 39.10% (172713/441773) |
   | Region Coverage   | 33.71% (133718/396714) |
   | Branch Coverage   | 34.66% (57560/166094) |


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-02 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 27.52 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 8b6cc38eaa64aa2e9bcaad20735fda7cf8e0ba69, 
data reload: false
   
   query1   0.060.050.04
   query2   0.100.050.05
   query3   0.260.090.09
   query4   1.610.110.12
   query5   0.270.260.27
   query6   1.140.650.64
   query7   0.040.030.02
   query8   0.050.040.05
   query9   0.570.510.50
   query10  0.550.570.55
   query11  0.160.100.11
   query12  0.160.110.11
   query13  0.640.600.60
   query14  1.000.980.98
   query15  0.820.800.82
   query16  0.390.450.40
   query17  1.071.071.00
   query18  0.230.220.21
   query19  1.841.851.78
   query20  0.020.010.01
   query21  15.44   0.270.15
   query22  4.670.060.05
   query23  16.02   0.290.10
   query24  1.060.571.24
   query25  0.110.050.06
   query26  0.140.130.13
   query27  0.060.050.04
   query28  4.481.201.03
   query29  12.62   4.073.19
   query30  0.280.140.13
   query31  2.840.640.39
   query32  3.230.550.47
   query33  3.063.023.11
   query34  16.71   5.224.52
   query35  4.524.564.61
   query36  0.660.500.49
   query37  0.100.060.06
   query38  0.060.040.04
   query39  0.040.030.03
   query40  0.180.130.14
   query41  0.080.030.04
   query42  0.040.020.02
   query43  0.040.030.04
   Total cold run time: 97.42 s
   Total hot run time: 27.52 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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-02 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 181259 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 8b6cc38eaa64aa2e9bcaad20735fda7cf8e0ba69, 
data reload: false
   
   query1   1034426 390 390
   query2   6622116511681165
   query3   6737233 229 229
   query4   25186   23345   22899   22899
   query5   5164667 484 484
   query6   347 243 225 225
   query7   4670523 304 304
   query8   307 246 253 246
   query9   8731262726172617
   query10  565 355 318 318
   query11  15142   15283   14822   14822
   query12  190 121 114 114
   query13  1683577 449 449
   query14  9917599559935993
   query15  213 198 186 186
   query16  7686674 527 527
   query17  1228793 635 635
   query18  2061436 344 344
   query19  223 209 185 185
   query20  129 123 119 119
   query21  219 138 120 120
   query22  3959405439133913
   query23  32727   31736   31921   31736
   query24  8445239923872387
   query25  629 565 492 492
   query26  1253285 173 173
   query27  2700491 353 353
   query28  4316217121502150
   query29  817 623 534 534
   query30  319 242 214 214
   query31  815 705 619 619
   query32  91  77  75  75
   query33  613 395 341 341
   query34  833 872 548 548
   query35  848 831 747 747
   query36  890 909 820 820
   query37  124 111 85  85
   query38  3785383837363736
   query39  1466139514091395
   query40  226 130 120 120
   query41  65  61  61  61
   query42  125 118 114 114
   query43  438 442 408 408
   query44  1291754 743 743
   query45  214 189 189 189
   query46  902 993 653 653
   query47  1707175716881688
   query48  398 419 316 316
   query49  799 518 413 413
   query50  671 714 403 403
   query51  3880389138393839
   query52  114 112 105 105
   query53  245 270 191 191
   query54  312 289 283 283
   query55  93  94  92  92
   query56  331 332 350 332
   query57  1125117310861086
   query58  289 272 270 270
   query59  2260247022952295
   query60  359 352 327 327
   query61  161 159 158 158
   query62  809 696 654 654
   query63  227 188 206 188
   query64  44831222905 905
   query65  4084397739933977
   query66  1094437 335 335
   query67  15205   15059   14783   14783
   query68  8276997 616 616
   query69  518 359 303 303
   query70  1088999 1020999
   query71  489 339 325 325
   query72  6062488650784886
   query73  749 596 341 341
   query74  8798868885738573
   query75  3610302825322532
   query76  37851141718 718
   query77  812 409 318 318
   query78  9431974088828882
   query79  2054857 577 577
   query80  665 588 499 499
   query81  499 272 241 241
   query82  489 141 112 112
   query83  274 265 252 252
   query84  263 123 98  98
   query85  938 492 441 441
   query86  344 314 281 281
   query87  4012408939183918
   query88  3925227022642264
   query89  386 330 308 308
   query90  2008222 215 215
   query91  172 169 140 140
   query92  85  70  64  64
   query93  16381009653 653
   query94  693 457 358 358
   query95  494 415 402 402
   query96  542 555 280 280
   query97  2626267125412541
   query98  252 217 215 215
   query99  1304140212901290
   Total cold run time: 271872 ms
   Total hot run time: 181259 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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-02 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 34196 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 8b6cc38eaa64aa2e9bcaad20735fda7cf8e0ba69, 
data reload: false
   
   -- Round 1 --
   q1   17630   512949124912
   q2   2049317 203 203
   q3   10276   1297717 717
   q4   10206   814 311 311
   q5   7539237021652165
   q6   189 178 139 139
   q7   970 776 637 637
   q8   9358140610941094
   q9   6911537354405373
   q10  6896218917721772
   q11  517 304 294 294
   q12  339 373 221 221
   q13  17797   369630293029
   q14  232 233 211 211
   q15  595 518 517 517
   q16  901 874 814 814
   q17  673 858 459 459
   q18  7572704670907046
   q19  1073984 590 590
   q20  365 351 224 224
   q21  3935321725322532
   q22  1035991 936 936
   Total cold run time: 107058 ms
   Total hot run time: 34196 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   4963490949514909
   q2   337 401 312 312
   q3   2144267222632263
   q4   1294172413051305
   q5   4199445745044457
   q6   219 187 132 132
   q7   2023195818641864
   q8   2732259325302530
   q9   7515745674437443
   q10  3080327928932893
   q11  601 537 506 506
   q12  680 766 631 631
   q13  3472393133243324
   q14  291 305 284 284
   q15  566 505 524 505
   q16  891 923 869 869
   q17  1196147314821473
   q18  7866756574627462
   q19  828 800 809 800
   q20  1868197217981798
   q21  4583423041524152
   q22  11021040964 964
   Total cold run time: 52450 ms
   Total hot run time: 50876 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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-02 Thread via GitHub


linrrzqqq commented on PR #57941:
URL: https://github.com/apache/doris/pull/57941#issuecomment-3601352271

   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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-01 Thread via GitHub


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

   # BE Regression && UT Coverage Report
   Increment line coverage `74.49% (73/98)` :tada:
   
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_bda4ca0cbd3283e991fa2fc3e2cc48f6d7a1b1ec_merge/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_bda4ca0cbd3283e991fa2fc3e2cc48f6d7a1b1ec_merge/report/index.html)
   | Category  | Coverage   |
   |---||
   | Function Coverage | 71.78% (24645/34335) |
   | Line Coverage | 58.30% (257241/441239) |
   | Region Coverage   | 53.38% (214308/401447) |
   | Branch Coverage   | 54.92% (91680/166930) |


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-01 Thread via GitHub


linrrzqqq commented on PR #57941:
URL: https://github.com/apache/doris/pull/57941#issuecomment-3596278141

   run external


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-01 Thread via GitHub


linrrzqqq commented on PR #57941:
URL: https://github.com/apache/doris/pull/57941#issuecomment-3595835651

   run external


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-01 Thread via GitHub


linrrzqqq commented on PR #57941:
URL: https://github.com/apache/doris/pull/57941#issuecomment-3595836368

   run nonConcurrent


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-01 Thread via GitHub


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

   # BE UT Coverage Report
   Increment line coverage `6.12% (6/98)` :tada:
   
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/bda4ca0cbd3283e991fa2fc3e2cc48f6d7a1b1ec_bda4ca0cbd3283e991fa2fc3e2cc48f6d7a1b1ec/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/bda4ca0cbd3283e991fa2fc3e2cc48f6d7a1b1ec_bda4ca0cbd3283e991fa2fc3e2cc48f6d7a1b1ec/report/index.html)
   | Category  | Coverage   |
   |---||
   | Function Coverage | 52.81% (18494/35018) |
   | Line Coverage | 38.35% (169372/441633) |
   | Region Coverage   | 33.17% (131550/396636) |
   | Branch Coverage   | 34.10% (56619/166033) |


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-01 Thread via GitHub


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

   # FE UT Coverage Report
   Increment line coverage `  58.60% (92/157)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_bda4ca0cbd3283e991fa2fc3e2cc48f6d7a1b1ec/fe_increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_bda4ca0cbd3283e991fa2fc3e2cc48f6d7a1b1ec/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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-01 Thread via GitHub


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

   
   
   ClickBench: Total hot run time: 27.34 s
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit bda4ca0cbd3283e991fa2fc3e2cc48f6d7a1b1ec, 
data reload: false
   
   query1   0.050.050.05
   query2   0.100.050.04
   query3   0.250.080.08
   query4   1.610.120.11
   query5   0.270.260.25
   query6   1.140.640.62
   query7   0.020.020.02
   query8   0.060.040.05
   query9   0.560.510.50
   query10  0.570.560.57
   query11  0.160.110.11
   query12  0.140.120.11
   query13  0.640.610.62
   query14  0.990.980.98
   query15  0.820.800.80
   query16  0.420.410.40
   query17  1.081.061.05
   query18  0.230.210.22
   query19  1.941.851.85
   query20  0.010.010.01
   query21  15.46   0.240.14
   query22  4.840.050.04
   query23  15.96   0.260.11
   query24  1.440.220.27
   query25  0.070.060.06
   query26  0.140.140.13
   query27  0.080.050.05
   query28  3.331.221.04
   query29  12.61   3.883.19
   query30  0.270.140.12
   query31  2.820.610.39
   query32  3.240.550.46
   query33  3.073.063.03
   query34  16.88   5.184.62
   query35  4.604.544.50
   query36  0.690.500.49
   query37  0.100.070.07
   query38  0.070.050.04
   query39  0.040.030.03
   query40  0.170.150.13
   query41  0.080.030.03
   query42  0.040.020.02
   query43  0.040.040.03
   Total cold run time: 97.1 s
   Total hot run time: 27.34 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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-01 Thread via GitHub


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

   
   
   TPC-DS: Total hot run time: 183185 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 bda4ca0cbd3283e991fa2fc3e2cc48f6d7a1b1ec, 
data reload: false
   
   query1   1068417 392 392
   query2   6583119111551155
   query3   6743237 241 237
   query4   25355   23257   23226   23226
   query5   5101662 516 516
   query6   357 262 238 238
   query7   4674519 315 315
   query8   331 268 256 256
   query9   8746267426762674
   query10  560 371 319 319
   query11  15489   15194   14896   14896
   query12  189 121 115 115
   query13  1691568 466 466
   query14  9933607060066006
   query15  214 203 190 190
   query16  7695701 551 551
   query17  1239777 639 639
   query18  2056438 353 353
   query19  225 221 203 203
   query20  135 126 126 126
   query21  220 141 120 120
   query22  3993398838683868
   query23  32831   32097   32162   32097
   query24  8446245123942394
   query25  659 579 486 486
   query26  1254284 195 195
   query27  2687496 359 359
   query28  4355217621672167
   query29  841 654 527 527
   query30  308 245 217 217
   query31  819 728 630 630
   query32  88  81  80  80
   query33  627 426 349 349
   query34  812 873 573 573
   query35  801 874 761 761
   query36  884 933 854 854
   query37  124 117 90  90
   query38  3912385737823782
   query39  1477141114041404
   query40  227 131 118 118
   query41  67  63  63  63
   query42  128 122 115 115
   query43  430 448 411 411
   query44  1280764 769 764
   query45  202 193 194 193
   query46  874 990 647 647
   query47  1665174716371637
   query48  387 417 330 330
   query49  777 510 420 420
   query50  657 680 420 420
   query51  3854394638643864
   query52  115 114 113 113
   query53  238 260 204 204
   query54  337 301 293 293
   query55  99  101 94  94
   query56  352 350 329 329
   query57  1125115511131113
   query58  322 283 288 283
   query59  2308243622762276
   query60  360 352 352 352
   query61  174 160 162 160
   query62  769 746 661 661
   query63  232 198 203 198
   query64  45191242921 921
   query65  4063397939873979
   query66  1095442 344 344
   query67  15405   14872   14935   14872
   query68  8349953 629 629
   query69  515 353 318 318
   query70  11181089997 997
   query71  487 343 320 320
   query72  5793494048714871
   query73  718 566 347 347
   query74  8868885787938793
   query75  3557300025332533
   query76  37781123755 755
   query77  810 400 326 326
   query78  9499965889048904
   query79  2231819 602 602
   query80  662 599 531 531
   query81  501 291 240 240
   query82  367 139 119 119
   query83  280 269 253 253
   query84  266 114 98  98
   query85  946 519 454 454
   query86  390 297 281 281
   query87  4058408539683968
   query88  4176230523002300
   query89  405 336 294 294
   query90  1973246 228 228
   query91  182 167 147 147
   query92  83  72  68  68
   query93  1802985 662 662
   query94  676 453 336 336
   query95  515 423 412 412
   query96  502 552 286 286
   query97  2627271226002600
   query98  246 213 218 213
   query99  1300136713001300
   Total cold run time: 273263 ms
   Total hot run time: 183185 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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-12-01 Thread via GitHub


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

   
   
   TPC-H: Total hot run time: 34801 ms
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit bda4ca0cbd3283e991fa2fc3e2cc48f6d7a1b1ec, 
data reload: false
   
   -- Round 1 --
   q1   17633   510850115011
   q2   2027319 209 209
   q3   10267   1316753 753
   q4   10201   803 306 306
   q5   7466241321082108
   q6   183 166 136 136
   q7   930 771 641 641
   q8   9343136210421042
   q9   7125531553535315
   q10  6873218017771777
   q11  517 307 287 287
   q12  395 377 228 228
   q13  17770   365330543054
   q14  238 242 221 221
   q15  592 514 517 514
   q16  898 861 810 810
   q17  590 778 503 503
   q18  7446736776177367
   q19  11221032646 646
   q20  354 353 247 247
   q21  4186403126042604
   q22  1125113510221022
   Total cold run time: 107281 ms
   Total hot run time: 34801 ms
   
   - Round 2, with runtime_filter_mode=off -
   q1   5207522851675167
   q2   329 415 358 358
   q3   2345293225162516
   q4   1417209013751375
   q5   4471451044524452
   q6   206 171 125 125
   q7   1990192717741774
   q8   2621254424642464
   q9   7553744472847284
   q10  2976307926642664
   q11  565 496 485 485
   q12  612 721 538 538
   q13  3248361830843084
   q14  261 299 268 268
   q15  537 511 498 498
   q16  856 886 838 838
   q17  1094137813731373
   q18  7263718370817081
   q19  736 712 756 712
   q20  1897196618161816
   q21  4690425242584252
   q22  1117105210091009
   Total cold run time: 51991 ms
   Total hot run time: 50133 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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-11-30 Thread via GitHub


linrrzqqq commented on PR #57941:
URL: https://github.com/apache/doris/pull/57941#issuecomment-3595096250

   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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-11-30 Thread via GitHub


linrrzqqq commented on PR #57941:
URL: https://github.com/apache/doris/pull/57941#issuecomment-3594514947

   run beut


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-11-27 Thread via GitHub


linrrzqqq commented on PR #57941:
URL: https://github.com/apache/doris/pull/57941#issuecomment-3588178605

   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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-11-24 Thread via GitHub


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

   # FE Regression Coverage Report
   Increment line coverage `  82.17% (129/157)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_197e83244237be4d5b0f8e2a36d94bf3e8b692ca_merge_fe/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_197e83244237be4d5b0f8e2a36d94bf3e8b692ca_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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-11-24 Thread via GitHub


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

   # FE UT Coverage Report
   Increment line coverage `  58.60% (92/157)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_197e83244237be4d5b0f8e2a36d94bf3e8b692ca/fe_increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_197e83244237be4d5b0f8e2a36d94bf3e8b692ca/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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-11-24 Thread via GitHub


linrrzqqq commented on PR #57941:
URL: https://github.com/apache/doris/pull/57941#issuecomment-3570786781

   run p0


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-11-24 Thread via GitHub


linrrzqqq commented on PR #57941:
URL: https://github.com/apache/doris/pull/57941#issuecomment-3570787452

   run performance


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-11-24 Thread via GitHub


linrrzqqq commented on PR #57941:
URL: https://github.com/apache/doris/pull/57941#issuecomment-3570631299

   run feut


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-11-24 Thread via GitHub


linrrzqqq commented on PR #57941:
URL: https://github.com/apache/doris/pull/57941#issuecomment-3570630062

   run p0


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-11-24 Thread via GitHub


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

   # FE Regression Coverage Report
   Increment line coverage `  82.17% (129/157)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_197e83244237be4d5b0f8e2a36d94bf3e8b692ca_merge_fe/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_197e83244237be4d5b0f8e2a36d94bf3e8b692ca_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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-11-24 Thread via GitHub


linrrzqqq commented on PR #57941:
URL: https://github.com/apache/doris/pull/57941#issuecomment-3569672287

   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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-11-17 Thread via GitHub


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

   # FE Regression Coverage Report
   Increment line coverage `  30.57% (48/157)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_547b9eea6ac9cd8e1c17631ef7ac7ef0c877dab0_merge_fe/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_547b9eea6ac9cd8e1c17631ef7ac7ef0c877dab0_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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-11-17 Thread via GitHub


linrrzqqq commented on PR #57941:
URL: https://github.com/apache/doris/pull/57941#issuecomment-3544685954

   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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-11-16 Thread via GitHub


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

   # FE UT Coverage Report
   Increment line coverage `  58.60% (92/157)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_c8d971748b2dcbe3e24b393cddca9da7a44dcb84/fe_increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_c8d971748b2dcbe3e24b393cddca9da7a44dcb84/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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-11-16 Thread via GitHub


linrrzqqq commented on PR #57941:
URL: https://github.com/apache/doris/pull/57941#issuecomment-3539819817

   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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-11-16 Thread via GitHub


linrrzqqq commented on PR #57941:
URL: https://github.com/apache/doris/pull/57941#issuecomment-3538334027

   run beut


-- 
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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-11-15 Thread via GitHub


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

   # FE Regression Coverage Report
   Increment line coverage `  30.57% (48/157)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_c8d971748b2dcbe3e24b393cddca9da7a44dcb84_merge_fe/increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_c8d971748b2dcbe3e24b393cddca9da7a44dcb84_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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-11-15 Thread via GitHub


linrrzqqq commented on PR #57941:
URL: https://github.com/apache/doris/pull/57941#issuecomment-3536598869

   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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-11-14 Thread via GitHub


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

   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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-11-14 Thread via GitHub


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

   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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-11-13 Thread via GitHub


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

   # FE UT Coverage Report
   Increment line coverage `  58.60% (92/157)` :tada:
   [Increment coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_c8d971748b2dcbe3e24b393cddca9da7a44dcb84/fe_increment_report/index.html)
   [Complete coverage 
report](http://coverage.selectdb-in.cc/coverage/57941_c8d971748b2dcbe3e24b393cddca9da7a44dcb84/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] [Opt](function) opt of certain time field functions used in conjunction with FROM_UNIXTIME. [doris]

2025-11-13 Thread via GitHub


morningman commented on PR #57941:
URL: https://github.com/apache/doris/pull/57941#issuecomment-3527409492

   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]