Skip to content
New issue

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

Sign up for GitHub

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

Already on GitHub? Sign in to your account

Jump to bottom

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

Open
wants to merge 1 commit into
base: master
Choose a base branch
from
Open

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

wants to merge 1 commit into from

Conversation

msridhar78
Copy link
Contributor

@msridhar78 msridhar78 commented Nov 21, 2024 •
edited
Loading

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
Copy link

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
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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
Copy link

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
Copy link

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
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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
Copy link

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
Copy link

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
Copy link
Contributor Author

run p0

@msridhar78
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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
Copy link

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
Copy link

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
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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
Copy link

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
Copy link

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
Copy link
Contributor Author

run buildall

@msridhar78
Copy link
Contributor Author

run P0

@LiBinfeng-01
Copy link
Collaborator

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

@msridhar78
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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
Copy link

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
Copy link

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
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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
Copy link

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
Copy link

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

starocean999
starocean999 reviewed Dec 19, 2024
View reviewed changes
fe/fe-core/src/main/java/org/apache/doris/nereids/parser/LogicalPlanBuilder.java Outdated
@@ -5031,6 +5033,11 @@ public LogicalPlan visitShowDelete(ShowDeleteContext ctx) {
return new ShowDeleteCommand(dbName);
}

@Override
public LogicalPlan visitShowStoragePolicy(ShowStoragePolicyContext ctx) {
return new ShowStoragePolicyCommand(ctx.identifierOrText().getText());
Copy link
Contributor

Choose a reason for hiding this comment

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

policy name is optional, please check if policy exists

Copy link
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
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17597	7470	7287	7287
q2	2044	185	169	169
q3	10596	1067	1201	1067
q4	10581	792	741	741
q5	7623	2672	2647	2647
q6	242	146	142	142
q7	988	624	610	610
q8	9254	1881	1956	1881
q9	6631	6426	6576	6426
q10	7029	2313	2313	2313
q11	476	268	261	261
q12	433	224	228	224
q13	17808	2856	2972	2856
q14	253	214	210	210
q15	569	512	508	508
q16	672	577	567	567
q17	975	594	544	544
q18	7261	6718	6688	6688
q19	1342	1018	1062	1018
q20	469	183	188	183
q21	4045	3224	3137	3137
q22	376	318	312	312
Total cold run time: 107264 ms
Total hot run time: 39791 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7307	7257	7287	7257
q2	334	233	229	229
q3	2920	2800	2945	2800
q4	2070	1803	1770	1770
q5	5643	5662	5641	5641
q6	227	143	143	143
q7	2277	1840	1826	1826
q8	3356	3586	3531	3531
q9	8857	8874	8859	8859
q10	3586	3545	3520	3520
q11	603	516	494	494
q12	849	621	598	598
q13	11983	3047	3157	3047
q14	304	270	297	270
q15	557	510	511	510
q16	697	671	663	663
q17	1851	1639	1611	1611
q18	8267	7938	7745	7745
q19	1756	1593	1476	1476
q20	2138	1817	1918	1817
q21	5677	5487	5482	5482
q22	630	577	576	576
Total cold run time: 71889 ms
Total hot run time: 59865 ms

@doris-robot
Copy link

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

query1	1314	1003	937	937
query2	6262	2325	2270	2270
query3	10973	4640	4567	4567
query4	33526	23404	23248	23248
query5	4097	460	460	460
query6	292	189	178	178
query7	4006	302	306	302
query8	305	255	239	239
query9	9345	2701	2701	2701
query10	469	260	248	248
query11	17747	15104	15307	15104
query12	155	105	104	104
query13	1590	426	431	426
query14	10091	7163	6924	6924
query15	264	228	194	194
query16	8193	469	455	455
query17	1676	589	568	568
query18	2098	312	308	308
query19	374	155	164	155
query20	125	109	112	109
query21	216	109	109	109
query22	4958	4523	4633	4523
query23	34632	33736	33738	33736
query24	10484	2403	2476	2403
query25	623	394	393	393
query26	1263	159	156	156
query27	2635	325	345	325
query28	8115	2430	2469	2430
query29	849	416	422	416
query30	236	153	153	153
query31	1034	817	832	817
query32	97	60	58	58
query33	748	304	286	286
query34	1180	532	532	532
query35	909	749	754	749
query36	1134	948	968	948
query37	131	77	71	71
query38	4323	4147	4231	4147
query39	1506	1453	1496	1453
query40	197	101	106	101
query41	47	42	43	42
query42	111	105	102	102
query43	521	490	503	490
query44	1301	859	851	851
query45	196	171	165	165
query46	1183	757	753	753
query47	2070	1941	1929	1929
query48	415	328	318	318
query49	965	395	411	395
query50	842	426	401	401
query51	7302	7259	7045	7045
query52	101	92	90	90
query53	266	182	185	182
query54	1129	410	450	410
query55	86	79	82	79
query56	266	253	254	253
query57	1300	1193	1139	1139
query58	241	225	231	225
query59	3369	3205	3081	3081
query60	283	253	252	252
query61	108	106	112	106
query62	881	705	714	705
query63	218	189	188	188
query64	3975	731	669	669
query65	3326	3314	3258	3258
query66	796	306	311	306
query67	16527	15517	15429	15429
query68	5591	567	538	538
query69	481	250	253	250
query70	1232	1139	1066	1066
query71	509	263	262	262
query72	7068	4159	4043	4043
query73	801	358	366	358
query74	10038	8828	8878	8828
query75	4075	2642	2643	2642
query76	3737	1118	1183	1118
query77	672	260	267	260
query78	10249	9389	9376	9376
query79	1130	589	595	589
query80	710	451	432	432
query81	544	229	231	229
query82	595	129	119	119
query83	174	152	149	149
query84	246	84	72	72
query85	1306	325	297	297
query86	388	293	270	270
query87	4529	4346	4602	4346
query88	3374	2239	2199	2199
query89	451	287	290	287
query90	2112	191	188	188
query91	142	104	114	104
query92	64	50	49	49
query93	1817	554	547	547
query94	893	284	266	266
query95	351	254	247	247
query96	612	278	278	278
query97	2874	2672	2686	2672
query98	214	211	198	198
query99	1558	1327	1312	1312
Total cold run time: 304534 ms
Total hot run time: 195757 ms

@doris-robot
Copy link

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

query1	0.04	0.04	0.03
query2	0.07	0.03	0.04
query3	0.24	0.07	0.07
query4	1.60	0.10	0.10
query5	0.45	0.41	0.41
query6	1.16	0.65	0.65
query7	0.02	0.02	0.02
query8	0.04	0.03	0.03
query9	0.56	0.52	0.50
query10	0.56	0.58	0.55
query11	0.15	0.11	0.10
query12	0.14	0.11	0.11
query13	0.61	0.61	0.60
query14	2.80	2.84	2.72
query15	0.91	0.82	0.82
query16	0.38	0.36	0.42
query17	1.06	1.06	1.07
query18	0.23	0.20	0.21
query19	1.91	1.91	2.04
query20	0.01	0.01	0.01
query21	15.35	0.60	0.60
query22	2.29	2.37	1.66
query23	17.16	1.01	0.92
query24	2.94	1.25	0.38
query25	0.32	0.21	0.20
query26	0.29	0.13	0.14
query27	0.05	0.04	0.03
query28	11.26	1.09	1.07
query29	12.58	3.26	3.19
query30	0.25	0.06	0.07
query31	2.87	0.39	0.37
query32	3.27	0.45	0.45
query33	3.16	3.09	3.15
query34	17.02	4.43	4.47
query35	4.50	4.44	4.45
query36	0.69	0.47	0.49
query37	0.09	0.06	0.06
query38	0.05	0.04	0.03
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: 107.43 s
Total hot run time: 32.08 s

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

@starocean999 starocean999 starocean999 left review comments

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

Assignees
No one assigned
Labels
None yet
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