doris icon indicating copy to clipboard operation
doris copied to clipboard
verified publisher icon apache

[feature](nereids)support unnest function

Open starocean999 opened this issue 1 month ago • 18 comments

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

starocean999 avatar Nov 21 '25 07:11 starocean999

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?

hello-stephen avatar Nov 21 '25 07:11 hello-stephen

run buildall

starocean999 avatar Nov 21 '25 07:11 starocean999

Cloud UT Coverage Report

Increment line coverage :tada:

Increment coverage report Complete coverage report

Category Coverage
Function Coverage 80.86% (1707/2111)
Line Coverage 66.85% (29887/44708)
Region Coverage 67.41% (14906/22114)
Branch Coverage 57.60% (7931/13768)

hello-stephen avatar Nov 21 '25 08:11 hello-stephen

run buildall

starocean999 avatar Nov 21 '25 09:11 starocean999

Cloud UT Coverage Report

Increment line coverage :tada:

Increment coverage report Complete coverage report

Category Coverage
Function Coverage 80.86% (1707/2111)
Line Coverage 66.86% (29890/44708)
Region Coverage 67.39% (14902/22114)
Branch Coverage 57.59% (7929/13768)

hello-stephen avatar Nov 21 '25 09:11 hello-stephen

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

------ Round 1 ----------------------------------
q1	17063	5142	4972	4972
q2	2046	326	225	225
q3	9932	1313	743	743
q4	10235	975	370	370
q5	7621	2356	2383	2356
q6	190	172	138	138
q7	909	785	646	646
q8	9365	1382	1056	1056
q9	7173	5418	5332	5332
q10	6877	2215	1814	1814
q11	518	296	285	285
q12	333	369	235	235
q13	17793	3647	3090	3090
q14	239	245	219	219
q15	579	509	501	501
q16	1010	998	943	943
q17	596	875	372	372
q18	7633	7780	8139	7780
q19	1088	953	555	555
q20	374	358	251	251
q21	4351	3374	2483	2483
q22	1160	1094	1024	1024
Total cold run time: 107085 ms
Total hot run time: 35390 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5318	5268	5212	5212
q2	341	395	324	324
q3	2351	2934	2508	2508
q4	1443	1927	1446	1446
q5	4543	4465	4575	4465
q6	206	172	132	132
q7	1975	2004	1778	1778
q8	2569	2614	2577	2577
q9	7667	7630	7647	7630
q10	3046	3244	2908	2908
q11	599	528	512	512
q12	659	713	615	615
q13	3294	3689	3066	3066
q14	266	277	258	258
q15	540	498	476	476
q16	1019	1047	998	998
q17	1110	1509	1308	1308
q18	7255	7115	7077	7077
q19	772	822	938	822
q20	1928	1973	1819	1819
q21	4793	4365	4371	4365
q22	1119	1052	1007	1007
Total cold run time: 52813 ms
Total hot run time: 51303 ms

doris-robot avatar Nov 21 '25 10:11 doris-robot

TPC-DS: Total hot run time: 187688 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 798928c902666be3e8aba982e06d8aa3fef521c4, data reload: false

query1	1047	460	390	390
query2	6572	1712	1711	1711
query3	6771	228	216	216
query4	26690	23044	22669	22669
query5	4431	639	482	482
query6	339	231	222	222
query7	4645	504	308	308
query8	306	245	231	231
query9	8710	2587	2615	2587
query10	499	362	285	285
query11	15791	14992	15003	14992
query12	202	117	110	110
query13	1699	590	473	473
query14	11089	9435	9376	9376
query15	211	193	180	180
query16	7406	724	559	559
query17	1218	753	609	609
query18	1990	414	319	319
query19	216	199	180	180
query20	129	124	121	121
query21	216	139	114	114
query22	4021	4269	3989	3989
query23	33978	32915	32721	32721
query24	8372	2438	2407	2407
query25	597	515	453	453
query26	1249	265	192	192
query27	2740	514	363	363
query28	4296	2204	2201	2201
query29	830	617	484	484
query30	299	228	211	211
query31	895	818	713	713
query32	91	70	72	70
query33	597	386	329	329
query34	793	850	512	512
query35	796	847	728	728
query36	961	990	908	908
query37	129	111	91	91
query38	3562	3596	3445	3445
query39	1502	1420	1420	1420
query40	225	134	120	120
query41	66	64	61	61
query42	127	114	114	114
query43	490	488	471	471
query44	1265	774	770	770
query45	187	174	174	174
query46	889	987	635	635
query47	1737	1777	1696	1696
query48	386	433	324	324
query49	786	486	412	412
query50	658	675	405	405
query51	3867	3952	3919	3919
query52	111	113	110	110
query53	243	275	199	199
query54	315	299	291	291
query55	89	86	89	86
query56	341	322	326	322
query57	1174	1191	1115	1115
query58	291	275	277	275
query59	2565	2641	2619	2619
query60	364	357	339	339
query61	184	200	156	156
query62	769	726	657	657
query63	231	202	204	202
query64	4368	1147	868	868
query65	4028	3947	3950	3947
query66	1156	436	325	325
query67	15246	15058	14857	14857
query68	4599	955	647	647
query69	498	326	294	294
query70	1374	1319	1223	1223
query71	434	347	327	327
query72	5769	5092	5047	5047
query73	665	589	369	369
query74	8925	9042	8867	8867
query75	3319	3352	2846	2846
query76	3332	1128	740	740
query77	533	426	335	335
query78	9591	9667	8947	8947
query79	1911	916	603	603
query80	1640	616	581	581
query81	562	267	229	229
query82	391	162	146	146
query83	323	263	255	255
query84	257	116	97	97
query85	949	489	440	440
query86	458	310	293	293
query87	3767	3716	3604	3604
query88	2812	2264	2237	2237
query89	382	327	301	301
query90	1790	220	217	217
query91	170	169	137	137
query92	70	63	66	63
query93	1272	1011	692	692
query94	711	413	350	350
query95	415	333	304	304
query96	471	574	279	279
query97	2877	2974	2884	2884
query98	232	215	204	204
query99	1347	1387	1290	1290
Total cold run time: 269889 ms
Total hot run time: 187688 ms

doris-robot avatar Nov 21 '25 10:11 doris-robot

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

query1	0.06	0.06	0.05
query2	0.09	0.05	0.05
query3	0.25	0.08	0.08
query4	1.61	0.11	0.10
query5	0.27	0.25	0.26
query6	1.16	0.66	0.65
query7	0.03	0.03	0.02
query8	0.06	0.04	0.04
query9	0.58	0.53	0.52
query10	0.58	0.58	0.57
query11	0.17	0.11	0.12
query12	0.15	0.12	0.11
query13	0.63	0.60	0.60
query14	1.00	1.00	0.99
query15	0.84	0.81	0.83
query16	0.40	0.39	0.39
query17	1.05	1.04	1.00
query18	0.21	0.20	0.20
query19	1.92	1.81	1.77
query20	0.02	0.01	0.02
query21	15.45	0.17	0.12
query22	5.23	0.09	0.05
query23	15.64	0.27	0.10
query24	2.30	0.82	0.43
query25	0.08	0.05	0.06
query26	0.15	0.13	0.13
query27	0.07	0.06	0.05
query28	4.75	1.15	0.93
query29	12.55	3.89	3.31
query30	0.28	0.16	0.14
query31	2.81	0.58	0.39
query32	3.23	0.55	0.47
query33	3.03	3.07	3.09
query34	16.02	5.12	4.55
query35	4.52	4.56	4.62
query36	0.66	0.52	0.48
query37	0.10	0.06	0.06
query38	0.06	0.04	0.04
query39	0.04	0.03	0.03
query40	0.16	0.14	0.13
query41	0.09	0.03	0.03
query42	0.04	0.03	0.03
query43	0.04	0.03	0.04
Total cold run time: 98.38 s
Total hot run time: 27.5 s

doris-robot avatar Nov 21 '25 10:11 doris-robot

BE UT Coverage Report

Increment line coverage :tada:

Increment coverage report Complete coverage report

Category Coverage
Function Coverage 52.63% (18280/34733)
Line Coverage 38.07% (166327/436873)
Region Coverage 33.03% (129352/391636)
Branch Coverage 33.82% (55510/164115)

hello-stephen avatar Nov 21 '25 11:11 hello-stephen

BE Regression && UT Coverage Report

Increment line coverage 100% (0/0) :tada:

Increment coverage report Complete coverage report

Category Coverage
Function Coverage 71.50% (24371/34083)
Line Coverage 58.06% (253364/436394)
Region Coverage 53.35% (211658/396741)
Branch Coverage 54.69% (90236/165003)

hello-stephen avatar Nov 21 '25 12:11 hello-stephen

FE Regression Coverage Report

Increment line coverage 81.02% (222/274) :tada: Increment coverage report Complete coverage report

hello-stephen avatar Nov 21 '25 12:11 hello-stephen

run buildall

starocean999 avatar Dec 11 '25 07:12 starocean999

Cloud UT Coverage Report

Increment line coverage :tada:

Increment coverage report Complete coverage report

Category Coverage
Function Coverage 79.83% (1730/2167)
Line Coverage 65.87% (30616/46476)
Region Coverage 66.61% (15276/22934)
Branch Coverage 56.90% (8117/14266)

doris-robot avatar Dec 11 '25 08:12 doris-robot

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

------ Round 1 ----------------------------------
q1	17634	4237	4102	4102
q2	2033	361	237	237
q3	10464	1358	753	753
q4	10346	833	320	320
q5	9674	2218	1922	1922
q6	256	170	138	138
q7	1023	857	724	724
q8	9362	1486	1096	1096
q9	7259	5474	5347	5347
q10	6889	2408	1988	1988
q11	539	311	280	280
q12	712	729	554	554
q13	17797	3835	3042	3042
q14	287	287	271	271
q15	595	518	520	518
q16	925	912	909	909
q17	722	832	549	549
q18	7469	7194	7043	7043
q19	1107	984	623	623
q20	408	368	248	248
q21	4270	3966	3498	3498
q22	1026	1003	968	968
Total cold run time: 110797 ms
Total hot run time: 35130 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4146	4064	4085	4064
q2	323	385	321	321
q3	2172	2701	2292	2292
q4	1357	1781	1283	1283
q5	4685	4767	4654	4654
q6	234	182	136	136
q7	2059	1949	1789	1789
q8	2721	2600	2572	2572
q9	7621	7597	7589	7589
q10	3070	3312	3025	3025
q11	610	506	499	499
q12	676	747	595	595
q13	3587	4126	3376	3376
q14	292	320	273	273
q15	557	505	509	505
q16	1050	967	860	860
q17	1190	1473	1405	1405
q18	7855	7579	7540	7540
q19	843	886	933	886
q20	2035	2124	2079	2079
q21	4692	4340	4258	4258
q22	1103	1030	975	975
Total cold run time: 52878 ms
Total hot run time: 50976 ms

doris-robot avatar Dec 11 '25 09:12 doris-robot

TPC-DS: Total hot run time: 178504 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 18a12ddb8cc536853316e7bc296a1b3daf6f858b, data reload: false

query5	4961	629	467	467
query6	333	231	208	208
query7	4227	461	275	275
query8	311	263	229	229
query9	8769	2541	2521	2521
query10	560	381	319	319
query11	15254	15153	14465	14465
query12	175	116	115	115
query13	1256	500	399	399
query14	6307	3206	2918	2918
query14_1	2893	2902	2911	2902
query15	220	201	185	185
query16	963	480	504	480
query17	1149	717	610	610
query18	2589	465	377	377
query19	218	221	214	214
query20	118	114	111	111
query21	222	140	112	112
query22	3982	4153	4013	4013
query23	16438	16110	15900	15900
query23_1	16007	15933	15977	15933
query24	7349	1648	1198	1198
query24_1	1249	1225	1212	1212
query25	532	464	425	425
query26	1257	268	160	160
query27	2760	473	313	313
query28	4500	2157	2132	2132
query29	798	540	423	423
query30	315	247	222	222
query31	826	731	619	619
query32	79	74	71	71
query33	560	335	281	281
query34	910	930	540	540
query35	778	817	708	708
query36	874	916	841	841
query37	128	92	75	75
query38	3874	3910	3760	3760
query39	763	741	735	735
query39_1	695	708	711	708
query40	229	142	120	120
query41	68	63	63	63
query42	106	110	101	101
query43	419	436	410	410
query44	1330	752	766	752
query45	192	190	184	184
query46	893	990	613	613
query47	1680	1713	1619	1619
query48	312	329	246	246
query49	654	461	363	363
query50	667	313	222	222
query51	3796	3818	3836	3818
query52	108	117	101	101
query53	326	352	299	299
query54	306	275	263	263
query55	85	79	76	76
query56	323	306	326	306
query57	1151	1146	1101	1101
query58	274	270	264	264
query59	2461	2528	2456	2456
query60	341	333	310	310
query61	193	191	191	191
query62	722	707	648	648
query63	334	297	306	297
query64	5116	1455	991	991
query65	4005	3954	3930	3930
query66	1434	449	321	321
query67	15153	15242	14914	14914
query68	8344	1020	738	738
query69	486	348	311	311
query70	1096	1012	988	988
query71	376	352	284	284
query72	6075	4909	2653	2653
query73	690	592	309	309
query74	8998	8838	8564	8564
query75	3631	3523	3153	3153
query76	4088	1115	741	741
query77	718	382	290	290
query78	9471	9572	8885	8885
query79	1618	908	626	626
query80	690	670	565	565
query81	490	269	235	235
query82	451	132	106	106
query83	276	265	238	238
query84	258	116	95	95
query85	951	507	460	460
query86	328	311	286	286
query87	4099	4081	3963	3963
query88	3853	2265	2250	2250
query89	467	425	399	399
query90	2195	159	143	143
query91	177	170	143	143
query92	81	68	67	67
query93	1107	916	566	566
query94	473	324	291	291
query95	577	340	362	340
query96	589	487	208	208
query97	2591	2657	2528	2528
query98	209	201	203	201
query99	1336	1328	1214	1214
Total cold run time: 264350 ms
Total hot run time: 178504 ms

doris-robot avatar Dec 11 '25 09:12 doris-robot

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

query1	0.06	0.05	0.04
query2	0.13	0.08	0.07
query3	0.32	0.08	0.08
query4	1.61	0.09	0.10
query5	0.26	0.25	0.25
query6	1.19	0.64	0.65
query7	0.03	0.02	0.03
query8	0.08	0.06	0.07
query9	0.58	0.51	0.50
query10	0.58	0.56	0.56
query11	0.26	0.14	0.13
query12	0.26	0.14	0.15
query13	0.63	0.62	0.61
query14	1.01	1.00	1.02
query15	0.88	0.82	0.82
query16	0.39	0.40	0.38
query17	1.05	0.98	1.04
query18	0.23	0.22	0.22
query19	1.86	1.82	1.77
query20	0.02	0.01	0.02
query21	15.41	0.28	0.23
query22	5.00	0.11	0.09
query23	15.40	0.39	0.22
query24	2.46	0.46	0.30
query25	0.10	0.09	0.10
query26	0.19	0.18	0.18
query27	0.09	0.09	0.09
query28	3.77	1.36	1.16
query29	12.57	4.09	3.30
query30	0.32	0.13	0.10
query31	2.81	0.67	0.42
query32	3.23	0.60	0.50
query33	3.11	3.06	3.14
query34	16.79	5.22	4.58
query35	4.70	4.64	4.66
query36	0.62	0.51	0.49
query37	0.24	0.08	0.08
query38	0.20	0.06	0.06
query39	0.07	0.05	0.05
query40	0.18	0.17	0.17
query41	0.12	0.06	0.06
query42	0.08	0.05	0.05
query43	0.06	0.06	0.05
Total cold run time: 98.95 s
Total hot run time: 28.34 s

doris-robot avatar Dec 11 '25 10:12 doris-robot

BE UT Coverage Report

Increment line coverage :tada:

Increment coverage report Complete coverage report

Category Coverage
Function Coverage 53.36% (18764/35165)
Line Coverage 39.11% (173516/443683)
Region Coverage 33.79% (134533/398203)
Branch Coverage 34.72% (57861/166643)

hello-stephen avatar Dec 11 '25 11:12 hello-stephen

BE Regression && UT Coverage Report

Increment line coverage 100% (0/0) :tada:

Increment coverage report Complete coverage report

Category Coverage
Function Coverage 72.35% (24937/34467)
Line Coverage 59.10% (261939/443207)
Region Coverage 54.09% (217938/402926)
Branch Coverage 55.59% (93119/167518)

hello-stephen avatar Dec 11 '25 13:12 hello-stephen

run buildall

starocean999 avatar Dec 12 '25 09:12 starocean999

Cloud UT Coverage Report

Increment line coverage :tada:

Increment coverage report Complete coverage report

Category Coverage
Function Coverage 79.83% (1730/2167)
Line Coverage 65.85% (30605/46476)
Region Coverage 66.60% (15274/22934)
Branch Coverage 56.93% (8122/14266)

doris-robot avatar Dec 12 '25 09:12 doris-robot

FE UT Coverage Report

Increment line coverage 27.87% (80/287) :tada: Increment coverage report Complete coverage report

hello-stephen avatar Dec 12 '25 10:12 hello-stephen

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

------ Round 1 ----------------------------------
q1	17604	4175	4107	4107
q2	2028	361	244	244
q3	10461	1360	753	753
q4	10326	872	324	324
q5	9860	2055	2088	2055
q6	216	165	137	137
q7	1017	860	720	720
q8	9357	1469	1194	1194
q9	7378	5380	5363	5363
q10	6895	2404	2004	2004
q11	521	329	317	317
q12	726	708	582	582
q13	17829	3677	3032	3032
q14	291	303	269	269
q15	603	515	515	515
q16	697	675	627	627
q17	701	787	628	628
q18	8010	7106	7219	7106
q19	1105	970	612	612
q20	392	362	253	253
q21	4304	3944	3754	3754
q22	1059	1030	984	984
Total cold run time: 111380 ms
Total hot run time: 35580 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4120	4081	4083	4081
q2	334	408	308	308
q3	2135	2748	2315	2315
q4	1373	1775	1293	1293
q5	4790	4899	4557	4557
q6	225	178	127	127
q7	2082	1946	1841	1841
q8	2670	2576	2717	2576
q9	7518	7636	7700	7636
q10	3045	3318	2821	2821
q11	639	515	489	489
q12	695	740	595	595
q13	3581	3963	3338	3338
q14	288	292	311	292
q15	557	576	550	550
q16	666	715	647	647
q17	1174	1545	1425	1425
q18	7825	7660	7534	7534
q19	898	851	934	851
q20	2011	2053	1986	1986
q21	4659	4279	4230	4230
q22	1101	1029	994	994
Total cold run time: 52386 ms
Total hot run time: 50486 ms

doris-robot avatar Dec 12 '25 11:12 doris-robot

TPC-DS: Total hot run time: 178971 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 af415a31276d2fe919e9e6fa92929661d8254f5f, data reload: false

query5	4559	619	454	454
query6	350	245	231	231
query7	4229	472	279	279
query8	305	266	248	248
query9	8795	2558	2586	2558
query10	474	374	319	319
query11	15272	14756	14780	14756
query12	176	120	118	118
query13	1270	518	401	401
query14	5544	3275	2985	2985
query14_1	2947	2897	2870	2870
query15	219	203	184	184
query16	943	471	475	471
query17	1171	739	614	614
query18	2487	455	360	360
query19	240	233	209	209
query20	122	114	118	114
query21	221	138	121	121
query22	3895	4064	3885	3885
query23	16568	16334	16019	16019
query23_1	16051	15975	16008	15975
query24	7423	1675	1256	1256
query24_1	1265	1234	1260	1234
query25	612	504	465	465
query26	1249	279	180	180
query27	2721	486	318	318
query28	4447	2158	2134	2134
query29	845	580	474	474
query30	322	248	223	223
query31	848	721	627	627
query32	80	71	71	71
query33	557	359	313	313
query34	922	904	563	563
query35	826	802	733	733
query36	862	895	819	819
query37	126	106	76	76
query38	2899	2861	2817	2817
query39	767	768	720	720
query39_1	699	743	691	691
query40	218	135	118	118
query41	69	62	61	61
query42	108	112	108	108
query43	443	439	418	418
query44	1318	744	756	744
query45	198	191	185	185
query46	877	990	625	625
query47	1647	1693	1632	1632
query48	316	320	247	247
query49	631	439	355	355
query50	661	298	214	214
query51	3812	3871	3848	3848
query52	108	109	98	98
query53	321	349	294	294
query54	290	263	262	262
query55	81	77	75	75
query56	299	303	297	297
query57	1138	1126	1074	1074
query58	267	262	243	243
query59	2387	2509	2453	2453
query60	328	313	298	298
query61	164	159	160	159
query62	698	684	614	614
query63	330	297	304	297
query64	5044	1328	1029	1029
query65	4020	3939	3939	3939
query66	1450	446	336	336
query67	15303	15235	14853	14853
query68	8332	1000	725	725
query69	493	344	314	314
query70	1091	989	989	989
query71	384	328	285	285
query72	6312	5050	5129	5050
query73	682	630	332	332
query74	8858	8776	8622	8622
query75	3188	3138	2775	2775
query76	3832	1134	774	774
query77	544	410	306	306
query78	9386	9708	8839	8839
query79	1828	885	612	612
query80	719	659	563	563
query81	499	273	236	236
query82	210	138	108	108
query83	259	253	241	241
query84	260	120	98	98
query85	906	511	474	474
query86	392	289	301	289
query87	3019	3124	2935	2935
query88	3552	2284	2298	2284
query89	475	430	393	393
query90	2221	165	163	163
query91	180	193	146	146
query92	87	68	68	68
query93	2082	930	556	556
query94	494	305	280	280
query95	589	342	309	309
query96	602	474	219	219
query97	2277	2282	2211	2211
query98	224	201	192	192
query99	1306	1322	1223	1223
Total cold run time: 261158 ms
Total hot run time: 178971 ms

doris-robot avatar Dec 12 '25 11:12 doris-robot

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

query1	0.05	0.05	0.05
query2	0.10	0.05	0.04
query3	0.25	0.08	0.09
query4	1.60	0.11	0.11
query5	0.27	0.26	0.27
query6	1.16	0.65	0.62
query7	0.03	0.03	0.02
query8	0.05	0.05	0.04
query9	0.57	0.51	0.51
query10	0.54	0.56	0.55
query11	0.16	0.11	0.12
query12	0.15	0.11	0.11
query13	0.61	0.60	0.61
query14	0.99	0.98	0.98
query15	0.83	0.80	0.82
query16	0.40	0.41	0.39
query17	1.01	1.05	1.05
query18	0.24	0.21	0.22
query19	1.90	1.87	1.75
query20	0.02	0.02	0.01
query21	15.45	0.27	0.14
query22	4.90	0.05	0.05
query23	15.99	0.28	0.10
query24	1.98	0.59	0.37
query25	0.09	0.21	0.07
query26	0.14	0.12	0.13
query27	0.07	0.06	0.07
query28	3.36	1.23	1.03
query29	12.60	4.01	3.27
query30	0.29	0.14	0.12
query31	2.82	0.63	0.40
query32	3.24	0.55	0.45
query33	2.98	3.09	3.02
query34	16.80	5.14	4.58
query35	4.55	4.70	5.33
query36	0.70	0.55	0.56
query37	0.12	0.07	0.07
query38	0.07	0.05	0.04
query39	0.05	0.03	0.03
query40	0.17	0.14	0.14
query41	0.09	0.03	0.02
query42	0.04	0.02	0.03
query43	0.04	0.03	0.03
Total cold run time: 97.47 s
Total hot run time: 27.67 s

doris-robot avatar Dec 12 '25 11:12 doris-robot

BE UT Coverage Report

Increment line coverage :tada:

Increment coverage report Complete coverage report

Category Coverage
Function Coverage 53.42% (18822/35236)
Line Coverage 39.15% (173991/444372)
Region Coverage 33.79% (134686/398603)
Branch Coverage 34.74% (57970/166882)

doris-robot avatar Dec 12 '25 12:12 doris-robot

BE Regression && UT Coverage Report

Increment line coverage 100% (0/0) :tada:

Increment coverage report Complete coverage report

Category Coverage
Function Coverage 72.41% (25004/34533)
Line Coverage 59.18% (262685/443867)
Region Coverage 54.08% (218102/403319)
Branch Coverage 55.63% (93327/167755)

hello-stephen avatar Dec 12 '25 16:12 hello-stephen

FE Regression Coverage Report

Increment line coverage 80.49% (231/287) :tada: Increment coverage report Complete coverage report

hello-stephen avatar Dec 12 '25 16:12 hello-stephen

run buildall

jacktengg avatar Dec 16 '25 16:12 jacktengg

FE UT Coverage Report

Increment line coverage 27.87% (80/287) :tada: Increment coverage report Complete coverage report

hello-stephen avatar Dec 16 '25 18:12 hello-stephen

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

------ Round 1 ----------------------------------
q1	17645	4329	4152	4152
q2	2025	366	240	240
q3	10504	1340	758	758
q4	10332	798	313	313
q5	9418	2116	2019	2019
q6	226	176	138	138
q7	1019	871	712	712
q8	9370	1493	1177	1177
q9	7365	5349	5322	5322
q10	6890	2398	1942	1942
q11	531	327	295	295
q12	739	781	567	567
q13	17842	3696	3069	3069
q14	285	310	275	275
q15	611	522	532	522
q16	685	685	624	624
q17	714	833	529	529
q18	7740	7320	7012	7012
q19	1148	967	612	612
q20	416	381	253	253
q21	4317	3956	4055	3956
q22	1041	1010	942	942
Total cold run time: 110863 ms
Total hot run time: 35429 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4205	4099	4084	4084
q2	411	411	315	315
q3	2153	2690	2291	2291
q4	1345	1819	1360	1360
q5	4711	4715	4639	4639
q6	219	173	127	127
q7	2059	1988	1830	1830
q8	2675	2577	2570	2570
q9	7549	7449	7557	7449
q10	3054	3250	2983	2983
q11	604	522	502	502
q12	708	746	600	600
q13	3706	4005	3387	3387
q14	301	313	268	268
q15	550	522	515	515
q16	636	714	618	618
q17	1231	1416	1441	1416
q18	7819	7610	7636	7610
q19	853	848	868	848
q20	1888	1961	1872	1872
q21	4691	4463	4198	4198
q22	1081	990	954	954
Total cold run time: 52449 ms
Total hot run time: 50436 ms

doris-robot avatar Dec 16 '25 18:12 doris-robot