You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "felixwluo (via GitHub)" <gi...@apache.org> on 2024/02/29 08:57:45 UTC

[PR] [fix](function) function DATE_FORMAT get wrong result [doris]

felixwluo opened a new pull request, #31598:
URL: https://github.com/apache/doris/pull/31598

   ## Proposed changes
   
   Issue Number: close #31524
   
   <!--Describe your changes.-->
   
   ## Further comments
   Let the query go be the correct result.
   before:
   <img width="495" alt="图片" src="https://github.com/apache/doris/assets/131352377/6ab1b2a2-835a-4941-9483-eaacce32f86f">
   
   now:
   <img width="660" alt="图片" src="https://github.com/apache/doris/assets/131352377/1aff6850-c1fc-401b-9596-6482f901c6f1">
   
   
   
   
   If this is a relatively large or complex change, kick off the discussion at [dev@doris.apache.org](mailto:dev@doris.apache.org) by explaining why you chose the solution you did and what alternatives you considered, etc...
   
   


-- 
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] [fix](function) function DATE_FORMAT get wrong result [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 37836 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 23ad8e512dcdd56d5112c60ca1bcf842ad1cb87a, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17643	4036	4029	4029
   q2	2051	144	133	133
   q3	10568	951	942	942
   q4	4665	938	941	938
   q5	7597	2841	3024	2841
   q6	178	124	123	123
   q7	1240	762	746	746
   q8	9240	1983	2028	1983
   q9	7198	6274	6266	6266
   q10	8183	2473	2464	2464
   q11	408	199	206	199
   q12	717	309	317	309
   q13	17947	3200	3216	3200
   q14	278	255	247	247
   q15	524	492	490	490
   q16	472	424	411	411
   q17	938	900	869	869
   q18	6869	6017	6068	6017
   q19	1583	1515	1520	1515
   q20	568	290	266	266
   q21	6874	3566	3568	3566
   q22	805	285	282	282
   Total cold run time: 106546 ms
   Total hot run time: 37836 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	3993	3974	3981	3974
   q2	306	222	216	216
   q3	2972	2936	2974	2936
   q4	1844	1788	1821	1788
   q5	5099	5118	5094	5094
   q6	202	115	117	115
   q7	2114	1719	1771	1719
   q8	3140	3185	3217	3185
   q9	8266	8218	8225	8218
   q10	6101	3718	3702	3702
   q11	513	440	441	440
   q12	677	559	536	536
   q13	16883	3044	3028	3028
   q14	266	258	253	253
   q15	544	479	493	479
   q16	505	487	480	480
   q17	1700	1694	1646	1646
   q18	7852	7553	7419	7419
   q19	1666	1644	1643	1643
   q20	2095	1913	1887	1887
   q21	4816	4685	4655	4655
   q22	509	449	451	449
   Total cold run time: 72063 ms
   Total hot run time: 53862 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] [fix](function) function DATE_FORMAT get wrong result [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 45686a0c63d841bbca90f2e68a4e6ad5798e3297 with default session variables
   Stream load json:         18 seconds loaded 2358488459 Bytes, about 124 MB/s
   Stream load orc:          59 seconds loaded 1101869774 Bytes, about 17 MB/s
   Stream load parquet:      32 seconds loaded 861443392 Bytes, about 25 MB/s
   Insert into select:       18.3 seconds inserted 10000000 Rows, about 546K ops/s
   ```
   


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

To unsubscribe, e-mail: commits-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] [fix](function) function DATE_FORMAT get wrong result [doris]

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

   replace snapshot with text for search engine and git commit message friendly


-- 
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] [fix](function) function DATE_FORMAT get wrong result [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 169043 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 23ad8e512dcdd56d5112c60ca1bcf842ad1cb87a, data reload: false
   
   query1	960	340	330	330
   query2	5465	1764	1645	1645
   query3	6695	209	210	209
   query4	23553	20516	20489	20489
   query5	3770	360	354	354
   query6	256	181	163	163
   query7	4606	291	284	284
   query8	263	197	197	197
   query9	8452	2228	2204	2204
   query10	409	218	216	216
   query11	14587	14186	14160	14160
   query12	130	81	81	81
   query13	1654	419	439	419
   query14	8571	6437	6599	6437
   query15	208	169	181	169
   query16	6559	266	273	266
   query17	1010	510	497	497
   query18	1822	271	261	261
   query19	196	149	148	148
   query20	84	81	85	81
   query21	188	118	120	118
   query22	4825	4615	4555	4555
   query23	30619	29841	29845	29841
   query24	12023	3148	3145	3145
   query25	600	355	356	355
   query26	1406	154	161	154
   query27	2989	300	305	300
   query28	7012	1815	1811	1811
   query29	1019	554	548	548
   query30	253	130	141	130
   query31	863	677	693	677
   query32	79	59	55	55
   query33	702	227	222	222
   query34	997	495	492	492
   query35	848	735	741	735
   query36	932	846	867	846
   query37	197	62	63	62
   query38	3073	2992	2960	2960
   query39	1309	1248	1251	1248
   query40	255	104	100	100
   query41	38	38	35	35
   query42	98	97	109	97
   query43	460	414	424	414
   query44	1074	699	714	699
   query45	200	177	166	166
   query46	1024	758	771	758
   query47	1446	1387	1390	1387
   query48	406	342	336	336
   query49	982	294	297	294
   query50	768	363	361	361
   query51	4332	4316	4318	4316
   query52	95	94	87	87
   query53	337	264	259	259
   query54	297	216	233	216
   query55	81	80	81	80
   query56	217	202	189	189
   query57	995	903	935	903
   query58	206	196	194	194
   query59	2058	2034	2101	2034
   query60	225	218	220	218
   query61	91	84	82	82
   query62	589	361	358	358
   query63	275	253	266	253
   query64	5566	3014	3104	3014
   query65	3238	3223	3185	3185
   query66	1244	313	308	308
   query67	14367	14176	14045	14045
   query68	4983	552	564	552
   query69	528	373	370	370
   query70	1197	1242	1156	1156
   query71	360	256	253	253
   query72	6105	2806	2655	2655
   query73	708	311	313	311
   query74	6271	6183	6114	6114
   query75	3078	2464	2525	2464
   query76	2692	1025	1152	1025
   query77	358	244	238	238
   query78	9165	8521	8528	8521
   query79	1283	508	507	507
   query80	1085	350	348	348
   query81	466	195	196	195
   query82	1192	84	84	84
   query83	214	123	121	121
   query84	281	79	75	75
   query85	1360	351	337	337
   query86	345	283	272	272
   query87	3268	3079	3102	3079
   query88	2682	2239	2250	2239
   query89	385	331	338	331
   query90	1865	164	158	158
   query91	146	123	127	123
   query92	57	46	47	46
   query93	1169	522	513	513
   query94	1208	185	176	176
   query95	444	345	335	335
   query96	580	265	256	256
   query97	4233	4104	4124	4104
   query98	222	199	193	193
   query99	1038	640	662	640
   Total cold run time: 259116 ms
   Total hot run time: 169043 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] [fix](function) function DATE_FORMAT get wrong result [doris]

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

   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] [fix](function) function DATE_FORMAT get wrong result [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 37811 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 45686a0c63d841bbca90f2e68a4e6ad5798e3297, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17655	4175	4050	4050
   q2	2044	140	133	133
   q3	10659	954	935	935
   q4	4657	916	940	916
   q5	7622	2927	3003	2927
   q6	176	122	117	117
   q7	1207	760	754	754
   q8	9294	1992	2027	1992
   q9	7221	6269	6303	6269
   q10	8201	2518	2524	2518
   q11	415	199	211	199
   q12	804	301	311	301
   q13	17940	3188	3239	3188
   q14	273	251	249	249
   q15	527	498	493	493
   q16	466	416	408	408
   q17	934	886	861	861
   q18	6746	5934	6074	5934
   q19	1557	1506	1509	1506
   q20	544	281	271	271
   q21	6350	3501	3532	3501
   q22	796	289	296	289
   Total cold run time: 106088 ms
   Total hot run time: 37811 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4009	4008	3979	3979
   q2	306	214	221	214
   q3	2944	2926	2926	2926
   q4	1817	1810	1799	1799
   q5	5098	5101	5093	5093
   q6	198	114	113	113
   q7	2117	1725	1681	1681
   q8	3137	3190	3207	3190
   q9	8163	8151	8179	8151
   q10	6074	3645	3646	3645
   q11	508	425	433	425
   q12	690	546	537	537
   q13	10365	3035	3055	3035
   q14	269	250	257	250
   q15	535	501	496	496
   q16	509	466	481	466
   q17	1696	1673	1670	1670
   q18	7811	7467	7538	7467
   q19	1655	1645	1631	1631
   q20	2110	1914	1891	1891
   q21	4795	4607	4581	4581
   q22	508	467	445	445
   Total cold run time: 65314 ms
   Total hot run time: 53685 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] [fix](function) function DATE_FORMAT get wrong result [doris]

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

   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)


-- 
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] [fix](function) function DATE_FORMAT get wrong result [doris]

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

   
   Load test result on machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   ```
   Load test result on commit 23ad8e512dcdd56d5112c60ca1bcf842ad1cb87a with default session variables
   Stream load json:         19 seconds loaded 2358488459 Bytes, about 118 MB/s
   Stream load orc:          59 seconds loaded 1101869774 Bytes, about 17 MB/s
   Stream load parquet:      31 seconds loaded 861443392 Bytes, about 26 MB/s
   Insert into select:       18.2 seconds inserted 10000000 Rows, about 549K ops/s
   ```
   


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

To unsubscribe, e-mail: commits-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] [fix](function) function DATE_FORMAT get wrong result [doris]

Posted by "felixwluo (via GitHub)" <gi...@apache.org>.
felixwluo closed pull request #31598: [fix](function) function DATE_FORMAT get wrong result
URL: https://github.com/apache/doris/pull/31598


-- 
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] [fix](function) function DATE_FORMAT get wrong result [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 169840 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 45686a0c63d841bbca90f2e68a4e6ad5798e3297, data reload: false
   
   query1	931	385	338	338
   query2	6525	1764	1742	1742
   query3	6700	214	210	210
   query4	23369	20484	20727	20484
   query5	4246	368	360	360
   query6	256	169	178	169
   query7	4610	307	295	295
   query8	265	193	193	193
   query9	8463	2250	2232	2232
   query10	418	218	223	218
   query11	14663	14138	14322	14138
   query12	131	83	79	79
   query13	1842	433	446	433
   query14	8649	6717	6591	6591
   query15	206	183	185	183
   query16	7079	268	258	258
   query17	1031	521	503	503
   query18	1906	276	262	262
   query19	190	156	148	148
   query20	85	83	91	83
   query21	201	125	115	115
   query22	4971	4755	4756	4755
   query23	30599	29941	29878	29878
   query24	11053	3117	3135	3117
   query25	614	362	344	344
   query26	1448	157	162	157
   query27	2977	325	321	321
   query28	6916	1836	1823	1823
   query29	1069	564	554	554
   query30	288	134	139	134
   query31	846	680	697	680
   query32	94	58	57	57
   query33	720	232	216	216
   query34	1046	486	486	486
   query35	858	756	772	756
   query36	932	839	834	834
   query37	122	63	60	60
   query38	3128	2986	2996	2986
   query39	1315	1275	1257	1257
   query40	275	104	99	99
   query41	42	37	36	36
   query42	96	99	97	97
   query43	451	418	414	414
   query44	1075	692	715	692
   query45	186	192	176	176
   query46	1034	805	782	782
   query47	1546	1380	1424	1380
   query48	417	340	345	340
   query49	1088	300	293	293
   query50	771	374	389	374
   query51	4315	4311	4320	4311
   query52	98	93	91	91
   query53	338	263	275	263
   query54	270	219	234	219
   query55	85	83	85	83
   query56	220	201	206	201
   query57	931	892	914	892
   query58	212	191	193	191
   query59	2184	2002	1925	1925
   query60	244	215	219	215
   query61	90	88	88	88
   query62	584	371	349	349
   query63	283	269	258	258
   query64	5745	3034	3160	3034
   query65	3257	3213	3202	3202
   query66	1106	336	322	322
   query67	14258	14225	14207	14207
   query68	4962	557	574	557
   query69	520	378	399	378
   query70	1219	1226	1264	1226
   query71	353	248	248	248
   query72	6345	2827	2701	2701
   query73	754	329	326	326
   query74	6339	5960	6038	5960
   query75	3079	2471	2398	2398
   query76	3108	1060	1187	1060
   query77	363	240	238	238
   query78	8968	8400	8437	8400
   query79	1335	522	527	522
   query80	1114	353	361	353
   query81	461	192	200	192
   query82	940	84	89	84
   query83	236	125	126	125
   query84	277	77	78	77
   query85	1195	356	352	352
   query86	383	304	292	292
   query87	3311	3123	3096	3096
   query88	2764	2353	2331	2331
   query89	401	325	341	325
   query90	1913	173	170	170
   query91	157	124	129	124
   query92	55	49	52	49
   query93	1143	528	503	503
   query94	1231	178	186	178
   query95	439	338	354	338
   query96	572	267	266	266
   query97	4224	4157	4177	4157
   query98	216	205	196	196
   query99	1085	635	684	635
   Total cold run time: 261425 ms
   Total hot run time: 169840 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] [fix](function) function DATE_FORMAT get wrong result [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 31.54 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 23ad8e512dcdd56d5112c60ca1bcf842ad1cb87a, data reload: false
   
   query1	0.04	0.04	0.04
   query2	0.05	0.02	0.02
   query3	0.23	0.06	0.06
   query4	1.67	0.10	0.10
   query5	0.52	0.52	0.51
   query6	1.34	0.66	0.68
   query7	0.02	0.02	0.01
   query8	0.04	0.03	0.02
   query9	0.57	0.50	0.52
   query10	0.55	0.56	0.58
   query11	0.12	0.10	0.10
   query12	0.12	0.10	0.10
   query13	0.64	0.61	0.60
   query14	0.80	0.80	0.80
   query15	0.84	0.84	0.82
   query16	0.36	0.37	0.39
   query17	0.98	0.99	1.00
   query18	0.26	0.24	0.24
   query19	1.82	1.71	1.70
   query20	0.02	0.01	0.01
   query21	15.40	0.67	0.62
   query22	2.78	3.20	2.06
   query23	17.88	0.96	1.02
   query24	2.48	0.48	0.19
   query25	0.25	0.14	0.04
   query26	0.15	0.14	0.13
   query27	0.05	0.03	0.03
   query28	12.30	0.84	0.82
   query29	12.53	3.26	3.22
   query30	0.55	0.51	0.47
   query31	2.79	0.35	0.36
   query32	3.35	0.49	0.48
   query33	3.20	3.20	3.22
   query34	15.37	4.72	4.74
   query35	4.77	4.74	4.72
   query36	1.14	1.07	1.06
   query37	0.07	0.05	0.05
   query38	0.04	0.03	0.03
   query39	0.02	0.01	0.01
   query40	0.16	0.15	0.13
   query41	0.08	0.02	0.01
   query42	0.02	0.01	0.01
   query43	0.02	0.02	0.02
   Total cold run time: 106.39 s
   Total hot run time: 31.54 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] [fix](function) function DATE_FORMAT get wrong result [doris]

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

   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] [fix](function) function DATE_FORMAT get wrong result [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 31.82 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 45686a0c63d841bbca90f2e68a4e6ad5798e3297, data reload: false
   
   query1	0.04	0.04	0.03
   query2	0.06	0.02	0.02
   query3	0.22	0.05	0.06
   query4	1.67	0.10	0.10
   query5	0.52	0.51	0.52
   query6	1.24	0.66	0.67
   query7	0.01	0.01	0.01
   query8	0.04	0.03	0.03
   query9	0.55	0.52	0.51
   query10	0.56	0.58	0.56
   query11	0.12	0.09	0.10
   query12	0.12	0.10	0.11
   query13	0.64	0.61	0.61
   query14	0.81	0.80	0.81
   query15	0.83	0.82	0.81
   query16	0.36	0.37	0.38
   query17	0.98	1.01	0.98
   query18	0.25	0.24	0.25
   query19	1.78	1.68	1.75
   query20	0.02	0.01	0.01
   query21	15.40	0.67	0.65
   query22	3.08	4.22	2.14
   query23	17.56	1.07	0.93
   query24	2.17	0.56	0.37
   query25	0.29	0.06	0.04
   query26	0.18	0.15	0.14
   query27	0.03	0.03	0.03
   query28	12.10	0.88	0.83
   query29	12.52	3.26	3.19
   query30	0.59	0.57	0.54
   query31	2.78	0.35	0.36
   query32	3.35	0.48	0.48
   query33	3.20	3.19	3.22
   query34	15.38	4.74	4.72
   query35	4.74	4.74	4.75
   query36	1.12	1.06	1.06
   query37	0.06	0.04	0.04
   query38	0.04	0.03	0.02
   query39	0.02	0.02	0.02
   query40	0.17	0.13	0.13
   query41	0.07	0.01	0.01
   query42	0.02	0.01	0.02
   query43	0.03	0.02	0.02
   Total cold run time: 105.72 s
   Total hot run time: 31.82 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