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.

Sign up for GitHub

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

Jump to bottom

[Feature](literal)Support TimeV2Literal #47319

Open
wants to merge 23 commits into
base: master
Choose a base branch
from
Open

[Feature](literal)Support TimeV2Literal #47319

wants to merge 23 commits into from
+1,288 −267

Conversation

koarz
Copy link
Contributor

@koarz koarz commented Jan 22, 2025

What problem does this PR solve?

Issue Number: close #xxx

Related PR: #xxx

Problem Summary:

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 22, 2025

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17624	5579	5363	5363
q2	2069	321	192	192
q3	10455	1241	747	747
q4	10214	981	522	522
q5	7612	2382	2170	2170
q6	197	171	136	136
q7	906	753	602	602
q8	9250	1384	1164	1164
q9	5159	4945	4927	4927
q10	6820	2332	1900	1900
q11	483	281	260	260
q12	338	367	209	209
q13	17778	3681	3045	3045
q14	239	231	214	214
q15	524	482	459	459
q16	620	619	572	572
q17	561	871	322	322
q18	7075	6617	6448	6448
q19	1633	965	540	540
q20	312	321	190	190
q21	2979	2168	2011	2011
q22	372	343	307	307
Total cold run time: 103220 ms
Total hot run time: 32300 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5528	5626	5537	5537
q2	242	334	235	235
q3	2255	2694	2351	2351
q4	1422	1862	1367	1367
q5	4334	4772	4627	4627
q6	164	162	127	127
q7	2087	1960	1860	1860
q8	2665	2811	2680	2680
q9	7384	7233	7293	7233
q10	3022	3289	2773	2773
q11	572	508	484	484
q12	647	755	557	557
q13	3514	3928	3257	3257
q14	281	302	280	280
q15	522	471	485	471
q16	666	696	650	650
q17	1228	1747	1315	1315
q18	7818	7623	7391	7391
q19	803	1020	1117	1020
q20	2032	2044	1939	1939
q21	5770	5164	4956	4956
q22	609	612	576	576
Total cold run time: 53565 ms
Total hot run time: 51686 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 195154 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 1f40fb9cf6fb7f759cc4bc0668f6ff76f2e61429, data reload: false

query1	1311	973	940	940
query2	6323	2065	2012	2012
query3	10959	4618	4472	4472
query4	60748	31352	23004	23004
query5	5605	623	478	478
query6	439	202	188	188
query7	5567	518	310	310
query8	323	237	221	221
query9	8217	2669	2700	2669
query10	452	311	262	262
query11	17492	15475	15648	15475
query12	163	108	108	108
query13	1440	549	423	423
query14	11075	7350	6697	6697
query15	214	201	197	197
query16	7214	685	492	492
query17	1109	736	573	573
query18	1853	407	310	310
query19	200	190	160	160
query20	116	124	117	117
query21	212	123	104	104
query22	4541	4758	4439	4439
query23	34136	33321	33494	33321
query24	5568	2358	2375	2358
query25	513	517	440	440
query26	648	295	165	165
query27	1612	516	336	336
query28	4230	2506	2482	2482
query29	560	587	421	421
query30	220	189	156	156
query31	937	925	874	874
query32	67	58	58	58
query33	429	361	308	308
query34	771	862	529	529
query35	831	826	756	756
query36	1016	1059	964	964
query37	130	115	80	80
query38	4391	4356	4341	4341
query39	1484	1448	1446	1446
query40	220	123	105	105
query41	52	49	54	49
query42	118	106	99	99
query43	518	540	502	502
query44	1364	837	836	836
query45	182	179	170	170
query46	923	1079	670	670
query47	1872	1939	1822	1822
query48	401	425	356	356
query49	713	523	400	400
query50	716	700	407	407
query51	7141	7110	7057	7057
query52	106	100	95	95
query53	238	262	195	195
query54	501	519	441	441
query55	85	77	78	77
query56	278	286	277	277
query57	1278	1217	1101	1101
query58	240	237	248	237
query59	3188	3237	2979	2979
query60	285	268	252	252
query61	121	119	118	118
query62	732	708	640	640
query63	229	196	192	192
query64	1320	1025	670	670
query65	3283	3150	3158	3150
query66	762	391	305	305
query67	15885	15598	15461	15461
query68	4130	857	533	533
query69	490	301	264	264
query70	1206	1138	1159	1138
query71	412	356	264	264
query72	6028	3881	3968	3881
query73	700	778	378	378
query74	10656	8840	8915	8840
query75	3259	3162	2676	2676
query76	3273	1202	810	810
query77	489	366	285	285
query78	10158	10281	9400	9400
query79	2749	828	612	612
query80	1682	549	530	530
query81	564	276	233	233
query82	347	149	127	127
query83	267	173	149	149
query84	288	105	74	74
query85	783	345	305	305
query86	420	325	288	288
query87	4368	4456	4463	4456
query88	3357	2246	2184	2184
query89	411	322	295	295
query90	1542	199	196	196
query91	135	142	117	117
query92	63	59	55	55
query93	1821	876	540	540
query94	697	386	296	296
query95	346	275	258	258
query96	489	633	285	285
query97	2819	2883	2781	2781
query98	231	197	199	197
query99	1290	1364	1358	1358
Total cold run time: 311337 ms
Total hot run time: 195154 ms

@doris-robot
Copy link

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

query1	0.03	0.03	0.03
query2	0.09	0.04	0.05
query3	0.23	0.06	0.05
query4	1.64	0.08	0.08
query5	0.42	0.39	0.39
query6	1.16	0.67	0.67
query7	0.02	0.02	0.02
query8	0.05	0.04	0.05
query9	0.56	0.49	0.49
query10	0.56	0.56	0.56
query11	0.16	0.12	0.11
query12	0.16	0.13	0.14
query13	0.60	0.60	0.60
query14	2.82	2.83	2.75
query15	0.91	0.83	0.84
query16	0.37	0.38	0.38
query17	1.08	1.06	1.05
query18	0.19	0.18	0.20
query19	1.92	1.88	2.07
query20	0.02	0.01	0.01
query21	15.36	0.98	0.65
query22	0.79	0.79	0.71
query23	14.97	1.43	0.69
query24	2.27	0.39	0.22
query25	0.14	0.08	0.08
query26	0.28	0.19	0.17
query27	0.08	0.08	0.08
query28	13.46	1.24	0.56
query29	12.69	4.08	3.39
query30	0.24	0.08	0.06
query31	2.83	0.61	0.39
query32	3.22	0.59	0.47
query33	3.00	3.00	3.03
query34	16.63	5.19	4.57
query35	4.57	4.55	4.56
query36	0.82	0.47	0.48
query37	0.20	0.17	0.16
query38	0.16	0.16	0.15
query39	0.05	0.04	0.04
query40	0.17	0.13	0.13
query41	0.10	0.06	0.06
query42	0.07	0.05	0.06
query43	0.05	0.05	0.04
Total cold run time: 105.14 s
Total hot run time: 30.98 s

@koarz
Copy link
Contributor Author

koarz commented Jan 22, 2025

run p0

1 similar comment
@koarz
Copy link
Contributor Author

koarz commented Jan 23, 2025

run p0

@koarz
Copy link
Contributor Author

koarz commented Jan 23, 2025

run buildall

@koarz
Copy link
Contributor Author

koarz commented Jan 23, 2025

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17951	5545	5434	5434
q2	2055	317	168	168
q3	10661	1276	744	744
q4	10293	972	546	546
q5	9372	2444	2189	2189
q6	206	169	138	138
q7	903	759	632	632
q8	9228	1323	1190	1190
q9	5982	4968	4878	4878
q10	6859	2318	1887	1887
q11	473	271	255	255
q12	351	369	227	227
q13	17778	3707	3162	3162
q14	243	245	209	209
q15	517	490	482	482
q16	638	620	598	598
q17	561	865	325	325
q18	7055	6529	6480	6480
q19	2154	961	572	572
q20	324	321	188	188
q21	2875	2276	2046	2046
q22	394	346	319	319
Total cold run time: 106873 ms
Total hot run time: 32669 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5724	5541	5579	5541
q2	238	336	235	235
q3	2272	2656	2287	2287
q4	1439	1803	1381	1381
q5	4358	4733	4962	4733
q6	176	163	126	126
q7	2067	1978	1854	1854
q8	2625	2801	2682	2682
q9	7226	7310	7131	7131
q10	2984	3308	2760	2760
q11	593	514	495	495
q12	688	765	636	636
q13	3557	3962	3310	3310
q14	292	309	284	284
q15	529	465	469	465
q16	657	687	639	639
q17	1210	1728	1225	1225
q18	7765	7465	7495	7465
q19	837	1168	1095	1095
q20	1986	2084	1900	1900
q21	5858	5323	4849	4849
q22	610	578	604	578
Total cold run time: 53691 ms
Total hot run time: 51671 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 184397 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 518d3307e8b03429c3449c21d91515816e537daa, data reload: false

query1	955	381	397	381
query2	6546	2012	2010	2010
query3	6791	211	218	211
query4	33680	23509	23535	23509
query5	4384	636	458	458
query6	297	200	196	196
query7	4600	507	318	318
query8	292	232	230	230
query9	9456	2595	2547	2547
query10	460	312	239	239
query11	17762	15135	14935	14935
query12	148	107	101	101
query13	1654	501	378	378
query14	10311	6361	6306	6306
query15	217	189	182	182
query16	7919	625	480	480
query17	1565	711	551	551
query18	2046	394	297	297
query19	214	174	161	161
query20	112	107	105	105
query21	205	119	102	102
query22	4277	4601	4146	4146
query23	34121	32724	32974	32724
query24	6523	2210	2260	2210
query25	459	439	376	376
query26	1088	232	152	152
query27	2050	453	337	337
query28	5378	2429	2420	2420
query29	545	500	455	455
query30	232	192	162	162
query31	961	865	741	741
query32	76	62	60	60
query33	512	349	294	294
query34	757	831	484	484
query35	798	820	746	746
query36	987	1013	954	954
query37	133	103	85	85
query38	4128	4075	4107	4075
query39	1459	1401	1404	1401
query40	212	115	101	101
query41	52	51	53	51
query42	141	99	96	96
query43	505	530	488	488
query44	1324	806	809	806
query45	184	174	163	163
query46	840	1022	636	636
query47	1841	1861	1799	1799
query48	390	385	308	308
query49	772	485	403	403
query50	634	664	394	394
query51	4169	4351	4110	4110
query52	109	103	92	92
query53	239	255	184	184
query54	484	474	418	418
query55	81	76	87	76
query56	263	263	268	263
query57	1162	1171	1113	1113
query58	253	232	237	232
query59	2853	3070	2945	2945
query60	274	268	249	249
query61	115	113	113	113
query62	803	724	666	666
query63	224	191	185	185
query64	4151	1010	685	685
query65	3216	3158	3130	3130
query66	1094	438	330	330
query67	15924	15559	15576	15559
query68	2376	822	542	542
query69	411	310	282	282
query70	1184	1114	1133	1114
query71	312	299	261	261
query72	4972	3835	3771	3771
query73	629	743	364	364
query74	9744	8886	8952	8886
query75	3127	3156	2658	2658
query76	2211	1214	761	761
query77	337	359	280	280
query78	10138	10353	9347	9347
query79	997	888	598	598
query80	734	602	447	447
query81	511	267	232	232
query82	1231	159	126	126
query83	249	176	157	157
query84	240	92	77	77
query85	817	347	306	306
query86	344	319	302	302
query87	4373	4417	4362	4362
query88	3262	2232	2183	2183
query89	406	331	294	294
query90	1638	194	190	190
query91	134	143	109	109
query92	61	56	57	56
query93	929	859	536	536
query94	520	404	293	293
query95	332	268	256	256
query96	488	612	274	274
query97	2804	2865	2751	2751
query98	217	206	200	200
query99	1288	1415	1268	1268
Total cold run time: 273423 ms
Total hot run time: 184397 ms

@doris-robot
Copy link

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

query1	0.04	0.03	0.03
query2	0.07	0.04	0.04
query3	0.25	0.07	0.06
query4	1.62	0.10	0.10
query5	0.41	0.42	0.39
query6	1.14	0.68	0.65
query7	0.02	0.02	0.01
query8	0.04	0.03	0.03
query9	0.58	0.52	0.51
query10	0.56	0.56	0.56
query11	0.14	0.10	0.11
query12	0.13	0.10	0.12
query13	0.61	0.59	0.61
query14	2.72	2.85	2.85
query15	0.91	0.83	0.83
query16	0.39	0.38	0.38
query17	1.09	1.06	1.07
query18	0.24	0.22	0.21
query19	1.98	1.77	2.02
query20	0.02	0.01	0.01
query21	15.37	0.90	0.57
query22	0.76	1.02	0.66
query23	15.78	1.53	0.58
query24	2.62	0.73	2.26
query25	0.17	0.18	0.06
query26	0.25	0.15	0.13
query27	0.05	0.05	0.05
query28	14.19	0.97	0.43
query29	12.62	3.91	3.20
query30	0.25	0.09	0.06
query31	2.85	0.60	0.40
query32	3.23	0.54	0.46
query33	2.95	3.01	3.08
query34	16.65	5.16	4.52
query35	4.58	4.58	4.56
query36	0.64	0.50	0.48
query37	0.10	0.06	0.06
query38	0.05	0.03	0.04
query39	0.03	0.02	0.02
query40	0.17	0.13	0.13
query41	0.08	0.02	0.02
query42	0.03	0.03	0.02
query43	0.03	0.03	0.03
Total cold run time: 106.41 s
Total hot run time: 30.49 s

@koarz
Copy link
Contributor Author

koarz commented Jan 25, 2025

run buildall

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 42.05% (10969/26083)
Line Coverage: 32.31% (92690/286839)
Region Coverage: 31.47% (47537/151055)
Branch Coverage: 27.51% (24079/87518)
Coverage Report: http://coverage.selectdb-in.cc/coverage/589606843828c8a7d376710ccd19e15f7dbe26b1_589606843828c8a7d376710ccd19e15f7dbe26b1/report/index.html

@koarz
Copy link
Contributor Author

koarz commented Jan 25, 2025

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17575	5485	5396	5396
q2	2058	299	166	166
q3	10617	1266	748	748
q4	10764	971	541	541
q5	9492	2391	2143	2143
q6	198	169	141	141
q7	898	763	627	627
q8	9240	1366	1218	1218
q9	5356	4737	4869	4737
q10	6822	2313	1881	1881
q11	488	291	258	258
q12	351	362	231	231
q13	17763	3675	3149	3149
q14	229	225	211	211
q15	527	461	469	461
q16	621	644	584	584
q17	570	864	329	329
q18	6928	6461	6430	6430
q19	1406	953	552	552
q20	319	329	194	194
q21	2874	2203	2018	2018
q22	361	345	300	300
Total cold run time: 105457 ms
Total hot run time: 32315 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5542	5488	5527	5488
q2	239	324	231	231
q3	2233	2610	2327	2327
q4	1415	1843	1362	1362
q5	4313	4732	4752	4732
q6	167	165	130	130
q7	2095	2011	1859	1859
q8	2644	2847	2741	2741
q9	7176	7197	7324	7197
q10	2994	3289	2794	2794
q11	567	505	491	491
q12	669	743	599	599
q13	3578	3970	3324	3324
q14	304	288	280	280
q15	517	505	471	471
q16	652	721	637	637
q17	1225	1754	1277	1277
q18	7651	7501	7200	7200
q19	811	1124	1066	1066
q20	2015	2025	1991	1991
q21	5901	5396	5086	5086
q22	606	613	559	559
Total cold run time: 53314 ms
Total hot run time: 51842 ms

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 42.06% (10971/26083)
Line Coverage: 32.33% (92734/286839)
Region Coverage: 31.48% (47555/151055)
Branch Coverage: 27.52% (24082/87518)
Coverage Report: http://coverage.selectdb-in.cc/coverage/6b6d272bafb084c78f41416678ac70d5ac6a1aa0_6b6d272bafb084c78f41416678ac70d5ac6a1aa0/report/index.html

@doris-robot
Copy link

TPC-DS: Total hot run time: 192714 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 6b6d272bafb084c78f41416678ac70d5ac6a1aa0, data reload: false

query1	1315	962	925	925
query2	6398	2026	1998	1998
query3	11011	4527	4559	4527
query4	60733	29542	23062	23062
query5	5542	593	459	459
query6	425	222	189	189
query7	5553	529	319	319
query8	345	246	242	242
query9	8344	2585	2593	2585
query10	460	318	256	256
query11	17811	15182	15521	15182
query12	171	118	110	110
query13	1482	572	425	425
query14	11327	7372	7558	7372
query15	217	220	203	203
query16	7430	630	464	464
query17	1124	752	615	615
query18	1903	421	315	315
query19	202	191	162	162
query20	119	121	114	114
query21	204	120	104	104
query22	4552	4669	4476	4476
query23	34128	33436	33665	33436
query24	5538	2356	2340	2340
query25	483	466	411	411
query26	651	298	159	159
query27	1541	496	351	351
query28	4462	2465	2442	2442
query29	551	559	432	432
query30	250	194	161	161
query31	927	879	838	838
query32	72	56	58	56
query33	448	357	312	312
query34	746	880	561	561
query35	820	884	787	787
query36	1005	1041	986	986
query37	129	108	79	79
query38	4401	4297	4243	4243
query39	1525	1426	1455	1426
query40	216	119	106	106
query41	51	50	47	47
query42	122	107	114	107
query43	538	558	503	503
query44	1498	825	821	821
query45	185	179	168	168
query46	921	1079	680	680
query47	1879	1917	1833	1833
query48	389	423	326	326
query49	699	512	411	411
query50	624	670	405	405
query51	4486	4380	4285	4285
query52	104	104	97	97
query53	248	280	201	201
query54	487	494	416	416
query55	81	82	83	82
query56	278	274	272	272
query57	1201	1248	1114	1114
query58	252	235	251	235
query59	3013	3216	3129	3129
query60	287	272	261	261
query61	141	138	166	138
query62	696	720	667	667
query63	234	193	192	192
query64	1262	1021	655	655
query65	3310	3215	3180	3180
query66	790	394	299	299
query67	15928	15643	15508	15508
query68	4233	855	532	532
query69	497	298	269	269
query70	1196	1137	1104	1104
query71	399	299	255	255
query72	5979	3925	3854	3854
query73	711	765	365	365
query74	9953	9011	8824	8824
query75	3273	3238	2726	2726
query76	3317	1191	794	794
query77	547	381	274	274
query78	10163	10019	9382	9382
query79	2525	825	622	622
query80	1638	546	439	439
query81	560	331	239	239
query82	343	160	118	118
query83	268	189	157	157
query84	290	93	74	74
query85	776	349	296	296
query86	463	321	307	307
query87	4535	4491	4398	4398
query88	3839	2191	2173	2173
query89	396	336	312	312
query90	1635	193	196	193
query91	137	144	106	106
query92	63	60	53	53
query93	2697	914	545	545
query94	753	411	300	300
query95	340	264	260	260
query96	483	615	277	277
query97	2737	2887	2736	2736
query98	219	195	199	195
query99	1255	1372	1273	1273
Total cold run time: 310485 ms
Total hot run time: 192714 ms

@doris-robot
Copy link

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

query1	0.03	0.03	0.03
query2	0.08	0.05	0.05
query3	0.24	0.06	0.05
query4	1.64	0.08	0.09
query5	0.42	0.41	0.39
query6	1.16	0.67	0.65
query7	0.02	0.01	0.01
query8	0.05	0.05	0.05
query9	0.55	0.49	0.49
query10	0.55	0.56	0.56
query11	0.18	0.12	0.12
query12	0.16	0.13	0.13
query13	0.62	0.60	0.61
query14	2.83	2.76	2.69
query15	0.91	0.84	0.83
query16	0.38	0.37	0.38
query17	1.06	1.06	1.07
query18	0.20	0.19	0.20
query19	1.98	1.82	1.98
query20	0.02	0.01	0.02
query21	15.36	0.98	0.66
query22	0.79	0.80	0.69
query23	14.97	1.48	0.68
query24	2.20	0.36	0.22
query25	0.15	0.09	0.09
query26	0.29	0.18	0.17
query27	0.08	0.08	0.08
query28	13.39	1.35	0.55
query29	12.63	4.16	3.40
query30	0.25	0.08	0.05
query31	2.84	0.64	0.41
query32	3.23	0.59	0.49
query33	2.98	3.01	3.09
query34	16.30	5.16	4.51
query35	4.59	4.56	4.61
query36	0.63	0.48	0.48
query37	0.19	0.17	0.16
query38	0.16	0.15	0.15
query39	0.05	0.04	0.04
query40	0.16	0.13	0.13
query41	0.09	0.06	0.05
query42	0.07	0.05	0.05
query43	0.04	0.04	0.04
Total cold run time: 104.52 s
Total hot run time: 30.85 s

@koarz
Copy link
Contributor Author

koarz commented Jan 25, 2025

run buildall

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 42.06% (10971/26083)
Line Coverage: 32.33% (92749/286839)
Region Coverage: 31.49% (47560/151055)
Branch Coverage: 27.52% (24082/87518)
Coverage Report: http://coverage.selectdb-in.cc/coverage/f33fec591abf5ca166717f4f3e76c300724f0051_f33fec591abf5ca166717f4f3e76c300724f0051/report/index.html

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17833	5503	5372	5372
q2	2054	326	175	175
q3	10669	1231	754	754
q4	10301	983	561	561
q5	8951	2381	2178	2178
q6	199	177	137	137
q7	921	747	606	606
q8	9248	1368	1186	1186
q9	5155	4906	4955	4906
q10	6832	2342	1903	1903
q11	461	284	258	258
q12	349	357	224	224
q13	17770	3728	3096	3096
q14	245	218	215	215
q15	536	452	471	452
q16	639	602	589	589
q17	564	872	333	333
q18	7068	6452	6470	6452
q19	2259	949	550	550
q20	310	326	189	189
q21	2912	2192	2040	2040
q22	375	339	316	316
Total cold run time: 105651 ms
Total hot run time: 32492 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5571	5478	5467	5467
q2	236	332	237	237
q3	2218	2683	2359	2359
q4	1437	1833	1388	1388
q5	4275	4735	4787	4735
q6	179	167	132	132
q7	2074	2026	1815	1815
q8	2645	2851	2716	2716
q9	7354	7220	7269	7220
q10	2984	3308	2741	2741
q11	558	514	482	482
q12	648	728	612	612
q13	3602	3991	3279	3279
q14	283	301	279	279
q15	509	480	469	469
q16	679	703	631	631
q17	1231	1739	1296	1296
q18	7727	7383	7294	7294
q19	827	1141	1088	1088
q20	2000	2026	1891	1891
q21	5792	5286	5013	5013
q22	618	608	564	564
Total cold run time: 53447 ms
Total hot run time: 51708 ms

@doris-robot
Copy link

TeamCity cloud ut coverage result:
Function Coverage: 82.38% (1061/1288)
Line Coverage: 65.86% (17543/26635)
Region Coverage: 65.38% (8655/13237)
Branch Coverage: 55.26% (4665/8442)
Coverage Report: http://coverage.selectdb-in.cc/coverage/96bffcf10041d0a5e5814ea6cc0f514875e79134_96bffcf10041d0a5e5814ea6cc0f514875e79134_cloud/report/index.html

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17580	5295	5060	5060
q2	2062	308	170	170
q3	10396	1338	692	692
q4	10219	1026	552	552
q5	7558	2391	2375	2375
q6	184	167	131	131
q7	921	732	598	598
q8	9314	1333	1127	1127
q9	4922	4642	4530	4530
q10	6823	2290	1893	1893
q11	490	277	257	257
q12	356	348	219	219
q13	17763	3693	3052	3052
q14	229	226	224	224
q15	527	488	465	465
q16	624	622	596	596
q17	584	861	351	351
q18	7328	6193	6045	6045
q19	1219	942	549	549
q20	315	327	192	192
q21	2776	2271	1980	1980
q22	373	334	304	304
Total cold run time: 102563 ms
Total hot run time: 31362 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5121	5102	5120	5102
q2	243	330	237	237
q3	2162	2729	2273	2273
q4	1472	1825	1420	1420
q5	4278	4348	4166	4166
q6	204	166	123	123
q7	1925	1824	1719	1719
q8	2665	2695	2720	2695
q9	7246	7131	7328	7131
q10	2989	3210	2696	2696
q11	572	497	498	497
q12	679	787	642	642
q13	3528	3944	3765	3765
q14	284	298	275	275
q15	511	477	468	468
q16	660	692	638	638
q17	1144	1564	1373	1373
q18	7623	7374	7364	7364
q19	793	827	928	827
q20	1970	2052	1862	1862
q21	5346	4857	4806	4806
q22	648	610	550	550
Total cold run time: 52063 ms
Total hot run time: 50629 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 190227 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 96bffcf10041d0a5e5814ea6cc0f514875e79134, data reload: false

query1	1306	978	931	931
query2	6187	1880	1810	1810
query3	10994	4482	4483	4482
query4	56343	25931	23593	23593
query5	5159	504	480	480
query6	381	205	185	185
query7	5035	499	290	290
query8	325	249	233	233
query9	6743	2499	2522	2499
query10	425	305	246	246
query11	15215	15164	14989	14989
query12	154	109	102	102
query13	1134	498	379	379
query14	10711	6851	6334	6334
query15	219	210	188	188
query16	7170	666	463	463
query17	1090	718	568	568
query18	1733	426	318	318
query19	201	195	171	171
query20	128	122	116	116
query21	212	128	107	107
query22	4493	4463	4341	4341
query23	33910	33373	33428	33373
query24	6095	2464	2433	2433
query25	457	450	394	394
query26	720	278	152	152
query27	1937	488	342	342
query28	2817	2478	2445	2445
query29	612	566	426	426
query30	234	193	165	165
query31	907	850	819	819
query32	69	62	59	59
query33	438	363	289	289
query34	769	845	497	497
query35	825	859	750	750
query36	985	1006	928	928
query37	129	110	90	90
query38	4315	4280	4286	4280
query39	1505	1488	1456	1456
query40	207	116	100	100
query41	55	49	67	49
query42	123	114	111	111
query43	490	518	513	513
query44	1326	794	812	794
query45	179	179	164	164
query46	869	1056	676	676
query47	1870	1895	1821	1821
query48	391	424	304	304
query49	708	517	411	411
query50	724	747	416	416
query51	4307	4379	4189	4189
query52	110	108	94	94
query53	237	254	199	199
query54	494	502	425	425
query55	81	82	83	82
query56	265	280	244	244
query57	1189	1214	1121	1121
query58	246	232	240	232
query59	2853	2810	2682	2682
query60	282	261	257	257
query61	138	110	112	110
query62	738	737	648	648
query63	222	189	186	186
query64	1760	1014	705	705
query65	3242	3192	3134	3134
query66	726	378	295	295
query67	15924	15747	15332	15332
query68	5413	777	511	511
query69	518	303	262	262
query70	1191	1183	1143	1143
query71	440	299	261	261
query72	6313	3681	3713	3681
query73	1155	741	336	336
query74	9065	8936	8784	8784
query75	3247	3111	2684	2684
query76	3806	1182	749	749
query77	529	358	284	284
query78	10097	10106	9342	9342
query79	2923	798	593	593
query80	813	524	503	503
query81	541	278	241	241
query82	841	147	116	116
query83	180	170	152	152
query84	282	90	72	72
query85	782	360	303	303
query86	454	311	290	290
query87	4486	4503	4597	4503
query88	3663	2189	2225	2189
query89	415	318	277	277
query90	1867	192	193	192
query91	134	132	109	109
query92	76	61	58	58
query93	2761	1011	582	582
query94	692	416	305	305
query95	355	266	260	260
query96	487	559	268	268
query97	2808	2873	2691	2691
query98	234	209	205	205
query99	1315	1405	1264	1264
Total cold run time: 299721 ms
Total hot run time: 190227 ms

@doris-robot
Copy link

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

query1	0.03	0.03	0.04
query2	0.11	0.05	0.04
query3	0.28	0.06	0.05
query4	1.60	0.07	0.07
query5	0.42	0.40	0.40
query6	1.17	0.65	0.65
query7	0.02	0.02	0.02
query8	0.05	0.04	0.04
query9	0.61	0.51	0.53
query10	0.58	0.58	0.58
query11	0.25	0.12	0.12
query12	0.25	0.13	0.13
query13	0.64	0.61	0.61
query14	2.69	2.71	2.70
query15	0.99	0.86	0.86
query16	0.36	0.38	0.37
query17	1.02	1.05	1.01
query18	0.23	0.21	0.21
query19	2.01	1.89	2.07
query20	0.02	0.01	0.01
query21	15.34	0.95	0.65
query22	0.92	1.10	0.79
query23	14.72	1.55	0.72
query24	5.40	0.60	0.28
query25	0.16	0.09	0.09
query26	0.55	0.23	0.18
query27	0.09	0.09	0.08
query28	10.99	1.21	0.55
query29	12.51	4.15	3.42
query30	0.28	0.08	0.06
query31	2.85	0.62	0.42
query32	3.22	0.58	0.50
query33	3.03	3.02	3.19
query34	16.73	5.19	4.40
query35	4.50	4.48	4.50
query36	0.66	0.51	0.50
query37	0.20	0.17	0.17
query38	0.17	0.16	0.15
query39	0.04	0.04	0.04
query40	0.19	0.15	0.14
query41	0.09	0.05	0.05
query42	0.06	0.05	0.05
query43	0.06	0.05	0.04
Total cold run time: 106.09 s
Total hot run time: 31.08 s

@koarz
Copy link
Contributor Author

koarz commented Feb 10, 2025

run beut

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 42.84% (11272/26312)
Line Coverage: 32.81% (94720/288655)
Region Coverage: 31.97% (48553/151894)
Branch Coverage: 27.83% (24484/87986)
Coverage Report: http://coverage.selectdb-in.cc/coverage/96bffcf10041d0a5e5814ea6cc0f514875e79134_96bffcf10041d0a5e5814ea6cc0f514875e79134/report/index.html

zclllyybb
zclllyybb approved these changes Feb 11, 2025
View reviewed changes
Copy link
Contributor

@zclllyybb zclllyybb left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

LGTM

@github-actions GitHub Actions
Copy link
Contributor

PR approved by anyone and no changes requested.

@koarz
Copy link
Contributor Author

koarz commented Feb 12, 2025

run buildall

@koarz koarz changed the title [Feature](literal)Support TimeLiteral [Feature](literal)Support TimeV2Literal Feb 12, 2025
@doris-robot
Copy link

TeamCity cloud ut coverage result:
Function Coverage: 82.38% (1061/1288)
Line Coverage: 65.85% (17545/26643)
Region Coverage: 65.38% (8654/13237)
Branch Coverage: 55.25% (4664/8442)
Coverage Report: http://coverage.selectdb-in.cc/coverage/578920bbcaf05360a538bd9e090d7b71ad02d3e5_578920bbcaf05360a538bd9e090d7b71ad02d3e5_cloud/report/index.html

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17657	5372	5128	5128
q2	2072	312	171	171
q3	10553	1254	774	774
q4	10237	1031	549	549
q5	7712	2427	2369	2369
q6	196	174	132	132
q7	909	765	614	614
q8	9316	1347	1102	1102
q9	4906	4576	4628	4576
q10	6828	2307	1902	1902
q11	480	285	247	247
q12	341	350	216	216
q13	17782	3734	3075	3075
q14	227	223	204	204
q15	528	475	468	468
q16	619	617	596	596
q17	571	866	346	346
q18	6763	6248	6166	6166
q19	2033	959	567	567
q20	314	323	188	188
q21	3006	2163	1987	1987
q22	369	327	308	308
Total cold run time: 103419 ms
Total hot run time: 31685 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5252	5132	5154	5132
q2	238	325	236	236
q3	2173	2689	2298	2298
q4	1493	1876	1390	1390
q5	4285	4197	4186	4186
q6	211	171	125	125
q7	1855	1840	1762	1762
q8	2660	2696	2607	2607
q9	7218	7124	7141	7124
q10	3033	3217	2797	2797
q11	588	520	485	485
q12	718	784	624	624
q13	3394	3853	3311	3311
q14	281	303	290	290
q15	500	469	473	469
q16	620	700	662	662
q17	1147	1570	1408	1408
q18	7785	7582	7368	7368
q19	804	821	840	821
q20	1991	2025	1912	1912
q21	5545	5086	4775	4775
q22	632	597	552	552
Total cold run time: 52423 ms
Total hot run time: 50334 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 190480 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 578920bbcaf05360a538bd9e090d7b71ad02d3e5, data reload: false

query1	1309	968	926	926
query2	6235	1837	1823	1823
query3	10929	4484	4526	4484
query4	53450	25285	23160	23160
query5	5357	597	506	506
query6	363	204	178	178
query7	4955	525	299	299
query8	320	246	240	240
query9	6145	2514	2524	2514
query10	443	310	259	259
query11	15227	15005	14866	14866
query12	155	105	104	104
query13	1095	516	362	362
query14	11056	6420	6975	6420
query15	192	209	179	179
query16	7099	644	473	473
query17	1077	721	570	570
query18	1562	420	312	312
query19	207	202	164	164
query20	128	121	119	119
query21	208	133	109	109
query22	4441	4837	4401	4401
query23	34002	33439	33425	33425
query24	5643	2490	2509	2490
query25	492	520	420	420
query26	680	289	154	154
query27	1634	514	339	339
query28	2877	2454	2440	2440
query29	586	556	418	418
query30	216	190	154	154
query31	887	901	809	809
query32	70	66	60	60
query33	431	366	308	308
query34	871	891	528	528
query35	801	826	772	772
query36	964	1017	904	904
query37	128	101	79	79
query38	4272	4250	4259	4250
query39	1496	1430	1425	1425
query40	207	117	114	114
query41	59	50	52	50
query42	117	109	104	104
query43	515	506	486	486
query44	1361	826	821	821
query45	186	174	162	162
query46	939	1091	659	659
query47	1829	1929	1808	1808
query48	394	417	321	321
query49	703	505	437	437
query50	794	779	433	433
query51	4292	4248	4269	4248
query52	111	103	97	97
query53	242	266	188	188
query54	481	501	410	410
query55	81	82	80	80
query56	276	282	271	271
query57	1154	1168	1132	1132
query58	284	242	256	242
query59	2848	2833	2783	2783
query60	281	265	284	265
query61	117	111	123	111
query62	755	751	695	695
query63	230	193	200	193
query64	1427	1047	712	712
query65	3326	3241	3138	3138
query66	741	400	288	288
query67	15853	15417	15560	15417
query68	3174	809	532	532
query69	491	304	277	277
query70	1197	1143	1104	1104
query71	352	347	268	268
query72	6347	3628	3732	3628
query73	633	766	350	350
query74	8957	9133	8986	8986
query75	3161	3144	2699	2699
query76	2172	1164	774	774
query77	536	370	275	275
query78	9934	10160	9275	9275
query79	1031	895	596	596
query80	824	556	454	454
query81	543	272	243	243
query82	424	158	127	127
query83	205	174	155	155
query84	281	98	79	79
query85	833	427	385	385
query86	377	328	289	289
query87	4495	4477	4392	4392
query88	3069	2233	2196	2196
query89	387	317	346	317
query90	1539	194	194	194
query91	135	134	108	108
query92	64	61	55	55
query93	1428	1015	571	571
query94	659	383	296	296
query95	353	267	254	254
query96	487	553	265	265
query97	2798	2858	2762	2762
query98	220	199	201	199
query99	1264	1453	1267	1267
Total cold run time: 285976 ms
Total hot run time: 190480 ms

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 42.98% (11310/26315)
Line Coverage: 32.92% (95025/288677)
Region Coverage: 32.07% (48711/151882)
Branch Coverage: 27.94% (24582/87980)
Coverage Report: http://coverage.selectdb-in.cc/coverage/578920bbcaf05360a538bd9e090d7b71ad02d3e5_578920bbcaf05360a538bd9e090d7b71ad02d3e5/report/index.html

@koarz
Copy link
Contributor Author

koarz commented Feb 12, 2025

run performance

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17745	5208	5108	5108
q2	2058	306	185	185
q3	10726	1305	702	702
q4	10305	1037	524	524
q5	9309	2526	2373	2373
q6	196	166	134	134
q7	924	789	618	618
q8	9322	1267	1011	1011
q9	5105	4822	4837	4822
q10	6839	2339	1899	1899
q11	476	284	257	257
q12	350	352	221	221
q13	17771	3714	3093	3093
q14	229	226	208	208
q15	517	466	469	466
q16	630	593	597	593
q17	568	883	362	362
q18	6740	6246	6250	6246
q19	1352	945	554	554
q20	322	333	210	210
q21	2805	2254	2023	2023
q22	373	325	306	306
Total cold run time: 104662 ms
Total hot run time: 31915 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5184	5116	5084	5084
q2	238	328	237	237
q3	2181	2701	2256	2256
q4	1486	1853	1396	1396
q5	4233	4149	4131	4131
q6	205	164	123	123
q7	1858	1929	1782	1782
q8	2583	2731	2573	2573
q9	7161	7103	7104	7103
q10	3044	3196	2787	2787
q11	584	530	504	504
q12	684	788	583	583
q13	3579	3843	3226	3226
q14	275	294	291	291
q15	503	461	464	461
q16	640	693	648	648
q17	1138	1614	1334	1334
q18	7700	7480	7385	7385
q19	774	839	847	839
q20	1996	2073	1856	1856
q21	5377	4898	4821	4821
q22	624	569	564	564
Total cold run time: 52047 ms
Total hot run time: 49984 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 183603 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 578920bbcaf05360a538bd9e090d7b71ad02d3e5, data reload: false

query1	968	382	382	382
query2	6525	1840	1794	1794
query3	6790	214	213	213
query4	26548	23560	23050	23050
query5	4319	639	483	483
query6	306	199	208	199
query7	4608	501	312	312
query8	302	250	230	230
query9	8610	2529	2520	2520
query10	448	317	261	261
query11	15786	15021	14913	14913
query12	159	110	107	107
query13	1651	522	395	395
query14	9344	6628	6735	6628
query15	212	202	175	175
query16	7475	632	480	480
query17	1203	720	556	556
query18	1963	412	305	305
query19	204	195	158	158
query20	130	118	121	118
query21	213	131	107	107
query22	4146	4254	4200	4200
query23	34194	32963	33178	32963
query24	7630	2410	2382	2382
query25	575	450	386	386
query26	1235	266	167	167
query27	2183	472	330	330
query28	3973	2379	2366	2366
query29	719	539	423	423
query30	231	189	156	156
query31	959	831	820	820
query32	76	63	62	62
query33	555	360	285	285
query34	796	828	506	506
query35	839	825	720	720
query36	978	969	909	909
query37	134	106	81	81
query38	4145	4132	4251	4132
query39	1456	1423	1430	1423
query40	206	112	101	101
query41	54	52	52	52
query42	122	109	105	105
query43	505	518	486	486
query44	1271	811	807	807
query45	177	172	159	159
query46	853	1033	643	643
query47	1779	1820	1726	1726
query48	374	415	304	304
query49	784	492	409	409
query50	667	730	416	416
query51	4165	4214	4119	4119
query52	105	112	93	93
query53	230	268	188	188
query54	519	499	409	409
query55	86	83	76	76
query56	249	269	254	254
query57	1133	1141	1084	1084
query58	252	233	237	233
query59	2579	2732	2513	2513
query60	283	269	268	268
query61	122	123	118	118
query62	883	739	642	642
query63	226	194	186	186
query64	4330	1028	656	656
query65	3249	3129	3110	3110
query66	1112	414	311	311
query67	15917	15615	15435	15435
query68	7965	762	506	506
query69	465	300	268	268
query70	1203	1153	1109	1109
query71	406	295	266	266
query72	5772	3522	3680	3522
query73	704	690	350	350
query74	8968	9081	8790	8790
query75	3312	3173	2744	2744
query76	3351	1172	735	735
query77	625	356	289	289
query78	9987	10100	9367	9367
query79	2809	808	592	592
query80	651	517	452	452
query81	507	288	239	239
query82	487	150	122	122
query83	164	180	156	156
query84	240	92	74	74
query85	766	345	320	320
query86	374	291	312	291
query87	4493	4559	4403	4403
query88	3842	2209	2202	2202
query89	384	351	293	293
query90	1929	189	194	189
query91	138	145	114	114
query92	76	58	55	55
query93	2189	993	570	570
query94	700	400	296	296
query95	358	264	253	253
query96	475	559	268	268
query97	2804	2834	2716	2716
query98	246	201	207	201
query99	1364	1395	1251	1251
Total cold run time: 272574 ms
Total hot run time: 183603 ms

@doris-robot
Copy link

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

query1	0.04	0.03	0.03
query2	0.07	0.02	0.03
query3	0.23	0.06	0.06
query4	1.64	0.10	0.10
query5	0.43	0.40	0.41
query6	1.16	0.64	0.67
query7	0.02	0.02	0.01
query8	0.04	0.04	0.03
query9	0.58	0.52	0.52
query10	0.58	0.59	0.57
query11	0.15	0.10	0.10
query12	0.14	0.11	0.12
query13	0.61	0.59	0.58
query14	2.69	2.71	2.70
query15	0.94	0.85	0.85
query16	0.38	0.38	0.38
query17	1.01	1.03	1.06
query18	0.21	0.20	0.19
query19	1.91	1.83	2.04
query20	0.02	0.00	0.02
query21	15.35	0.90	0.53
query22	0.74	1.09	0.75
query23	14.94	1.37	0.64
query24	7.46	1.12	0.34
query25	0.48	0.23	0.05
query26	0.57	0.16	0.14
query27	0.06	0.05	0.05
query28	9.19	0.92	0.43
query29	12.62	3.83	3.24
query30	0.24	0.09	0.06
query31	2.84	0.59	0.38
query32	3.23	0.54	0.46
query33	2.98	2.99	3.05
query34	15.79	5.16	4.46
query35	4.56	4.55	4.56
query36	0.66	0.49	0.48
query37	0.09	0.06	0.06
query38	0.05	0.04	0.04
query39	0.03	0.02	0.02
query40	0.16	0.14	0.13
query41	0.08	0.02	0.02
query42	0.03	0.02	0.02
query43	0.03	0.03	0.03
Total cold run time: 105.03 s
Total hot run time: 30.02 s

BiteTheDDDDt
BiteTheDDDDt reviewed Feb 12, 2025
View reviewed changes
be/src/vec/functions/function_cast.h Outdated
@@ -169,6 +169,12 @@ struct TimeCast {
num = int_value;
return true;
};
bool neg {};
Copy link
Contributor

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

better use sign, sign maybe is 1 or -1

@koarz
Copy link
Contributor Author

koarz commented Feb 12, 2025

run buildall

@doris-robot
Copy link

TeamCity cloud ut coverage result:
Function Coverage: 82.38% (1061/1288)
Line Coverage: 65.98% (17583/26648)
Region Coverage: 65.47% (8667/13238)
Branch Coverage: 55.34% (4672/8442)
Coverage Report: http://coverage.selectdb-in.cc/coverage/98d21a1cd7b967903790b3110be28765d0f917e4_98d21a1cd7b967903790b3110be28765d0f917e4_cloud/report/index.html

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17845	5259	5130	5130
q2	2054	307	166	166
q3	10499	1331	717	717
q4	10246	1019	554	554
q5	7691	2381	2403	2381
q6	187	166	136	136
q7	910	758	618	618
q8	9329	1364	1111	1111
q9	4902	4724	4831	4724
q10	6841	2322	1885	1885
q11	465	271	254	254
q12	346	353	218	218
q13	17787	3700	3072	3072
q14	228	241	211	211
q15	513	489	485	485
q16	625	613	590	590
q17	570	879	347	347
q18	7032	6240	6261	6240
q19	1230	958	544	544
q20	312	319	193	193
q21	2864	2288	1961	1961
q22	364	323	301	301
Total cold run time: 102840 ms
Total hot run time: 31838 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5167	5160	5113	5113
q2	229	325	232	232
q3	2194	2711	2280	2280
q4	1454	1851	1359	1359
q5	4296	4174	4198	4174
q6	206	165	123	123
q7	1893	1863	1808	1808
q8	2657	2661	2586	2586
q9	7360	7151	7083	7083
q10	3080	3234	2814	2814
q11	574	499	486	486
q12	675	790	610	610
q13	3726	3889	3248	3248
q14	294	296	288	288
q15	498	477	462	462
q16	641	687	631	631
q17	1149	1633	1319	1319
q18	7578	7277	7314	7277
q19	818	810	830	810
q20	2025	2033	1877	1877
q21	5433	4968	4756	4756
q22	603	620	564	564
Total cold run time: 52550 ms
Total hot run time: 49900 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 182897 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 98d21a1cd7b967903790b3110be28765d0f917e4, data reload: false

query1	969	395	389	389
query2	6561	1880	1851	1851
query3	6782	208	212	208
query4	26574	23757	23113	23113
query5	4346	691	505	505
query6	297	206	196	196
query7	4620	513	320	320
query8	304	255	239	239
query9	8614	2527	2531	2527
query10	475	325	289	289
query11	15391	15140	14976	14976
query12	166	112	105	105
query13	1668	525	383	383
query14	9363	6534	6520	6520
query15	207	189	177	177
query16	7694	610	440	440
query17	1172	699	530	530
query18	1999	380	304	304
query19	192	187	146	146
query20	125	140	110	110
query21	206	121	99	99
query22	4312	4330	4288	4288
query23	33996	33080	33013	33013
query24	7681	2363	2408	2363
query25	559	439	376	376
query26	1228	266	156	156
query27	2152	490	324	324
query28	3919	2396	2387	2387
query29	723	535	408	408
query30	235	181	155	155
query31	957	853	788	788
query32	72	65	64	64
query33	567	351	299	299
query34	784	847	510	510
query35	830	823	749	749
query36	951	999	919	919
query37	120	93	74	74
query38	4085	4064	4119	4064
query39	1434	1411	1383	1383
query40	203	115	106	106
query41	56	57	53	53
query42	123	101	101	101
query43	497	509	462	462
query44	1336	791	787	787
query45	182	172	161	161
query46	872	1038	651	651
query47	1743	1826	1691	1691
query48	388	410	299	299
query49	790	535	419	419
query50	683	730	430	430
query51	4161	4166	4104	4104
query52	117	111	127	111
query53	219	256	190	190
query54	484	499	392	392
query55	80	79	84	79
query56	263	268	267	267
query57	1134	1145	1069	1069
query58	243	242	238	238
query59	2492	2772	2511	2511
query60	290	271	281	271
query61	122	121	113	113
query62	778	773	659	659
query63	219	185	188	185
query64	4254	999	668	668
query65	3237	3135	3155	3135
query66	1059	408	332	332
query67	15776	15535	15452	15452
query68	2292	778	523	523
query69	423	303	283	283
query70	1204	1137	1103	1103
query71	346	298	271	271
query72	5037	3504	2690	2690
query73	579	644	352	352
query74	9181	9152	8738	8738
query75	3143	3163	2660	2660
query76	2304	1164	738	738
query77	345	353	292	292
query78	9925	10156	9419	9419
query79	1088	872	594	594
query80	624	520	475	475
query81	466	290	239	239
query82	1236	137	96	96
query83	282	198	161	161
query84	239	92	80	80
query85	783	415	372	372
query86	335	309	295	295
query87	4393	4385	4388	4385
query88	2880	2258	2247	2247
query89	391	319	289	289
query90	1694	273	195	195
query91	129	137	109	109
query92	62	59	59	59
query93	1117	1019	573	573
query94	471	408	278	278
query95	355	269	253	253
query96	482	598	266	266
query97	2751	2850	2718	2718
query98	234	210	196	196
query99	1315	1395	1265	1265
Total cold run time: 260237 ms
Total hot run time: 182897 ms

@doris-robot
Copy link

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

query1	0.03	0.03	0.03
query2	0.07	0.03	0.04
query3	0.23	0.06	0.06
query4	1.62	0.11	0.10
query5	0.43	0.41	0.41
query6	1.17	0.67	0.67
query7	0.02	0.02	0.02
query8	0.04	0.03	0.03
query9	0.59	0.53	0.53
query10	0.58	0.58	0.57
query11	0.16	0.10	0.11
query12	0.15	0.12	0.11
query13	0.63	0.60	0.59
query14	2.70	2.81	2.70
query15	0.93	0.85	0.86
query16	0.38	0.38	0.38
query17	1.02	1.03	1.02
query18	0.22	0.20	0.19
query19	1.94	1.78	2.03
query20	0.01	0.02	0.02
query21	15.37	0.88	0.55
query22	0.76	1.12	0.72
query23	14.89	1.39	0.62
query24	7.11	2.75	0.40
query25	0.32	0.27	0.10
query26	0.65	0.17	0.13
query27	0.05	0.05	0.05
query28	9.31	0.85	0.44
query29	12.56	3.97	3.25
query30	0.25	0.09	0.06
query31	2.81	0.60	0.39
query32	3.22	0.55	0.46
query33	3.00	3.03	3.06
query34	15.89	5.18	4.53
query35	4.61	4.57	4.56
query36	0.66	0.50	0.50
query37	0.09	0.07	0.06
query38	0.05	0.04	0.04
query39	0.03	0.02	0.03
query40	0.16	0.14	0.13
query41	0.08	0.03	0.02
query42	0.03	0.02	0.02
query43	0.04	0.03	0.02
Total cold run time: 104.86 s
Total hot run time: 30.29 s

@doris-robot
Copy link

TeamCity be ut coverage result:
Function Coverage: 42.98% (11310/26315)
Line Coverage: 32.91% (94985/288659)
Region Coverage: 32.08% (48712/151869)
Branch Coverage: 27.93% (24575/87978)
Coverage Report: http://coverage.selectdb-in.cc/coverage/98d21a1cd7b967903790b3110be28765d0f917e4_98d21a1cd7b967903790b3110be28765d0f917e4/report/index.html

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers

@BiteTheDDDDt BiteTheDDDDt BiteTheDDDDt left review comments

@morrySnow morrySnow morrySnow left review comments

@zclllyybb zclllyybb zclllyybb approved these changes

At least 1 approving review is required to merge this pull request.

Assignees

@morrySnow morrySnow

Labels
reviewed
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.
6 participants
@koarz @hello-stephen @doris-robot @zclllyybb @BiteTheDDDDt @morrySnow