Skip to content

[Enhancement] (nereids)implement showStoragePolicyCommand in nereids - #44393

Merged
starocean999 merged 1 commit into
apache:masterfrom
msridhar78:show_storage_policy
Mar 5, 2025
Merged

[Enhancement] (nereids)implement showStoragePolicyCommand in nereids#44393
starocean999 merged 1 commit into
apache:masterfrom
msridhar78:show_storage_policy

Conversation

@msridhar78

@msridhar78 msridhar78 commented Nov 21, 2024 •
edited
Loading

Copy link
Copy Markdown
Contributor

What problem does this PR solve?

Issue Number: close #42721

Problem Summary:

[Enhancement] (nereids)implement showStoragePolicyCommand in nereids

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

@doris-robot

doris-robot commented Nov 21, 2024

Copy link
Copy Markdown

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?

@msridhar78

msridhar78 commented Nov 21, 2024

Copy link
Copy Markdown
Contributor Author

run buildall

@doris-robot

doris-robot commented Nov 21, 2024

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

------ Round 1 ----------------------------------
q1	17601	7464	7250	7250
q2	2044	175	167	167
q3	10657	1073	1187	1073
q4	10588	812	762	762
q5	7615	2736	2739	2736
q6	241	151	150	150
q7	1003	656	604	604
q8	9217	1871	1892	1871
q9	6598	6390	6407	6390
q10	7044	2331	2323	2323
q11	466	265	260	260
q12	428	231	221	221
q13	17801	3022	3098	3022
q14	247	225	218	218
q15	572	531	521	521
q16	673	607	585	585
q17	987	550	534	534
q18	7469	6972	6864	6864
q19	1338	1008	1026	1008
q20	486	187	182	182
q21	3972	3260	3126	3126
q22	375	316	312	312
Total cold run time: 107422 ms
Total hot run time: 40179 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7696	7347	7277	7277
q2	317	225	230	225
q3	2903	2850	2957	2850
q4	2129	1828	1863	1828
q5	5656	5738	5707	5707
q6	224	144	142	142
q7	2247	1800	1785	1785
q8	3413	3575	3542	3542
q9	8922	8956	8956	8956
q10	3611	3538	3586	3538
q11	600	523	513	513
q12	809	612	620	612
q13	10978	3283	3202	3202
q14	291	266	281	266
q15	585	534	530	530
q16	705	647	645	645
q17	1863	1631	1627	1627
q18	8452	7800	7662	7662
q19	1740	1606	1560	1560
q20	2100	1953	1997	1953
q21	5630	5398	5406	5398
q22	653	569	568	568
Total cold run time: 71524 ms
Total hot run time: 60386 ms

@doris-robot

doris-robot commented Nov 21, 2024

Copy link
Copy Markdown
TPC-DS: Total hot run time: 197673 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 f1124e44cd4bf27eb85dcc04805cdf8ef39b4e68, data reload: false

query1	1253	974	948	948
query2	6249	2040	2013	2013
query3	10775	4095	4113	4095
query4	68025	28779	23597	23597
query5	4980	468	472	468
query6	410	187	181	181
query7	5518	296	288	288
query8	312	228	221	221
query9	8590	2680	2666	2666
query10	441	251	252	251
query11	17373	15198	15941	15198
query12	157	105	102	102
query13	1445	441	418	418
query14	10519	7362	7596	7362
query15	206	195	221	195
query16	7111	478	502	478
query17	1091	564	573	564
query18	1886	302	305	302
query19	205	153	166	153
query20	124	112	115	112
query21	195	102	106	102
query22	4805	4630	4512	4512
query23	35206	34316	34670	34316
query24	5540	2524	2474	2474
query25	497	444	416	416
query26	642	153	155	153
query27	2109	296	298	296
query28	3974	2484	2441	2441
query29	714	466	451	451
query30	222	152	148	148
query31	1019	842	864	842
query32	66	54	55	54
query33	432	295	278	278
query34	934	522	506	506
query35	856	761	729	729
query36	1106	969	974	969
query37	129	75	77	75
query38	4526	4480	4456	4456
query39	1548	1487	1540	1487
query40	208	103	99	99
query41	81	42	41	41
query42	115	107	101	101
query43	546	525	509	509
query44	1242	878	872	872
query45	201	180	170	170
query46	1168	724	728	724
query47	2067	1984	1979	1979
query48	426	330	340	330
query49	719	398	397	397
query50	845	407	396	396
query51	7439	7247	7164	7164
query52	101	86	86	86
query53	253	176	175	175
query54	502	404	389	389
query55	76	76	75	75
query56	257	242	241	241
query57	1296	1165	1160	1160
query58	221	211	204	204
query59	3165	2942	3042	2942
query60	283	253	254	253
query61	141	132	125	125
query62	774	720	672	672
query63	207	188	187	187
query64	1351	655	648	648
query65	3294	3238	3206	3206
query66	702	300	311	300
query67	16246	15750	15929	15750
query68	4021	581	564	564
query69	429	253	247	247
query70	1182	1152	1110	1110
query71	363	277	255	255
query72	6505	4097	4062	4062
query73	777	358	362	358
query74	10288	9103	9060	9060
query75	3416	2723	2692	2692
query76	1921	992	1106	992
query77	501	277	278	277
query78	10631	9454	9471	9454
query79	1448	597	592	592
query80	861	448	450	448
query81	516	227	233	227
query82	1196	131	116	116
query83	194	159	144	144
query84	283	75	71	71
query85	825	313	300	300
query86	321	300	298	298
query87	4961	4704	4588	4588
query88	3823	2248	2192	2192
query89	418	296	305	296
query90	2021	194	187	187
query91	132	102	110	102
query92	66	51	51	51
query93	1864	545	544	544
query94	751	302	269	269
query95	355	247	243	243
query96	632	274	271	271
query97	2867	2738	2675	2675
query98	209	201	191	191
query99	1658	1292	1285	1285
Total cold run time: 320551 ms
Total hot run time: 197673 ms

@doris-robot

doris-robot commented Nov 21, 2024

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

query1	0.03	0.03	0.03
query2	0.06	0.04	0.03
query3	0.23	0.08	0.07
query4	1.64	0.10	0.10
query5	0.44	0.42	0.40
query6	1.17	0.66	0.66
query7	0.02	0.01	0.02
query8	0.04	0.03	0.03
query9	0.55	0.52	0.52
query10	0.55	0.56	0.54
query11	0.14	0.10	0.10
query12	0.14	0.11	0.11
query13	0.61	0.60	0.59
query14	2.72	2.85	2.88
query15	0.88	0.83	0.83
query16	0.37	0.38	0.38
query17	1.06	1.08	0.98
query18	0.23	0.22	0.22
query19	1.95	1.87	2.02
query20	0.02	0.01	0.01
query21	15.35	0.60	0.60
query22	2.37	2.32	1.96
query23	16.95	1.08	0.85
query24	2.96	1.73	1.07
query25	0.29	0.24	0.05
query26	0.39	0.13	0.13
query27	0.04	0.04	0.05
query28	10.15	1.11	1.09
query29	12.57	3.28	3.28
query30	0.25	0.07	0.07
query31	2.87	0.39	0.38
query32	3.28	0.47	0.48
query33	3.04	3.07	3.08
query34	17.07	4.47	4.45
query35	4.53	4.50	4.46
query36	0.66	0.50	0.49
query37	0.09	0.06	0.07
query38	0.05	0.04	0.04
query39	0.03	0.03	0.02
query40	0.17	0.13	0.13
query41	0.08	0.03	0.02
query42	0.03	0.02	0.02
query43	0.04	0.03	0.03
Total cold run time: 106.11 s
Total hot run time: 33.11 s

@msridhar78

msridhar78 commented Nov 28, 2024

Copy link
Copy Markdown
Contributor Author

run buildall

@doris-robot

doris-robot commented Nov 28, 2024

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

------ Round 1 ----------------------------------
q1	17569	7434	7289	7289
q2	2034	176	187	176
q3	10606	1083	1197	1083
q4	10562	772	804	772
q5	7602	2693	2651	2651
q6	241	148	147	147
q7	974	623	614	614
q8	9240	1830	1899	1830
q9	6492	6403	6365	6365
q10	7050	2279	2301	2279
q11	465	271	248	248
q12	419	223	223	223
q13	17816	3027	3026	3026
q14	238	206	207	206
q15	596	519	511	511
q16	653	583	581	581
q17	969	533	520	520
q18	7272	6680	6711	6680
q19	1349	1021	894	894
q20	457	179	185	179
q21	3960	3240	3162	3162
q22	382	307	311	307
Total cold run time: 106946 ms
Total hot run time: 39743 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7219	7249	7236	7236
q2	328	225	227	225
q3	2890	2803	2921	2803
q4	2041	1787	1830	1787
q5	5673	5674	5666	5666
q6	227	140	145	140
q7	2243	1804	1812	1804
q8	3372	3593	3480	3480
q9	8917	8903	8967	8903
q10	3586	3529	3533	3529
q11	607	490	512	490
q12	829	591	591	591
q13	13457	3256	3177	3177
q14	312	277	269	269
q15	570	528	520	520
q16	705	669	639	639
q17	1828	1627	1634	1627
q18	8346	7750	7713	7713
q19	1682	1588	1554	1554
q20	2085	1846	1863	1846
q21	5631	5339	5467	5339
q22	635	589	597	589
Total cold run time: 73183 ms
Total hot run time: 59927 ms

@doris-robot

doris-robot commented Nov 28, 2024

Copy link
Copy Markdown
TPC-DS: Total hot run time: 195937 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 b1de3a846940b467c91e36371d5b889c2cd324b5, data reload: false

query1	1301	950	919	919
query2	6226	2086	2071	2071
query3	10946	4044	4083	4044
query4	66997	28770	23578	23578
query5	4889	478	461	461
query6	418	193	172	172
query7	5539	292	292	292
query8	328	238	231	231
query9	8704	2722	2737	2722
query10	428	249	252	249
query11	17043	15206	15975	15206
query12	159	105	108	105
query13	1449	450	436	436
query14	10354	7496	6573	6573
query15	217	195	194	194
query16	7225	459	456	456
query17	1036	575	566	566
query18	1931	295	310	295
query19	194	150	145	145
query20	127	111	114	111
query21	213	104	101	101
query22	4824	4447	4458	4447
query23	35036	34221	34736	34221
query24	5800	2557	2458	2458
query25	478	406	388	388
query26	648	149	154	149
query27	2057	282	283	282
query28	4605	2503	2455	2455
query29	683	416	431	416
query30	215	149	145	145
query31	1029	832	845	832
query32	62	55	56	55
query33	436	280	302	280
query34	921	518	524	518
query35	874	760	752	752
query36	1102	957	961	957
query37	125	74	78	74
query38	4437	4520	4342	4342
query39	1531	1494	1453	1453
query40	200	97	96	96
query41	43	42	41	41
query42	125	103	111	103
query43	549	502	490	490
query44	1187	829	843	829
query45	193	167	167	167
query46	1160	701	687	687
query47	2036	1926	1961	1926
query48	415	328	319	319
query49	738	402	381	381
query50	849	406	396	396
query51	7377	7227	6999	6999
query52	101	91	90	90
query53	246	176	184	176
query54	507	395	389	389
query55	76	74	77	74
query56	252	240	235	235
query57	1309	1213	1142	1142
query58	219	206	233	206
query59	3154	3094	3305	3094
query60	257	246	251	246
query61	112	109	104	104
query62	819	671	665	665
query63	207	180	186	180
query64	1413	676	622	622
query65	3236	3202	3223	3202
query66	710	302	304	302
query67	15811	15611	15680	15611
query68	3886	564	547	547
query69	432	253	254	253
query70	1172	1171	1115	1115
query71	360	252	251	251
query72	6376	3993	4113	3993
query73	774	358	361	358
query74	10278	8935	9087	8935
query75	3393	2647	2654	2647
query76	1922	1099	1113	1099
query77	486	272	282	272
query78	10656	9520	9409	9409
query79	1509	592	580	580
query80	889	429	433	429
query81	527	250	231	231
query82	1317	120	114	114
query83	274	152	149	149
query84	278	71	70	70
query85	911	309	295	295
query86	334	304	301	301
query87	4735	4607	4650	4607
query88	3792	2217	2206	2206
query89	419	292	290	290
query90	2065	197	188	188
query91	135	103	104	103
query92	68	49	49	49
query93	1942	541	535	535
query94	828	295	299	295
query95	345	246	289	246
query96	618	284	286	284
query97	2873	2711	2650	2650
query98	217	197	195	195
query99	1804	1318	1333	1318
Total cold run time: 319503 ms
Total hot run time: 195937 ms

@doris-robot

doris-robot commented Nov 28, 2024

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

query1	0.03	0.03	0.03
query2	0.08	0.04	0.03
query3	0.23	0.08	0.06
query4	1.63	0.10	0.11
query5	0.42	0.42	0.42
query6	1.19	0.66	0.65
query7	0.02	0.02	0.02
query8	0.04	0.03	0.03
query9	0.59	0.50	0.49
query10	0.55	0.56	0.56
query11	0.14	0.11	0.11
query12	0.15	0.12	0.11
query13	0.62	0.62	0.60
query14	2.75	2.73	2.74
query15	0.91	0.82	0.82
query16	0.39	0.37	0.39
query17	1.00	0.96	1.05
query18	0.22	0.21	0.21
query19	1.85	1.82	2.00
query20	0.01	0.01	0.01
query21	15.36	0.61	0.60
query22	2.58	2.09	1.53
query23	17.22	1.02	0.83
query24	3.42	1.59	0.66
query25	0.17	0.18	0.17
query26	0.48	0.13	0.14
query27	0.04	0.04	0.05
query28	10.13	1.11	1.07
query29	12.55	3.23	3.22
query30	0.25	0.07	0.06
query31	2.86	0.38	0.37
query32	3.29	0.47	0.47
query33	3.01	3.02	3.02
query34	17.05	4.47	4.48
query35	4.54	4.50	4.43
query36	0.66	0.49	0.49
query37	0.10	0.07	0.07
query38	0.05	0.03	0.04
query39	0.03	0.02	0.03
query40	0.17	0.12	0.12
query41	0.07	0.03	0.02
query42	0.04	0.02	0.02
query43	0.03	0.04	0.04
Total cold run time: 106.92 s
Total hot run time: 32.01 s

@msridhar78

msridhar78 commented Nov 28, 2024

Copy link
Copy Markdown
Contributor Author

run p0

@msridhar78

msridhar78 commented Nov 28, 2024

Copy link
Copy Markdown
Contributor Author

run buildall

@doris-robot

doris-robot commented Nov 28, 2024

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

------ Round 1 ----------------------------------
q1	17679	7654	7358	7358
q2	2059	186	188	186
q3	10688	1140	1218	1140
q4	10533	707	677	677
q5	7633	2815	2717	2717
q6	248	150	153	150
q7	1004	644	606	606
q8	9271	1872	1932	1872
q9	6768	6480	6520	6480
q10	6984	2293	2348	2293
q11	472	251	263	251
q12	415	220	222	220
q13	17770	3014	3081	3014
q14	244	208	216	208
q15	588	536	517	517
q16	665	578	584	578
q17	1002	515	482	482
q18	7466	6875	6682	6682
q19	1347	1031	1028	1028
q20	477	177	186	177
q21	4234	3228	3198	3198
q22	391	318	306	306
Total cold run time: 107938 ms
Total hot run time: 40140 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7304	7351	7266	7266
q2	330	231	236	231
q3	2903	2910	2990	2910
q4	2120	1847	1845	1845
q5	5624	5689	5699	5689
q6	225	147	141	141
q7	2288	1824	1815	1815
q8	3424	3586	3563	3563
q9	8979	9185	9108	9108
q10	3611	3592	3562	3562
q11	606	511	510	510
q12	807	630	627	627
q13	11389	3246	3248	3246
q14	315	272	273	272
q15	583	532	548	532
q16	696	651	637	637
q17	1885	1669	1614	1614
q18	8510	7692	7862	7692
q19	1813	1618	1513	1513
q20	2189	1909	1948	1909
q21	5808	5673	5446	5446
q22	657	627	566	566
Total cold run time: 72066 ms
Total hot run time: 60694 ms

@doris-robot

doris-robot commented Nov 28, 2024

Copy link
Copy Markdown
TPC-DS: Total hot run time: 196783 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 b1de3a846940b467c91e36371d5b889c2cd324b5, data reload: false

query1	1254	951	915	915
query2	6238	2004	1974	1974
query3	11017	4324	4409	4324
query4	66865	29241	23558	23558
query5	4874	451	448	448
query6	428	190	171	171
query7	5679	304	289	289
query8	318	232	224	224
query9	9286	2726	2743	2726
query10	467	261	253	253
query11	17569	15217	15840	15217
query12	152	105	102	102
query13	1569	433	437	433
query14	9880	7403	7031	7031
query15	210	181	198	181
query16	7089	470	499	470
query17	1110	561	545	545
query18	1874	305	305	305
query19	228	166	151	151
query20	120	117	110	110
query21	213	103	100	100
query22	4936	4583	4699	4583
query23	34783	34491	34675	34491
query24	5505	2546	2477	2477
query25	513	382	390	382
query26	680	142	143	142
query27	1822	286	281	281
query28	4550	2503	2495	2495
query29	674	466	405	405
query30	220	149	144	144
query31	990	833	851	833
query32	64	58	54	54
query33	399	287	283	283
query34	964	527	503	503
query35	871	765	777	765
query36	1090	994	969	969
query37	128	76	74	74
query38	4432	4343	4373	4343
query39	1545	1460	1451	1451
query40	213	100	102	100
query41	46	45	43	43
query42	109	98	95	95
query43	514	501	490	490
query44	1186	843	812	812
query45	187	167	169	167
query46	1212	738	726	726
query47	2071	1931	1907	1907
query48	411	316	318	316
query49	725	377	387	377
query50	848	390	379	379
query51	7380	7234	7041	7041
query52	97	87	88	87
query53	258	176	170	170
query54	511	399	380	380
query55	73	73	73	73
query56	259	229	226	226
query57	1251	1073	1105	1073
query58	213	207	223	207
query59	3140	3124	3114	3114
query60	301	240	249	240
query61	104	100	104	100
query62	795	676	678	676
query63	207	182	184	182
query64	1361	639	652	639
query65	3299	3229	3247	3229
query66	699	292	310	292
query67	15947	15796	15582	15582
query68	3757	565	559	559
query69	419	249	245	245
query70	1213	1178	1126	1126
query71	353	253	246	246
query72	6574	4090	4079	4079
query73	769	363	361	361
query74	10126	9077	8965	8965
query75	3399	2644	2677	2644
query76	1852	1149	1096	1096
query77	571	262	264	262
query78	10761	9470	9398	9398
query79	2373	590	615	590
query80	1172	413	419	413
query81	516	234	224	224
query82	1136	114	117	114
query83	256	138	146	138
query84	281	73	67	67
query85	957	301	289	289
query86	431	287	317	287
query87	4624	4561	4535	4535
query88	3568	2211	2175	2175
query89	420	296	283	283
query90	1939	177	186	177
query91	144	102	102	102
query92	62	49	48	48
query93	2645	540	535	535
query94	860	285	279	279
query95	352	247	241	241
query96	625	273	279	273
query97	2877	2733	2630	2630
query98	215	195	191	191
query99	1590	1341	1286	1286
Total cold run time: 320860 ms
Total hot run time: 196783 ms

@doris-robot

doris-robot commented Nov 28, 2024

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

query1	0.04	0.03	0.02
query2	0.07	0.03	0.03
query3	0.24	0.07	0.07
query4	1.62	0.10	0.11
query5	0.40	0.41	0.43
query6	1.17	0.66	0.65
query7	0.02	0.01	0.02
query8	0.04	0.03	0.03
query9	0.60	0.50	0.51
query10	0.56	0.57	0.55
query11	0.14	0.10	0.10
query12	0.14	0.10	0.11
query13	0.61	0.60	0.60
query14	2.72	2.75	2.85
query15	0.92	0.85	0.82
query16	0.39	0.38	0.38
query17	1.04	0.98	1.06
query18	0.21	0.21	0.20
query19	1.88	1.78	1.97
query20	0.01	0.01	0.01
query21	15.36	0.58	0.58
query22	2.68	2.13	1.87
query23	16.95	0.95	0.84
query24	3.19	2.11	1.12
query25	0.29	0.12	0.09
query26	0.66	0.13	0.14
query27	0.05	0.05	0.05
query28	9.87	1.10	1.08
query29	12.55	3.27	3.29
query30	0.25	0.07	0.06
query31	2.85	0.38	0.38
query32	3.28	0.46	0.47
query33	3.05	3.06	3.06
query34	16.65	4.51	4.51
query35	4.58	4.49	4.51
query36	0.67	0.50	0.48
query37	0.09	0.06	0.06
query38	0.05	0.03	0.03
query39	0.03	0.03	0.02
query40	0.17	0.13	0.12
query41	0.08	0.03	0.02
query42	0.04	0.02	0.02
query43	0.03	0.03	0.03
Total cold run time: 106.24 s
Total hot run time: 32.86 s

@msridhar78

msridhar78 commented Dec 2, 2024

Copy link
Copy Markdown
Contributor Author

run buildall

@doris-robot

doris-robot commented Dec 2, 2024

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

------ Round 1 ----------------------------------
q1	17598	7474	7301	7301
q2	2043	179	166	166
q3	10583	1090	1205	1090
q4	10473	720	722	720
q5	7604	2754	2722	2722
q6	240	145	149	145
q7	982	621	588	588
q8	9242	1872	1928	1872
q9	6738	6444	6508	6444
q10	7056	2306	2328	2306
q11	466	263	266	263
q12	435	219	219	219
q13	17765	3000	3054	3000
q14	258	222	210	210
q15	573	531	534	531
q16	675	595	591	591
q17	990	640	528	528
q18	7286	6731	6599	6599
q19	1350	1080	977	977
q20	487	181	181	181
q21	4029	3244	3179	3179
q22	385	319	325	319
Total cold run time: 107258 ms
Total hot run time: 39951 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7284	7198	7265	7198
q2	331	237	228	228
q3	2918	2884	2963	2884
q4	2043	1783	1933	1783
q5	5669	5686	5654	5654
q6	231	143	144	143
q7	2206	1876	1811	1811
q8	3395	3576	3530	3530
q9	8917	9008	9040	9008
q10	3633	3585	3582	3582
q11	598	510	533	510
q12	832	646	602	602
q13	10082	3246	3249	3246
q14	326	270	299	270
q15	585	524	522	522
q16	706	634	638	634
q17	1863	1631	1618	1618
q18	8244	7780	7705	7705
q19	1710	1592	1570	1570
q20	2109	1865	1875	1865
q21	5765	5420	5470	5420
q22	665	610	593	593
Total cold run time: 70112 ms
Total hot run time: 60376 ms

@doris-robot

doris-robot commented Dec 2, 2024

Copy link
Copy Markdown
TPC-DS: Total hot run time: 197703 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 0d1d9db872fcb833c97b1cda02f81c76dac8fc83, data reload: false

query1	1248	973	987	973
query2	6243	2131	2094	2094
query3	10974	4540	4510	4510
query4	66603	29021	23600	23600
query5	4946	483	486	483
query6	426	185	187	185
query7	5635	316	310	310
query8	344	244	241	241
query9	9394	2733	2697	2697
query10	449	265	249	249
query11	17566	15460	15915	15460
query12	165	107	113	107
query13	1517	415	399	399
query14	10974	8996	6904	6904
query15	227	204	199	199
query16	7231	449	489	449
query17	1083	600	600	600
query18	1077	319	323	319
query19	219	185	176	176
query20	126	116	115	115
query21	212	119	110	110
query22	4669	4494	4448	4448
query23	34948	34453	34659	34453
query24	5785	2456	2677	2456
query25	501	391	404	391
query26	647	165	166	165
query27	2065	285	289	285
query28	4334	2475	2494	2475
query29	675	432	458	432
query30	209	151	154	151
query31	1017	858	866	858
query32	67	63	57	57
query33	451	300	301	300
query34	906	517	541	517
query35	933	773	776	773
query36	1084	969	1006	969
query37	122	71	75	71
query38	4443	4423	4377	4377
query39	1486	1465	1472	1465
query40	205	106	102	102
query41	47	46	43	43
query42	122	103	104	103
query43	544	504	512	504
query44	1204	847	855	847
query45	188	171	168	168
query46	1180	744	764	744
query47	2032	1937	1959	1937
query48	412	321	334	321
query49	722	396	412	396
query50	850	426	402	402
query51	7298	7360	7083	7083
query52	101	84	90	84
query53	270	181	181	181
query54	518	408	386	386
query55	77	76	80	76
query56	248	238	251	238
query57	1292	1092	1122	1092
query58	223	211	210	210
query59	3200	3053	2854	2854
query60	263	249	258	249
query61	124	112	111	111
query62	782	667	679	667
query63	218	190	219	190
query64	1378	687	653	653
query65	3320	3205	3237	3205
query66	714	311	313	311
query67	15797	15670	15610	15610
query68	4133	571	569	569
query69	429	249	255	249
query70	1191	1108	1105	1105
query71	357	250	250	250
query72	6488	4029	4084	4029
query73	764	367	358	358
query74	10212	9032	9064	9032
query75	3390	2681	2681	2681
query76	1879	1119	983	983
query77	605	280	276	276
query78	10401	9502	9414	9414
query79	2181	607	612	607
query80	1387	435	449	435
query81	513	233	239	233
query82	1278	125	118	118
query83	227	141	142	141
query84	281	76	67	67
query85	1058	327	313	313
query86	414	305	290	290
query87	4759	4571	4574	4571
query88	3708	2221	2188	2188
query89	432	306	287	287
query90	1928	194	191	191
query91	137	104	105	104
query92	67	51	49	49
query93	3009	556	536	536
query94	778	298	299	298
query95	362	249	255	249
query96	651	285	280	280
query97	2946	2708	2719	2708
query98	228	193	197	193
query99	1623	1309	1310	1309
Total cold run time: 322146 ms
Total hot run time: 197703 ms

@doris-robot

doris-robot commented Dec 2, 2024

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

query1	0.04	0.03	0.03
query2	0.07	0.04	0.02
query3	0.23	0.07	0.07
query4	1.63	0.10	0.10
query5	0.44	0.39	0.41
query6	1.16	0.66	0.67
query7	0.02	0.02	0.02
query8	0.04	0.04	0.03
query9	0.56	0.54	0.52
query10	0.54	0.56	0.55
query11	0.15	0.11	0.10
query12	0.14	0.12	0.12
query13	0.60	0.60	0.60
query14	2.81	2.82	2.74
query15	0.91	0.82	0.82
query16	0.39	0.39	0.39
query17	1.05	1.05	1.05
query18	0.23	0.21	0.21
query19	1.91	1.89	2.04
query20	0.01	0.01	0.02
query21	15.35	0.60	0.58
query22	2.22	1.83	1.49
query23	17.04	0.95	0.84
query24	3.27	2.47	1.71
query25	0.37	0.10	0.24
query26	0.54	0.15	0.13
query27	0.04	0.04	0.04
query28	8.76	1.11	1.10
query29	12.51	3.21	3.17
query30	0.25	0.06	0.06
query31	2.87	0.39	0.37
query32	3.25	0.47	0.47
query33	3.00	3.07	3.04
query34	17.01	4.45	4.44
query35	4.58	4.50	4.46
query36	0.66	0.51	0.50
query37	0.09	0.06	0.06
query38	0.04	0.04	0.04
query39	0.03	0.02	0.02
query40	0.17	0.12	0.12
query41	0.08	0.03	0.02
query42	0.04	0.02	0.02
query43	0.03	0.04	0.03
Total cold run time: 105.13 s
Total hot run time: 33.13 s

@msridhar78

msridhar78 commented Dec 3, 2024

Copy link
Copy Markdown
Contributor Author

run buildall

@msridhar78

msridhar78 commented Dec 4, 2024

Copy link
Copy Markdown
Contributor Author

run P0

@LiBinfeng-01

LiBinfeng-01 commented Dec 4, 2024

Copy link
Copy Markdown
Contributor

pls check cases failed in p0, it seems related to changed

@msridhar78

msridhar78 commented Dec 8, 2024

Copy link
Copy Markdown
Contributor Author

run buildall

@doris-robot

doris-robot commented Dec 8, 2024

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

------ Round 1 ----------------------------------
q1	17614	7561	7285	7285
q2	2042	185	182	182
q3	10730	1070	1164	1070
q4	10553	811	722	722
q5	7592	2758	2708	2708
q6	240	155	160	155
q7	990	647	617	617
q8	9463	1888	1940	1888
q9	7907	6404	6431	6404
q10	6950	2339	2350	2339
q11	452	265	264	264
q12	437	225	231	225
q13	17808	3042	3082	3042
q14	236	213	210	210
q15	578	529	507	507
q16	657	581	595	581
q17	994	510	514	510
q18	7167	6825	6774	6774
q19	1349	984	964	964
q20	485	173	188	173
q21	4130	3218	3228	3218
q22	381	318	311	311
Total cold run time: 108755 ms
Total hot run time: 40149 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7272	7263	7285	7263
q2	323	227	229	227
q3	2943	2996	2980	2980
q4	2081	1887	1855	1855
q5	5607	5686	5696	5686
q6	225	146	143	143
q7	2284	1841	1840	1840
q8	3375	3560	3505	3505
q9	8908	9006	8979	8979
q10	3590	3580	3533	3533
q11	616	510	495	495
q12	827	624	636	624
q13	9943	3243	3310	3243
q14	325	293	269	269
q15	584	534	531	531
q16	702	648	644	644
q17	1854	1653	1593	1593
q18	8396	7786	7563	7563
q19	1692	1549	1666	1549
q20	2137	1867	1870	1867
q21	5732	5587	5445	5445
q22	647	568	579	568
Total cold run time: 70063 ms
Total hot run time: 60402 ms

@doris-robot

doris-robot commented Dec 8, 2024

Copy link
Copy Markdown
TPC-DS: Total hot run time: 198082 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 0d1d9db872fcb833c97b1cda02f81c76dac8fc83, data reload: false

query1	1300	956	956	956
query2	6252	2102	2079	2079
query3	10965	4349	4397	4349
query4	66713	28837	23630	23630
query5	4992	469	478	469
query6	421	187	175	175
query7	5529	311	298	298
query8	337	239	240	239
query9	8499	2636	2649	2636
query10	440	257	258	257
query11	17257	15537	16025	15537
query12	158	114	111	111
query13	1482	462	428	428
query14	10962	7386	7109	7109
query15	219	192	208	192
query16	7246	501	484	484
query17	1248	603	582	582
query18	1854	309	306	306
query19	231	151	157	151
query20	121	111	141	111
query21	214	114	107	107
query22	4798	4388	4345	4345
query23	35033	34560	34653	34560
query24	5506	2466	2642	2466
query25	508	389	393	389
query26	642	156	159	156
query27	1807	287	291	287
query28	4256	2452	2491	2452
query29	687	436	427	427
query30	209	160	156	156
query31	1018	877	840	840
query32	70	53	55	53
query33	463	299	298	298
query34	940	519	538	519
query35	890	773	775	773
query36	1100	964	1014	964
query37	134	73	75	73
query38	4533	4461	4610	4461
query39	1544	1481	1478	1478
query40	206	100	103	100
query41	46	43	43	43
query42	107	100	99	99
query43	544	513	510	510
query44	1220	834	813	813
query45	198	172	172	172
query46	1202	760	795	760
query47	2048	1943	1943	1943
query48	424	317	319	317
query49	728	414	398	398
query50	848	397	410	397
query51	7396	7382	7105	7105
query52	103	87	89	87
query53	267	192	178	178
query54	522	399	395	395
query55	75	74	74	74
query56	251	255	247	247
query57	1248	1125	1171	1125
query58	216	227	216	216
query59	3290	2946	2936	2936
query60	276	248	246	246
query61	109	106	107	106
query62	760	697	677	677
query63	218	190	199	190
query64	1336	670	655	655
query65	3290	3224	3241	3224
query66	696	304	307	304
query67	15834	15564	15528	15528
query68	3847	581	582	581
query69	419	255	260	255
query70	1180	1137	1129	1129
query71	365	267	302	267
query72	6429	4173	4128	4128
query73	796	357	364	357
query74	10116	9036	9033	9033
query75	3413	2663	2644	2644
query76	1868	1075	1142	1075
query77	482	373	266	266
query78	10475	9488	9468	9468
query79	1627	607	615	607
query80	878	432	447	432
query81	491	233	238	233
query82	1245	126	116	116
query83	192	145	141	141
query84	285	131	69	69
query85	891	317	310	310
query86	340	304	317	304
query87	4648	4654	4646	4646
query88	3471	2145	2137	2137
query89	424	297	288	288
query90	1953	189	183	183
query91	131	102	106	102
query92	66	52	51	51
query93	1936	559	566	559
query94	759	289	292	289
query95	352	254	250	250
query96	633	281	273	273
query97	2897	2643	2678	2643
query98	222	198	197	197
query99	1604	1301	1307	1301
Total cold run time: 318471 ms
Total hot run time: 198082 ms

@doris-robot

doris-robot commented Dec 8, 2024

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

query1	0.03	0.03	0.05
query2	0.07	0.03	0.03
query3	0.23	0.07	0.07
query4	1.62	0.10	0.11
query5	0.45	0.39	0.41
query6	1.13	0.65	0.66
query7	0.02	0.02	0.01
query8	0.04	0.03	0.03
query9	0.58	0.51	0.50
query10	0.57	0.56	0.59
query11	0.14	0.11	0.10
query12	0.14	0.12	0.12
query13	0.61	0.60	0.61
query14	2.86	2.89	2.75
query15	0.91	0.83	0.82
query16	0.38	0.38	0.37
query17	1.06	1.05	1.07
query18	0.23	0.21	0.21
query19	1.93	1.90	2.01
query20	0.02	0.01	0.01
query21	15.36	0.59	0.58
query22	2.27	1.80	1.87
query23	16.94	1.15	0.83
query24	2.83	1.59	1.19
query25	0.21	0.24	0.08
query26	0.42	0.14	0.14
query27	0.06	0.05	0.05
query28	10.40	1.10	1.09
query29	12.54	3.24	3.21
query30	0.27	0.08	0.06
query31	2.85	0.40	0.38
query32	3.24	0.46	0.48
query33	3.14	3.01	3.06
query34	16.98	4.50	4.46
query35	4.50	4.47	4.54
query36	0.68	0.48	0.49
query37	0.09	0.06	0.05
query38	0.05	0.04	0.04
query39	0.04	0.03	0.02
query40	0.17	0.14	0.12
query41	0.08	0.03	0.02
query42	0.03	0.02	0.02
query43	0.04	0.04	0.03
Total cold run time: 106.21 s
Total hot run time: 32.89 s

@msridhar78

msridhar78 commented Dec 18, 2024

Copy link
Copy Markdown
Contributor Author

run buildall

@doris-robot

doris-robot commented Dec 18, 2024

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

------ Round 1 ----------------------------------
q1	17551	7458	7246	7246
q2	2047	172	167	167
q3	10737	1069	1199	1069
q4	10570	755	653	653
q5	7608	2672	2718	2672
q6	238	146	144	144
q7	998	624	599	599
q8	9246	1846	1925	1846
q9	6632	6400	6352	6352
q10	6978	2297	2329	2297
q11	464	266	260	260
q12	429	224	216	216
q13	17760	2944	2977	2944
q14	255	204	210	204
q15	549	522	509	509
q16	659	598	591	591
q17	982	506	544	506
q18	7114	6698	6709	6698
q19	1338	1058	915	915
q20	462	179	180	179
q21	4052	3259	3178	3178
q22	380	309	305	305
Total cold run time: 107049 ms
Total hot run time: 39550 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7278	7254	7292	7254
q2	338	232	236	232
q3	2954	2927	3025	2927
q4	2109	1848	1917	1848
q5	5826	5779	5661	5661
q6	227	139	140	139
q7	2263	1846	1835	1835
q8	3370	3568	3513	3513
q9	8956	9012	8937	8937
q10	3609	3535	3565	3535
q11	608	516	499	499
q12	844	634	592	592
q13	13812	3207	3286	3207
q14	339	297	300	297
q15	577	509	510	509
q16	729	661	647	647
q17	1871	1657	1652	1652
q18	8648	8472	7977	7977
q19	2916	1592	1632	1592
q20	2117	1857	1806	1806
q21	5555	5520	5479	5479
q22	689	583	596	583
Total cold run time: 75635 ms
Total hot run time: 60721 ms

@doris-robot

doris-robot commented Dec 18, 2024

Copy link
Copy Markdown
TPC-DS: Total hot run time: 196085 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 bd828574107e20c1877100458daf7b0e7b4f6e09, data reload: false

query1	1320	926	912	912
query2	6356	2272	2276	2272
query3	11003	4792	4640	4640
query4	33396	23276	23394	23276
query5	5052	451	467	451
query6	271	185	185	185
query7	3995	305	315	305
query8	304	258	233	233
query9	9301	2696	2682	2682
query10	504	252	247	247
query11	18040	15263	15151	15151
query12	151	103	104	103
query13	1770	426	413	413
query14	11818	7302	7089	7089
query15	279	186	180	180
query16	8152	443	480	443
query17	1623	602	568	568
query18	2157	311	312	311
query19	373	161	155	155
query20	115	108	112	108
query21	205	109	120	109
query22	4772	4637	4438	4438
query23	34274	33576	33667	33576
query24	9593	2562	2476	2476
query25	575	391	390	390
query26	718	156	159	156
query27	2137	331	341	331
query28	6479	2458	2440	2440
query29	772	411	408	408
query30	229	152	153	152
query31	1015	847	838	838
query32	95	54	56	54
query33	643	292	285	285
query34	943	531	558	531
query35	902	763	754	754
query36	1126	966	977	966
query37	125	72	72	72
query38	4399	4188	4152	4152
query39	1498	1476	1436	1436
query40	215	111	100	100
query41	47	44	47	44
query42	118	106	98	98
query43	536	499	489	489
query44	1180	835	840	835
query45	190	173	173	173
query46	1190	706	748	706
query47	2066	1962	1977	1962
query48	421	333	331	331
query49	855	387	384	384
query50	836	394	388	388
query51	7314	7247	7271	7247
query52	99	94	89	89
query53	253	184	180	180
query54	1185	415	392	392
query55	84	78	80	78
query56	273	242	271	242
query57	1274	1170	1184	1170
query58	262	227	237	227
query59	3279	3097	3048	3048
query60	300	250	245	245
query61	108	99	105	99
query62	861	689	688	688
query63	224	197	193	193
query64	3642	667	632	632
query65	3295	3316	3264	3264
query66	755	311	306	306
query67	16807	15628	15650	15628
query68	5052	559	551	551
query69	481	252	250	250
query70	1203	1130	1108	1108
query71	464	243	251	243
query72	7080	4160	4079	4079
query73	786	352	367	352
query74	9944	8802	8815	8802
query75	3656	2642	2611	2611
query76	3567	1131	1065	1065
query77	570	271	280	271
query78	10306	9404	9398	9398
query79	1113	593	586	586
query80	758	419	444	419
query81	535	235	222	222
query82	582	117	124	117
query83	169	154	141	141
query84	244	68	66	66
query85	1181	296	299	296
query86	393	304	296	296
query87	4652	4380	4301	4301
query88	3345	2251	2256	2251
query89	436	289	297	289
query90	1995	186	192	186
query91	150	102	103	102
query92	65	53	50	50
query93	2404	532	524	524
query94	753	283	273	273
query95	347	250	248	248
query96	614	278	275	275
query97	2840	2723	2687	2687
query98	210	200	194	194
query99	1570	1336	1306	1306
Total cold run time: 301614 ms
Total hot run time: 196085 ms

@doris-robot

doris-robot commented Dec 18, 2024

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

query1	0.04	0.03	0.02
query2	0.07	0.04	0.03
query3	0.24	0.07	0.07
query4	1.61	0.10	0.11
query5	0.43	0.40	0.41
query6	1.20	0.65	0.66
query7	0.02	0.02	0.02
query8	0.03	0.03	0.03
query9	0.57	0.52	0.51
query10	0.55	0.57	0.55
query11	0.15	0.10	0.10
query12	0.13	0.11	0.11
query13	0.61	0.60	0.59
query14	2.74	2.84	2.74
query15	0.90	0.82	0.82
query16	0.39	0.38	0.39
query17	0.99	1.08	1.06
query18	0.22	0.21	0.21
query19	1.85	1.82	2.00
query20	0.02	0.01	0.01
query21	15.36	0.60	0.59
query22	2.52	2.17	1.23
query23	17.15	0.94	0.79
query24	3.71	1.76	2.41
query25	0.30	0.13	0.14
query26	0.65	0.13	0.12
query27	0.05	0.04	0.04
query28	8.55	1.12	1.08
query29	12.61	3.26	3.26
query30	0.25	0.06	0.06
query31	2.84	0.38	0.38
query32	3.26	0.46	0.46
query33	3.24	3.11	3.12
query34	16.86	4.44	4.49
query35	4.46	4.45	4.40
query36	0.69	0.49	0.50
query37	0.10	0.06	0.06
query38	0.05	0.04	0.04
query39	0.04	0.03	0.02
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.02	0.02
Total cold run time: 105.76 s
Total hot run time: 32.87 s

@doris-robot

doris-robot commented Jan 14, 2025

Copy link
Copy Markdown
TPC-DS: Total hot run time: 195122 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 69942ec61c94b2f39e1e4637a1f211500fed1d77, data reload: false

query1	1317	953	957	953
query2	6364	2103	2011	2011
query3	10921	4467	4282	4282
query4	60988	29515	23103	23103
query5	5432	609	461	461
query6	441	187	189	187
query7	5612	503	292	292
query8	315	253	223	223
query9	8245	2752	2754	2752
query10	475	327	255	255
query11	17607	15087	15881	15087
query12	166	111	107	107
query13	1476	534	413	413
query14	10983	7514	7028	7028
query15	208	197	186	186
query16	7230	654	458	458
query17	1110	733	579	579
query18	1892	402	360	360
query19	197	188	154	154
query20	130	112	115	112
query21	218	127	106	106
query22	4467	4627	4568	4568
query23	34227	34133	33392	33392
query24	5760	2365	2290	2290
query25	483	461	392	392
query26	680	279	158	158
query27	1794	476	343	343
query28	4177	2559	2519	2519
query29	543	557	426	426
query30	219	198	159	159
query31	923	898	867	867
query32	71	62	58	58
query33	481	357	302	302
query34	772	875	525	525
query35	806	854	781	781
query36	996	1056	961	961
query37	132	101	81	81
query38	4276	4263	4227	4227
query39	1537	1471	1444	1444
query40	204	116	106	106
query41	52	51	78	51
query42	123	107	102	102
query43	514	532	494	494
query44	1371	854	834	834
query45	180	173	169	169
query46	869	1050	654	654
query47	1970	1923	1899	1899
query48	391	399	323	323
query49	713	491	401	401
query50	692	674	411	411
query51	6918	7100	7007	7007
query52	105	107	94	94
query53	237	260	187	187
query54	499	520	425	425
query55	91	89	84	84
query56	276	281	267	267
query57	1233	1195	1146	1146
query58	268	248	249	248
query59	3204	3250	3103	3103
query60	304	284	266	266
query61	163	140	173	140
query62	776	762	695	695
query63	221	184	189	184
query64	1283	1013	656	656
query65	3255	3163	3116	3116
query66	704	408	305	305
query67	15978	15726	15792	15726
query68	5047	826	539	539
query69	480	294	260	260
query70	1142	1162	1115	1115
query71	425	289	267	267
query72	5928	3962	3868	3868
query73	825	759	373	373
query74	10303	8878	9052	8878
query75	3226	3165	2647	2647
query76	3801	1159	773	773
query77	464	359	277	277
query78	10065	9970	9306	9306
query79	2998	805	602	602
query80	705	531	452	452
query81	499	279	231	231
query82	624	150	138	138
query83	175	178	148	148
query84	288	101	85	85
query85	853	365	308	308
query86	371	323	280	280
query87	4381	4587	4353	4353
query88	4570	2201	2187	2187
query89	404	324	287	287
query90	1635	187	193	187
query91	135	142	106	106
query92	63	57	54	54
query93	2794	882	530	530
query94	716	401	318	318
query95	337	271	256	256
query96	501	607	294	294
query97	2864	2905	2766	2766
query98	220	198	192	192
query99	1390	1468	1350	1350
Total cold run time: 314494 ms
Total hot run time: 195122 ms

@doris-robot

doris-robot commented Jan 14, 2025

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

query1	0.04	0.04	0.03
query2	0.07	0.04	0.03
query3	0.24	0.07	0.07
query4	1.60	0.11	0.10
query5	0.42	0.41	0.41
query6	1.16	0.66	0.64
query7	0.02	0.02	0.02
query8	0.04	0.03	0.04
query9	0.59	0.50	0.50
query10	0.56	0.58	0.56
query11	0.15	0.10	0.10
query12	0.15	0.12	0.12
query13	0.61	0.59	0.60
query14	2.74	2.89	2.71
query15	0.88	0.82	0.82
query16	0.38	0.39	0.38
query17	1.03	1.07	1.09
query18	0.23	0.21	0.21
query19	1.97	1.81	2.02
query20	0.01	0.02	0.01
query21	15.38	0.95	0.56
query22	0.75	0.82	0.76
query23	15.16	1.41	0.51
query24	2.94	1.00	0.84
query25	0.24	0.28	0.17
query26	0.21	0.13	0.14
query27	0.06	0.05	0.05
query28	13.75	1.56	1.06
query29	12.56	3.86	3.20
query30	0.26	0.09	0.06
query31	2.83	0.59	0.38
query32	3.23	0.54	0.46
query33	2.97	3.00	3.09
query34	16.64	5.16	4.44
query35	4.58	4.47	4.60
query36	0.83	0.48	0.48
query37	0.10	0.06	0.06
query38	0.05	0.04	0.04
query39	0.04	0.02	0.02
query40	0.17	0.12	0.12
query41	0.09	0.03	0.02
query42	0.04	0.03	0.02
query43	0.04	0.03	0.03
Total cold run time: 105.81 s
Total hot run time: 31.09 s

@msridhar78

msridhar78 commented Jan 15, 2025

Copy link
Copy Markdown
Contributor Author

run buildall

@doris-robot

doris-robot commented Jan 15, 2025

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

------ Round 1 ----------------------------------
q1	17578	5474	5369	5369
q2	2043	324	170	170
q3	10397	1272	733	733
q4	10229	957	534	534
q5	7536	2391	2183	2183
q6	193	171	139	139
q7	916	768	619	619
q8	9255	1372	1126	1126
q9	5211	4943	4909	4909
q10	6828	2332	1896	1896
q11	482	271	248	248
q12	350	365	218	218
q13	17786	3707	3051	3051
q14	222	235	206	206
q15	511	468	474	468
q16	615	643	579	579
q17	560	859	315	315
q18	7126	6489	6349	6349
q19	1213	981	545	545
q20	318	325	205	205
q21	2929	2172	1955	1955
q22	369	333	323	323
Total cold run time: 102667 ms
Total hot run time: 32140 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5459	5517	5476	5476
q2	248	330	238	238
q3	2274	2699	2347	2347
q4	1444	1909	1432	1432
q5	4373	4720	4629	4629
q6	161	157	125	125
q7	2045	2032	1833	1833
q8	2694	2805	2690	2690
q9	7229	7199	7118	7118
q10	3009	3284	2789	2789
q11	585	527	485	485
q12	676	775	616	616
q13	3467	3994	3233	3233
q14	280	293	288	288
q15	540	472	473	472
q16	660	679	633	633
q17	1217	1706	1292	1292
q18	7737	7476	7376	7376
q19	778	946	1157	946
q20	1967	2023	1871	1871
q21	5739	5214	5006	5006
q22	634	634	560	560
Total cold run time: 53216 ms
Total hot run time: 51455 ms

@doris-robot

doris-robot commented Jan 15, 2025

Copy link
Copy Markdown
TPC-DS: Total hot run time: 187200 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 19e594cbb80c0f793822d8497e63d416324ffb48, data reload: false

query1	965	384	379	379
query2	6518	2162	2046	2046
query3	6796	218	211	211
query4	33046	23454	23012	23012
query5	4396	613	458	458
query6	292	198	182	182
query7	4610	476	305	305
query8	281	224	215	215
query9	9573	2706	2696	2696
query10	489	334	252	252
query11	17887	15154	14961	14961
query12	152	106	104	104
query13	1652	525	413	413
query14	9019	6368	6521	6368
query15	230	211	193	193
query16	7815	632	478	478
query17	1631	741	567	567
query18	1985	405	301	301
query19	219	187	165	165
query20	124	117	117	117
query21	214	124	101	101
query22	4347	4283	4086	4086
query23	33798	32893	32981	32893
query24	7653	2290	2238	2238
query25	496	454	411	411
query26	1228	270	156	156
query27	2679	471	328	328
query28	5618	2480	2425	2425
query29	745	548	419	419
query30	234	182	158	158
query31	960	866	813	813
query32	88	59	64	59
query33	508	353	294	294
query34	755	855	533	533
query35	789	813	754	754
query36	980	1018	952	952
query37	124	100	80	80
query38	4201	4194	4108	4108
query39	1455	1387	1409	1387
query40	205	116	101	101
query41	53	51	50	50
query42	128	103	103	103
query43	520	511	493	493
query44	1341	806	805	805
query45	173	168	164	164
query46	867	1075	653	653
query47	1807	1843	1795	1795
query48	365	400	314	314
query49	796	478	397	397
query50	645	667	400	400
query51	6916	6886	6719	6719
query52	103	99	92	92
query53	222	251	190	190
query54	482	496	412	412
query55	80	83	77	77
query56	259	282	247	247
query57	1185	1185	1079	1079
query58	244	229	249	229
query59	3151	3044	2904	2904
query60	291	271	266	266
query61	121	114	119	114
query62	769	717	647	647
query63	226	201	185	185
query64	4412	1027	658	658
query65	3291	3154	3178	3154
query66	1064	415	319	319
query67	15715	15589	15588	15588
query68	5757	765	527	527
query69	476	296	265	265
query70	1226	1150	1103	1103
query71	380	292	260	260
query72	5802	3832	3784	3784
query73	654	756	366	366
query74	10509	9131	8934	8934
query75	3223	3199	2674	2674
query76	3213	1172	779	779
query77	518	358	277	277
query78	9969	9801	9360	9360
query79	3160	832	590	590
query80	1335	538	449	449
query81	551	276	248	248
query82	711	150	123	123
query83	192	180	160	160
query84	249	92	72	72
query85	795	369	297	297
query86	449	322	301	301
query87	4479	4411	4361	4361
query88	5007	2213	2196	2196
query89	403	325	289	289
query90	1834	192	194	192
query91	131	140	107	107
query92	77	56	53	53
query93	2732	862	546	546
query94	761	416	297	297
query95	343	260	258	258
query96	491	627	291	291
query97	2832	2838	2784	2784
query98	222	204	195	195
query99	1294	1354	1289	1289
Total cold run time: 289758 ms
Total hot run time: 187200 ms

@doris-robot

doris-robot commented Jan 15, 2025

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

query1	0.03	0.03	0.03
query2	0.07	0.04	0.04
query3	0.24	0.08	0.07
query4	1.61	0.11	0.11
query5	0.43	0.40	0.41
query6	1.18	0.66	0.65
query7	0.02	0.02	0.02
query8	0.04	0.03	0.03
query9	0.56	0.51	0.50
query10	0.53	0.56	0.55
query11	0.15	0.11	0.10
query12	0.13	0.11	0.11
query13	0.61	0.61	0.61
query14	2.76	2.74	2.83
query15	0.91	0.83	0.83
query16	0.38	0.37	0.37
query17	0.99	1.01	1.02
query18	0.22	0.21	0.22
query19	1.91	1.77	1.95
query20	0.01	0.01	0.01
query21	15.37	0.96	0.61
query22	0.76	0.72	0.60
query23	15.43	1.49	0.53
query24	2.85	1.73	0.96
query25	0.22	0.17	0.10
query26	0.29	0.14	0.13
query27	0.06	0.04	0.05
query28	14.01	1.01	0.43
query29	12.60	3.98	3.27
query30	0.24	0.09	0.07
query31	2.84	0.58	0.39
query32	3.22	0.54	0.46
query33	2.98	2.94	3.04
query34	16.62	5.14	4.45
query35	4.50	4.58	4.49
query36	0.67	0.48	0.49
query37	0.09	0.06	0.06
query38	0.04	0.04	0.04
query39	0.04	0.03	0.02
query40	0.16	0.14	0.12
query41	0.07	0.03	0.03
query42	0.03	0.03	0.02
query43	0.03	0.03	0.03
Total cold run time: 105.9 s
Total hot run time: 30.43 s

@msridhar78

msridhar78 commented Mar 3, 2025

Copy link
Copy Markdown
Contributor Author

run buildall

@doris-robot

doris-robot commented Mar 3, 2025

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

------ Round 1 ----------------------------------
q1	17577	5296	5177	5177
q2	2042	302	169	169
q3	10406	1311	750	750
q4	10202	1018	547	547
q5	7499	2392	2344	2344
q6	191	176	135	135
q7	908	757	618	618
q8	9320	1313	1121	1121
q9	5042	4828	4718	4718
q10	6848	2307	1915	1915
q11	471	285	252	252
q12	356	359	223	223
q13	17755	3722	3100	3100
q14	231	236	218	218
q15	505	480	463	463
q16	627	626	591	591
q17	590	859	345	345
q18	6719	6167	6303	6167
q19	1519	970	575	575
q20	324	322	191	191
q21	2876	2169	2007	2007
q22	377	334	304	304
Total cold run time: 102385 ms
Total hot run time: 31930 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5309	5274	5163	5163
q2	246	327	240	240
q3	2279	2787	2407	2407
q4	1518	1896	1444	1444
q5	4360	4218	4234	4218
q6	222	169	127	127
q7	1927	1904	1839	1839
q8	2652	2730	2666	2666
q9	7339	7169	7242	7169
q10	3028	3227	2807	2807
q11	568	536	489	489
q12	694	775	591	591
q13	3469	3920	3251	3251
q14	287	305	268	268
q15	521	461	469	461
q16	645	696	643	643
q17	1177	1613	1374	1374
q18	7672	7327	7224	7224
q19	832	877	1101	877
q20	1977	2032	1895	1895
q21	5531	5019	4740	4740
q22	616	584	586	584
Total cold run time: 52869 ms
Total hot run time: 50477 ms

@doris-robot

doris-robot commented Mar 3, 2025

Copy link
Copy Markdown
TPC-DS: Total hot run time: 190534 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 18da17b25ef02ea19d146490e853213a48084134, data reload: false

query1	1293	933	939	933
query2	6275	1899	1847	1847
query3	10998	4554	4603	4554
query4	55948	25056	23070	23070
query5	5234	536	517	517
query6	393	205	207	205
query7	5118	513	296	296
query8	329	262	250	250
query9	6726	2558	2553	2553
query10	422	340	274	274
query11	15125	15121	14923	14923
query12	158	115	112	112
query13	1168	532	390	390
query14	10857	7081	6654	6654
query15	188	196	183	183
query16	7016	650	487	487
query17	1048	727	563	563
query18	1557	420	303	303
query19	201	205	167	167
query20	123	119	128	119
query21	207	133	104	104
query22	4387	4603	4442	4442
query23	34051	33301	33367	33301
query24	5667	2402	2448	2402
query25	454	457	392	392
query26	671	283	161	161
query27	1913	509	341	341
query28	2775	2476	2450	2450
query29	583	575	413	413
query30	211	193	155	155
query31	892	881	851	851
query32	75	65	65	65
query33	455	350	314	314
query34	746	870	507	507
query35	824	847	760	760
query36	937	1013	892	892
query37	125	108	76	76
query38	4269	4368	4152	4152
query39	1543	1466	1411	1411
query40	225	118	107	107
query41	57	54	65	54
query42	138	114	107	107
query43	519	519	485	485
query44	1366	830	825	825
query45	187	177	177	177
query46	922	1087	678	678
query47	1853	1864	1805	1805
query48	405	432	315	315
query49	784	608	421	421
query50	754	788	421	421
query51	4262	4305	4193	4193
query52	112	105	98	98
query53	237	267	192	192
query54	504	505	423	423
query55	82	84	90	84
query56	278	278	256	256
query57	1186	1174	1107	1107
query58	242	263	250	250
query59	2798	2917	2699	2699
query60	294	278	273	273
query61	121	119	114	114
query62	746	778	697	697
query63	232	200	192	192
query64	1467	1080	721	721
query65	3297	3209	3224	3209
query66	718	399	312	312
query67	16042	15753	15292	15292
query68	7176	890	507	507
query69	544	303	262	262
query70	1209	1145	1087	1087
query71	504	289	280	280
query72	6081	3673	3718	3673
query73	1271	752	348	348
query74	9237	9163	8698	8698
query75	3702	3204	2699	2699
query76	4203	1191	785	785
query77	589	447	299	299
query78	10127	10055	9292	9292
query79	2379	899	594	594
query80	632	535	439	439
query81	505	282	243	243
query82	685	127	96	96
query83	177	177	167	167
query84	293	100	76	76
query85	784	358	328	328
query86	403	281	289	281
query87	4384	4426	4313	4313
query88	3666	2217	2205	2205
query89	430	326	293	293
query90	1789	200	198	198
query91	140	140	115	115
query92	71	59	59	59
query93	1998	1049	589	589
query94	666	399	289	289
query95	352	269	258	258
query96	482	562	268	268
query97	3317	3447	3226	3226
query98	233	203	210	203
query99	1395	1416	1268	1268
Total cold run time: 300214 ms
Total hot run time: 190534 ms

@doris-robot

doris-robot commented Mar 3, 2025

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

query1	0.03	0.03	0.03
query2	0.08	0.04	0.04
query3	0.24	0.06	0.07
query4	1.61	0.10	0.10
query5	0.56	0.54	0.54
query6	1.19	0.72	0.73
query7	0.02	0.02	0.02
query8	0.04	0.03	0.04
query9	0.59	0.54	0.53
query10	0.56	0.58	0.57
query11	0.17	0.11	0.11
query12	0.14	0.12	0.13
query13	0.62	0.60	0.59
query14	2.80	2.71	2.83
query15	0.92	0.85	0.84
query16	0.38	0.38	0.37
query17	1.03	1.00	1.03
query18	0.21	0.20	0.20
query19	1.92	1.86	1.98
query20	0.02	0.01	0.01
query21	15.36	0.94	0.55
query22	0.76	1.22	0.67
query23	14.87	1.39	0.59
query24	6.67	2.14	1.01
query25	0.47	0.10	0.26
query26	0.70	0.17	0.14
query27	0.05	0.06	0.05
query28	9.94	0.84	0.44
query29	12.51	3.98	3.32
query30	0.25	0.08	0.06
query31	2.81	0.58	0.38
query32	3.23	0.56	0.46
query33	3.00	3.00	3.00
query34	15.81	5.15	4.54
query35	4.52	4.54	4.52
query36	0.66	0.50	0.49
query37	0.10	0.06	0.07
query38	0.06	0.04	0.04
query39	0.03	0.03	0.03
query40	0.19	0.14	0.13
query41	0.08	0.02	0.02
query42	0.04	0.02	0.02
query43	0.04	0.04	0.03
Total cold run time: 105.28 s
Total hot run time: 31.1 s

starocean999
starocean999 previously approved these changes Mar 4, 2025
View reviewed changes
@github-actions github-actions Bot added the approved Indicates a PR has been approved by one committer. label Mar 4, 2025
@github-actions

github-actions Bot commented Mar 4, 2025

Copy link
Copy Markdown
Contributor

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

@github-actions

github-actions Bot commented Mar 4, 2025

Copy link
Copy Markdown
Contributor

PR approved by anyone and no changes requested.

LiBinfeng-01
LiBinfeng-01 reviewed Mar 4, 2025
View reviewed changes
Comment thread fe/fe-core/src/main/java/org/apache/doris/nereids/parser/LogicalPlanBuilder.java Outdated
public LogicalPlan visitShowStoragePolicy(ShowStoragePolicyContext ctx) {
String policyName = null;
if (ctx.identifierOrText() != null) {
policyName = ctx.identifierOrText().getText();

@LiBinfeng-01 LiBinfeng-01 Mar 4, 2025

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

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

stripQuotes(ctx.identifierOrText().getText())

@LiBinfeng-01 LiBinfeng-01 Mar 4, 2025

Copy link
Copy Markdown
Contributor

Choose a reason for hiding this comment

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

pls use stripQuotes to avoid quote affect string behavior

@msridhar78 msridhar78 Mar 4, 2025

Copy link
Copy Markdown
Contributor Author

Choose a reason for hiding this comment

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

done - please review

@msridhar78
msridhar78 force-pushed the show_storage_policy branch from 18da17b to fbf7b9a Compare March 4, 2025 17:17
@github-actions github-actions Bot removed the approved Indicates a PR has been approved by one committer. label Mar 4, 2025
@msridhar78

msridhar78 commented Mar 4, 2025

Copy link
Copy Markdown
Contributor Author

run buildall

@doris-robot

doris-robot commented Mar 4, 2025

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

------ Round 1 ----------------------------------
q1	17598	5160	5115	5115
q2	2049	293	163	163
q3	10467	1266	763	763
q4	10228	1030	542	542
q5	7596	2417	2342	2342
q6	194	174	133	133
q7	887	737	612	612
q8	9308	1306	1134	1134
q9	4932	4926	4615	4615
q10	6864	2304	1936	1936
q11	491	284	257	257
q12	342	361	226	226
q13	17769	3701	3092	3092
q14	229	235	206	206
q15	507	471	451	451
q16	651	642	599	599
q17	588	830	379	379
q18	6662	6288	6286	6286
q19	1315	953	571	571
q20	325	331	197	197
q21	2758	2114	1947	1947
q22	363	330	306	306
Total cold run time: 102123 ms
Total hot run time: 31872 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5147	5150	5204	5150
q2	248	331	235	235
q3	2181	2706	2306	2306
q4	1452	1829	1397	1397
q5	4216	4122	4137	4122
q6	208	170	126	126
q7	1894	1849	1719	1719
q8	2599	2644	2554	2554
q9	7255	7204	7186	7186
q10	3014	3237	2793	2793
q11	585	534	498	498
q12	701	819	636	636
q13	3414	3940	3311	3311
q14	292	310	269	269
q15	504	475	465	465
q16	645	700	650	650
q17	1128	1626	1343	1343
q18	7642	7374	7310	7310
q19	842	814	888	814
q20	2001	2025	1873	1873
q21	5498	5091	4691	4691
q22	653	575	543	543
Total cold run time: 52119 ms
Total hot run time: 49991 ms

@doris-robot

doris-robot commented Mar 4, 2025

Copy link
Copy Markdown
TPC-DS: Total hot run time: 190709 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 fbf7b9a70b9ffd531676cf2a11d5bf2166691ee0, data reload: false

query1	1307	940	931	931
query2	6223	1874	1871	1871
query3	11000	4326	4311	4311
query4	53888	25140	23343	23343
query5	5097	621	485	485
query6	319	188	188	188
query7	4874	502	292	292
query8	303	253	245	245
query9	5200	2639	2628	2628
query10	412	327	261	261
query11	15069	15113	14863	14863
query12	165	113	109	109
query13	1028	542	365	365
query14	10252	6792	6645	6645
query15	206	191	186	186
query16	7208	655	470	470
query17	1067	726	606	606
query18	1576	415	306	306
query19	196	185	165	165
query20	134	132	126	126
query21	212	126	102	102
query22	4373	4474	4398	4398
query23	34080	33377	33336	33336
query24	5712	2435	2453	2435
query25	447	455	399	399
query26	701	291	154	154
query27	2036	485	335	335
query28	2999	2476	2471	2471
query29	581	585	419	419
query30	213	195	161	161
query31	873	867	826	826
query32	76	64	66	64
query33	451	362	305	305
query34	786	877	507	507
query35	851	824	773	773
query36	963	1032	905	905
query37	129	103	74	74
query38	4156	4427	4113	4113
query39	1574	1434	1424	1424
query40	204	118	103	103
query41	53	51	53	51
query42	127	110	104	104
query43	493	522	489	489
query44	1288	801	824	801
query45	176	171	176	171
query46	908	1060	663	663
query47	1857	1871	1812	1812
query48	385	418	309	309
query49	678	525	439	439
query50	717	760	416	416
query51	4304	4258	4279	4258
query52	108	111	96	96
query53	236	266	192	192
query54	499	516	419	419
query55	83	82	80	80
query56	261	264	268	264
query57	1167	1213	1119	1119
query58	258	268	259	259
query59	2926	2972	2795	2795
query60	295	289	279	279
query61	148	150	140	140
query62	726	756	704	704
query63	233	204	199	199
query64	1859	1162	715	715
query65	3292	3302	3258	3258
query66	756	411	296	296
query67	15945	15555	15121	15121
query68	7136	877	519	519
query69	526	301	274	274
query70	1177	1128	1123	1123
query71	502	292	266	266
query72	5754	3580	3657	3580
query73	1406	684	354	354
query74	9257	8966	8736	8736
query75	4130	3171	2738	2738
query76	4285	1194	775	775
query77	773	358	277	277
query78	10136	10209	9326	9326
query79	2500	827	580	580
query80	599	557	439	439
query81	510	280	244	244
query82	550	124	102	102
query83	171	167	155	155
query84	282	97	75	75
query85	761	354	308	308
query86	388	306	298	298
query87	4404	4520	4400	4400
query88	3729	2214	2219	2214
query89	408	317	276	276
query90	1789	197	187	187
query91	136	193	112	112
query92	76	60	57	57
query93	1814	1062	574	574
query94	669	399	295	295
query95	341	264	255	255
query96	493	557	272	272
query97	3305	3391	3272	3272
query98	233	207	206	206
query99	1418	1408	1271	1271
Total cold run time: 296377 ms
Total hot run time: 190709 ms

@doris-robot

doris-robot commented Mar 4, 2025

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

query1	0.03	0.03	0.03
query2	0.07	0.04	0.04
query3	0.23	0.07	0.06
query4	1.62	0.09	0.10
query5	0.57	0.54	0.56
query6	1.20	0.72	0.73
query7	0.03	0.02	0.02
query8	0.05	0.03	0.03
query9	0.59	0.54	0.54
query10	0.57	0.59	0.57
query11	0.16	0.10	0.11
query12	0.14	0.11	0.12
query13	0.62	0.59	0.59
query14	2.65	2.69	2.80
query15	0.93	0.86	0.84
query16	0.37	0.37	0.38
query17	1.05	1.06	1.05
query18	0.21	0.19	0.20
query19	1.91	1.96	1.90
query20	0.01	0.01	0.01
query21	15.37	0.88	0.53
query22	0.77	1.21	0.69
query23	14.86	1.39	0.65
query24	6.96	1.27	1.16
query25	0.51	0.16	0.24
query26	0.67	0.16	0.13
query27	0.05	0.06	0.04
query28	9.53	0.86	0.44
query29	12.57	4.05	3.34
query30	0.26	0.10	0.06
query31	2.81	0.59	0.38
query32	3.22	0.56	0.47
query33	3.02	3.00	3.09
query34	15.76	5.14	4.49
query35	4.58	4.57	4.52
query36	0.65	0.51	0.48
query37	0.10	0.07	0.06
query38	0.06	0.04	0.04
query39	0.03	0.03	0.02
query40	0.17	0.13	0.12
query41	0.07	0.03	0.02
query42	0.04	0.03	0.02
query43	0.03	0.03	0.03
Total cold run time: 105.1 s
Total hot run time: 31.34 s

@github-actions github-actions Bot added the approved Indicates a PR has been approved by one committer. label Mar 5, 2025
@github-actions

github-actions Bot commented Mar 5, 2025

Copy link
Copy Markdown
Contributor

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

@starocean999
starocean999 merged commit b4f8fcd into apache:master Mar 5, 2025
koarz pushed a commit to koarz/doris that referenced this pull request Jun 4, 2025
@msridhar78 koarz
[Enhancement] (nereids)implement showStoragePolicyCommand in nereids (a…
6e51cca 
…pache#44393)

Issue Number: close apache#42721
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

@starocean999 starocean999 starocean999 approved these changes
+1 more reviewer
@LiBinfeng-01 LiBinfeng-01 LiBinfeng-01 approved these changes
Reviewers whose approvals may not affect merge requirements

Assignees

No one assigned

Labels

approved Indicates a PR has been approved by one committer. reviewed

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

[Enhancement] (nereids)implement showStoragePolicyCommand in nereids

4 participants

@msridhar78 @doris-robot @LiBinfeng-01 @starocean999