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

[Bug](auto-partition) fix auto partition could set storage_medium properties #45955

Merged
merged 7 commits into from
Jan 2, 2025
Merged

[Bug](auto-partition) fix auto partition could set storage_medium properties #45955

merged 7 commits into from
Jan 2, 2025

Conversation

zhangstar333
Copy link
Contributor

@zhangstar333 zhangstar333 commented Dec 25, 2024 •
edited
Loading

What problem does this PR solve?

Problem Summary:
as the auto partition table maybe no any partitions firstly, it's should same as table's storage medium rather than default storage medium, maybe user have change different from default value.

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

@Thearas
Copy link
Contributor

Thearas commented Dec 25, 2024

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?

@zhangstar333
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17626	6112	6067	6067
q2	2056	309	170	170
q3	10476	1219	764	764
q4	10269	885	453	453
q5	7648	2165	1964	1964
q6	202	178	151	151
q7	882	761	609	609
q8	9237	1350	1120	1120
q9	5264	4891	4883	4883
q10	6734	2332	1851	1851
q11	470	280	255	255
q12	346	366	222	222
q13	17763	3542	3068	3068
q14	251	239	237	237
q15	555	516	499	499
q16	627	620	582	582
q17	557	845	324	324
q18	6954	6549	6404	6404
q19	2084	956	562	562
q20	295	315	188	188
q21	2830	2163	2005	2005
q22	360	334	305	305
Total cold run time: 103486 ms
Total hot run time: 32683 ms

----- Round 2, with runtime_filter_mode=off -----
q1	6267	6214	6237	6214
q2	237	320	231	231
q3	2259	2676	2314	2314
q4	1383	1816	1375	1375
q5	4375	4728	4767	4728
q6	188	182	148	148
q7	2062	2034	1841	1841
q8	2625	2813	2639	2639
q9	7251	7270	7251	7251
q10	3040	3354	2845	2845
q11	576	500	504	500
q12	607	765	637	637
q13	3353	3755	3058	3058
q14	287	298	297	297
q15	586	509	517	509
q16	645	671	633	633
q17	1208	1737	1273	1273
q18	7527	7621	7444	7444
q19	799	949	1162	949
q20	2053	2053	1924	1924
q21	5739	5323	4939	4939
q22	638	621	593	593
Total cold run time: 53705 ms
Total hot run time: 52342 ms

@doris-robot
Copy link

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

query1	1287	990	900	900
query2	6488	2483	2251	2251
query3	11003	4600	4685	4600
query4	33073	23562	23428	23428
query5	4426	616	465	465
query6	287	202	193	193
query7	3987	487	307	307
query8	314	246	240	240
query9	9345	2760	2733	2733
query10	454	320	255	255
query11	18004	15348	15067	15067
query12	155	107	107	107
query13	1580	559	424	424
query14	10991	7300	7559	7300
query15	246	205	196	196
query16	8067	637	490	490
query17	1573	807	602	602
query18	2130	420	340	340
query19	249	195	169	169
query20	122	115	112	112
query21	204	131	109	109
query22	4668	4556	4558	4556
query23	34117	33441	33695	33441
query24	6356	2312	2342	2312
query25	476	458	396	396
query26	719	268	150	150
query27	2004	480	333	333
query28	5729	2539	2481	2481
query29	667	559	436	436
query30	212	184	152	152
query31	979	925	837	837
query32	83	60	56	56
query33	464	352	285	285
query34	774	850	539	539
query35	808	839	776	776
query36	1024	1037	968	968
query37	112	97	83	83
query38	4341	4303	4104	4104
query39	1535	1449	1457	1449
query40	210	114	103	103
query41	46	44	43	43
query42	140	105	114	105
query43	508	529	495	495
query44	1295	829	839	829
query45	184	176	168	168
query46	873	1058	687	687
query47	2035	1990	1934	1934
query48	409	420	341	341
query49	737	465	399	399
query50	620	670	391	391
query51	7330	7152	7148	7148
query52	105	104	97	97
query53	234	249	185	185
query54	489	508	437	437
query55	83	89	83	83
query56	266	254	243	243
query57	1266	1239	1195	1195
query58	244	225	252	225
query59	3104	3448	3136	3136
query60	274	262	257	257
query61	111	111	121	111
query62	861	826	779	779
query63	229	197	195	195
query64	3465	1006	687	687
query65	3361	3234	3317	3234
query66	801	420	294	294
query67	16230	15943	15534	15534
query68	10149	753	535	535
query69	485	295	258	258
query70	1201	1186	1120	1120
query71	430	277	263	263
query72	5766	3827	3805	3805
query73	805	751	369	369
query74	9960	9343	8870	8870
query75	4615	3114	2647	2647
query76	5545	1194	789	789
query77	1013	441	266	266
query78	9945	10230	9868	9868
query79	2675	907	612	612
query80	717	511	433	433
query81	491	270	232	232
query82	372	169	127	127
query83	185	163	145	145
query84	281	94	72	72
query85	823	369	298	298
query86	343	320	310	310
query87	4660	4443	4456	4443
query88	3309	2238	2240	2238
query89	413	337	299	299
query90	1848	187	190	187
query91	131	132	106	106
query92	63	55	52	52
query93	952	873	543	543
query94	678	389	296	296
query95	336	276	248	248
query96	491	601	283	283
query97	2777	2812	2719	2719
query98	238	194	199	194
query99	1648	1533	1447	1447
Total cold run time: 297908 ms
Total hot run time: 197051 ms

@doris-robot
Copy link

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

query1	0.04	0.03	0.03
query2	0.07	0.03	0.03
query3	0.23	0.07	0.06
query4	1.62	0.10	0.10
query5	0.41	0.41	0.42
query6	1.17	0.66	0.65
query7	0.02	0.02	0.02
query8	0.04	0.03	0.03
query9	0.60	0.48	0.51
query10	0.56	0.54	0.55
query11	0.15	0.11	0.11
query12	0.13	0.12	0.11
query13	0.61	0.62	0.59
query14	2.71	2.76	2.88
query15	0.88	0.82	0.82
query16	0.37	0.37	0.38
query17	1.04	1.07	0.97
query18	0.23	0.22	0.21
query19	1.94	1.80	1.93
query20	0.02	0.01	0.02
query21	15.37	0.95	0.60
query22	0.76	0.73	0.62
query23	15.39	1.45	0.52
query24	3.09	1.38	0.63
query25	0.17	0.08	0.13
query26	0.41	0.16	0.14
query27	0.05	0.05	0.05
query28	13.51	1.58	1.05
query29	12.57	4.05	3.32
query30	0.25	0.09	0.06
query31	2.86	0.62	0.39
query32	3.23	0.54	0.46
query33	3.09	3.31	3.16
query34	16.68	5.09	4.48
query35	4.50	4.49	4.45
query36	0.64	0.50	0.47
query37	0.09	0.06	0.06
query38	0.04	0.04	0.03
query39	0.04	0.03	0.02
query40	0.16	0.13	0.12
query41	0.08	0.02	0.02
query42	0.03	0.02	0.02
query43	0.04	0.03	0.02
Total cold run time: 105.89 s
Total hot run time: 30.87 s

@zhangstar333
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17602	6282	6221	6221
q2	2055	314	172	172
q3	10400	1310	729	729
q4	10215	886	452	452
q5	7526	2243	2038	2038
q6	227	178	149	149
q7	927	807	631	631
q8	9250	1469	1237	1237
q9	5531	5013	5053	5013
q10	6811	2337	1875	1875
q11	509	273	263	263
q12	351	382	227	227
q13	17783	3677	2976	2976
q14	251	237	217	217
q15	564	515	501	501
q16	635	627	591	591
q17	566	892	339	339
q18	7050	6529	6448	6448
q19	1234	1079	582	582
q20	332	344	197	197
q21	3068	2225	2054	2054
q22	378	338	320	320
Total cold run time: 103265 ms
Total hot run time: 33232 ms

----- Round 2, with runtime_filter_mode=off -----
q1	6494	6472	6444	6444
q2	251	344	238	238
q3	2227	2698	2307	2307
q4	1415	1830	1354	1354
q5	4429	4792	4807	4792
q6	196	180	143	143
q7	2009	1866	1727	1727
q8	2594	2775	2715	2715
q9	6967	6918	6835	6835
q10	3009	3254	2729	2729
q11	603	514	505	505
q12	652	705	558	558
q13	3339	3705	2954	2954
q14	295	281	270	270
q15	575	505	493	493
q16	669	667	638	638
q17	1217	1762	1233	1233
q18	7358	7231	7002	7002
q19	879	1220	1231	1220
q20	2003	1969	1892	1892
q21	5627	5126	4896	4896
q22	610	615	604	604
Total cold run time: 53418 ms
Total hot run time: 51549 ms

@doris-robot
Copy link

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

query1	984	392	395	392
query2	6524	2393	2336	2336
query3	6705	215	214	214
query4	34025	24116	23583	23583
query5	4318	634	463	463
query6	290	201	195	195
query7	4626	501	311	311
query8	311	262	254	254
query9	9518	2757	2760	2757
query10	457	300	259	259
query11	18212	15390	15142	15142
query12	156	107	106	106
query13	1664	558	415	415
query14	10799	7106	7416	7106
query15	255	198	186	186
query16	8012	593	451	451
query17	1571	725	567	567
query18	2122	404	299	299
query19	220	191	169	169
query20	118	111	116	111
query21	212	123	104	104
query22	4247	4294	4385	4294
query23	34287	33333	33503	33333
query24	6435	2309	2241	2241
query25	524	462	401	401
query26	781	273	161	161
query27	2027	462	330	330
query28	5411	2486	2451	2451
query29	710	573	446	446
query30	282	177	156	156
query31	975	883	833	833
query32	94	63	61	61
query33	496	355	292	292
query34	781	839	509	509
query35	786	804	764	764
query36	1008	1078	937	937
query37	117	102	84	84
query38	4115	4174	4361	4174
query39	1492	1441	1398	1398
query40	208	118	103	103
query41	46	47	47	47
query42	119	105	104	104
query43	520	523	487	487
query44	1342	820	808	808
query45	186	169	165	165
query46	870	1044	645	645
query47	1905	1895	1844	1844
query48	386	404	322	322
query49	727	478	387	387
query50	627	644	389	389
query51	7353	7414	7140	7140
query52	106	103	94	94
query53	230	267	190	190
query54	485	494	405	405
query55	81	84	84	84
query56	256	271	260	260
query57	1221	1146	1126	1126
query58	232	226	224	224
query59	2941	3102	2870	2870
query60	270	254	247	247
query61	109	107	110	107
query62	858	824	731	731
query63	228	194	196	194
query64	3832	996	643	643
query65	3275	3197	3244	3197
query66	864	416	310	310
query67	16086	15945	15628	15628
query68	9789	763	526	526
query69	474	285	250	250
query70	1242	1143	1138	1138
query71	446	280	255	255
query72	5845	3828	3830	3828
query73	1080	765	369	369
query74	10312	9115	9366	9115
query75	4586	3159	2668	2668
query76	5562	1197	772	772
query77	1018	379	267	267
query78	10120	10189	9513	9513
query79	4213	887	588	588
query80	688	514	429	429
query81	484	275	235	235
query82	210	149	124	124
query83	257	164	149	149
query84	285	94	71	71
query85	743	350	329	329
query86	339	279	297	279
query87	4639	4500	4547	4500
query88	4054	2213	2203	2203
query89	492	328	307	307
query90	2060	188	186	186
query91	136	132	106	106
query92	65	58	53	53
query93	3202	894	534	534
query94	669	379	288	288
query95	335	260	254	254
query96	508	620	285	285
query97	2752	2835	2725	2725
query98	220	202	197	197
query99	1619	1580	1510	1510
Total cold run time: 299474 ms
Total hot run time: 191089 ms

@doris-robot
Copy link

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

query1	0.03	0.03	0.04
query2	0.07	0.03	0.03
query3	0.24	0.07	0.07
query4	1.61	0.10	0.11
query5	0.44	0.42	0.42
query6	1.15	0.66	0.65
query7	0.02	0.02	0.01
query8	0.04	0.03	0.03
query9	0.59	0.51	0.51
query10	0.56	0.61	0.57
query11	0.15	0.11	0.11
query12	0.14	0.12	0.11
query13	0.62	0.60	0.61
query14	2.74	2.85	2.74
query15	0.90	0.84	0.84
query16	0.38	0.40	0.39
query17	1.03	1.02	1.03
query18	0.22	0.21	0.20
query19	1.98	1.88	2.03
query20	0.02	0.02	0.01
query21	15.36	0.95	0.59
query22	0.75	0.76	0.63
query23	15.37	1.48	0.55
query24	3.59	1.41	0.37
query25	0.19	0.19	0.21
query26	0.30	0.15	0.13
query27	0.08	0.05	0.05
query28	13.23	1.56	1.05
query29	12.62	3.98	3.29
query30	0.25	0.11	0.07
query31	2.82	0.62	0.38
query32	3.23	0.54	0.46
query33	3.24	3.24	3.12
query34	16.66	5.07	4.48
query35	4.50	4.46	4.44
query36	0.65	0.50	0.49
query37	0.10	0.06	0.07
query38	0.05	0.04	0.04
query39	0.03	0.02	0.02
query40	0.17	0.13	0.12
query41	0.08	0.03	0.02
query42	0.04	0.03	0.02
query43	0.03	0.03	0.03
Total cold run time: 106.27 s
Total hot run time: 30.92 s

@zhangstar333
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17596	6171	6088	6088
q2	2043	305	168	168
q3	10408	1313	742	742
q4	10230	873	442	442
q5	7541	2190	1994	1994
q6	208	180	145	145
q7	896	754	612	612
q8	9242	1362	1189	1189
q9	5368	4959	4962	4959
q10	6793	2308	1884	1884
q11	478	290	261	261
q12	359	365	224	224
q13	17772	3596	2978	2978
q14	240	245	218	218
q15	554	516	495	495
q16	648	620	585	585
q17	578	844	320	320
q18	6938	6377	6534	6377
q19	1227	977	574	574
q20	316	321	199	199
q21	3038	2169	1991	1991
q22	372	333	320	320
Total cold run time: 102845 ms
Total hot run time: 32765 ms

----- Round 2, with runtime_filter_mode=off -----
q1	6245	6228	6256	6228
q2	240	325	234	234
q3	2208	2650	2319	2319
q4	1391	1840	1385	1385
q5	4357	4716	4671	4671
q6	177	171	139	139
q7	1973	1842	1737	1737
q8	2512	2745	2628	2628
q9	6946	6848	6873	6848
q10	2943	3200	2738	2738
q11	573	525	500	500
q12	721	736	557	557
q13	3194	3675	3012	3012
q14	287	284	263	263
q15	559	498	495	495
q16	627	682	630	630
q17	1189	1702	1218	1218
q18	7266	6967	7113	6967
q19	844	1033	1106	1033
q20	1903	1983	1832	1832
q21	5368	5147	4905	4905
q22	614	631	606	606
Total cold run time: 52137 ms
Total hot run time: 50945 ms

zclllyybb
zclllyybb approved these changes Dec 26, 2024
View reviewed changes
Copy link
Contributor

@zclllyybb zclllyybb left a comment

Choose a reason for hiding this comment

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

LGTM

@github-actions GitHub Actions
Copy link
Contributor

PR approved by anyone and no changes requested.

@doris-robot
Copy link

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

query1	976	402	386	386
query2	6575	2327	2243	2243
query3	6718	213	207	207
query4	33629	23488	23444	23444
query5	4342	609	459	459
query6	286	203	198	198
query7	4620	505	302	302
query8	316	251	243	243
query9	9734	2782	2760	2760
query10	465	303	246	246
query11	18269	15741	15258	15258
query12	159	109	106	106
query13	1663	533	411	411
query14	11987	7484	6885	6885
query15	241	197	191	191
query16	8120	611	428	428
query17	1572	731	559	559
query18	2122	391	287	287
query19	216	177	155	155
query20	118	113	114	113
query21	208	123	101	101
query22	4312	4450	4180	4180
query23	34361	33140	33974	33140
query24	6336	2274	2344	2274
query25	504	458	380	380
query26	909	280	154	154
query27	1999	461	335	335
query28	5062	2480	2447	2447
query29	711	549	421	421
query30	227	181	153	153
query31	986	890	818	818
query32	98	59	60	59
query33	483	358	291	291
query34	757	838	519	519
query35	799	793	748	748
query36	1009	1053	948	948
query37	118	98	77	77
query38	3998	4177	4085	4085
query39	1483	1430	1464	1430
query40	208	115	102	102
query41	48	45	44	44
query42	129	108	101	101
query43	514	527	495	495
query44	1343	804	812	804
query45	177	175	169	169
query46	877	1061	648	648
query47	1892	1913	1840	1840
query48	384	427	324	324
query49	714	471	393	393
query50	644	655	401	401
query51	7315	7124	7174	7124
query52	105	107	93	93
query53	237	259	187	187
query54	478	487	406	406
query55	80	82	80	80
query56	258	253	227	227
query57	1200	1165	1100	1100
query58	238	233	225	225
query59	3034	3092	3118	3092
query60	273	271	262	262
query61	112	105	112	105
query62	869	797	716	716
query63	236	195	189	189
query64	3831	998	654	654
query65	3320	3207	3255	3207
query66	754	423	311	311
query67	15994	15685	15542	15542
query68	7913	764	528	528
query69	480	290	250	250
query70	1201	1145	1124	1124
query71	448	290	260	260
query72	5849	3861	3853	3853
query73	666	771	368	368
query74	9494	9299	9023	9023
query75	4159	3145	2662	2662
query76	3682	1212	776	776
query77	774	369	267	267
query78	9937	10195	9244	9244
query79	2670	897	607	607
query80	591	526	433	433
query81	500	274	233	233
query82	507	147	121	121
query83	166	166	150	150
query84	241	87	75	75
query85	865	485	305	305
query86	396	323	298	298
query87	4462	4486	4466	4466
query88	5021	2225	2221	2221
query89	407	329	304	304
query90	1797	189	193	189
query91	127	140	107	107
query92	60	59	50	50
query93	1933	904	540	540
query94	657	395	294	294
query95	332	267	258	258
query96	501	612	285	285
query97	2741	2833	2703	2703
query98	228	216	196	196
query99	1464	1599	1470	1470
Total cold run time: 292021 ms
Total hot run time: 189942 ms

@doris-robot
Copy link

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

query1	0.03	0.03	0.04
query2	0.07	0.03	0.04
query3	0.24	0.07	0.07
query4	1.60	0.11	0.10
query5	0.42	0.42	0.41
query6	1.17	0.66	0.65
query7	0.02	0.02	0.01
query8	0.04	0.03	0.04
query9	0.59	0.51	0.52
query10	0.55	0.58	0.54
query11	0.14	0.10	0.11
query12	0.15	0.12	0.11
query13	0.62	0.62	0.61
query14	2.78	2.86	2.75
query15	0.90	0.84	0.83
query16	0.38	0.37	0.38
query17	1.07	0.98	1.01
query18	0.21	0.21	0.20
query19	1.85	1.88	2.00
query20	0.01	0.01	0.01
query21	15.36	0.94	0.61
query22	0.75	0.86	0.56
query23	15.34	1.46	0.59
query24	2.61	1.52	1.21
query25	0.22	0.07	0.27
query26	0.26	0.14	0.15
query27	0.07	0.08	0.04
query28	14.10	1.53	1.04
query29	12.57	3.93	3.31
query30	0.25	0.10	0.06
query31	2.82	0.60	0.40
query32	3.24	0.55	0.45
query33	3.07	3.32	3.05
query34	16.65	5.10	4.57
query35	4.57	4.50	4.54
query36	0.63	0.51	0.52
query37	0.09	0.07	0.06
query38	0.05	0.03	0.03
query39	0.04	0.02	0.03
query40	0.16	0.13	0.12
query41	0.07	0.02	0.03
query42	0.04	0.02	0.02
query43	0.03	0.03	0.04
Total cold run time: 105.83 s
Total hot run time: 31.63 s

@zhangstar333
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17605	6131	6038	6038
q2	2041	292	170	170
q3	10440	1239	711	711
q4	10204	846	420	420
q5	7518	2153	1943	1943
q6	208	182	148	148
q7	874	751	595	595
q8	9238	1334	1202	1202
q9	5196	4842	4893	4842
q10	6731	2305	1889	1889
q11	478	277	261	261
q12	357	361	217	217
q13	17754	3654	2916	2916
q14	234	228	210	210
q15	558	510	494	494
q16	631	612	587	587
q17	557	834	335	335
q18	7216	6499	6296	6296
q19	1238	954	542	542
q20	308	322	188	188
q21	2736	2129	1949	1949
q22	357	322	308	308
Total cold run time: 102479 ms
Total hot run time: 32261 ms

----- Round 2, with runtime_filter_mode=off -----
q1	6147	6158	6147	6147
q2	239	323	239	239
q3	2248	2621	2363	2363
q4	1382	1825	1354	1354
q5	4359	4710	4711	4710
q6	188	176	143	143
q7	2099	2036	1816	1816
q8	2556	2733	2618	2618
q9	7369	7204	7173	7173
q10	3068	3307	2822	2822
q11	611	525	503	503
q12	657	778	641	641
q13	3359	3779	3025	3025
q14	297	293	298	293
q15	579	509	507	507
q16	650	696	644	644
q17	1178	1719	1232	1232
q18	7649	7380	7143	7143
q19	776	1082	1040	1040
q20	1884	1992	1903	1903
q21	5541	5099	4793	4793
q22	616	643	571	571
Total cold run time: 53452 ms
Total hot run time: 51680 ms

@doris-robot
Copy link

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

query1	967	373	366	366
query2	6520	2510	2329	2329
query3	6711	223	216	216
query4	34267	23732	23533	23533
query5	4365	616	452	452
query6	287	193	184	184
query7	4619	530	302	302
query8	320	245	248	245
query9	9604	2735	2733	2733
query10	434	308	240	240
query11	18104	15412	15407	15407
query12	164	111	99	99
query13	1657	537	407	407
query14	10107	6843	7799	6843
query15	247	195	186	186
query16	8235	589	434	434
query17	1575	762	559	559
query18	2025	399	302	302
query19	204	183	155	155
query20	117	118	111	111
query21	215	120	105	105
query22	4276	4560	4403	4403
query23	34596	33592	33493	33493
query24	6443	2353	2234	2234
query25	485	447	379	379
query26	1191	286	159	159
query27	2009	471	328	328
query28	5172	2479	2440	2440
query29	738	578	412	412
query30	237	181	153	153
query31	971	913	821	821
query32	97	61	58	58
query33	498	344	289	289
query34	771	839	521	521
query35	782	786	739	739
query36	1027	1035	961	961
query37	115	98	75	75
query38	4375	4156	4208	4156
query39	1497	1612	1419	1419
query40	208	119	104	104
query41	47	46	44	44
query42	120	103	99	99
query43	505	515	490	490
query44	1325	813	804	804
query45	205	175	165	165
query46	870	1035	650	650
query47	1930	1966	1884	1884
query48	386	401	328	328
query49	761	490	394	394
query50	622	651	392	392
query51	7127	7246	7000	7000
query52	110	96	92	92
query53	217	252	183	183
query54	468	470	404	404
query55	80	79	76	76
query56	264	262	228	228
query57	1210	1178	1139	1139
query58	232	222	222	222
query59	3151	3134	3119	3119
query60	276	262	249	249
query61	110	110	106	106
query62	896	802	728	728
query63	226	186	210	186
query64	4603	983	652	652
query65	3283	3164	3234	3164
query66	1084	438	311	311
query67	16119	15912	15649	15649
query68	9840	767	527	527
query69	468	290	261	261
query70	1237	1169	1141	1141
query71	423	288	250	250
query72	5905	3788	3840	3788
query73	693	752	374	374
query74	9753	9590	8820	8820
query75	4372	3181	2665	2665
query76	5517	1192	759	759
query77	1018	371	271	271
query78	10117	10345	9419	9419
query79	3021	923	595	595
query80	698	516	424	424
query81	484	281	229	229
query82	669	161	124	124
query83	190	165	147	147
query84	282	88	81	81
query85	771	385	374	374
query86	352	313	294	294
query87	4402	4531	4438	4438
query88	4624	2232	2186	2186
query89	411	337	301	301
query90	1923	193	186	186
query91	135	134	102	102
query92	66	57	53	53
query93	1397	870	540	540
query94	662	396	289	289
query95	329	264	251	251
query96	489	612	284	284
query97	2808	2768	2735	2735
query98	228	211	198	198
query99	2071	1569	1453	1453
Total cold run time: 297814 ms
Total hot run time: 190669 ms

@doris-robot
Copy link

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

query1	0.04	0.05	0.03
query2	0.07	0.03	0.04
query3	0.24	0.07	0.06
query4	1.62	0.10	0.10
query5	0.45	0.39	0.39
query6	1.15	0.65	0.67
query7	0.02	0.02	0.01
query8	0.04	0.03	0.03
query9	0.58	0.53	0.51
query10	0.55	0.57	0.56
query11	0.16	0.10	0.10
query12	0.15	0.10	0.10
query13	0.59	0.60	0.60
query14	2.79	2.73	2.72
query15	0.91	0.83	0.82
query16	0.38	0.39	0.38
query17	1.01	1.05	0.99
query18	0.24	0.22	0.21
query19	1.96	1.84	1.97
query20	0.02	0.01	0.02
query21	15.44	0.97	0.60
query22	0.76	0.80	0.73
query23	15.20	1.40	0.54
query24	3.39	1.68	1.26
query25	0.18	0.19	0.17
query26	0.24	0.16	0.15
query27	0.07	0.08	0.05
query28	14.22	1.52	1.06
query29	12.59	3.98	3.31
query30	0.25	0.09	0.06
query31	2.82	0.63	0.39
query32	3.24	0.55	0.46
query33	3.07	3.10	3.17
query34	16.86	5.11	4.47
query35	4.49	4.48	4.44
query36	0.64	0.51	0.48
query37	0.09	0.06	0.06
query38	0.05	0.04	0.04
query39	0.04	0.03	0.03
query40	0.16	0.13	0.13
query41	0.08	0.03	0.03
query42	0.03	0.03	0.02
query43	0.03	0.03	0.03
Total cold run time: 106.91 s
Total hot run time: 31.75 s

@HappenLee
Copy link
Contributor

PLEASE ADD TEST CASE！

@zhangstar333
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17577	6206	6030	6030
q2	2043	301	167	167
q3	10424	1226	709	709
q4	10213	853	420	420
q5	7513	2145	1903	1903
q6	210	181	145	145
q7	894	740	598	598
q8	9228	1348	1177	1177
q9	5251	4925	4902	4902
q10	6735	2297	1880	1880
q11	461	284	256	256
q12	342	355	213	213
q13	17744	3602	3037	3037
q14	226	237	213	213
q15	552	510	510	510
q16	624	623	591	591
q17	553	841	325	325
q18	7065	6585	6416	6416
q19	1234	961	554	554
q20	302	305	186	186
q21	2766	2209	1962	1962
q22	356	330	314	314
Total cold run time: 102313 ms
Total hot run time: 32508 ms

----- Round 2, with runtime_filter_mode=off -----
q1	6182	6205	6208	6205
q2	236	324	234	234
q3	2231	2671	2362	2362
q4	1427	1871	1360	1360
q5	4344	4728	4655	4655
q6	189	177	144	144
q7	2095	1983	1786	1786
q8	2602	2814	2669	2669
q9	7361	7168	7223	7168
q10	3097	3344	2828	2828
q11	594	516	492	492
q12	667	744	599	599
q13	3373	3712	3058	3058
q14	298	302	279	279
q15	581	519	489	489
q16	661	685	657	657
q17	1169	1726	1223	1223
q18	7563	7317	7348	7317
q19	786	1126	1042	1042
q20	1887	2004	1829	1829
q21	5486	5073	4900	4900
q22	608	621	587	587
Total cold run time: 53437 ms
Total hot run time: 51883 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 190442 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 5436469c4fe8841c3a5f1a75d050e4c0210dc60c, data reload: false

query1	969	378	360	360
query2	6513	2492	2328	2328
query3	6705	228	212	212
query4	33798	23864	23687	23687
query5	4431	623	460	460
query6	285	196	189	189
query7	4612	491	301	301
query8	321	255	241	241
query9	9583	2751	2731	2731
query10	469	335	262	262
query11	17975	15483	15145	15145
query12	168	108	105	105
query13	1684	527	405	405
query14	10131	7249	8107	7249
query15	271	191	185	185
query16	8189	603	455	455
query17	1649	770	588	588
query18	1346	373	309	309
query19	232	187	160	160
query20	119	116	122	116
query21	212	121	105	105
query22	4533	4528	4351	4351
query23	34601	33316	33246	33246
query24	6378	2253	2263	2253
query25	487	442	371	371
query26	1183	267	154	154
query27	2022	452	340	340
query28	5293	2448	2430	2430
query29	652	565	408	408
query30	228	181	146	146
query31	980	883	821	821
query32	92	59	62	59
query33	517	349	296	296
query34	763	843	512	512
query35	808	811	721	721
query36	1021	1026	972	972
query37	113	103	77	77
query38	4086	4496	4043	4043
query39	1497	1424	1431	1424
query40	208	114	100	100
query41	45	48	44	44
query42	120	101	101	101
query43	520	514	488	488
query44	1308	793	830	793
query45	177	177	168	168
query46	854	1037	657	657
query47	1915	1903	1845	1845
query48	386	430	316	316
query49	763	481	388	388
query50	630	640	397	397
query51	7128	7379	7071	7071
query52	101	99	90	90
query53	228	245	189	189
query54	474	481	399	399
query55	86	80	79	79
query56	263	255	235	235
query57	1208	1166	1139	1139
query58	236	230	230	230
query59	3012	2973	2863	2863
query60	261	260	243	243
query61	113	141	119	119
query62	877	791	746	746
query63	231	187	191	187
query64	4294	987	705	705
query65	3263	3208	3242	3208
query66	1066	411	309	309
query67	16023	15907	15565	15565
query68	9658	761	529	529
query69	471	295	260	260
query70	1206	1123	1086	1086
query71	445	282	252	252
query72	5837	3817	3834	3817
query73	676	759	368	368
query74	10477	9005	8952	8952
query75	4603	3142	2633	2633
query76	5534	1204	792	792
query77	1023	370	282	282
query78	10031	10189	9336	9336
query79	5592	878	617	617
query80	712	544	506	506
query81	474	266	230	230
query82	339	154	118	118
query83	198	168	152	152
query84	288	85	74	74
query85	738	379	303	303
query86	354	316	290	290
query87	4414	4366	4310	4310
query88	4051	2247	2207	2207
query89	440	330	296	296
query90	2075	189	194	189
query91	141	132	106	106
query92	64	59	53	53
query93	3376	878	610	610
query94	667	380	282	282
query95	345	268	255	255
query96	493	621	280	280
query97	2777	2814	2664	2664
query98	222	197	199	197
query99	1622	1578	1505	1505
Total cold run time: 300049 ms
Total hot run time: 190442 ms

@doris-robot
Copy link

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

query1	0.03	0.03	0.03
query2	0.08	0.03	0.03
query3	0.24	0.07	0.07
query4	1.60	0.10	0.10
query5	0.42	0.41	0.41
query6	1.15	0.65	0.64
query7	0.02	0.01	0.01
query8	0.04	0.03	0.03
query9	0.56	0.52	0.51
query10	0.56	0.60	0.54
query11	0.14	0.10	0.11
query12	0.15	0.10	0.12
query13	0.61	0.60	0.59
query14	2.88	2.85	2.76
query15	0.88	0.86	0.83
query16	0.38	0.39	0.39
query17	0.98	1.05	1.03
query18	0.21	0.22	0.21
query19	1.93	1.83	2.01
query20	0.02	0.01	0.01
query21	15.37	0.88	0.57
query22	0.75	0.80	0.65
query23	15.33	1.36	0.59
query24	2.70	1.39	1.65
query25	0.22	0.13	0.05
query26	0.24	0.15	0.14
query27	0.06	0.06	0.06
query28	14.45	1.48	1.05
query29	12.58	4.02	3.26
query30	0.25	0.09	0.05
query31	2.83	0.59	0.37
query32	3.23	0.55	0.46
query33	3.08	3.13	3.12
query34	16.72	5.07	4.50
query35	4.50	4.44	4.46
query36	0.64	0.51	0.52
query37	0.09	0.06	0.07
query38	0.05	0.04	0.04
query39	0.03	0.02	0.03
query40	0.17	0.14	0.12
query41	0.08	0.03	0.02
query42	0.04	0.02	0.03
query43	0.04	0.03	0.03
Total cold run time: 106.33 s
Total hot run time: 31.74 s

@zhangstar333
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17575	6205	6090	6090
q2	2053	310	173	173
q3	10586	1312	747	747
q4	10276	875	435	435
q5	8415	2196	2207	2196
q6	211	175	147	147
q7	893	733	622	622
q8	9253	1347	1089	1089
q9	5149	4866	4940	4866
q10	6781	2310	1841	1841
q11	467	268	262	262
q12	344	363	238	238
q13	17752	3615	3033	3033
q14	240	238	209	209
q15	543	518	512	512
q16	644	630	603	603
q17	572	847	320	320
q18	7127	6506	6423	6423
q19	3557	961	556	556
q20	304	311	183	183
q21	2732	2174	1966	1966
q22	369	323	311	311
Total cold run time: 105843 ms
Total hot run time: 32822 ms

----- Round 2, with runtime_filter_mode=off -----
q1	6386	6279	6370	6279
q2	238	322	239	239
q3	2294	2651	2330	2330
q4	1438	1843	1402	1402
q5	4314	4747	5088	4747
q6	181	174	141	141
q7	2046	1963	1815	1815
q8	2636	2771	2647	2647
q9	7295	7170	7239	7170
q10	3069	3360	2809	2809
q11	594	529	501	501
q12	668	735	605	605
q13	3360	3679	3081	3081
q14	289	323	331	323
q15	571	502	502	502
q16	662	677	644	644
q17	1195	1715	1248	1248
q18	7805	7363	7152	7152
q19	786	1154	993	993
q20	1867	1973	1814	1814
q21	5427	5367	4988	4988
q22	606	632	568	568
Total cold run time: 53727 ms
Total hot run time: 51998 ms

@doris-robot
Copy link

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

query1	985	382	386	382
query2	6547	2446	2313	2313
query3	6725	221	211	211
query4	34339	23682	23678	23678
query5	4412	631	460	460
query6	270	192	190	190
query7	4623	497	307	307
query8	304	236	232	232
query9	9630	2769	2752	2752
query10	474	332	255	255
query11	18504	15377	15449	15377
query12	162	113	106	106
query13	1667	576	425	425
query14	10561	6696	7319	6696
query15	240	194	188	188
query16	8238	607	464	464
query17	1581	751	582	582
query18	2151	414	311	311
query19	232	189	164	164
query20	124	110	112	110
query21	214	124	108	108
query22	4237	4484	4164	4164
query23	34372	33182	33806	33182
query24	6693	2255	2315	2255
query25	500	456	373	373
query26	837	280	155	155
query27	1996	463	341	341
query28	5483	2461	2446	2446
query29	690	532	416	416
query30	233	188	154	154
query31	964	881	794	794
query32	92	62	61	61
query33	493	344	321	321
query34	757	832	509	509
query35	786	835	725	725
query36	1040	1059	966	966
query37	115	95	86	86
query38	4120	4128	4025	4025
query39	1494	1429	1467	1429
query40	205	116	97	97
query41	48	44	48	44
query42	116	101	100	100
query43	511	532	487	487
query44	1333	803	803	803
query45	180	172	168	168
query46	877	1034	653	653
query47	1933	1929	1860	1860
query48	394	413	323	323
query49	744	477	402	402
query50	672	652	392	392
query51	7227	7183	7028	7028
query52	101	103	100	100
query53	228	264	195	195
query54	477	484	410	410
query55	83	77	79	77
query56	267	251	231	231
query57	1219	1204	1141	1141
query58	242	220	234	220
query59	3022	3177	2930	2930
query60	280	266	275	266
query61	111	109	112	109
query62	867	778	764	764
query63	236	194	194	194
query64	3896	987	657	657
query65	3302	3216	3217	3216
query66	743	415	334	334
query67	15876	15681	15520	15520
query68	9106	764	539	539
query69	464	303	259	259
query70	1250	1161	1137	1137
query71	418	289	264	264
query72	5903	3832	3841	3832
query73	663	749	362	362
query74	10226	9237	9046	9046
query75	4501	3156	2638	2638
query76	5158	1204	775	775
query77	992	370	299	299
query78	10097	10214	9433	9433
query79	4452	870	597	597
query80	768	516	428	428
query81	486	272	220	220
query82	322	141	123	123
query83	192	169	148	148
query84	279	95	76	76
query85	761	371	385	371
query86	344	318	309	309
query87	4699	4603	4357	4357
query88	3305	2252	2237	2237
query89	429	332	307	307
query90	2042	188	188	188
query91	132	132	104	104
query92	68	58	53	53
query93	2536	869	542	542
query94	703	401	292	292
query95	336	269	256	256
query96	499	607	280	280
query97	2760	2785	2686	2686
query98	227	203	196	196
query99	1637	1573	1452	1452
Total cold run time: 297830 ms
Total hot run time: 190240 ms

@doris-robot
Copy link

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

query1	0.04	0.05	0.03
query2	0.07	0.03	0.03
query3	0.24	0.07	0.07
query4	1.65	0.11	0.10
query5	0.42	0.40	0.41
query6	1.16	0.64	0.65
query7	0.03	0.02	0.02
query8	0.04	0.03	0.03
query9	0.59	0.52	0.50
query10	0.55	0.57	0.56
query11	0.15	0.10	0.11
query12	0.14	0.11	0.11
query13	0.61	0.62	0.60
query14	2.85	2.74	2.71
query15	0.90	0.83	0.82
query16	0.37	0.39	0.39
query17	1.07	1.05	1.00
query18	0.24	0.22	0.21
query19	1.87	1.75	2.00
query20	0.01	0.01	0.01
query21	15.36	0.98	0.58
query22	0.74	0.86	0.67
query23	15.27	1.41	0.55
query24	2.92	0.94	1.17
query25	0.18	0.14	0.10
query26	0.32	0.15	0.14
query27	0.05	0.08	0.04
query28	13.73	1.55	1.06
query29	12.59	3.89	3.31
query30	0.26	0.09	0.06
query31	2.82	0.61	0.39
query32	3.23	0.54	0.46
query33	3.08	3.08	3.10
query34	16.84	5.12	4.49
query35	4.56	4.44	4.52
query36	0.65	0.48	0.48
query37	0.08	0.06	0.06
query38	0.04	0.04	0.03
query39	0.03	0.02	0.02
query40	0.15	0.13	0.13
query41	0.07	0.02	0.02
query42	0.04	0.02	0.02
query43	0.04	0.03	0.02
Total cold run time: 106.05 s
Total hot run time: 31.17 s

@zhangstar333
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17562	6140	6049	6049
q2	2047	302	178	178
q3	10415	1248	718	718
q4	10211	872	427	427
q5	7509	2169	1926	1926
q6	207	177	144	144
q7	888	754	622	622
q8	9241	1321	1212	1212
q9	5262	4990	4918	4918
q10	6754	2296	1854	1854
q11	484	278	252	252
q12	338	359	212	212
q13	17770	3544	2924	2924
q14	227	229	208	208
q15	564	528	505	505
q16	610	611	582	582
q17	596	843	325	325
q18	7140	6427	6572	6427
q19	1219	960	589	589
q20	321	344	199	199
q21	2828	2137	1994	1994
q22	365	337	313	313
Total cold run time: 102558 ms
Total hot run time: 32578 ms

----- Round 2, with runtime_filter_mode=off -----
q1	6241	6212	6206	6206
q2	234	326	228	228
q3	2205	2696	2356	2356
q4	1395	1823	1335	1335
q5	4330	4732	4750	4732
q6	175	184	142	142
q7	2089	1991	1834	1834
q8	2558	2812	2724	2724
q9	7359	7180	7112	7112
q10	3045	3317	2804	2804
q11	593	531	496	496
q12	665	740	606	606
q13	3401	3743	3082	3082
q14	298	304	272	272
q15	559	511	504	504
q16	661	692	640	640
q17	1209	1716	1283	1283
q18	7686	7571	7277	7277
q19	804	1142	1008	1008
q20	1912	1967	1893	1893
q21	5374	5193	4925	4925
q22	594	612	589	589
Total cold run time: 53387 ms
Total hot run time: 52048 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 190784 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 17a131c2692fc757f7461ccaf9c360694cd30c61, data reload: false

query1	966	412	376	376
query2	6535	2392	2267	2267
query3	6707	216	211	211
query4	34035	23577	23749	23577
query5	4365	620	475	475
query6	276	204	183	183
query7	4626	508	302	302
query8	317	250	239	239
query9	9248	2761	2746	2746
query10	469	319	254	254
query11	18568	15480	15246	15246
query12	166	114	106	106
query13	1658	578	417	417
query14	11081	7170	7356	7170
query15	264	191	193	191
query16	8715	595	452	452
query17	1634	756	582	582
query18	2146	406	360	360
query19	214	186	159	159
query20	115	114	108	108
query21	209	124	104	104
query22	4271	4369	4305	4305
query23	34495	33384	33678	33384
query24	6402	2172	2279	2172
query25	491	442	383	383
query26	1179	270	150	150
query27	2035	470	341	341
query28	5372	2473	2447	2447
query29	740	530	409	409
query30	228	185	146	146
query31	993	884	810	810
query32	115	60	57	57
query33	511	355	287	287
query34	760	827	502	502
query35	785	801	721	721
query36	1020	1036	951	951
query37	112	96	75	75
query38	4472	4257	4167	4167
query39	1499	1431	1427	1427
query40	203	112	101	101
query41	46	44	44	44
query42	123	102	101	101
query43	520	510	487	487
query44	1298	792	811	792
query45	184	174	170	170
query46	863	1023	646	646
query47	1902	1918	1856	1856
query48	374	420	326	326
query49	766	468	406	406
query50	638	640	389	389
query51	6994	7127	7024	7024
query52	104	102	91	91
query53	224	252	180	180
query54	477	481	410	410
query55	83	78	74	74
query56	287	256	243	243
query57	1218	1164	1129	1129
query58	238	222	236	222
query59	3031	3190	3072	3072
query60	274	256	242	242
query61	109	110	104	104
query62	921	804	711	711
query63	225	189	190	189
query64	4227	992	627	627
query65	3286	3181	3216	3181
query66	1074	420	312	312
query67	15966	15983	15614	15614
query68	9526	748	532	532
query69	450	285	256	256
query70	1214	1190	1128	1128
query71	438	280	259	259
query72	5943	3843	3823	3823
query73	667	757	372	372
query74	9599	9149	8924	8924
query75	4607	3151	2675	2675
query76	5020	1176	764	764
query77	987	370	275	275
query78	10061	10426	9429	9429
query79	2883	902	602	602
query80	713	513	424	424
query81	472	264	234	234
query82	338	140	127	127
query83	194	170	147	147
query84	277	100	70	70
query85	736	345	336	336
query86	360	320	311	311
query87	4457	4579	4589	4579
query88	2971	2253	2215	2215
query89	421	338	296	296
query90	2086	186	182	182
query91	134	133	104	104
query92	63	58	53	53
query93	1657	885	542	542
query94	666	376	263	263
query95	342	260	248	248
query96	492	605	281	281
query97	2752	2828	2699	2699
query98	224	199	195	195
query99	1693	1549	1437	1437
Total cold run time: 295892 ms
Total hot run time: 190784 ms

@doris-robot
Copy link

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

query1	0.03	0.03	0.03
query2	0.07	0.03	0.03
query3	0.23	0.07	0.07
query4	1.62	0.11	0.10
query5	0.40	0.42	0.42
query6	1.17	0.66	0.65
query7	0.02	0.02	0.01
query8	0.04	0.03	0.03
query9	0.59	0.51	0.50
query10	0.55	0.58	0.55
query11	0.15	0.10	0.10
query12	0.14	0.10	0.11
query13	0.61	0.61	0.60
query14	2.73	2.83	2.76
query15	0.91	0.83	0.82
query16	0.37	0.38	0.38
query17	1.06	1.01	1.07
query18	0.22	0.21	0.21
query19	1.97	1.90	2.00
query20	0.01	0.01	0.00
query21	15.35	0.89	0.56
query22	0.75	0.84	0.69
query23	15.20	1.40	0.57
query24	2.70	0.76	1.29
query25	0.14	0.10	0.11
query26	0.30	0.14	0.12
query27	0.08	0.05	0.05
query28	14.04	1.57	1.04
query29	12.64	3.90	3.22
query30	0.25	0.09	0.07
query31	2.82	0.61	0.38
query32	3.23	0.55	0.46
query33	3.11	3.14	3.21
query34	16.79	5.13	4.47
query35	4.58	4.46	4.41
query36	0.63	0.51	0.50
query37	0.09	0.06	0.06
query38	0.05	0.04	0.04
query39	0.03	0.03	0.02
query40	0.17	0.13	0.12
query41	0.07	0.03	0.03
query42	0.03	0.02	0.02
query43	0.04	0.04	0.03
Total cold run time: 105.98 s
Total hot run time: 31.13 s

@zhangstar333
Copy link
Contributor Author

run buildall

@zhangstar333
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17574	6108	6022	6022
q2	2050	317	164	164
q3	10586	1217	734	734
q4	10221	868	431	431
q5	7852	2166	1981	1981
q6	216	178	147	147
q7	882	759	611	611
q8	9244	1357	1157	1157
q9	5118	4888	4878	4878
q10	6804	2322	1869	1869
q11	472	281	270	270
q12	345	357	227	227
q13	17784	3554	2958	2958
q14	220	228	217	217
q15	551	497	538	497
q16	625	614	580	580
q17	578	834	311	311
q18	6911	6737	6371	6371
q19	1234	957	559	559
q20	310	313	196	196
q21	2882	2187	1954	1954
q22	358	326	299	299
Total cold run time: 102817 ms
Total hot run time: 32433 ms

----- Round 2, with runtime_filter_mode=off -----
q1	6193	6219	6203	6203
q2	245	336	233	233
q3	2229	2652	2288	2288
q4	1367	1823	1336	1336
q5	4346	4744	4739	4739
q6	186	176	144	144
q7	2076	1942	1825	1825
q8	2650	2849	2713	2713
q9	7287	7253	7343	7253
q10	3058	3357	2852	2852
q11	597	521	511	511
q12	647	729	576	576
q13	3417	3810	3160	3160
q14	287	305	310	305
q15	561	528	503	503
q16	668	687	632	632
q17	1233	1757	1275	1275
q18	7729	7451	7312	7312
q19	861	1166	1073	1073
q20	2006	2072	1871	1871
q21	5830	5417	5088	5088
q22	628	620	584	584
Total cold run time: 54101 ms
Total hot run time: 52476 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 196940 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 80b5ac2d4c3527ad5e10277c7f2492d9d533ee55, data reload: false

query1	1323	946	932	932
query2	6491	2218	2232	2218
query3	10931	4638	4626	4626
query4	35339	23690	23432	23432
query5	4274	617	474	474
query6	300	222	198	198
query7	4004	484	305	305
query8	310	244	242	242
query9	9515	2751	2732	2732
query10	474	320	253	253
query11	18171	15279	15411	15279
query12	160	110	111	110
query13	1582	545	415	415
query14	10977	7111	7599	7111
query15	260	224	183	183
query16	7970	583	485	485
query17	1527	776	586	586
query18	2173	406	355	355
query19	214	184	157	157
query20	116	113	110	110
query21	203	126	106	106
query22	4568	4667	4482	4482
query23	34637	33543	33759	33543
query24	6434	2374	2320	2320
query25	500	447	401	401
query26	866	275	166	166
query27	2027	480	338	338
query28	5089	2524	2468	2468
query29	663	556	450	450
query30	208	185	151	151
query31	986	913	825	825
query32	92	66	60	60
query33	510	362	278	278
query34	782	852	527	527
query35	841	847	774	774
query36	1023	1092	986	986
query37	124	105	75	75
query38	4328	4171	4195	4171
query39	1526	1467	1484	1467
query40	210	113	101	101
query41	51	51	45	45
query42	123	109	115	109
query43	530	544	508	508
query44	1346	840	830	830
query45	184	202	173	173
query46	902	1070	677	677
query47	1993	1961	1956	1956
query48	396	433	329	329
query49	716	485	399	399
query50	636	664	397	397
query51	7411	7286	7239	7239
query52	102	109	95	95
query53	232	264	198	198
query54	518	505	422	422
query55	92	79	80	79
query56	274	272	247	247
query57	1244	1249	1179	1179
query58	249	216	224	216
query59	3174	3407	3173	3173
query60	292	287	267	267
query61	110	105	120	105
query62	868	825	755	755
query63	227	195	197	195
query64	3529	1036	670	670
query65	3345	3295	3266	3266
query66	783	410	329	329
query67	16511	15770	15496	15496
query68	9061	772	526	526
query69	467	294	259	259
query70	1216	1129	1156	1129
query71	436	286	272	272
query72	6176	3810	3809	3809
query73	673	762	361	361
query74	9680	9032	9102	9032
query75	4582	3158	2664	2664
query76	3780	1223	803	803
query77	789	370	282	282
query78	10132	10095	9340	9340
query79	3537	911	594	594
query80	751	527	435	435
query81	486	270	231	231
query82	641	152	126	126
query83	192	160	142	142
query84	281	97	204	97
query85	800	359	313	313
query86	355	332	295	295
query87	4605	4663	4396	4396
query88	3516	2296	2241	2241
query89	444	329	299	299
query90	1938	190	193	190
query91	136	137	106	106
query92	68	57	55	55
query93	1872	900	542	542
query94	657	392	289	289
query95	335	265	259	259
query96	491	607	280	280
query97	2730	2817	2657	2657
query98	243	209	210	209
query99	1675	1580	1461	1461
Total cold run time: 300311 ms
Total hot run time: 196940 ms

@doris-robot
Copy link

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

query1	0.04	0.03	0.06
query2	0.07	0.04	0.04
query3	0.24	0.06	0.07
query4	1.63	0.11	0.10
query5	0.41	0.43	0.39
query6	1.15	0.64	0.65
query7	0.02	0.01	0.01
query8	0.04	0.04	0.03
query9	0.62	0.50	0.52
query10	0.55	0.56	0.55
query11	0.14	0.11	0.10
query12	0.13	0.11	0.11
query13	0.61	0.60	0.61
query14	2.71	2.80	2.82
query15	0.90	0.83	0.82
query16	0.40	0.39	0.39
query17	1.04	1.05	1.07
query18	0.22	0.20	0.21
query19	1.96	1.87	2.02
query20	0.01	0.02	0.01
query21	15.35	0.89	0.56
query22	0.75	0.74	0.73
query23	15.29	1.37	0.57
query24	2.86	2.17	2.37
query25	0.15	0.23	0.06
query26	0.17	0.14	0.14
query27	0.06	0.05	0.05
query28	14.93	1.41	1.05
query29	12.62	3.95	3.24
query30	0.24	0.09	0.06
query31	2.82	0.58	0.38
query32	3.22	0.54	0.47
query33	3.06	3.00	3.14
query34	16.64	5.10	4.46
query35	4.50	4.43	4.48
query36	0.62	0.50	0.47
query37	0.10	0.07	0.05
query38	0.05	0.03	0.03
query39	0.04	0.02	0.03
query40	0.17	0.14	0.12
query41	0.08	0.03	0.02
query42	0.03	0.02	0.03
query43	0.03	0.03	0.03
Total cold run time: 106.67 s
Total hot run time: 32.43 s

HappenLee
HappenLee approved these changes Jan 2, 2025
View reviewed changes
Copy link
Contributor

@HappenLee HappenLee left a comment

Choose a reason for hiding this comment

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

LGTM

@github-actions github-actions bot added the approved Indicates a PR has been approved by one committer. label Jan 2, 2025
@github-actions GitHub Actions
Copy link
Contributor

github-actions bot commented Jan 2, 2025

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

@HappenLee HappenLee merged commit 52d8f6f into apache:master Jan 2, 2025
23 checks passed
github-actions bot pushed a commit that referenced this pull request Jan 2, 2025
@zhangstar333
[Bug](auto-partition) fix auto partition could set storage_medium pro…
da2ee1d 
…perties (#45955)

as the auto partition table maybe no any partitions firstly, it's should
same as table's storage medium rather than default storage medium, maybe
user have change different from default value.
@github-actions github-actions bot mentioned this pull request Jan 2, 2025
Open
github-actions bot pushed a commit that referenced this pull request Jan 2, 2025
@zhangstar333
[Bug](auto-partition) fix auto partition could set storage_medium pro…
7fbce78 
…perties (#45955)

as the auto partition table maybe no any partitions firstly, it's should
same as table's storage medium rather than default storage medium, maybe
user have change different from default value.
@github-actions github-actions bot mentioned this pull request Jan 2, 2025
Merged
yiguolei pushed a commit that referenced this pull request Jan 2, 2025
@github-actions @zhangstar333
branch-2.1: [Bug](auto-partition) fix auto partition could set storag…
f6d98a6 
…e_medium properties #45955 (#46260)

Cherry-picked from #45955

Co-authored-by: zhangstar333 <[email protected]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers

@zclllyybb zclllyybb zclllyybb approved these changes

@HappenLee HappenLee HappenLee approved these changes

Assignees
No one assigned
Labels
approved Indicates a PR has been approved by one committer. dev/2.1.8-merged dev/3.0.x kind/behavior-changed reviewed
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.
7 participants
@zhangstar333 @Thearas @doris-robot @HappenLee @zclllyybb @yiguolei @morrySnow