Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[feature]Support TimeLiteral #47177

Closed
wants to merge 11 commits into from
Closed

[feature]Support TimeLiteral #47177

wants to merge 11 commits into from

Conversation

koarz
Copy link
Contributor

@koarz koarz commented Jan 17, 2025

What problem does this PR solve?

Issue Number: close #xxx

Related PR: #xxx

Problem Summary:
Support TimeLiteral

Release note

None

Check List (For Author)

  • Test

    • 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
  • Behavior changed:

    • No.
    • Yes.
  • Does this need documentation?

    • No.
    • Yes.

Check List (For Reviewer who merge this PR)

  • Confirm the release note
  • Confirm test cases
  • Confirm document
  • Add branch pick label

@hello-stephen
Copy link
Contributor

Thank you for your contribution to Apache Doris.
Don't know what should be done next? See 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?

@koarz
Copy link
Contributor Author

koarz commented Jan 17, 2025

run buildall

@koarz koarz changed the title [function]Support Fuction Time [feature](function) Support Fuction Time Jan 17, 2025
@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 41.51% (10820/26066)
Line Coverage: 31.91% (91411/286503)
Region Coverage: 31.06% (46842/150807)
Branch Coverage: 27.15% (23722/87360)
Coverage Report: http://coverage.selectdb-in.cc/coverage/d2aeea3b286f0df552bab2bd16c1ee8a60655135_d2aeea3b286f0df552bab2bd16c1ee8a60655135/report/index.html

@koarz
Copy link
Contributor Author

koarz commented Jan 17, 2025

run buildall

@doris-robot
Copy link

TPC-H: Total hot run time: 32629 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 949ccb6432cf8b374d454120623c113dee3de0f9, data reload: false

------ Round 1 ----------------------------------
q1	17618	5583	5390	5390
q2	2050	298	165	165
q3	10429	1241	748	748
q4	10220	978	537	537
q5	7541	2406	2171	2171
q6	195	161	134	134
q7	896	776	622	622
q8	9242	1372	1165	1165
q9	5351	4941	4883	4883
q10	6849	2317	1925	1925
q11	472	272	265	265
q12	357	381	224	224
q13	17762	3661	3094	3094
q14	237	225	218	218
q15	516	459	460	459
q16	631	624	599	599
q17	582	875	342	342
q18	7006	6649	6567	6567
q19	1215	961	563	563
q20	323	333	199	199
q21	3017	2212	2042	2042
q22	363	339	317	317
Total cold run time: 102872 ms
Total hot run time: 32629 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5480	5509	5481	5481
q2	241	335	248	248
q3	2262	2654	2338	2338
q4	1493	1872	1417	1417
q5	4364	4767	4735	4735
q6	174	155	125	125
q7	2075	1969	1856	1856
q8	2644	2843	2669	2669
q9	7278	7203	7253	7203
q10	2996	3229	2796	2796
q11	614	529	503	503
q12	699	758	639	639
q13	3507	3951	3325	3325
q14	288	292	266	266
q15	509	471	470	470
q16	661	688	653	653
q17	1238	1727	1242	1242
q18	7653	7613	7294	7294
q19	829	885	1198	885
q20	1995	2050	1950	1950
q21	5822	5259	5167	5167
q22	595	654	578	578
Total cold run time: 53417 ms
Total hot run time: 51840 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 188123 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 949ccb6432cf8b374d454120623c113dee3de0f9, data reload: false

query1	989	385	366	366
query2	6513	2085	2001	2001
query3	6790	235	225	225
query4	33680	23448	23298	23298
query5	4339	602	484	484
query6	276	197	190	190
query7	4612	486	303	303
query8	277	239	219	219
query9	9511	2573	2575	2573
query10	478	327	268	268
query11	17872	15185	14993	14993
query12	155	112	110	110
query13	1653	504	409	409
query14	9762	6539	6715	6539
query15	224	188	198	188
query16	7620	630	454	454
query17	1593	696	542	542
query18	1757	379	297	297
query19	204	184	151	151
query20	124	109	111	109
query21	213	116	106	106
query22	4275	4444	4364	4364
query23	33969	33042	33135	33042
query24	6880	2337	2351	2337
query25	488	475	385	385
query26	1216	273	157	157
query27	2411	458	325	325
query28	5590	2417	2389	2389
query29	703	541	446	446
query30	231	181	160	160
query31	965	886	839	839
query32	86	61	64	61
query33	512	350	300	300
query34	731	859	523	523
query35	792	827	742	742
query36	986	998	968	968
query37	118	95	78	78
query38	4362	4148	4011	4011
query39	1620	1385	1392	1385
query40	210	114	99	99
query41	58	51	54	51
query42	128	103	103	103
query43	513	523	504	504
query44	1263	806	795	795
query45	178	174	160	160
query46	861	1035	648	648
query47	1814	1815	1765	1765
query48	385	396	308	308
query49	786	492	415	415
query50	620	647	420	420
query51	6942	6997	6870	6870
query52	104	101	92	92
query53	227	257	184	184
query54	496	511	411	411
query55	84	79	81	79
query56	273	265	252	252
query57	1148	1173	1096	1096
query58	257	246	246	246
query59	3185	3158	2934	2934
query60	281	292	277	277
query61	118	121	120	120
query62	821	721	670	670
query63	225	193	185	185
query64	4354	1049	662	662
query65	3251	3190	3172	3172
query66	1080	424	302	302
query67	15816	15763	15411	15411
query68	2328	818	544	544
query69	434	296	262	262
query70	1210	1128	1135	1128
query71	326	299	256	256
query72	5831	3846	3928	3846
query73	618	745	357	357
query74	10187	8984	8998	8984
query75	3155	3191	2680	2680
query76	2646	1241	768	768
query77	474	374	280	280
query78	10049	10005	9286	9286
query79	2785	791	631	631
query80	1656	526	465	465
query81	574	279	242	242
query82	356	153	124	124
query83	262	182	155	155
query84	248	90	73	73
query85	767	359	306	306
query86	475	312	300	300
query87	4406	4551	4463	4463
query88	4731	2174	2130	2130
query89	387	328	299	299
query90	1732	190	192	190
query91	146	144	110	110
query92	71	60	56	56
query93	2730	843	539	539
query94	744	403	330	330
query95	346	267	261	261
query96	493	597	287	287
query97	2777	2821	2753	2753
query98	232	201	211	201
query99	1285	1376	1249	1249
Total cold run time: 284516 ms
Total hot run time: 188123 ms

@doris-robot
Copy link

ClickBench: Total hot run time: 30.97 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 949ccb6432cf8b374d454120623c113dee3de0f9, data reload: false

query1	0.03	0.03	0.03
query2	0.08	0.03	0.03
query3	0.24	0.07	0.07
query4	1.61	0.11	0.10
query5	0.41	0.44	0.43
query6	1.16	0.66	0.65
query7	0.02	0.01	0.02
query8	0.04	0.04	0.03
query9	0.58	0.49	0.51
query10	0.54	0.58	0.55
query11	0.14	0.10	0.10
query12	0.14	0.11	0.12
query13	0.60	0.61	0.62
query14	2.73	2.81	2.74
query15	0.90	0.82	0.83
query16	0.38	0.39	0.39
query17	1.00	1.06	1.00
query18	0.23	0.22	0.21
query19	1.96	1.83	2.02
query20	0.01	0.02	0.01
query21	15.36	0.93	0.59
query22	0.76	0.95	0.59
query23	15.28	1.42	0.64
query24	2.61	1.21	1.25
query25	0.18	0.08	0.21
query26	0.38	0.14	0.14
query27	0.06	0.06	0.06
query28	13.75	1.03	0.43
query29	12.64	3.95	3.30
query30	0.25	0.08	0.06
query31	2.84	0.60	0.38
query32	3.23	0.54	0.46
query33	3.07	3.07	3.00
query34	16.63	5.13	4.50
query35	4.51	4.56	4.52
query36	0.62	0.49	0.50
query37	0.09	0.06	0.06
query38	0.05	0.04	0.04
query39	0.04	0.03	0.02
query40	0.18	0.13	0.12
query41	0.08	0.02	0.02
query42	0.03	0.02	0.02
query43	0.04	0.03	0.03
Total cold run time: 105.48 s
Total hot run time: 30.97 s

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 41.51% (10821/26066)
Line Coverage: 31.91% (91411/286503)
Region Coverage: 31.06% (46839/150807)
Branch Coverage: 27.15% (23720/87360)
Coverage Report: http://coverage.selectdb-in.cc/coverage/949ccb6432cf8b374d454120623c113dee3de0f9_949ccb6432cf8b374d454120623c113dee3de0f9/report/index.html

@koarz
Copy link
Contributor Author

koarz commented Jan 20, 2025

run buildall

@koarz
Copy link
Contributor Author

koarz commented Jan 20, 2025

run buildall

@koarz
Copy link
Contributor Author

koarz commented Jan 21, 2025

run buildall

@koarz
Copy link
Contributor Author

koarz commented Jan 21, 2025

run buildall

@koarz
Copy link
Contributor Author

koarz commented Jan 21, 2025

run buildall

@doris-robot
Copy link

TPC-H: Total hot run time: 32408 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit de1a351fc851441eddf496d81da79b19f53ad7e5, data reload: false

------ Round 1 ----------------------------------
q1	17580	5494	5428	5428
q2	2057	316	179	179
q3	10469	1257	741	741
q4	10224	1013	537	537
q5	7613	2433	2208	2208
q6	201	164	132	132
q7	925	759	604	604
q8	9249	1406	1197	1197
q9	5267	4980	4963	4963
q10	6842	2349	1886	1886
q11	476	268	262	262
q12	341	357	216	216
q13	17786	3722	3117	3117
q14	230	232	207	207
q15	535	481	461	461
q16	651	619	598	598
q17	575	878	335	335
q18	7011	6617	6327	6327
q19	4286	1087	533	533
q20	303	316	179	179
q21	2777	2148	1996	1996
q22	371	347	302	302
Total cold run time: 105769 ms
Total hot run time: 32408 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5703	5528	5506	5506
q2	241	330	232	232
q3	2248	2714	2283	2283
q4	1442	1849	1412	1412
q5	4318	4784	4853	4784
q6	178	168	125	125
q7	2078	1974	1837	1837
q8	2658	2889	2727	2727
q9	7375	7272	7303	7272
q10	2994	3283	2664	2664
q11	579	522	487	487
q12	674	782	615	615
q13	3545	3868	3237	3237
q14	305	316	291	291
q15	520	487	482	482
q16	645	706	666	666
q17	1222	1783	1275	1275
q18	7835	7412	7425	7412
q19	811	1181	1055	1055
q20	2016	2043	1874	1874
q21	5743	5024	5034	5024
q22	590	591	572	572
Total cold run time: 53720 ms
Total hot run time: 51832 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 194732 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit de1a351fc851441eddf496d81da79b19f53ad7e5, data reload: false

query1	1330	978	942	942
query2	6308	2109	1956	1956
query3	11104	4424	4466	4424
query4	60723	29236	22998	22998
query5	5554	620	450	450
query6	439	202	185	185
query7	5592	535	293	293
query8	339	253	237	237
query9	8192	2611	2602	2602
query10	461	321	250	250
query11	17726	15156	15445	15156
query12	165	112	108	108
query13	1485	543	411	411
query14	11546	6927	7412	6927
query15	212	202	188	188
query16	7193	652	473	473
query17	1143	709	574	574
query18	1888	416	335	335
query19	195	192	163	163
query20	122	110	109	109
query21	204	135	107	107
query22	4427	4664	4686	4664
query23	34106	33710	33405	33405
query24	5567	2459	2269	2269
query25	469	461	400	400
query26	635	229	153	153
query27	1744	467	341	341
query28	4070	2543	2472	2472
query29	571	541	429	429
query30	226	200	157	157
query31	893	953	843	843
query32	78	60	61	60
query33	464	372	317	317
query34	755	869	526	526
query35	815	850	787	787
query36	1020	1061	977	977
query37	130	106	87	87
query38	4191	4267	4352	4267
query39	1539	1465	1451	1451
query40	203	121	96	96
query41	51	52	50	50
query42	128	108	104	104
query43	525	523	503	503
query44	1323	855	802	802
query45	183	177	176	176
query46	906	1083	671	671
query47	1931	1924	1874	1874
query48	410	420	327	327
query49	704	515	388	388
query50	647	673	401	401
query51	7010	6884	6957	6884
query52	104	112	96	96
query53	234	264	186	186
query54	479	502	429	429
query55	84	81	86	81
query56	277	252	242	242
query57	1178	1196	1189	1189
query58	233	237	240	237
query59	3115	3030	2835	2835
query60	279	267	261	261
query61	120	120	113	113
query62	694	734	675	675
query63	227	193	186	186
query64	1258	1063	714	714
query65	3246	3159	3148	3148
query66	703	408	304	304
query67	15945	15754	15764	15754
query68	5044	813	514	514
query69	498	301	265	265
query70	1173	1152	1117	1117
query71	404	285	256	256
query72	6015	3928	3853	3853
query73	819	769	350	350
query74	8980	8911	8747	8747
query75	3220	3136	2686	2686
query76	3816	1180	788	788
query77	510	379	280	280
query78	10092	10485	9616	9616
query79	2768	843	600	600
query80	647	540	460	460
query81	499	281	240	240
query82	228	147	125	125
query83	169	171	150	150
query84	299	97	77	77
query85	758	355	307	307
query86	379	331	296	296
query87	4353	4515	4426	4426
query88	4136	2164	2138	2138
query89	402	322	291	291
query90	1650	185	189	185
query91	135	143	120	120
query92	69	58	60	58
query93	2043	869	523	523
query94	683	421	311	311
query95	320	268	255	255
query96	504	611	291	291
query97	2829	2834	2716	2716
query98	227	202	196	196
query99	1288	1373	1276	1276
Total cold run time: 310775 ms
Total hot run time: 194732 ms

@doris-robot
Copy link

ClickBench: Total hot run time: 31.02 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit de1a351fc851441eddf496d81da79b19f53ad7e5, data reload: false

query1	0.04	0.03	0.03
query2	0.08	0.05	0.04
query3	0.24	0.06	0.06
query4	1.64	0.09	0.08
query5	0.44	0.40	0.40
query6	1.16	0.67	0.67
query7	0.02	0.02	0.02
query8	0.05	0.05	0.04
query9	0.55	0.48	0.50
query10	0.56	0.56	0.54
query11	0.17	0.12	0.12
query12	0.18	0.13	0.13
query13	0.61	0.60	0.60
query14	2.83	2.73	2.85
query15	0.91	0.84	0.84
query16	0.37	0.38	0.38
query17	1.03	1.04	1.02
query18	0.20	0.19	0.20
query19	1.85	2.00	1.75
query20	0.02	0.01	0.02
query21	15.35	0.98	0.69
query22	0.79	0.79	0.70
query23	14.94	1.49	0.68
query24	2.21	0.37	0.22
query25	0.16	0.09	0.09
query26	0.28	0.19	0.18
query27	0.08	0.08	0.08
query28	13.38	1.29	0.56
query29	12.65	4.15	3.43
query30	0.25	0.08	0.06
query31	2.83	0.62	0.41
query32	3.23	0.59	0.50
query33	3.05	2.99	3.07
query34	16.50	5.27	4.58
query35	4.75	4.65	4.64
query36	0.82	0.47	0.47
query37	0.20	0.17	0.16
query38	0.17	0.15	0.15
query39	0.05	0.04	0.04
query40	0.18	0.13	0.12
query41	0.09	0.06	0.05
query42	0.06	0.05	0.06
query43	0.06	0.05	0.04
Total cold run time: 105.03 s
Total hot run time: 31.02 s

@koarz
Copy link
Contributor Author

koarz commented Jan 21, 2025

run buildall

@doris-robot
Copy link

TPC-H: Total hot run time: 32177 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 1bd9010b49b87aa410ac8e5e6865f043b9dc25f7, data reload: false

------ Round 1 ----------------------------------
q1	17840	5633	5431	5431
q2	2052	303	167	167
q3	10660	1227	734	734
q4	10282	952	508	508
q5	8507	2349	2126	2126
q6	190	168	133	133
q7	902	754	623	623
q8	9246	1351	1143	1143
q9	5227	4861	4885	4861
q10	6825	2326	1857	1857
q11	479	290	261	261
q12	358	361	224	224
q13	17784	3772	3125	3125
q14	226	238	205	205
q15	530	464	479	464
q16	655	622	581	581
q17	588	850	323	323
q18	6982	6580	6259	6259
q19	3149	999	585	585
q20	312	316	191	191
q21	2754	2231	2069	2069
q22	361	333	307	307
Total cold run time: 105909 ms
Total hot run time: 32177 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5671	5449	5467	5449
q2	244	324	238	238
q3	2258	2642	2338	2338
q4	1381	1785	1423	1423
q5	4294	4739	4738	4738
q6	180	163	127	127
q7	2025	1948	1809	1809
q8	2618	2837	2699	2699
q9	7272	7145	7262	7145
q10	2992	3278	2754	2754
q11	560	512	482	482
q12	655	722	585	585
q13	3513	3918	3286	3286
q14	283	289	266	266
q15	512	494	471	471
q16	638	722	641	641
q17	1217	1735	1278	1278
q18	7764	7580	7388	7388
q19	839	990	1134	990
q20	1992	2006	1925	1925
q21	5692	5104	4932	4932
q22	584	607	570	570
Total cold run time: 53184 ms
Total hot run time: 51534 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 194237 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 1bd9010b49b87aa410ac8e5e6865f043b9dc25f7, data reload: false

query1	1312	959	940	940
query2	6277	2004	2045	2004
query3	10995	4553	4698	4553
query4	32686	23534	22791	22791
query5	3607	587	456	456
query6	286	186	182	182
query7	3980	485	298	298
query8	273	233	215	215
query9	9352	2568	2582	2568
query10	453	312	248	248
query11	17694	15132	15020	15020
query12	139	109	102	102
query13	1553	505	385	385
query14	8935	7304	7315	7304
query15	255	225	191	191
query16	7439	624	466	466
query17	1530	746	563	563
query18	1596	375	312	312
query19	211	184	165	165
query20	122	116	113	113
query21	208	125	124	124
query22	4348	4711	4319	4319
query23	34159	33619	33400	33400
query24	6496	2263	2263	2263
query25	477	469	405	405
query26	786	270	152	152
query27	2067	470	331	331
query28	5220	2495	2457	2457
query29	627	566	464	464
query30	225	194	160	160
query31	958	887	854	854
query32	82	61	59	59
query33	516	391	311	311
query34	780	862	526	526
query35	804	864	779	779
query36	1028	1047	1007	1007
query37	131	108	85	85
query38	4231	4205	4331	4205
query39	1509	1464	1474	1464
query40	207	111	99	99
query41	58	54	53	53
query42	130	106	102	102
query43	511	516	492	492
query44	1320	798	813	798
query45	193	177	166	166
query46	870	1053	661	661
query47	1892	1919	1845	1845
query48	390	412	321	321
query49	752	501	400	400
query50	663	670	400	400
query51	7040	6918	6949	6918
query52	103	103	94	94
query53	233	264	186	186
query54	490	506	430	430
query55	82	81	82	81
query56	256	259	252	252
query57	1220	1217	1125	1125
query58	245	229	242	229
query59	3099	3160	3122	3122
query60	287	278	259	259
query61	120	124	157	124
query62	776	710	688	688
query63	231	188	194	188
query64	3444	1023	660	660
query65	3254	3148	3165	3148
query66	781	397	297	297
query67	15922	15769	15456	15456
query68	5835	807	518	518
query69	491	293	264	264
query70	1167	1126	1080	1080
query71	389	285	303	285
query72	6020	3845	3883	3845
query73	634	750	357	357
query74	10030	8892	8864	8864
query75	3192	3130	2674	2674
query76	3172	1168	777	777
query77	465	369	278	278
query78	10037	10077	9655	9655
query79	3430	760	587	587
query80	581	553	438	438
query81	502	284	234	234
query82	592	151	126	126
query83	187	238	158	158
query84	254	97	77	77
query85	789	347	315	315
query86	390	317	290	290
query87	4601	4478	4282	4282
query88	4648	2180	2148	2148
query89	414	330	282	282
query90	1812	192	199	192
query91	139	133	107	107
query92	68	56	55	55
query93	1605	867	532	532
query94	686	410	294	294
query95	347	259	251	251
query96	503	629	291	291
query97	2811	2881	2703	2703
query98	226	198	191	191
query99	1279	1361	1252	1252
Total cold run time: 285212 ms
Total hot run time: 194237 ms

@doris-robot
Copy link

ClickBench: Total hot run time: 31.1 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 1bd9010b49b87aa410ac8e5e6865f043b9dc25f7, data reload: false

query1	0.03	0.03	0.03
query2	0.09	0.05	0.04
query3	0.23	0.05	0.06
query4	1.65	0.07	0.08
query5	0.42	0.41	0.41
query6	1.15	0.65	0.66
query7	0.02	0.01	0.01
query8	0.05	0.05	0.05
query9	0.54	0.50	0.50
query10	0.55	0.56	0.56
query11	0.15	0.12	0.12
query12	0.16	0.12	0.13
query13	0.60	0.59	0.59
query14	2.72	2.83	2.80
query15	0.92	0.83	0.84
query16	0.38	0.37	0.38
query17	1.04	1.07	1.08
query18	0.18	0.19	0.19
query19	1.96	1.89	2.05
query20	0.02	0.02	0.02
query21	15.35	0.96	0.67
query22	0.79	0.78	0.69
query23	15.02	1.52	0.69
query24	1.72	0.44	0.26
query25	0.14	0.09	0.10
query26	0.29	0.18	0.18
query27	0.08	0.08	0.08
query28	13.42	1.29	0.55
query29	12.62	4.12	3.38
query30	0.24	0.09	0.05
query31	2.84	0.62	0.39
query32	3.22	0.57	0.48
query33	2.99	3.02	3.05
query34	16.22	5.14	4.58
query35	4.51	4.57	4.53
query36	0.62	0.49	0.48
query37	0.20	0.16	0.16
query38	0.17	0.15	0.16
query39	0.06	0.05	0.04
query40	0.18	0.13	0.12
query41	0.10	0.05	0.06
query42	0.06	0.06	0.05
query43	0.05	0.04	0.05
Total cold run time: 103.75 s
Total hot run time: 31.1 s

@koarz
Copy link
Contributor Author

koarz commented Jan 21, 2025

run buildall

@doris-robot
Copy link

TPC-H: Total hot run time: 32734 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 3d332d8b41f96c51de3137f055817ef436133274, data reload: false

------ Round 1 ----------------------------------
q1	17960	5600	5538	5538
q2	2054	314	189	189
q3	10639	1319	739	739
q4	10301	974	528	528
q5	8954	2432	2187	2187
q6	199	165	132	132
q7	940	752	610	610
q8	9249	1407	1227	1227
q9	5408	4899	4927	4899
q10	6849	2337	1974	1974
q11	474	274	270	270
q12	343	365	217	217
q13	17774	3750	3120	3120
q14	247	222	203	203
q15	528	491	459	459
q16	623	627	586	586
q17	592	879	333	333
q18	7257	6528	6414	6414
q19	2085	977	567	567
q20	322	318	188	188
q21	2908	2248	2036	2036
q22	371	323	318	318
Total cold run time: 106077 ms
Total hot run time: 32734 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5661	5573	5541	5541
q2	238	327	237	237
q3	2273	2672	2347	2347
q4	1424	1914	1389	1389
q5	4346	4752	4891	4752
q6	176	161	127	127
q7	2120	1998	1793	1793
q8	2628	2781	2710	2710
q9	7266	7272	7233	7233
q10	2998	3248	2757	2757
q11	584	501	495	495
q12	691	787	620	620
q13	3516	3942	3286	3286
q14	273	307	284	284
q15	511	480	459	459
q16	651	691	661	661
q17	1249	1779	1261	1261
q18	7817	7516	7241	7241
q19	826	1174	1055	1055
q20	1991	2002	1892	1892
q21	5753	5335	4842	4842
q22	587	582	529	529
Total cold run time: 53579 ms
Total hot run time: 51511 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 186990 ms
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
TPC-DS sf100 test result on commit 3d332d8b41f96c51de3137f055817ef436133274, data reload: false

query1	950	380	375	375
query2	6540	1999	1949	1949
query3	6794	217	219	217
query4	33480	23595	23007	23007
query5	4428	622	443	443
query6	298	201	184	184
query7	4602	491	307	307
query8	319	241	237	237
query9	9305	2595	2589	2589
query10	465	316	247	247
query11	17723	15131	15274	15131
query12	165	106	113	106
query13	1663	507	391	391
query14	10800	6537	6876	6537
query15	240	205	183	183
query16	8097	640	468	468
query17	1623	751	571	571
query18	2129	415	298	298
query19	216	182	157	157
query20	128	115	113	113
query21	211	125	102	102
query22	4358	4363	4213	4213
query23	33946	32918	32859	32859
query24	6499	2392	2234	2234
query25	495	459	374	374
query26	1202	276	162	162
query27	2030	456	326	326
query28	5337	2436	2403	2403
query29	729	557	468	468
query30	232	188	156	156
query31	945	874	801	801
query32	91	62	57	57
query33	513	354	292	292
query34	790	829	515	515
query35	822	813	734	734
query36	984	1015	920	920
query37	114	103	76	76
query38	4184	4215	4058	4058
query39	1454	1391	1411	1391
query40	211	114	102	102
query41	60	52	51	51
query42	128	105	100	100
query43	494	527	470	470
query44	1304	801	806	801
query45	176	168	159	159
query46	872	1047	647	647
query47	1831	1809	1740	1740
query48	391	403	315	315
query49	791	518	400	400
query50	622	658	401	401
query51	6819	6918	6903	6903
query52	100	110	89	89
query53	230	259	196	196
query54	490	498	432	432
query55	85	79	83	79
query56	266	291	236	236
query57	1184	1161	1070	1070
query58	247	235	266	235
query59	3006	2987	2838	2838
query60	267	259	251	251
query61	130	116	127	116
query62	808	697	689	689
query63	229	193	193	193
query64	4607	997	679	679
query65	3228	3183	3170	3170
query66	1076	421	315	315
query67	15933	15374	15113	15113
query68	5413	838	524	524
query69	477	294	265	265
query70	1197	1035	1110	1035
query71	386	287	273	273
query72	5789	3858	3856	3856
query73	654	753	352	352
query74	10157	9246	9016	9016
query75	3146	3198	2712	2712
query76	3149	1181	777	777
query77	466	353	289	289
query78	10056	10036	9340	9340
query79	2755	789	598	598
query80	594	524	457	457
query81	526	281	240	240
query82	234	155	122	122
query83	178	179	161	161
query84	248	96	72	72
query85	807	345	296	296
query86	398	304	306	304
query87	4426	4522	4616	4522
query88	5056	2160	2157	2157
query89	393	337	288	288
query90	1952	191	193	191
query91	141	140	105	105
query92	67	64	53	53
query93	1879	868	529	529
query94	661	410	301	301
query95	345	261	254	254
query96	500	613	281	281
query97	2775	2875	2742	2742
query98	225	203	203	203
query99	1282	1372	1234	1234
Total cold run time: 286818 ms
Total hot run time: 186990 ms

@doris-robot
Copy link

ClickBench: Total hot run time: 30.58 s
machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 3d332d8b41f96c51de3137f055817ef436133274, data reload: false

query1	0.03	0.03	0.03
query2	0.07	0.03	0.03
query3	0.24	0.06	0.06
query4	1.62	0.10	0.10
query5	0.40	0.38	0.41
query6	1.15	0.65	0.64
query7	0.02	0.02	0.02
query8	0.04	0.03	0.03
query9	0.54	0.48	0.50
query10	0.56	0.56	0.55
query11	0.13	0.09	0.10
query12	0.14	0.11	0.11
query13	0.61	0.60	0.60
query14	2.78	2.73	2.71
query15	0.90	0.84	0.83
query16	0.39	0.38	0.38
query17	1.02	1.08	1.06
query18	0.22	0.20	0.20
query19	2.00	1.83	2.00
query20	0.01	0.02	0.01
query21	15.36	0.91	0.60
query22	0.76	0.85	0.74
query23	15.20	1.41	0.61
query24	3.35	0.87	1.17
query25	0.25	0.18	0.13
query26	0.27	0.15	0.14
query27	0.07	0.06	0.05
query28	13.98	0.98	0.44
query29	12.57	3.94	3.28
query30	0.25	0.09	0.06
query31	2.85	0.58	0.38
query32	3.22	0.55	0.46
query33	2.97	3.00	3.00
query34	16.65	5.06	4.40
query35	4.45	4.50	4.52
query36	0.63	0.49	0.47
query37	0.09	0.07	0.05
query38	0.04	0.04	0.04
query39	0.03	0.02	0.02
query40	0.16	0.13	0.13
query41	0.08	0.02	0.02
query42	0.04	0.02	0.02
query43	0.04	0.03	0.03
Total cold run time: 106.18 s
Total hot run time: 30.58 s

@koarz koarz changed the title [feature](function) Support Fuction Time [feature]Support TimeLiteral Jan 22, 2025
@koarz
Copy link
Contributor Author

koarz commented Jan 22, 2025

run buildall

@koarz koarz closed this Jan 22, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

3 participants