You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "robll-v1 (via GitHub)" <gi...@apache.org> on 2025/11/11 05:44:16 UTC

[PR] (enhanced) completed the function : century from duckdb [doris]

robll-v1 opened a new pull request, #57893:
URL: https://github.com/apache/doris/pull/57893

   ### What problem does this PR solve?
   
   Issue Number: close #xxx
   
   Related PR: #xxx
   
   Problem Summary:
   mysql> SELECT CENTURY('2024-01-15');
   +-----------------------+
   | CENTURY('2024-01-15') |
   +-----------------------+
   |                    21 |
   +-----------------------+
   1 row in set (0.03 sec)
   
   mysql> SELECT CENTURY(NOW());  
   +----------------+
   | CENTURY(NOW()) |
   +----------------+
   |             21 |
   +----------------+
   1 row in set (0.01 sec)
   ### Release note
   
   None
   
   ### Check List (For Author)
   
   - Test <!-- At least one of them must be included. -->
       - [ ] Regression test
       - [ ] Unit Test
       - [ ] Manual test (add detailed scripts or steps below)
       - [ ] No need to test or manual test. Explain why:
           - [ ] This is a refactor/code format and no logic has been changed.
           - [ ] Previous test can cover this change.
           - [ ] No code files have been changed.
           - [ ] Other reason <!-- Add your reason?  -->
   
   - Behavior changed:
       - [ ] No.
       - [ ] Yes. <!-- Explain the behavior change -->
   
   - Does this need documentation?
       - [ ] No.
       - [ ] Yes. <!-- Add document PR link here. eg: https://github.com/apache/doris-website/pull/1214 -->
   
   ### Check List (For Reviewer who merge this PR)
   
   - [ ] Confirm the release note
   - [ ] Confirm test cases
   - [ ] Confirm document
   - [ ] Add branch pick label <!-- Add branch pick label that this PR should merge into -->
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3569353726

   PR approved by anyone and no changes requested.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3572360459

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 184809 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit 400017aef5f4fc75d75e289c44184ed9887e3786, data reload: false
   
   query1	1039	419	416	416
   query2	6607	1566	1592	1566
   query3	6764	222	227	222
   query4	25667	22539	22723	22539
   query5	4382	632	470	470
   query6	339	240	223	223
   query7	4650	498	303	303
   query8	301	250	235	235
   query9	8689	2590	2610	2590
   query10	496	382	318	318
   query11	15363	14818	14623	14623
   query12	187	117	113	113
   query13	1703	594	467	467
   query14	10271	8997	9059	8997
   query15	209	206	181	181
   query16	7587	711	558	558
   query17	1289	784	647	647
   query18	2059	458	351	351
   query19	220	211	183	183
   query20	137	134	118	118
   query21	218	138	119	119
   query22	4012	4053	3822	3822
   query23	33039	31986	31946	31946
   query24	8529	2429	2418	2418
   query25	598	535	451	451
   query26	1238	272	163	163
   query27	2772	532	358	358
   query28	4397	2185	2163	2163
   query29	817	631	492	492
   query30	306	244	210	210
   query31	825	699	634	634
   query32	83	75	68	68
   query33	612	412	333	333
   query34	803	870	524	524
   query35	814	827	740	740
   query36	901	957	854	854
   query37	131	117	88	88
   query38	3431	3409	3250	3250
   query39	1467	1414	1407	1407
   query40	224	129	118	118
   query41	82	61	64	61
   query42	124	109	116	109
   query43	459	470	445	445
   query44	1270	775	770	770
   query45	192	192	190	190
   query46	902	1021	669	669
   query47	1689	1711	1667	1667
   query48	399	441	326	326
   query49	775	514	413	413
   query50	659	683	404	404
   query51	3875	3868	4005	3868
   query52	110	110	107	107
   query53	251	275	194	194
   query54	312	300	282	282
   query55	94	88	85	85
   query56	329	319	314	314
   query57	1138	1168	1106	1106
   query58	289	274	267	267
   query59	2366	2554	2408	2408
   query60	352	354	334	334
   query61	169	171	165	165
   query62	781	724	666	666
   query63	229	197	201	197
   query64	4503	1245	920	920
   query65	4070	3976	4002	3976
   query66	1165	434	330	330
   query67	15172	15116	14902	14902
   query68	5482	942	655	655
   query69	537	358	304	304
   query70	1281	1212	1139	1139
   query71	409	339	308	308
   query72	6096	5008	5063	5008
   query73	697	636	374	374
   query74	8810	8781	8567	8567
   query75	3283	3366	2847	2847
   query76	3355	1141	727	727
   query77	510	401	310	310
   query78	9457	9775	8937	8937
   query79	1068	822	604	604
   query80	1176	589	497	497
   query81	533	266	237	237
   query82	432	171	136	136
   query83	281	266	267	266
   query84	251	120	94	94
   query85	895	526	559	526
   query86	338	312	293	293
   query87	3494	3567	3399	3399
   query88	2836	2254	2239	2239
   query89	386	334	287	287
   query90	1759	225	219	219
   query91	193	195	173	173
   query92	75	70	71	70
   query93	1125	999	680	680
   query94	744	459	366	366
   query95	523	427	414	414
   query96	493	542	286	286
   query97	2908	2969	2893	2893
   query98	244	215	208	208
   query99	1296	1389	1293	1293
   Total cold run time: 265899 ms
   Total hot run time: 184809 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3575087879

   PR approved by at least one committer and no changes requested.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565809082

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 27.22 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 62513b022ed749f63ca2f086fcb60b2088ca7cd7, data reload: false
   
   query1	0.05	0.05	0.05
   query2	0.09	0.05	0.06
   query3	0.26	0.08	0.08
   query4	1.60	0.11	0.11
   query5	0.27	0.26	0.25
   query6	1.17	0.66	0.65
   query7	0.03	0.03	0.02
   query8	0.06	0.04	0.04
   query9	0.58	0.53	0.53
   query10	0.57	0.57	0.56
   query11	0.16	0.11	0.11
   query12	0.14	0.12	0.12
   query13	0.62	0.60	0.61
   query14	1.00	1.00	0.99
   query15	0.85	0.82	0.83
   query16	0.39	0.41	0.38
   query17	1.01	1.03	1.04
   query18	0.21	0.20	0.19
   query19	1.87	1.73	1.76
   query20	0.04	0.01	0.01
   query21	15.43	0.20	0.13
   query22	5.06	0.07	0.05
   query23	15.65	0.26	0.11
   query24	2.90	1.54	0.31
   query25	0.07	0.06	0.06
   query26	0.15	0.12	0.13
   query27	0.06	0.05	0.06
   query28	4.08	1.15	0.95
   query29	12.56	3.85	3.21
   query30	0.27	0.12	0.11
   query31	2.81	0.58	0.39
   query32	3.22	0.54	0.49
   query33	2.95	3.06	3.01
   query34	15.77	5.11	4.54
   query35	4.65	4.56	4.54
   query36	0.68	0.49	0.48
   query37	0.10	0.07	0.06
   query38	0.07	0.04	0.04
   query39	0.03	0.03	0.03
   query40	0.17	0.13	0.13
   query41	0.09	0.03	0.03
   query42	0.04	0.03	0.03
   query43	0.05	0.03	0.04
   Total cold run time: 97.83 s
   Total hot run time: 27.22 s
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565867126

   # FE UT Coverage Report
   Increment line coverage `  5.56% (1/18)` :tada:
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7/fe_increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7/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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3551307666

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3562848470

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 34973 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 6cef593381e024328e084fe233417b7c22b8c6da, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17592	4958	4888	4888
   q2	1997	317	202	202
   q3	10312	1358	717	717
   q4	10265	915	375	375
   q5	8233	2294	2431	2294
   q6	187	167	137	137
   q7	930	797	647	647
   q8	9367	1352	1077	1077
   q9	7293	5531	5765	5531
   q10	6890	2248	1793	1793
   q11	520	294	276	276
   q12	332	364	224	224
   q13	17776	3672	2998	2998
   q14	225	237	218	218
   q15	580	511	505	505
   q16	1008	1028	942	942
   q17	584	860	364	364
   q18	7441	7539	7568	7539
   q19	1357	966	554	554
   q20	367	373	237	237
   q21	3996	3338	2413	2413
   q22	1093	1103	1042	1042
   Total cold run time: 108345 ms
   Total hot run time: 34973 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5191	5161	5152	5152
   q2	327	411	355	355
   q3	2289	2935	2458	2458
   q4	1471	1858	1458	1458
   q5	4470	4664	4343	4343
   q6	197	161	121	121
   q7	1959	1935	1808	1808
   q8	2618	2567	2526	2526
   q9	7623	7473	7184	7184
   q10	2871	3076	2628	2628
   q11	555	511	500	500
   q12	621	713	553	553
   q13	3224	3677	2994	2994
   q14	271	284	253	253
   q15	527	503	484	484
   q16	1016	1053	999	999
   q17	1078	1453	1314	1314
   q18	7267	6983	6910	6910
   q19	751	724	794	724
   q20	1897	1950	1821	1821
   q21	4813	4398	4370	4370
   q22	1073	1023	962	962
   Total cold run time: 52109 ms
   Total hot run time: 49917 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3571857339

   PR approved by at least one committer and no changes requested.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "zclllyybb (via GitHub)" <gi...@apache.org>.
zclllyybb merged PR #57893:
URL: https://github.com/apache/doris/pull/57893


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "linrrzqqq (via GitHub)" <gi...@apache.org>.
linrrzqqq commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3569348377

   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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3572383091

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 27.36 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 400017aef5f4fc75d75e289c44184ed9887e3786, data reload: false
   
   query1	0.05	0.05	0.05
   query2	0.10	0.05	0.05
   query3	0.25	0.09	0.08
   query4	1.61	0.11	0.10
   query5	0.28	0.25	0.25
   query6	1.15	0.65	0.65
   query7	0.02	0.02	0.02
   query8	0.05	0.05	0.04
   query9	0.58	0.54	0.51
   query10	0.58	0.59	0.58
   query11	0.16	0.11	0.11
   query12	0.15	0.13	0.11
   query13	0.61	0.61	0.60
   query14	1.00	1.00	1.00
   query15	0.85	0.83	0.84
   query16	0.41	0.39	0.39
   query17	1.03	1.04	1.02
   query18	0.22	0.21	0.20
   query19	1.84	1.84	1.83
   query20	0.01	0.01	0.01
   query21	15.52	0.20	0.13
   query22	5.08	0.07	0.04
   query23	15.68	0.26	0.11
   query24	2.68	0.88	0.32
   query25	0.08	0.06	0.06
   query26	0.14	0.13	0.12
   query27	0.06	0.05	0.06
   query28	3.77	1.14	0.94
   query29	12.56	3.98	3.23
   query30	0.28	0.13	0.12
   query31	2.81	0.57	0.38
   query32	3.23	0.57	0.47
   query33	2.97	3.15	3.02
   query34	16.01	5.19	4.52
   query35	4.55	4.59	4.57
   query36	0.69	0.50	0.49
   query37	0.10	0.06	0.08
   query38	0.07	0.04	0.04
   query39	0.04	0.03	0.03
   query40	0.17	0.15	0.14
   query41	0.09	0.02	0.03
   query42	0.03	0.03	0.03
   query43	0.04	0.04	0.04
   Total cold run time: 97.6 s
   Total hot run time: 27.36 s
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "zclllyybb (via GitHub)" <gi...@apache.org>.
zclllyybb commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3572035723

   compile failed. still need to fix


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3573312261

   # BE Regression && UT Coverage Report
   Increment line coverage `100.00% (10/10)` :tada:
   
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/57893_400017aef5f4fc75d75e289c44184ed9887e3786_merge/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/57893_400017aef5f4fc75d75e289c44184ed9887e3786_merge/report/index.html)
   | Category          | Coverage           |
   |-------------------|--------------------|
   | Function Coverage | 71.55% (24404/34106) |
   | Line Coverage     | 58.02% (253661/437196) |
   | Region Coverage   | 53.40% (211996/396965) |
   | Branch Coverage   | 54.68% (90292/165135) |


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565796346

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 187024 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit 62513b022ed749f63ca2f086fcb60b2088ca7cd7, data reload: false
   
   query1	1096	391	372	372
   query2	6610	1699	1712	1699
   query3	6858	222	223	222
   query4	25959	23458	22727	22727
   query5	4410	644	485	485
   query6	381	263	249	249
   query7	4657	493	296	296
   query8	323	260	244	244
   query9	8713	2588	2583	2583
   query10	505	348	296	296
   query11	15235	15062	14805	14805
   query12	176	126	114	114
   query13	1686	588	456	456
   query14	10494	9171	9192	9171
   query15	196	189	177	177
   query16	7683	672	530	530
   query17	1244	736	615	615
   query18	2009	419	323	323
   query19	211	203	175	175
   query20	131	127	121	121
   query21	266	131	113	113
   query22	3966	4061	3959	3959
   query23	34002	33082	33094	33082
   query24	8418	2410	2388	2388
   query25	599	522	459	459
   query26	1248	270	164	164
   query27	2740	494	363	363
   query28	4356	2189	2160	2160
   query29	814	611	492	492
   query30	318	218	212	212
   query31	894	789	717	717
   query32	81	81	74	74
   query33	624	382	319	319
   query34	795	847	517	517
   query35	841	837	729	729
   query36	938	980	857	857
   query37	141	102	83	83
   query38	3528	3521	3499	3499
   query39	1476	1416	1405	1405
   query40	229	124	121	121
   query41	70	64	63	63
   query42	123	106	115	106
   query43	491	499	457	457
   query44	1236	762	757	757
   query45	187	177	177	177
   query46	884	985	632	632
   query47	1730	1755	1682	1682
   query48	398	418	329	329
   query49	767	490	390	390
   query50	639	675	402	402
   query51	3883	3842	3990	3842
   query52	113	113	103	103
   query53	246	264	195	195
   query54	307	288	276	276
   query55	84	82	81	81
   query56	332	320	314	314
   query57	1158	1171	1106	1106
   query58	284	280	285	280
   query59	2539	2603	2494	2494
   query60	338	343	334	334
   query61	191	164	160	160
   query62	789	703	661	661
   query63	240	199	192	192
   query64	4425	1175	877	877
   query65	4051	3945	3934	3934
   query66	1126	440	329	329
   query67	15268	15014	14721	14721
   query68	4706	951	638	638
   query69	522	325	281	281
   query70	1319	1318	1280	1280
   query71	418	343	313	313
   query72	5964	5021	5121	5021
   query73	665	603	365	365
   query74	8835	9035	8884	8884
   query75	3281	3334	2806	2806
   query76	3267	1156	732	732
   query77	535	419	318	318
   query78	9432	9791	8989	8989
   query79	2103	812	608	608
   query80	1289	664	501	501
   query81	550	252	222	222
   query82	412	155	130	130
   query83	271	262	240	240
   query84	259	115	98	98
   query85	909	487	453	453
   query86	396	290	301	290
   query87	3796	3768	3645	3645
   query88	2836	2282	2266	2266
   query89	376	327	288	288
   query90	1667	231	225	225
   query91	165	170	133	133
   query92	75	69	57	57
   query93	1231	997	685	685
   query94	764	430	348	348
   query95	397	327	314	314
   query96	472	568	282	282
   query97	2897	2990	2846	2846
   query98	235	215	207	207
   query99	1286	1416	1292	1292
   Total cold run time: 268080 ms
   Total hot run time: 187024 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565777112

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 34352 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 62513b022ed749f63ca2f086fcb60b2088ca7cd7, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17694	5031	4882	4882
   q2	2224	310	209	209
   q3	10192	1278	688	688
   q4	10253	922	399	399
   q5	7585	2345	2410	2345
   q6	184	175	139	139
   q7	892	770	639	639
   q8	9380	1343	1160	1160
   q9	7206	5460	5537	5460
   q10	7016	2233	1792	1792
   q11	504	300	290	290
   q12	334	361	227	227
   q13	17777	3577	3019	3019
   q14	225	237	207	207
   q15	571	522	501	501
   q16	1011	1009	978	978
   q17	588	855	364	364
   q18	7380	7100	7196	7100
   q19	1166	931	525	525
   q20	336	326	221	221
   q21	3613	3086	2229	2229
   q22	1092	1015	978	978
   Total cold run time: 107223 ms
   Total hot run time: 34352 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4970	4922	4906	4906
   q2	320	388	329	329
   q3	2120	2681	2211	2211
   q4	1315	1771	1330	1330
   q5	4186	4462	4501	4462
   q6	220	188	133	133
   q7	2057	1911	1791	1791
   q8	2647	2495	2628	2495
   q9	7540	7483	7566	7483
   q10	2999	3246	2794	2794
   q11	604	545	518	518
   q12	733	758	654	654
   q13	3503	3895	3285	3285
   q14	306	298	287	287
   q15	561	493	496	493
   q16	1082	1082	1043	1043
   q17	1114	1517	1422	1422
   q18	7830	7500	7713	7500
   q19	800	892	868	868
   q20	2014	2042	1797	1797
   q21	4718	4414	4316	4316
   q22	1056	1033	997	997
   Total cold run time: 52695 ms
   Total hot run time: 51114 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565847264

   # BE UT Coverage Report
   Increment line coverage `100.00% (10/10)` :tada:
   
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/62513b022ed749f63ca2f086fcb60b2088ca7cd7_62513b022ed749f63ca2f086fcb60b2088ca7cd7/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/62513b022ed749f63ca2f086fcb60b2088ca7cd7_62513b022ed749f63ca2f086fcb60b2088ca7cd7/report/index.html)
   | Category          | Coverage           |
   |-------------------|--------------------|
   | Function Coverage | 52.64% (18283/34735) |
   | Line Coverage     | 38.08% (166359/436870) |
   | Region Coverage   | 33.03% (129368/391628) |
   | Branch Coverage   | 33.83% (55514/164107) |


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3562890328

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 186757 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit 6cef593381e024328e084fe233417b7c22b8c6da, data reload: false
   
   query1	1013	404	410	404
   query2	6541	1687	1658	1658
   query3	6768	222	229	222
   query4	26285	23135	22989	22989
   query5	4422	647	474	474
   query6	348	244	232	232
   query7	4647	496	303	303
   query8	313	267	246	246
   query9	8707	2590	2587	2587
   query10	474	351	294	294
   query11	15641	15079	14801	14801
   query12	170	113	108	108
   query13	1674	570	439	439
   query14	11146	9093	9064	9064
   query15	196	185	161	161
   query16	7590	669	503	503
   query17	1226	734	633	633
   query18	2015	421	318	318
   query19	205	199	174	174
   query20	126	123	119	119
   query21	212	132	112	112
   query22	4092	4110	4127	4110
   query23	33887	33039	32885	32885
   query24	8435	2399	2431	2399
   query25	576	513	429	429
   query26	1234	266	153	153
   query27	2783	484	358	358
   query28	4345	2195	2175	2175
   query29	795	606	468	468
   query30	305	225	197	197
   query31	930	793	720	720
   query32	80	76	71	71
   query33	572	384	325	325
   query34	785	848	518	518
   query35	801	823	725	725
   query36	952	982	899	899
   query37	149	108	88	88
   query38	3463	3474	3463	3463
   query39	1640	1570	1433	1433
   query40	219	124	118	118
   query41	67	61	60	60
   query42	125	111	111	111
   query43	477	482	468	468
   query44	1247	766	768	766
   query45	186	182	170	170
   query46	878	981	631	631
   query47	1769	1827	1731	1731
   query48	410	427	326	326
   query49	786	478	404	404
   query50	652	673	392	392
   query51	3862	3874	3933	3874
   query52	107	111	106	106
   query53	238	261	197	197
   query54	307	289	284	284
   query55	85	83	82	82
   query56	337	325	327	325
   query57	1196	1184	1116	1116
   query58	280	276	274	274
   query59	2550	2629	2484	2484
   query60	331	338	342	338
   query61	166	165	161	161
   query62	770	702	676	676
   query63	225	190	188	188
   query64	4480	1271	936	936
   query65	4029	3963	3942	3942
   query66	1105	429	325	325
   query67	14924	15372	14847	14847
   query68	5700	959	632	632
   query69	495	320	277	277
   query70	1339	1185	1270	1185
   query71	424	339	309	309
   query72	5980	4847	4814	4814
   query73	614	583	368	368
   query74	8890	9041	8645	8645
   query75	3297	3295	2787	2787
   query76	3310	1126	698	698
   query77	538	397	314	314
   query78	9614	9614	8919	8919
   query79	1397	812	606	606
   query80	683	563	492	492
   query81	486	255	227	227
   query82	213	171	154	154
   query83	277	272	258	258
   query84	252	114	87	87
   query85	883	476	483	476
   query86	323	306	293	293
   query87	3719	3804	3618	3618
   query88	2889	2273	2238	2238
   query89	402	331	308	308
   query90	1746	226	229	226
   query91	187	178	153	153
   query92	71	72	62	62
   query93	1154	988	688	688
   query94	663	473	357	357
   query95	429	344	334	334
   query96	493	583	280	280
   query97	2889	2982	2853	2853
   query98	234	209	216	209
   query99	1330	1390	1301	1301
   Total cold run time: 268272 ms
   Total hot run time: 186757 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3563834247

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 27.31 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 1b4dee7d8e8e582813a843d9acddf72ff86782d5, data reload: false
   
   query1	0.05	0.05	0.05
   query2	0.10	0.05	0.05
   query3	0.26	0.08	0.08
   query4	1.60	0.11	0.10
   query5	0.27	0.26	0.26
   query6	1.17	0.65	0.63
   query7	0.03	0.02	0.03
   query8	0.05	0.04	0.04
   query9	0.58	0.53	0.52
   query10	0.57	0.58	0.57
   query11	0.16	0.11	0.12
   query12	0.15	0.11	0.13
   query13	0.62	0.60	0.62
   query14	1.01	0.99	1.00
   query15	0.83	0.83	0.84
   query16	0.38	0.40	0.38
   query17	1.01	1.02	1.00
   query18	0.21	0.20	0.20
   query19	1.95	1.77	1.82
   query20	0.02	0.01	0.01
   query21	15.47	0.21	0.13
   query22	5.07	0.06	0.05
   query23	15.64	0.26	0.11
   query24	2.45	1.37	0.32
   query25	0.08	0.06	0.07
   query26	0.15	0.13	0.14
   query27	0.08	0.06	0.06
   query28	4.33	1.16	0.93
   query29	12.58	3.88	3.24
   query30	0.28	0.15	0.11
   query31	2.81	0.59	0.41
   query32	3.22	0.54	0.47
   query33	3.11	3.02	3.06
   query34	15.56	5.15	4.55
   query35	4.59	4.58	4.55
   query36	0.68	0.50	0.49
   query37	0.10	0.07	0.06
   query38	0.07	0.04	0.05
   query39	0.04	0.03	0.03
   query40	0.17	0.14	0.14
   query41	0.08	0.03	0.03
   query42	0.04	0.03	0.02
   query43	0.04	0.04	0.04
   Total cold run time: 97.66 s
   Total hot run time: 27.31 s
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3563980243

   # BE UT Coverage Report
   Increment line coverage `100.00% (10/10)` :tada:
   
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/1b4dee7d8e8e582813a843d9acddf72ff86782d5_1b4dee7d8e8e582813a843d9acddf72ff86782d5/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/1b4dee7d8e8e582813a843d9acddf72ff86782d5_1b4dee7d8e8e582813a843d9acddf72ff86782d5/report/index.html)
   | Category          | Coverage           |
   |-------------------|--------------------|
   | Function Coverage | 52.64% (18283/34735) |
   | Line Coverage     | 38.08% (166359/436861) |
   | Region Coverage   | 33.03% (129338/391628) |
   | Branch Coverage   | 33.82% (55509/164107) |


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565496728

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565696423

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3566373316

   # BE Regression && UT Coverage Report
   Increment line coverage `100.00% (10/10)` :tada:
   
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7_merge/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7_merge/report/index.html)
   | Category          | Coverage           |
   |-------------------|--------------------|
   | Function Coverage | 73.01% (24895/34096) |
   | Line Coverage     | 60.05% (262461/437036) |
   | Region Coverage   | 55.39% (219866/396936) |
   | Branch Coverage   | 57.06% (94213/165118) |


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3566324778

   # BE Regression && UT Coverage Report
   Increment line coverage `100.00% (10/10)` :tada:
   
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7_merge/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7_merge/report/index.html)
   | Category          | Coverage           |
   |-------------------|--------------------|
   | Function Coverage | 73.01% (24893/34096) |
   | Line Coverage     | 60.05% (262441/437036) |
   | Region Coverage   | 55.38% (219820/396936) |
   | Branch Coverage   | 57.06% (94209/165118) |


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3572158109

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3515493800

   # BE UT Coverage Report
   Increment line coverage ` ` :tada:
   
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/1b9ab77eb857ca1fa6af6d1183feba8da7912751_1b9ab77eb857ca1fa6af6d1183feba8da7912751/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/1b9ab77eb857ca1fa6af6d1183feba8da7912751_1b9ab77eb857ca1fa6af6d1183feba8da7912751/report/index.html)
   | Category          | Coverage           |
   |-------------------|--------------------|
   | Function Coverage | 52.82% (18283/34611) |
   | Line Coverage     | 38.20% (166245/435251) |
   | Region Coverage   | 33.19% (129247/389444) |
   | Branch Coverage   | 33.92% (55461/163488) |


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3520370913

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "linrrzqqq (via GitHub)" <gi...@apache.org>.
linrrzqqq commented on code in PR #57893:
URL: https://github.com/apache/doris/pull/57893#discussion_r2514774317


##########
be/src/vec/functions/date_time_transforms.h:
##########
@@ -74,6 +74,23 @@ namespace doris::vectorized {
 #define TO_TIME_FUNCTION(CLASS, UNIT) TIME_FUNCTION_IMPL(CLASS, UNIT, UNIT())
 
 TO_TIME_FUNCTION(ToYearImpl, year);
+template <PrimitiveType PType>
+struct ToCenturyImpl {
+    static constexpr PrimitiveType OpArgType = PType;
+    using NativeType = typename PrimitiveTypeTraits<PType>::CppNativeType;
+    static constexpr auto name = "century";
+    
+    static inline auto execute(const NativeType& t) {
+        const auto& date_time_value = (typename PrimitiveTypeTraits<PType>::CppType&)(t);
+        int year = date_time_value.year();
+        // 计算世纪: (year - 1) / 100 + 1

Review Comment:
   plz use english for comment



##########
be/src/vec/functions/date_time_transforms.h:
##########
@@ -74,6 +74,23 @@ namespace doris::vectorized {
 #define TO_TIME_FUNCTION(CLASS, UNIT) TIME_FUNCTION_IMPL(CLASS, UNIT, UNIT())
 
 TO_TIME_FUNCTION(ToYearImpl, year);
+template <PrimitiveType PType>

Review Comment:
   where is this template instantiated? 



##########
be/src/vec/functions/date_time_transforms.h:
##########
@@ -74,6 +74,23 @@ namespace doris::vectorized {
 #define TO_TIME_FUNCTION(CLASS, UNIT) TIME_FUNCTION_IMPL(CLASS, UNIT, UNIT())
 
 TO_TIME_FUNCTION(ToYearImpl, year);
+template <PrimitiveType PType>

Review Comment:
   Also register this function in BE.
   
   I think the example in pr description didn't reach be, because the input is a constant value, which will directly go through the constant folding part of fe. If you want to test the code of be, you can try `SET debug_skip_fold_constant = true;` or directly creating a table.



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3521803246

   @linrrzqqq Could you please first check the correctness of my code


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3563699282

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3562906274

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 27.4 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 6cef593381e024328e084fe233417b7c22b8c6da, data reload: false
   
   query1	0.05	0.04	0.04
   query2	0.09	0.05	0.05
   query3	0.26	0.08	0.08
   query4	1.64	0.11	0.10
   query5	0.27	0.26	0.25
   query6	1.16	0.65	0.64
   query7	0.04	0.03	0.02
   query8	0.05	0.04	0.04
   query9	0.58	0.54	0.52
   query10	0.57	0.59	0.57
   query11	0.16	0.11	0.11
   query12	0.16	0.11	0.12
   query13	0.62	0.60	0.61
   query14	1.00	1.00	0.99
   query15	0.84	0.83	0.85
   query16	0.39	0.40	0.38
   query17	1.05	0.99	1.01
   query18	0.22	0.19	0.19
   query19	1.98	1.76	1.86
   query20	0.02	0.02	0.02
   query21	15.44	0.19	0.12
   query22	4.90	0.07	0.05
   query23	15.68	0.25	0.10
   query24	1.99	0.58	0.46
   query25	0.07	0.07	0.06
   query26	0.15	0.13	0.14
   query27	0.06	0.06	0.05
   query28	4.38	1.15	0.92
   query29	12.56	3.90	3.32
   query30	0.27	0.14	0.11
   query31	2.81	0.60	0.39
   query32	3.22	0.55	0.47
   query33	3.02	3.05	3.09
   query34	15.79	5.19	4.53
   query35	4.51	4.52	4.54
   query36	0.67	0.51	0.49
   query37	0.10	0.07	0.06
   query38	0.07	0.04	0.03
   query39	0.04	0.04	0.03
   query40	0.18	0.15	0.14
   query41	0.08	0.03	0.03
   query42	0.04	0.03	0.02
   query43	0.04	0.03	0.03
   Total cold run time: 97.22 s
   Total hot run time: 27.4 s
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3550911005

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3573346829

   # FE Regression Coverage Report
   Increment line coverage `  77.78% (14/18)` :tada:
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/57893_400017aef5f4fc75d75e289c44184ed9887e3786_merge_fe/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/57893_400017aef5f4fc75d75e289c44184ed9887e3786_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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3572399331

   # BE UT Coverage Report
   Increment line coverage `100.00% (10/10)` :tada:
   
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/400017aef5f4fc75d75e289c44184ed9887e3786_400017aef5f4fc75d75e289c44184ed9887e3786/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/400017aef5f4fc75d75e289c44184ed9887e3786_400017aef5f4fc75d75e289c44184ed9887e3786/report/index.html)
   | Category          | Coverage           |
   |-------------------|--------------------|
   | Function Coverage | 52.65% (18294/34748) |
   | Line Coverage     | 38.07% (166391/437039) |
   | Region Coverage   | 33.04% (129398/391640) |
   | Branch Coverage   | 33.82% (55504/164134) |


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3566417641

   # FE Regression Coverage Report
   Increment line coverage `  77.78% (14/18)` :tada:
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7_merge_fe/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7_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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565627409

   # BE UT Coverage Report
   Increment line coverage `100.00% (10/10)` :tada:
   
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/62513b022ed749f63ca2f086fcb60b2088ca7cd7_62513b022ed749f63ca2f086fcb60b2088ca7cd7/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/62513b022ed749f63ca2f086fcb60b2088ca7cd7_62513b022ed749f63ca2f086fcb60b2088ca7cd7/report/index.html)
   | Category          | Coverage           |
   |-------------------|--------------------|
   | Function Coverage | 52.64% (18283/34735) |
   | Line Coverage     | 38.08% (166367/436870) |
   | Region Coverage   | 33.03% (129345/391628) |
   | Branch Coverage   | 33.83% (55511/164107) |


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565648843

   # FE UT Coverage Report
   Increment line coverage `  5.56% (1/18)` :tada:
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7/fe_increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7/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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565856913

   # BE Regression && UT Coverage Report
   Increment line coverage `100.00% (10/10)` :tada:
   
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7_merge/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7_merge/report/index.html)
   | Category          | Coverage           |
   |-------------------|--------------------|
   | Function Coverage | 71.49% (24375/34096) |
   | Line Coverage     | 57.96% (253314/437036) |
   | Region Coverage   | 53.29% (211514/396936) |
   | Branch Coverage   | 54.62% (90189/165118) |


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "zclllyybb (via GitHub)" <gi...@apache.org>.
zclllyybb commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3575192527

   fix the docs then we can merge both~


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3575215283

   Okay, thank you for your patience


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3521928200

   solve the format


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3515092111

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3545037921

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3572430557

   # FE UT Coverage Report
   Increment line coverage `  5.56% (1/18)` :tada:
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/57893_400017aef5f4fc75d75e289c44184ed9887e3786/fe_increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/57893_400017aef5f4fc75d75e289c44184ed9887e3786/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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3515398839

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 34180 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 1b9ab77eb857ca1fa6af6d1183feba8da7912751, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17602	5176	5050	5050
   q2	2034	358	206	206
   q3	10220	1272	695	695
   q4	10233	918	372	372
   q5	7526	2365	2308	2308
   q6	184	170	132	132
   q7	918	763	616	616
   q8	9328	1329	1092	1092
   q9	6917	5122	5154	5122
   q10	6880	2215	1816	1816
   q11	496	298	303	298
   q12	338	363	231	231
   q13	18114	3710	3150	3150
   q14	231	234	226	226
   q15	580	512	501	501
   q16	1022	1025	955	955
   q17	607	887	375	375
   q18	7587	7050	7086	7050
   q19	1483	946	545	545
   q20	354	333	218	218
   q21	3666	3188	2252	2252
   q22	1069	1018	970	970
   Total cold run time: 107389 ms
   Total hot run time: 34180 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5161	5115	5058	5058
   q2	245	324	226	226
   q3	2184	2648	2295	2295
   q4	1356	1747	1357	1357
   q5	4135	4381	4567	4381
   q6	212	173	133	133
   q7	2030	1950	1755	1755
   q8	2707	2730	2558	2558
   q9	7359	7412	7278	7278
   q10	3088	3249	2793	2793
   q11	602	529	496	496
   q12	684	1067	613	613
   q13	3453	3895	3244	3244
   q14	277	348	308	308
   q15	539	504	494	494
   q16	1065	1114	1081	1081
   q17	1178	1556	1383	1383
   q18	7951	7881	7544	7544
   q19	779	857	1012	857
   q20	2047	1996	1830	1830
   q21	4730	4497	4270	4270
   q22	1090	1030	984	984
   Total cold run time: 52872 ms
   Total hot run time: 50938 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3515446987

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 27.42 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 1b9ab77eb857ca1fa6af6d1183feba8da7912751, data reload: false
   
   query1	0.06	0.04	0.05
   query2	0.10	0.05	0.04
   query3	0.25	0.08	0.08
   query4	1.61	0.12	0.11
   query5	0.27	0.26	0.26
   query6	1.18	0.64	0.66
   query7	0.03	0.02	0.03
   query8	0.05	0.05	0.04
   query9	0.60	0.52	0.51
   query10	0.57	0.57	0.57
   query11	0.16	0.12	0.11
   query12	0.16	0.12	0.12
   query13	0.61	0.61	0.60
   query14	0.99	1.00	1.01
   query15	0.83	0.81	0.82
   query16	0.41	0.39	0.39
   query17	1.01	1.00	1.05
   query18	0.21	0.20	0.20
   query19	1.93	1.81	1.82
   query20	0.01	0.02	0.01
   query21	15.44	0.18	0.13
   query22	5.18	0.06	0.05
   query23	15.66	0.26	0.10
   query24	2.60	1.17	0.42
   query25	0.07	0.06	0.06
   query26	0.14	0.14	0.13
   query27	0.07	0.05	0.05
   query28	4.58	1.13	0.94
   query29	12.57	3.91	3.21
   query30	0.28	0.16	0.11
   query31	2.82	0.59	0.39
   query32	3.24	0.56	0.48
   query33	3.07	3.02	3.12
   query34	15.81	5.19	4.59
   query35	4.59	4.60	4.54
   query36	0.67	0.49	0.49
   query37	0.09	0.06	0.07
   query38	0.06	0.04	0.04
   query39	0.04	0.03	0.03
   query40	0.17	0.15	0.14
   query41	0.09	0.03	0.02
   query42	0.04	0.03	0.03
   query43	0.04	0.04	0.03
   Total cold run time: 98.36 s
   Total hot run time: 27.42 s
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "linrrzqqq (via GitHub)" <gi...@apache.org>.
linrrzqqq commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3517765661

   Please add as comprehensive test cases as possible.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3521091973

   # BE UT Coverage Report
   Increment line coverage ` ` :tada:
   
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/9c2892f46a2873712235737086dcada39333cef6_9c2892f46a2873712235737086dcada39333cef6/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/9c2892f46a2873712235737086dcada39333cef6_9c2892f46a2873712235737086dcada39333cef6/report/index.html)
   | Category          | Coverage           |
   |-------------------|--------------------|
   | Function Coverage | 52.81% (18279/34611) |
   | Line Coverage     | 38.17% (166148/435260) |
   | Region Coverage   | 33.20% (129299/389453) |
   | Branch Coverage   | 33.91% (55438/163491) |


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3521941204

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3563302740

   # FE Regression Coverage Report
   Increment line coverage `  72.22% (13/18)` :tada:
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/57893_6cef593381e024328e084fe233417b7c22b8c6da_merge_fe/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/57893_6cef593381e024328e084fe233417b7c22b8c6da_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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3563209918

   # BE Regression && UT Coverage Report
   Increment line coverage `100.00% (10/10)` :tada:
   
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/57893_6cef593381e024328e084fe233417b7c22b8c6da_merge/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/57893_6cef593381e024328e084fe233417b7c22b8c6da_merge/report/index.html)
   | Category          | Coverage           |
   |-------------------|--------------------|
   | Function Coverage | 71.56% (24400/34096) |
   | Line Coverage     | 58.03% (253608/437027) |
   | Region Coverage   | 53.30% (211585/396936) |
   | Branch Coverage   | 54.74% (90382/165118) |


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3515135236

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3515287924

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565588086

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 27.19 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 62513b022ed749f63ca2f086fcb60b2088ca7cd7, data reload: false
   
   query1	0.05	0.05	0.08
   query2	0.09	0.04	0.04
   query3	0.26	0.09	0.08
   query4	1.61	0.11	0.11
   query5	0.26	0.24	0.25
   query6	1.20	0.66	0.63
   query7	0.04	0.02	0.03
   query8	0.06	0.04	0.05
   query9	0.58	0.52	0.52
   query10	0.58	0.56	0.58
   query11	0.16	0.11	0.11
   query12	0.15	0.12	0.12
   query13	0.62	0.60	0.60
   query14	1.00	1.01	0.98
   query15	0.83	0.82	0.83
   query16	0.40	0.38	0.39
   query17	1.04	1.04	1.03
   query18	0.21	0.20	0.19
   query19	1.92	1.85	1.80
   query20	0.02	0.01	0.01
   query21	15.40	0.22	0.13
   query22	4.90	0.07	0.05
   query23	15.69	0.25	0.10
   query24	2.85	1.63	0.39
   query25	0.08	0.07	0.05
   query26	0.15	0.14	0.13
   query27	0.07	0.05	0.05
   query28	4.70	1.16	0.93
   query29	12.62	3.88	3.22
   query30	0.28	0.13	0.11
   query31	2.81	0.57	0.38
   query32	3.23	0.53	0.46
   query33	2.95	3.02	3.04
   query34	15.83	5.19	4.46
   query35	4.56	4.55	4.54
   query36	0.69	0.51	0.49
   query37	0.10	0.07	0.07
   query38	0.06	0.04	0.04
   query39	0.04	0.04	0.03
   query40	0.18	0.15	0.13
   query41	0.08	0.03	0.03
   query42	0.04	0.03	0.02
   query43	0.05	0.03	0.03
   Total cold run time: 98.44 s
   Total hot run time: 27.19 s
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565824192

   # BE Regression && UT Coverage Report
   Increment line coverage `100.00% (10/10)` :tada:
   
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7_merge/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7_merge/report/index.html)
   | Category          | Coverage           |
   |-------------------|--------------------|
   | Function Coverage | 71.49% (24375/34096) |
   | Line Coverage     | 57.96% (253317/437036) |
   | Region Coverage   | 53.29% (211546/396936) |
   | Branch Coverage   | 54.62% (90192/165118) |


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "zclllyybb (via GitHub)" <gi...@apache.org>.
zclllyybb commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3560994068

   compile failed in FE. please rebase your code and fix it


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3562697812

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3545322682

   # BE UT Coverage Report
   Increment line coverage `50.00% (5/10)` :tada:
   
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/6554d35d7deb278c66a82afee685d67c69a83418_6554d35d7deb278c66a82afee685d67c69a83418/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/6554d35d7deb278c66a82afee685d67c69a83418_6554d35d7deb278c66a82afee685d67c69a83418/report/index.html)
   | Category          | Coverage           |
   |-------------------|--------------------|
   | Function Coverage | 52.73% (18271/34650) |
   | Line Coverage     | 38.10% (165990/435675) |
   | Region Coverage   | 33.06% (129091/390422) |
   | Branch Coverage   | 33.81% (55376/163777) |


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "linrrzqqq (via GitHub)" <gi...@apache.org>.
linrrzqqq commented on code in PR #57893:
URL: https://github.com/apache/doris/pull/57893#discussion_r2555016206


##########
be/src/vec/functions/date_time_transforms.h:
##########
@@ -74,6 +74,22 @@ namespace doris::vectorized {
 #define TO_TIME_FUNCTION(CLASS, UNIT) TIME_FUNCTION_IMPL(CLASS, UNIT, UNIT())
 
 TO_TIME_FUNCTION(ToYearImpl, year);
+template <PrimitiveType PType>
+struct ToCenturyImpl {
+    static constexpr PrimitiveType OpArgType = PType;
+    using NativeType = typename PrimitiveTypeTraits<PType>::CppNativeType;
+    static constexpr auto name = "century";
+
+    static inline auto execute(const NativeType& t) {
+        const auto& date_time_value = (typename PrimitiveTypeTraits<PType>::CppType&)(t);

Review Comment:
   ```suggestion
           const auto& date_time_value = assert_cast<typename PrimitiveTypeTraits<PType>::CppType&>(t);
   ```



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3515091464

   
   Thank you for your contribution to Apache Doris.
   Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/How+to+process+your+PR).
   
   Please clearly describe your PR:
   1. What problem was fixed (it's best to include specific error reporting information). How it was fixed.
   2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
   3. What features were added. Why was this function added?
   4. Which code was refactored and why was this part of the code refactored?
   5. Which functions were optimized and what is the difference before and after the optimization?
       


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3515432177

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 187991 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit 1b9ab77eb857ca1fa6af6d1183feba8da7912751, data reload: false
   
   query1	1059	406	410	406
   query2	6617	1734	1725	1725
   query3	6753	223	216	216
   query4	26624	23870	23468	23468
   query5	4410	600	464	464
   query6	329	228	218	218
   query7	4645	494	291	291
   query8	295	259	264	259
   query9	8698	2600	2597	2597
   query10	497	349	307	307
   query11	15844	15010	14854	14854
   query12	178	121	111	111
   query13	1659	559	441	441
   query14	11081	9248	9238	9238
   query15	199	185	181	181
   query16	7513	686	493	493
   query17	1212	732	608	608
   query18	2017	444	321	321
   query19	211	201	175	175
   query20	133	128	119	119
   query21	213	131	112	112
   query22	3877	3972	4056	3972
   query23	33753	32949	33112	32949
   query24	8457	2404	2433	2404
   query25	597	549	445	445
   query26	1241	269	161	161
   query27	2768	494	355	355
   query28	4363	2201	2221	2201
   query29	792	593	470	470
   query30	306	224	203	203
   query31	924	800	719	719
   query32	81	72	67	67
   query33	584	366	324	324
   query34	788	844	529	529
   query35	806	834	752	752
   query36	964	1004	901	901
   query37	116	110	87	87
   query38	3548	3578	3461	3461
   query39	1467	1430	1415	1415
   query40	225	130	124	124
   query41	62	60	63	60
   query42	124	117	113	113
   query43	485	506	458	458
   query44	1211	741	735	735
   query45	192	185	185	185
   query46	901	984	637	637
   query47	1733	1809	1687	1687
   query48	385	422	318	318
   query49	812	517	418	418
   query50	641	685	407	407
   query51	3867	3968	3873	3873
   query52	114	113	102	102
   query53	248	262	203	203
   query54	322	301	295	295
   query55	87	89	83	83
   query56	347	333	332	332
   query57	1176	1187	1118	1118
   query58	294	282	283	282
   query59	2553	2630	2612	2612
   query60	358	361	348	348
   query61	193	197	192	192
   query62	798	733	675	675
   query63	231	200	190	190
   query64	4561	1268	950	950
   query65	4047	3958	3947	3947
   query66	1143	465	365	365
   query67	15331	14929	14804	14804
   query68	8233	918	600	600
   query69	503	331	295	295
   query70	1311	1258	1213	1213
   query71	454	340	324	324
   query72	6267	4929	5034	4929
   query73	644	607	362	362
   query74	8879	9032	8980	8980
   query75	3539	3323	2745	2745
   query76	3405	1155	746	746
   query77	717	404	310	310
   query78	9508	9605	8865	8865
   query79	2296	875	608	608
   query80	692	567	492	492
   query81	515	260	231	231
   query82	459	165	128	128
   query83	277	262	243	243
   query84	258	108	102	102
   query85	918	470	452	452
   query86	389	299	308	299
   query87	3700	3677	3653	3653
   query88	3837	2265	2243	2243
   query89	399	345	288	288
   query90	1924	222	230	222
   query91	191	168	141	141
   query92	80	68	65	65
   query93	2206	962	630	630
   query94	723	458	333	333
   query95	405	321	318	318
   query96	487	559	285	285
   query97	2900	2958	2854	2854
   query98	243	218	215	215
   query99	1379	1428	1288	1288
   Total cold run time: 275798 ms
   Total hot run time: 187991 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "linrrzqqq (via GitHub)" <gi...@apache.org>.
linrrzqqq commented on code in PR #57893:
URL: https://github.com/apache/doris/pull/57893#discussion_r2517725572


##########
regression-test/suites/query_p0/sql_functions/datetime_functions/test_date_function.groovy:
##########


Review Comment:
   Add expected results in `test_date_function.out`.



-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565555501

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 35127 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 62513b022ed749f63ca2f086fcb60b2088ca7cd7, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17595	5059	4879	4879
   q2	2008	318	214	214
   q3	10224	1270	737	737
   q4	10232	892	358	358
   q5	7538	2414	2342	2342
   q6	184	170	139	139
   q7	925	787	623	623
   q8	9353	1344	1201	1201
   q9	6990	5338	5376	5338
   q10	7230	2232	1824	1824
   q11	493	295	283	283
   q12	342	372	238	238
   q13	17850	3641	3024	3024
   q14	239	229	211	211
   q15	580	503	499	499
   q16	999	995	952	952
   q17	571	838	392	392
   q18	7281	7427	7636	7427
   q19	1166	981	568	568
   q20	372	368	262	262
   q21	4461	4020	2580	2580
   q22	1147	1123	1036	1036
   Total cold run time: 107780 ms
   Total hot run time: 35127 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5168	5254	5220	5220
   q2	325	401	321	321
   q3	2454	2892	2485	2485
   q4	1468	1906	1453	1453
   q5	4568	4534	4282	4282
   q6	198	171	127	127
   q7	2032	1906	1722	1722
   q8	2671	2599	2510	2510
   q9	7579	7452	7504	7452
   q10	2902	3110	2659	2659
   q11	561	498	495	495
   q12	649	721	556	556
   q13	3275	3681	3077	3077
   q14	283	284	261	261
   q15	546	492	497	492
   q16	1012	1039	982	982
   q17	1104	1516	1322	1322
   q18	7311	7250	7026	7026
   q19	789	776	982	776
   q20	1946	1997	1797	1797
   q21	4704	4375	4197	4197
   q22	1075	1031	1001	1001
   Total cold run time: 52620 ms
   Total hot run time: 50213 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3562962822

   # BE UT Coverage Report
   Increment line coverage `100.00% (10/10)` :tada:
   
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/6cef593381e024328e084fe233417b7c22b8c6da_6cef593381e024328e084fe233417b7c22b8c6da/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/6cef593381e024328e084fe233417b7c22b8c6da_6cef593381e024328e084fe233417b7c22b8c6da/report/index.html)
   | Category          | Coverage           |
   |-------------------|--------------------|
   | Function Coverage | 52.63% (18282/34735) |
   | Line Coverage     | 38.08% (166356/436861) |
   | Region Coverage   | 33.01% (129295/391628) |
   | Branch Coverage   | 33.83% (55512/164107) |


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3563776879

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 34328 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 1b4dee7d8e8e582813a843d9acddf72ff86782d5, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17588	5078	5063	5063
   q2	2026	315	204	204
   q3	10252	1272	722	722
   q4	10242	977	379	379
   q5	7543	2360	2331	2331
   q6	179	173	137	137
   q7	927	773	637	637
   q8	9345	1341	1089	1089
   q9	7098	5348	5357	5348
   q10	6814	2234	1788	1788
   q11	475	300	279	279
   q12	340	368	240	240
   q13	17776	3667	3022	3022
   q14	226	247	222	222
   q15	556	517	513	513
   q16	1022	1018	935	935
   q17	588	858	385	385
   q18	7463	7216	7003	7003
   q19	1078	964	547	547
   q20	342	340	224	224
   q21	3765	3226	2285	2285
   q22	1044	1026	975	975
   Total cold run time: 106689 ms
   Total hot run time: 34328 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4990	4951	4949	4949
   q2	312	394	307	307
   q3	2229	2687	2257	2257
   q4	1338	1771	1321	1321
   q5	4171	4376	4660	4376
   q6	215	170	132	132
   q7	2044	1967	1812	1812
   q8	2648	2664	2641	2641
   q9	7583	7525	7546	7525
   q10	3054	3296	2916	2916
   q11	574	555	498	498
   q12	666	772	619	619
   q13	3489	3931	3364	3364
   q14	304	297	266	266
   q15	547	517	527	517
   q16	1064	1098	1091	1091
   q17	1155	1593	1382	1382
   q18	7972	7592	7619	7592
   q19	788	797	929	797
   q20	2046	2065	1913	1913
   q21	5095	4352	4194	4194
   q22	1078	1027	996	996
   Total cold run time: 53362 ms
   Total hot run time: 51465 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3566364854

   # FE Regression Coverage Report
   Increment line coverage `  77.78% (14/18)` :tada:
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7_merge_fe/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7_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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "linrrzqqq (via GitHub)" <gi...@apache.org>.
linrrzqqq commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565483063

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3572313231

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 35754 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 400017aef5f4fc75d75e289c44184ed9887e3786, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17578	5075	4994	4994
   q2	2018	336	208	208
   q3	10240	1335	740	740
   q4	10234	952	378	378
   q5	7542	2423	2347	2347
   q6	181	168	138	138
   q7	920	778	625	625
   q8	9370	1322	1124	1124
   q9	7048	5274	5318	5274
   q10	6879	2230	1828	1828
   q11	497	305	288	288
   q12	345	365	229	229
   q13	17793	3645	3070	3070
   q14	236	244	212	212
   q15	585	521	515	515
   q16	1025	1002	965	965
   q17	590	890	359	359
   q18	7500	7435	7614	7435
   q19	1312	988	585	585
   q20	382	358	246	246
   q21	4418	3802	3147	3147
   q22	1111	1070	1047	1047
   Total cold run time: 107804 ms
   Total hot run time: 35754 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	5231	5183	5194	5183
   q2	349	397	320	320
   q3	2395	2877	2463	2463
   q4	1459	1909	1451	1451
   q5	4605	4468	4549	4468
   q6	203	167	126	126
   q7	2016	1995	1805	1805
   q8	2651	2992	2583	2583
   q9	7496	7524	7391	7391
   q10	2873	3120	2689	2689
   q11	560	497	481	481
   q12	650	714	568	568
   q13	3249	3641	3029	3029
   q14	281	290	254	254
   q15	533	508	493	493
   q16	1025	1058	1022	1022
   q17	1087	1393	1318	1318
   q18	7221	7173	7003	7003
   q19	765	802	883	802
   q20	1918	1959	1813	1813
   q21	4778	4403	4320	4320
   q22	1080	1041	1006	1006
   Total cold run time: 52425 ms
   Total hot run time: 50588 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3522369661

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "linrrzqqq (via GitHub)" <gi...@apache.org>.
linrrzqqq commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3521181253

   Resolve formatting issues and remember to link your function doc and issue(`Issue Number: #xxxxx`) in pr description


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3551595807

   # BE UT Coverage Report
   Increment line coverage `100.00% (10/10)` :tada:
   
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/6004f83144bf54d4a0fcc92fc0d0a69164ede5de_6004f83144bf54d4a0fcc92fc0d0a69164ede5de/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/6004f83144bf54d4a0fcc92fc0d0a69164ede5de_6004f83144bf54d4a0fcc92fc0d0a69164ede5de/report/index.html)
   | Category          | Coverage           |
   |-------------------|--------------------|
   | Function Coverage | 52.74% (18279/34659) |
   | Line Coverage     | 38.10% (166077/435843) |
   | Region Coverage   | 33.03% (129085/390837) |
   | Branch Coverage   | 33.81% (55401/163845) |


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3563817401

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 187853 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit 1b4dee7d8e8e582813a843d9acddf72ff86782d5, data reload: false
   
   query1	1031	436	389	389
   query2	6551	1692	1651	1651
   query3	6749	225	220	220
   query4	25908	23346	23408	23346
   query5	4399	620	464	464
   query6	341	247	243	243
   query7	4660	487	308	308
   query8	306	265	253	253
   query9	8704	2554	2593	2554
   query10	503	342	297	297
   query11	15939	15032	14734	14734
   query12	170	117	114	114
   query13	1696	583	474	474
   query14	11009	9185	9198	9185
   query15	214	195	179	179
   query16	7420	695	516	516
   query17	1270	787	642	642
   query18	2007	412	311	311
   query19	196	199	170	170
   query20	125	124	120	120
   query21	217	139	114	114
   query22	4007	4065	4076	4065
   query23	33901	32785	32777	32777
   query24	8540	2353	2400	2353
   query25	588	535	443	443
   query26	1239	272	160	160
   query27	2769	502	357	357
   query28	4351	2180	2184	2180
   query29	813	609	476	476
   query30	303	222	207	207
   query31	883	807	704	704
   query32	86	72	76	72
   query33	603	374	344	344
   query34	774	849	513	513
   query35	824	822	736	736
   query36	960	998	910	910
   query37	127	112	81	81
   query38	3489	3510	3500	3500
   query39	1457	1425	1412	1412
   query40	233	129	119	119
   query41	68	64	64	64
   query42	130	110	108	108
   query43	480	516	455	455
   query44	1218	765	763	763
   query45	183	179	175	175
   query46	894	992	635	635
   query47	1724	1781	1716	1716
   query48	386	420	315	315
   query49	782	493	411	411
   query50	687	679	406	406
   query51	3863	3938	3895	3895
   query52	114	110	108	108
   query53	242	261	199	199
   query54	306	292	270	270
   query55	85	84	81	81
   query56	326	332	300	300
   query57	1185	1188	1113	1113
   query58	281	279	271	271
   query59	2518	2614	2608	2608
   query60	361	337	334	334
   query61	167	162	159	159
   query62	792	688	659	659
   query63	225	189	198	189
   query64	4524	1169	877	877
   query65	4049	3922	3936	3922
   query66	1162	427	321	321
   query67	15208	15172	15215	15172
   query68	4173	968	642	642
   query69	482	313	279	279
   query70	1356	1284	1239	1239
   query71	413	341	303	303
   query72	5924	5288	5256	5256
   query73	682	630	365	365
   query74	8827	8822	8678	8678
   query75	3265	3350	2822	2822
   query76	3264	1155	764	764
   query77	522	394	319	319
   query78	10216	9773	8859	8859
   query79	1700	794	595	595
   query80	1647	579	510	510
   query81	556	262	227	227
   query82	398	158	133	133
   query83	353	263	245	245
   query84	249	118	91	91
   query85	924	505	460	460
   query86	380	301	318	301
   query87	3669	3700	3634	3634
   query88	2885	2276	2230	2230
   query89	386	335	290	290
   query90	1744	224	224	224
   query91	170	171	139	139
   query92	73	71	64	64
   query93	1171	1045	687	687
   query94	703	440	352	352
   query95	405	328	324	324
   query96	489	554	279	279
   query97	2895	2944	2832	2832
   query98	235	218	215	215
   query99	1296	1401	1276	1276
   Total cold run time: 268774 ms
   Total hot run time: 187853 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565578264

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 186696 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit 62513b022ed749f63ca2f086fcb60b2088ca7cd7, data reload: false
   
   query1	1028	391	431	391
   query2	6551	1700	1722	1700
   query3	6770	232	220	220
   query4	25770	23163	22723	22723
   query5	4399	627	470	470
   query6	319	257	220	220
   query7	4661	498	301	301
   query8	314	276	245	245
   query9	8754	2581	2588	2581
   query10	516	339	295	295
   query11	15102	15063	14875	14875
   query12	178	117	117	117
   query13	1695	583	466	466
   query14	10276	9161	9174	9161
   query15	209	187	174	174
   query16	7417	693	543	543
   query17	1291	773	655	655
   query18	2006	431	341	341
   query19	210	210	185	185
   query20	131	128	124	124
   query21	215	154	115	115
   query22	3931	4101	4071	4071
   query23	33925	32999	33119	32999
   query24	8493	2420	2399	2399
   query25	640	543	480	480
   query26	1240	283	167	167
   query27	2746	502	361	361
   query28	4365	2178	2162	2162
   query29	853	671	517	517
   query30	301	224	191	191
   query31	908	788	721	721
   query32	87	78	75	75
   query33	619	399	353	353
   query34	803	859	586	586
   query35	778	836	731	731
   query36	944	973	921	921
   query37	117	112	86	86
   query38	3475	3510	3437	3437
   query39	1472	1420	1416	1416
   query40	221	130	120	120
   query41	66	60	61	60
   query42	128	110	114	110
   query43	493	495	452	452
   query44	1243	758	774	758
   query45	179	180	173	173
   query46	908	993	644	644
   query47	1735	1767	1709	1709
   query48	406	420	322	322
   query49	771	472	410	410
   query50	658	678	404	404
   query51	3840	3867	3811	3811
   query52	111	110	103	103
   query53	243	273	203	203
   query54	310	296	280	280
   query55	89	87	86	86
   query56	338	367	305	305
   query57	1194	1172	1117	1117
   query58	292	278	272	272
   query59	2495	2615	2507	2507
   query60	341	350	344	344
   query61	163	165	163	163
   query62	772	699	658	658
   query63	231	203	198	198
   query64	4481	1184	874	874
   query65	4004	3914	3939	3914
   query66	1170	446	347	347
   query67	15073	14897	14825	14825
   query68	8423	954	628	628
   query69	495	321	284	284
   query70	1319	1262	1257	1257
   query71	518	357	313	313
   query72	5922	4913	4792	4792
   query73	657	574	367	367
   query74	8887	9101	8629	8629
   query75	4066	3277	2824	2824
   query76	3709	1124	734	734
   query77	828	413	319	319
   query78	9450	9564	8805	8805
   query79	2032	843	599	599
   query80	638	563	500	500
   query81	504	263	222	222
   query82	486	154	136	136
   query83	267	252	257	252
   query84	250	107	98	98
   query85	924	489	441	441
   query86	392	314	283	283
   query87	3739	3667	3575	3575
   query88	3889	2251	2243	2243
   query89	399	324	293	293
   query90	1955	221	222	221
   query91	181	170	133	133
   query92	84	66	62	62
   query93	1765	985	684	684
   query94	709	455	334	334
   query95	412	325	317	317
   query96	495	556	290	290
   query97	2932	2935	2842	2842
   query98	269	217	206	206
   query99	1424	1429	1269	1269
   Total cold run time: 273484 ms
   Total hot run time: 186696 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "linrrzqqq (via GitHub)" <gi...@apache.org>.
linrrzqqq commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565482775

   Please submit a PR for `century` function document to the repository https://github.com/apache/doris-website, and link it in the description in this pr.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3565858136

   # FE Regression Coverage Report
   Increment line coverage `  77.78% (14/18)` :tada:
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7_merge_fe/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/57893_62513b022ed749f63ca2f086fcb60b2088ca7cd7_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: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "robll-v1 (via GitHub)" <gi...@apache.org>.
robll-v1 commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3573453127

   fixed


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] (enhanced) completed the function : century from duckdb [doris]

Posted by "zclllyybb (via GitHub)" <gi...@apache.org>.
zclllyybb commented on PR #57893:
URL: https://github.com/apache/doris/pull/57893#issuecomment-3571854630

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org