doris icon indicating copy to clipboard operation
doris copied to clipboard

[fix](mtmv) Fix mv rewrite failed when mv is rewritten by LimitAggToTopNAgg but query is not

Open seawinde opened this issue 1 month ago • 6 comments

What problem does this PR solve?

Fix mv rewrite failed when mv is rewritten by LimitAggToTopNAgg but query is not such as query and mv def sql is as fllowing:

SELECT
              c_name,
              c_custkey,
              o_orderkey,
              o_orderdate,
              o_totalprice,
              sum(l_quantity)
            FROM
              customer,
              orders,
              lineitem
            WHERE
              o_orderkey IN (
                SELECT l_orderkey
                FROM
                  lineitem
                GROUP BY
                  l_orderkey
                HAVING
                  sum(l_quantity) > 300
              )
              AND c_custkey = o_custkey
              AND o_orderkey = l_orderkey
            GROUP BY
              c_name,
              c_custkey,
              o_orderkey,
              o_orderdate,
              o_totalprice
            ORDER BY
              o_totalprice DESC,
              o_orderdate
            LIMIT 100

if query plan is rewrtten by rule LimitAggToTopNAgg, plan would be like as following, tonN contains all goup by key

 LogicalResultSink[812] ( outputExprs=[c_name#1, c_custkey#0, o_orderkey#8, o_orderdate#12, o_totalprice#11, __sum_5#50] )                                                                                                                                                                                                                                                        
**| +--LogicalTopN ( limit=100, offset=0, orderKeys=[o_totalprice#11 desc, o_orderdate#12 asc null first, c_name#1 asc, c_custkey#0 asc, o_orderkey#8 asc] )**                                                                                                                                                                                                                         

if mv plan is not rewrtten by rule LimitAggToTopNAgg, plan would be like as following, tonN not contain all goup by key

LogicalResultSink[801] ( outputExprs=[c_name#1, c_custkey#0, o_orderkey#8, o_orderdate#12, o_totalprice#11, __sum_5#50] )
    **+--LogicalTopN ( limit=100, offset=0, orderKeys=[o_totalprice#11 desc, o_orderdate#12 asc null first] )**

this would cause doris/regression-test/suites/nereids_rules_p0/mv/tpch/mv_tpch_test.groovy mv18 rewrite fail, the pr fix this

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.
      • [x] 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

seawinde avatar Dec 11 '25 12:12 seawinde

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 Dec 11 '25 12:12 hello-stephen

run buildall

seawinde avatar Dec 11 '25 12:12 seawinde

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

------ Round 1 ----------------------------------
q1	17606	4231	4142	4142
q2	2024	353	244	244
q3	10171	1362	758	758
q4	10205	830	334	334
q5	7533	2050	2051	2050
q6	183	172	135	135
q7	1011	833	739	739
q8	9382	1413	1270	1270
q9	7093	5338	5390	5338
q10	6808	2384	1977	1977
q11	526	312	295	295
q12	651	757	603	603
q13	17760	3654	3091	3091
q14	313	297	272	272
q15	580	518	528	518
q16	907	925	878	878
q17	716	794	531	531
q18	7476	7151	7032	7032
q19	1106	972	623	623
q20	414	369	259	259
q21	4227	3984	3707	3707
q22	1042	999	977	977
Total cold run time: 107734 ms
Total hot run time: 35773 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4137	4069	4088	4069
q2	327	405	322	322
q3	2160	2673	2282	2282
q4	1317	1773	1333	1333
q5	4257	4656	4834	4656
q6	243	183	136	136
q7	2109	1991	1832	1832
q8	2660	2610	2561	2561
q9	7845	7519	7486	7486
q10	3148	3231	2814	2814
q11	599	514	494	494
q12	714	765	596	596
q13	3526	4049	3286	3286
q14	282	300	282	282
q15	549	496	591	496
q16	1056	940	856	856
q17	1199	1369	1330	1330
q18	8277	7692	7686	7686
q19	891	886	890	886
q20	2072	2149	1903	1903
q21	5064	4538	4286	4286
q22	1066	1041	1006	1006
Total cold run time: 53498 ms
Total hot run time: 50598 ms

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

TPC-DS: Total hot run time: 180941 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 85d0a2196931841f78a17c1d76c4fb34bd35cbe4, data reload: false

query5	4928	640	491	491
query6	342	249	242	242
query7	4225	478	280	280
query8	324	271	251	251
query9	8791	2596	2596	2596
query10	528	384	338	338
query11	15332	14744	14584	14584
query12	194	123	116	116
query13	1279	523	411	411
query14	6338	3385	3055	3055
query14_1	2896	2965	2952	2952
query15	213	206	184	184
query16	921	489	465	465
query17	1123	721	610	610
query18	2718	454	364	364
query19	246	240	217	217
query20	129	118	113	113
query21	225	139	117	117
query22	3910	3956	3757	3757
query23	16561	16207	15909	15909
query23_1	16019	16052	15972	15972
query24	7406	1660	1251	1251
query24_1	1253	1262	1265	1262
query25	584	497	490	490
query26	1233	266	163	163
query27	2766	493	307	307
query28	4420	2157	2160	2157
query29	807	553	441	441
query30	319	237	219	219
query31	807	699	640	640
query32	74	73	71	71
query33	554	341	298	298
query34	904	902	548	548
query35	805	818	727	727
query36	876	920	828	828
query37	138	105	81	81
query38	3913	3726	3830	3726
query39	763	760	712	712
query39_1	700	693	682	682
query40	229	143	124	124
query41	68	67	62	62
query42	108	108	105	105
query43	434	442	401	401
query44	1369	762	763	762
query45	197	187	183	183
query46	878	978	614	614
query47	1641	1684	1584	1584
query48	314	334	255	255
query49	632	477	402	402
query50	662	298	232	232
query51	3797	3829	3752	3752
query52	111	111	101	101
query53	327	348	292	292
query54	292	276	256	256
query55	80	84	72	72
query56	300	299	310	299
query57	1136	1107	1068	1068
query58	275	258	256	256
query59	2438	2436	2357	2357
query60	322	320	304	304
query61	164	158	153	153
query62	690	675	615	615
query63	323	300	297	297
query64	4945	1296	1020	1020
query65	4010	3965	3952	3952
query66	1437	443	325	325
query67	15180	14997	14749	14749
query68	8355	1032	748	748
query69	504	360	315	315
query70	1119	1021	1012	1012
query71	363	315	297	297
query72	6101	4915	4765	4765
query73	684	587	315	315
query74	8797	8697	8564	8564
query75	3563	3590	3185	3185
query76	3950	1185	770	770
query77	529	411	283	283
query78	9425	9755	8767	8767
query79	1642	884	615	615
query80	725	657	553	553
query81	521	267	241	241
query82	209	128	105	105
query83	270	266	241	241
query84	268	117	104	104
query85	936	510	463	463
query86	385	302	288	288
query87	4136	4087	3961	3961
query88	3230	2301	2276	2276
query89	466	434	412	412
query90	2118	167	165	165
query91	178	170	146	146
query92	76	67	64	64
query93	1133	951	574	574
query94	481	323	265	265
query95	570	393	324	324
query96	602	464	211	211
query97	2572	2652	2550	2550
query98	224	200	205	200
query99	1301	1363	1261	1261
Total cold run time: 263426 ms
Total hot run time: 180941 ms

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

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

query1	0.05	0.05	0.04
query2	0.10	0.04	0.04
query3	0.25	0.08	0.08
query4	1.61	0.11	0.11
query5	0.28	0.25	0.26
query6	1.19	0.64	0.64
query7	0.04	0.03	0.02
query8	0.05	0.04	0.04
query9	0.58	0.51	0.51
query10	0.54	0.54	0.56
query11	0.17	0.11	0.13
query12	0.15	0.12	0.11
query13	0.62	0.60	0.61
query14	0.99	0.99	1.00
query15	0.81	0.81	0.84
query16	0.42	0.40	0.43
query17	1.08	1.03	0.99
query18	0.23	0.22	0.22
query19	1.85	1.74	1.76
query20	0.02	0.02	0.01
query21	15.44	0.28	0.14
query22	4.74	0.05	0.05
query23	16.08	0.27	0.11
query24	0.94	0.66	0.95
query25	0.11	0.08	0.06
query26	0.14	0.14	0.13
query27	0.09	0.04	0.04
query28	5.32	1.22	1.02
query29	12.64	4.01	3.22
query30	0.27	0.15	0.13
query31	2.81	0.64	0.39
query32	3.23	0.55	0.48
query33	3.06	2.95	3.03
query34	17.00	5.18	4.50
query35	4.55	4.52	4.54
query36	0.67	0.50	0.49
query37	0.11	0.07	0.06
query38	0.07	0.04	0.04
query39	0.04	0.02	0.03
query40	0.17	0.14	0.13
query41	0.09	0.03	0.02
query42	0.05	0.04	0.03
query43	0.04	0.03	0.04
Total cold run time: 98.69 s
Total hot run time: 27.47 s

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

FE Regression Coverage Report

Increment line coverage 100.00% (1/1) :tada: Increment coverage report Complete coverage report

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

FE Regression Coverage Report

Increment line coverage 100.00% (1/1) :tada: Increment coverage report Complete coverage report

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

run buildall

seawinde avatar Dec 12 '25 03:12 seawinde

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

------ Round 1 ----------------------------------
q1	18457	4339	4204	4204
q2	2499	370	241	241
q3	10286	1364	776	776
q4	10976	879	318	318
q5	7507	2247	1919	1919
q6	189	172	140	140
q7	1043	882	708	708
q8	9457	1467	1148	1148
q9	7740	5404	5286	5286
q10	7246	2404	2001	2001
q11	570	331	293	293
q12	682	725	586	586
q13	17788	3732	3043	3043
q14	292	297	269	269
q15	602	525	510	510
q16	700	678	642	642
q17	726	858	534	534
q18	7500	7135	7045	7045
q19	1102	978	618	618
q20	408	365	246	246
q21	4206	3989	3619	3619
q22	1030	1050	979	979
Total cold run time: 111006 ms
Total hot run time: 35125 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4097	4072	4091	4072
q2	335	398	317	317
q3	2159	2694	2311	2311
q4	1310	1740	1289	1289
q5	4840	4703	4655	4655
q6	221	175	128	128
q7	2006	1945	1836	1836
q8	2684	2546	2485	2485
q9	7563	7570	7459	7459
q10	3073	3250	2823	2823
q11	600	594	497	497
q12	715	799	593	593
q13	3586	4017	3364	3364
q14	282	293	290	290
q15	565	565	541	541
q16	673	683	636	636
q17	1203	1384	1389	1384
q18	8001	7590	7907	7590
q19	911	888	910	888
q20	2013	2074	1962	1962
q21	4614	4316	4227	4227
q22	1100	1054	1000	1000
Total cold run time: 52551 ms
Total hot run time: 50347 ms

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

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

query5	4441	623	498	498
query6	360	242	236	236
query7	4233	470	284	284
query8	305	270	253	253
query9	8775	2574	2565	2565
query10	538	390	322	322
query11	15363	15414	14591	14591
query12	193	122	119	119
query13	1275	534	396	396
query14	6631	3351	3045	3045
query14_1	2949	2937	2923	2923
query15	223	200	183	183
query16	920	483	466	466
query17	1153	726	615	615
query18	2722	455	355	355
query19	270	227	205	205
query20	123	111	112	111
query21	282	137	120	120
query22	4060	4197	3855	3855
query23	16507	16311	15912	15912
query23_1	16018	16079	16010	16010
query24	7348	1679	1239	1239
query24_1	1254	1258	1245	1245
query25	560	521	426	426
query26	1245	270	157	157
query27	2754	482	309	309
query28	4429	2143	2141	2141
query29	800	545	452	452
query30	347	241	229	229
query31	836	687	634	634
query32	80	69	69	69
query33	538	346	293	293
query34	905	919	538	538
query35	804	821	744	744
query36	866	898	798	798
query37	160	91	76	76
query38	2859	2908	2889	2889
query39	767	747	728	728
query39_1	713	708	683	683
query40	227	139	121	121
query41	66	63	61	61
query42	109	107	103	103
query43	439	443	409	409
query44	1360	748	756	748
query45	200	190	184	184
query46	907	984	619	619
query47	1654	1673	1610	1610
query48	314	336	248	248
query49	641	437	354	354
query50	681	311	224	224
query51	3826	3861	3796	3796
query52	104	116	105	105
query53	322	352	292	292
query54	298	266	251	251
query55	79	75	74	74
query56	298	311	305	305
query57	1134	1149	1095	1095
query58	290	261	258	258
query59	2446	2506	2383	2383
query60	318	326	293	293
query61	166	160	154	154
query62	704	656	610	610
query63	328	311	308	308
query64	4849	1309	1013	1013
query65	4069	3937	4016	3937
query66	1380	439	322	322
query67	15328	15088	15030	15030
query68	4705	1045	745	745
query69	531	353	314	314
query70	1055	995	984	984
query71	374	310	301	301
query72	6194	5182	5231	5182
query73	712	636	314	314
query74	8827	8780	8677	8677
query75	3159	3142	2802	2802
query76	3959	1178	792	792
query77	530	397	307	307
query78	9499	9505	8926	8926
query79	2074	894	630	630
query80	1545	667	569	569
query81	593	274	232	232
query82	433	135	106	106
query83	351	256	253	253
query84	262	117	106	106
query85	968	513	469	469
query86	461	296	310	296
query87	3079	3145	3000	3000
query88	3282	2305	2263	2263
query89	466	430	392	392
query90	2041	165	161	161
query91	170	165	159	159
query92	85	69	66	66
query93	1267	908	563	563
query94	541	319	298	298
query95	583	391	318	318
query96	594	473	211	211
query97	2315	2330	2227	2227
query98	210	201	187	187
query99	1273	1327	1211	1211
Total cold run time: 259536 ms
Total hot run time: 179247 ms

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

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

query1	0.05	0.05	0.05
query2	0.16	0.05	0.05
query3	0.26	0.09	0.09
query4	1.61	0.12	0.11
query5	0.28	0.24	0.27
query6	1.18	0.64	0.63
query7	0.03	0.03	0.03
query8	0.05	0.04	0.04
query9	0.61	0.52	0.53
query10	0.56	0.56	0.56
query11	0.19	0.11	0.12
query12	0.15	0.12	0.12
query13	0.62	0.60	0.60
query14	0.99	1.00	0.98
query15	0.81	0.80	0.81
query16	0.43	0.39	0.41
query17	1.08	1.06	1.05
query18	0.23	0.21	0.22
query19	1.89	1.86	1.85
query20	0.02	0.02	0.01
query21	15.44	0.30	0.15
query22	4.73	0.05	0.04
query23	16.22	0.28	0.10
query24	2.05	0.69	0.25
query25	0.08	0.04	0.06
query26	0.15	0.13	0.14
query27	0.07	0.05	0.05
query28	3.85	1.22	1.02
query29	12.66	4.13	3.26
query30	0.28	0.14	0.11
query31	2.82	0.63	0.39
query32	3.24	0.56	0.46
query33	2.98	3.02	3.05
query34	16.98	5.24	4.56
query35	4.60	4.65	4.60
query36	0.65	0.50	0.51
query37	0.13	0.07	0.06
query38	0.07	0.05	0.04
query39	0.07	0.03	0.03
query40	0.17	0.14	0.14
query41	0.10	0.04	0.03
query42	0.06	0.04	0.03
query43	0.05	0.03	0.04
Total cold run time: 98.65 s
Total hot run time: 27.48 s

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

FE UT Coverage Report

Increment line coverage 0.00% (0/2) :tada: Increment coverage report Complete coverage report

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

run buildall

seawinde avatar Dec 12 '25 06:12 seawinde

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

------ Round 1 ----------------------------------
q1	17638	4229	4045	4045
q2	2082	353	248	248
q3	10136	1369	749	749
q4	10222	825	307	307
q5	8092	2169	1875	1875
q6	218	165	134	134
q7	1009	848	708	708
q8	9354	1437	1141	1141
q9	7146	5349	5316	5316
q10	6869	2402	1966	1966
q11	516	333	289	289
q12	741	736	577	577
q13	17784	3658	3012	3012
q14	297	298	271	271
q15	595	515	516	515
q16	683	671	626	626
q17	686	806	544	544
q18	7429	7625	7825	7625
q19	1508	1022	635	635
q20	431	369	264	264
q21	4545	4296	4172	4172
q22	1123	1073	1020	1020
Total cold run time: 109104 ms
Total hot run time: 36039 ms

----- Round 2, with runtime_filter_mode=off -----
q1	4410	4340	4256	4256
q2	324	398	316	316
q3	2422	3090	2457	2457
q4	1371	1918	1399	1399
q5	4579	4470	4566	4470
q6	213	163	123	123
q7	2049	1955	1801	1801
q8	2724	2523	2544	2523
q9	7437	7459	7207	7207
q10	2901	3105	2643	2643
q11	563	505	475	475
q12	620	689	571	571
q13	3263	3587	2988	2988
q14	256	279	258	258
q15	536	500	497	497
q16	618	639	591	591
q17	1090	1316	1356	1316
q18	7374	7105	7006	7006
q19	875	820	831	820
q20	1880	1942	1818	1818
q21	4617	4283	4166	4166
q22	1073	1021	991	991
Total cold run time: 51195 ms
Total hot run time: 48692 ms

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

TPC-DS: Total hot run time: 177746 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 9d6d48cfa24b183c75773507aac862d3e58fcdce, data reload: false

query5	5097	665	481	481
query6	340	222	232	222
query7	4233	470	275	275
query8	308	258	237	237
query9	8780	2542	2573	2542
query10	550	387	327	327
query11	15353	14968	14431	14431
query12	198	127	113	113
query13	1275	509	385	385
query14	6661	3227	3001	3001
query14_1	2880	2882	2906	2882
query15	207	196	181	181
query16	885	477	438	438
query17	1133	724	606	606
query18	2709	458	353	353
query19	235	236	213	213
query20	124	114	121	114
query21	221	143	115	115
query22	3873	3960	3852	3852
query23	16650	16301	15999	15999
query23_1	16095	16096	16086	16086
query24	7252	1660	1256	1256
query24_1	1258	1236	1251	1236
query25	595	496	441	441
query26	1240	265	163	163
query27	2733	471	313	313
query28	4446	2121	2119	2119
query29	816	576	473	473
query30	317	247	216	216
query31	833	691	630	630
query32	76	73	67	67
query33	557	352	295	295
query34	910	906	551	551
query35	786	829	723	723
query36	872	893	805	805
query37	133	140	79	79
query38	2900	2832	2846	2832
query39	767	738	726	726
query39_1	693	695	689	689
query40	230	132	118	118
query41	65	64	66	64
query42	106	108	106	106
query43	435	436	397	397
query44	1368	755	736	736
query45	192	184	180	180
query46	905	995	625	625
query47	1654	1679	1597	1597
query48	323	334	243	243
query49	654	426	352	352
query50	682	298	217	217
query51	3814	3877	3912	3877
query52	105	111	98	98
query53	317	356	292	292
query54	292	277	255	255
query55	79	75	73	73
query56	320	296	289	289
query57	1146	1128	1080	1080
query58	275	261	258	258
query59	2332	2419	2434	2419
query60	307	324	296	296
query61	201	156	151	151
query62	719	691	642	642
query63	327	302	300	300
query64	4925	1329	1020	1020
query65	4027	3973	3962	3962
query66	1391	445	314	314
query67	15227	14871	14695	14695
query68	8233	1027	718	718
query69	491	355	309	309
query70	1084	967	997	967
query71	372	309	284	284
query72	6095	4890	4835	4835
query73	679	569	316	316
query74	8645	8830	8589	8589
query75	3155	3106	2755	2755
query76	3990	1166	747	747
query77	541	417	297	297
query78	9606	9724	8836	8836
query79	1720	859	599	599
query80	723	681	543	543
query81	493	272	235	235
query82	226	136	103	103
query83	268	261	234	234
query84	265	117	98	98
query85	911	499	474	474
query86	386	316	277	277
query87	3026	3042	2985	2985
query88	3257	2248	2261	2248
query89	463	420	396	396
query90	2169	156	156	156
query91	171	166	145	145
query92	83	68	64	64
query93	1913	892	553	553
query94	479	295	281	281
query95	577	316	314	314
query96	580	477	205	205
query97	2258	2274	2232	2232
query98	213	195	195	195
query99	1295	1339	1194	1194
Total cold run time: 261439 ms
Total hot run time: 177746 ms

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

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

query1	0.05	0.05	0.05
query2	0.11	0.05	0.05
query3	0.25	0.09	0.09
query4	1.61	0.11	0.11
query5	0.28	0.26	0.25
query6	1.18	0.63	0.62
query7	0.03	0.02	0.02
query8	0.05	0.04	0.04
query9	0.58	0.51	0.51
query10	0.55	0.56	0.56
query11	0.16	0.11	0.11
query12	0.15	0.12	0.12
query13	0.62	0.61	0.60
query14	0.99	0.98	0.99
query15	0.80	0.82	0.80
query16	0.42	0.39	0.39
query17	1.05	1.07	1.04
query18	0.22	0.21	0.21
query19	1.91	1.86	1.86
query20	0.01	0.02	0.01
query21	15.45	0.30	0.15
query22	4.93	0.05	0.05
query23	16.19	0.29	0.10
query24	1.53	0.46	1.08
query25	0.08	0.05	0.05
query26	0.14	0.14	0.14
query27	0.06	0.07	0.05
query28	4.59	1.21	1.02
query29	12.62	3.94	3.19
query30	0.28	0.13	0.12
query31	2.83	0.64	0.38
query32	3.23	0.54	0.46
query33	3.00	3.02	3.08
query34	16.72	5.23	4.59
query35	4.58	4.67	4.55
query36	0.67	0.52	0.50
query37	0.10	0.07	0.07
query38	0.07	0.05	0.04
query39	0.04	0.02	0.03
query40	0.17	0.14	0.13
query41	0.09	0.03	0.03
query42	0.04	0.02	0.02
query43	0.05	0.03	0.03
Total cold run time: 98.48 s
Total hot run time: 27.59 s

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

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

github-actions[bot] avatar Dec 12 '25 09:12 github-actions[bot]

PR approved by anyone and no changes requested.

github-actions[bot] avatar Dec 12 '25 09:12 github-actions[bot]

FE Regression Coverage Report

Increment line coverage 100.00% (2/2) :tada: Increment coverage report Complete coverage report

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

FE Regression Coverage Report

Increment line coverage 100.00% (2/2) :tada: Increment coverage report Complete coverage report

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