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 showTableCreationCommand in nereids #42776 #44703

Merged
merged 2 commits into from
Dec 9, 2024
Merged

[Enhancement] (nereids)implement showTableCreationCommand in nereids #42776 #44703

merged 2 commits into from
Dec 9, 2024

Conversation

rijeshkp
Copy link
Contributor

What problem does this PR solve?

Issue Number: close #42776

Related PR: #xxx

Problem Summary:
Support for Show table creation command 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?

@rijeshkp rijeshkp changed the title Show table creation command [Enhancement] (nereids)implement showTableCreationCommand in nereids #42776 Nov 29, 2024
@rijeshkp rijeshkp marked this pull request as ready for review November 29, 2024 10:50
@rijeshkp
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17586	8050	7255	7255
q2	2038	181	172	172
q3	10576	1084	1141	1084
q4	10592	733	784	733
q5	7602	2752	2694	2694
q6	236	145	142	142
q7	989	620	612	612
q8	9249	1796	1912	1796
q9	6633	6461	6456	6456
q10	6951	2251	2299	2251
q11	456	255	255	255
q12	427	225	225	225
q13	17777	2982	3077	2982
q14	241	208	212	208
q15	585	550	534	534
q16	644	600	577	577
q17	981	556	497	497
q18	7182	6621	6603	6603
q19	1337	1056	992	992
q20	490	185	179	179
q21	4037	3193	3056	3056
q22	392	316	324	316
Total cold run time: 107001 ms
Total hot run time: 39619 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7227	7243	7250	7243
q2	325	233	228	228
q3	2899	2787	2931	2787
q4	2069	1786	1809	1786
q5	5715	5682	5619	5619
q6	225	142	147	142
q7	2232	1876	1817	1817
q8	3398	3561	3504	3504
q9	8948	9017	9061	9017
q10	3572	3559	3569	3559
q11	592	511	495	495
q12	817	659	619	619
q13	12301	3258	3265	3258
q14	311	268	271	268
q15	579	529	522	522
q16	691	649	652	649
q17	1833	1619	1630	1619
q18	8276	7707	7576	7576
q19	1683	1541	1593	1541
q20	2107	1884	1881	1881
q21	5719	5490	5474	5474
q22	629	589	595	589
Total cold run time: 72148 ms
Total hot run time: 60193 ms

@doris-robot
Copy link

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

query1	1243	940	961	940
query2	6221	2170	2098	2098
query3	10946	4587	4511	4511
query4	66669	29024	23533	23533
query5	4925	477	467	467
query6	405	175	172	172
query7	5550	309	297	297
query8	315	234	236	234
query9	8788	2680	2679	2679
query10	434	251	246	246
query11	17294	15188	15943	15188
query12	154	101	105	101
query13	1474	423	416	416
query14	9822	7345	7565	7345
query15	219	192	206	192
query16	6901	457	479	457
query17	1164	574	591	574
query18	1699	322	311	311
query19	200	158	170	158
query20	122	112	116	112
query21	209	114	105	105
query22	4729	4609	4523	4523
query23	34823	34406	34384	34384
query24	5406	2422	2477	2422
query25	483	391	391	391
query26	657	150	153	150
query27	1827	280	288	280
query28	4068	2464	2490	2464
query29	708	425	404	404
query30	207	151	165	151
query31	1043	835	827	827
query32	65	56	54	54
query33	433	282	291	282
query34	927	519	514	514
query35	919	753	760	753
query36	1122	958	960	958
query37	124	76	78	76
query38	4447	4439	4394	4394
query39	1509	1481	1503	1481
query40	206	102	105	102
query41	50	46	47	46
query42	108	98	100	98
query43	552	519	507	507
query44	1209	854	852	852
query45	182	172	169	169
query46	1160	762	714	714
query47	2058	1964	1915	1915
query48	427	322	343	322
query49	735	385	384	384
query50	841	404	387	387
query51	7405	7268	7212	7212
query52	107	86	88	86
query53	252	173	177	173
query54	506	389	390	389
query55	78	78	81	78
query56	259	228	231	228
query57	1263	1131	1114	1114
query58	214	213	204	204
query59	3341	3274	3121	3121
query60	274	234	226	226
query61	112	140	119	119
query62	783	660	687	660
query63	213	182	190	182
query64	1383	655	635	635
query65	3244	3208	3227	3208
query66	694	297	298	297
query67	15989	15778	15714	15714
query68	4013	554	578	554
query69	429	245	244	244
query70	1209	1143	1137	1137
query71	362	244	247	244
query72	6344	4084	3997	3997
query73	757	357	359	357
query74	10188	8926	8974	8926
query75	3401	2673	2685	2673
query76	1832	1027	1051	1027
query77	470	276	267	267
query78	10514	9393	9405	9393
query79	1778	589	585	585
query80	1299	425	462	425
query81	499	240	237	237
query82	1299	119	128	119
query83	253	137	143	137
query84	274	72	66	66
query85	952	296	316	296
query86	404	306	309	306
query87	4723	4657	4682	4657
query88	3544	2205	2164	2164
query89	422	291	291	291
query90	1944	181	183	181
query91	136	167	110	110
query92	67	49	48	48
query93	1994	537	532	532
query94	836	288	286	286
query95	348	258	239	239
query96	617	281	280	280
query97	2857	2660	2661	2660
query98	220	204	203	203
query99	1668	1319	1311	1311
Total cold run time: 317549 ms
Total hot run time: 197738 ms

@doris-robot
Copy link

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

query1	0.04	0.03	0.04
query2	0.07	0.04	0.03
query3	0.23	0.07	0.07
query4	1.64	0.10	0.11
query5	0.42	0.40	0.40
query6	1.18	0.66	0.66
query7	0.02	0.02	0.02
query8	0.04	0.03	0.03
query9	0.57	0.53	0.50
query10	0.55	0.57	0.56
query11	0.14	0.11	0.11
query12	0.14	0.11	0.11
query13	0.61	0.60	0.60
query14	2.73	2.70	2.82
query15	0.92	0.82	0.81
query16	0.40	0.38	0.40
query17	1.06	1.05	1.04
query18	0.23	0.21	0.21
query19	2.01	1.89	2.02
query20	0.02	0.01	0.01
query21	15.36	0.60	0.58
query22	2.60	2.78	2.07
query23	16.92	0.91	0.78
query24	3.10	0.83	0.99
query25	0.29	0.05	0.04
query26	0.52	0.14	0.13
query27	0.04	0.03	0.04
query28	10.89	1.09	1.08
query29	12.58	3.36	3.37
query30	0.25	0.06	0.06
query31	2.87	0.39	0.38
query32	3.28	0.46	0.46
query33	3.06	3.10	3.06
query34	17.35	4.45	4.46
query35	4.52	4.54	4.45
query36	0.65	0.49	0.48
query37	0.09	0.06	0.06
query38	0.05	0.04	0.03
query39	0.03	0.02	0.02
query40	0.16	0.13	0.12
query41	0.08	0.03	0.03
query42	0.03	0.02	0.02
query43	0.03	0.03	0.03
Total cold run time: 107.77 s
Total hot run time: 32.81 s

@rijeshkp rijeshkp force-pushed the ShowTableCreationCommand branch 2 times, most recently from fe77b05 to cb85f13 Compare December 4, 2024 13:19
@rijeshkp
Copy link
Contributor Author

rijeshkp commented Dec 4, 2024

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17612	7513	7300	7300
q2	2039	177	167	167
q3	10595	1112	1216	1112
q4	10560	729	709	709
q5	7613	2713	2714	2713
q6	247	149	146	146
q7	995	644	619	619
q8	9258	1838	1938	1838
q9	6757	6476	6486	6476
q10	7011	2290	2311	2290
q11	472	261	258	258
q12	436	232	231	231
q13	17772	3070	3087	3070
q14	255	213	211	211
q15	570	528	518	518
q16	637	574	573	573
q17	986	573	581	573
q18	7229	6554	6678	6554
q19	1350	1004	952	952
q20	477	181	184	181
q21	4273	3222	3310	3222
q22	381	316	303	303
Total cold run time: 107525 ms
Total hot run time: 40016 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7278	7256	7268	7256
q2	343	228	232	228
q3	2922	2816	2937	2816
q4	2120	1855	1880	1855
q5	5666	5681	5627	5627
q6	233	152	148	148
q7	2259	1838	1765	1765
q8	3422	3567	3511	3511
q9	8978	8961	8986	8961
q10	3610	3593	3558	3558
q11	593	521	507	507
q12	832	637	638	637
q13	12581	3365	3407	3365
q14	314	293	276	276
q15	578	548	544	544
q16	678	694	630	630
q17	1912	1659	1650	1650
q18	8380	7751	7614	7614
q19	1926	1579	1587	1579
q20	2092	1889	1863	1863
q21	5638	5478	5427	5427
q22	622	569	562	562
Total cold run time: 72977 ms
Total hot run time: 60379 ms

@doris-robot
Copy link

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

query1	1559	964	963	963
query2	6238	2181	2092	2092
query3	10965	4671	4334	4334
query4	33269	23495	23499	23495
query5	3635	491	468	468
query6	297	186	192	186
query7	3977	311	326	311
query8	299	241	235	235
query9	9359	2721	2723	2721
query10	493	249	280	249
query11	17974	15181	15262	15181
query12	149	106	100	100
query13	1562	406	415	406
query14	9543	8126	7308	7308
query15	291	218	192	192
query16	8124	469	475	469
query17	1872	592	586	586
query18	2153	301	304	301
query19	360	154	158	154
query20	120	113	111	111
query21	218	102	101	101
query22	4974	4531	4537	4531
query23	35369	34380	34351	34351
query24	10391	2443	2571	2443
query25	606	412	389	389
query26	1305	147	149	147
query27	2455	280	287	280
query28	7267	2509	2464	2464
query29	836	402	413	402
query30	240	151	153	151
query31	1063	838	867	838
query32	101	57	52	52
query33	779	291	297	291
query34	1121	517	510	510
query35	875	739	794	739
query36	1137	988	963	963
query37	148	105	73	73
query38	4706	4421	4487	4421
query39	1523	1462	1493	1462
query40	207	99	108	99
query41	51	42	43	42
query42	113	103	98	98
query43	522	511	487	487
query44	1290	814	825	814
query45	193	167	175	167
query46	1186	712	706	706
query47	2050	1932	1939	1932
query48	434	330	328	328
query49	979	384	415	384
query50	858	401	414	401
query51	7485	7257	7280	7257
query52	102	89	89	89
query53	263	189	186	186
query54	1170	440	423	423
query55	89	76	76	76
query56	260	253	238	238
query57	1293	1145	1121	1121
query58	220	228	211	211
query59	3307	3070	3038	3038
query60	275	242	249	242
query61	109	102	108	102
query62	869	674	664	664
query63	209	190	184	184
query64	3887	666	646	646
query65	3324	3273	3222	3222
query66	845	298	343	298
query67	15975	15506	15485	15485
query68	4321	565	577	565
query69	420	245	263	245
query70	1180	1077	1164	1077
query71	329	255	243	243
query72	6339	4035	4009	4009
query73	752	354	353	353
query74	10231	9201	8949	8949
query75	3421	2679	2696	2679
query76	2574	1157	1110	1110
query77	377	287	268	268
query78	10407	9515	9422	9422
query79	1092	598	592	592
query80	823	461	471	461
query81	510	251	225	225
query82	1322	122	119	119
query83	251	144	148	144
query84	231	65	70	65
query85	1093	289	298	289
query86	319	313	307	307
query87	4770	4621	4514	4514
query88	3459	2211	2205	2205
query89	417	294	296	294
query90	2096	188	195	188
query91	134	99	104	99
query92	56	47	50	47
query93	1093	532	529	529
query94	786	297	294	294
query95	355	249	244	244
query96	621	278	286	278
query97	2839	2644	2668	2644
query98	221	198	198	198
query99	1621	1312	1313	1312
Total cold run time: 299378 ms
Total hot run time: 197378 ms

@doris-robot
Copy link

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

query1	0.04	0.03	0.03
query2	0.07	0.03	0.04
query3	0.24	0.07	0.07
query4	1.62	0.10	0.11
query5	0.41	0.41	0.41
query6	1.14	0.66	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.56	0.54	0.58
query11	0.14	0.11	0.11
query12	0.13	0.11	0.10
query13	0.61	0.60	0.60
query14	2.75	2.73	2.87
query15	0.91	0.83	0.84
query16	0.39	0.38	0.39
query17	1.02	0.99	1.03
query18	0.22	0.22	0.22
query19	1.97	1.82	2.03
query20	0.01	0.01	0.02
query21	15.37	0.59	0.58
query22	2.67	2.75	2.09
query23	16.89	1.04	0.86
query24	3.59	0.64	1.61
query25	0.27	0.07	0.19
query26	0.38	0.14	0.14
query27	0.04	0.05	0.04
query28	10.28	1.10	1.07
query29	12.58	3.22	3.21
query30	0.25	0.06	0.06
query31	2.85	0.39	0.38
query32	3.27	0.47	0.46
query33	3.02	3.16	3.01
query34	16.98	4.43	4.57
query35	4.47	4.49	4.52
query36	0.67	0.49	0.49
query37	0.09	0.06	0.06
query38	0.04	0.03	0.04
query39	0.03	0.03	0.02
query40	0.16	0.12	0.11
query41	0.08	0.03	0.02
query42	0.04	0.02	0.02
query43	0.04	0.03	0.03
Total cold run time: 106.93 s
Total hot run time: 32.48 s

@rijeshkp rijeshkp force-pushed the ShowTableCreationCommand branch 2 times, most recently from 1d8471a to e5862fd Compare December 5, 2024 12:54
@rijeshkp
Copy link
Contributor Author

rijeshkp commented Dec 5, 2024

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17583	7496	7279	7279
q2	2043	177	171	171
q3	10640	1079	1139	1079
q4	10576	766	738	738
q5	7600	2731	2691	2691
q6	236	149	147	147
q7	991	637	593	593
q8	9345	1876	1958	1876
q9	6647	6512	6520	6512
q10	7002	2356	2343	2343
q11	457	274	259	259
q12	434	228	226	226
q13	17760	3016	2979	2979
q14	252	224	242	224
q15	583	519	527	519
q16	659	603	595	595
q17	965	507	506	506
q18	7127	6638	6697	6638
q19	1350	1023	1002	1002
q20	473	178	177	177
q21	4073	3317	3110	3110
q22	382	319	317	317
Total cold run time: 107178 ms
Total hot run time: 39981 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7183	7240	7209	7209
q2	336	235	236	235
q3	2916	2775	2961	2775
q4	2073	1842	1828	1828
q5	5665	5633	5691	5633
q6	227	138	139	138
q7	2233	1807	1838	1807
q8	3377	3577	3476	3476
q9	8912	9062	9060	9060
q10	3636	3573	3544	3544
q11	604	492	514	492
q12	823	603	609	603
q13	10830	3243	3280	3243
q14	307	270	287	270
q15	576	547	533	533
q16	687	637	629	629
q17	1848	1642	1591	1591
q18	8282	7812	7627	7627
q19	1693	1580	1596	1580
q20	2136	1861	1913	1861
q21	5777	5560	5521	5521
q22	663	586	602	586
Total cold run time: 70784 ms
Total hot run time: 60241 ms

@doris-robot
Copy link

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

query1	1473	973	900	900
query2	6249	2060	1978	1978
query3	11054	4724	4458	4458
query4	66797	28879	23680	23680
query5	4950	459	460	459
query6	431	185	191	185
query7	5505	312	298	298
query8	326	241	244	241
query9	8614	2727	2724	2724
query10	439	243	247	243
query11	17156	15439	15912	15439
query12	161	108	109	108
query13	1501	425	422	422
query14	14446	7240	6835	6835
query15	220	186	193	186
query16	7188	466	431	431
query17	1004	583	591	583
query18	1098	318	296	296
query19	191	154	150	150
query20	114	110	112	110
query21	213	100	98	98
query22	4565	4413	4477	4413
query23	34918	35093	34510	34510
query24	5498	2495	2463	2463
query25	506	395	380	380
query26	673	148	151	148
query27	1867	285	291	285
query28	4703	2483	2484	2483
query29	667	428	412	412
query30	209	152	152	152
query31	1010	831	865	831
query32	72	57	56	56
query33	408	291	300	291
query34	939	532	557	532
query35	901	780	761	761
query36	1094	959	937	937
query37	149	79	73	73
query38	4553	4429	4495	4429
query39	1530	1477	1504	1477
query40	204	101	95	95
query41	44	43	40	40
query42	110	102	106	102
query43	541	493	487	487
query44	1181	860	814	814
query45	191	168	172	168
query46	1163	740	756	740
query47	2045	1911	1968	1911
query48	421	331	336	331
query49	734	381	393	381
query50	865	397	406	397
query51	7282	7160	7088	7088
query52	95	86	85	85
query53	249	181	183	181
query54	517	386	401	386
query55	75	76	72	72
query56	243	234	228	228
query57	1231	1159	1127	1127
query58	212	210	206	206
query59	3099	2883	2905	2883
query60	259	234	233	233
query61	109	101	106	101
query62	789	705	698	698
query63	213	184	187	184
query64	1700	654	619	619
query65	3346	3226	3192	3192
query66	672	303	302	302
query67	16047	15484	15757	15484
query68	3686	591	582	582
query69	441	253	249	249
query70	1171	1146	1113	1113
query71	350	246	255	246
query72	6119	4047	4007	4007
query73	767	364	361	361
query74	10253	9019	9112	9019
query75	3397	2691	2689	2689
query76	2092	1171	1010	1010
query77	471	270	263	263
query78	10574	9385	9382	9382
query79	2032	620	609	609
query80	1369	420	507	420
query81	512	230	226	226
query82	1270	117	119	117
query83	191	140	146	140
query84	277	75	71	71
query85	1000	304	304	304
query86	409	314	302	302
query87	4759	4591	4544	4544
query88	3760	2250	2193	2193
query89	423	312	287	287
query90	1979	190	190	190
query91	135	104	103	103
query92	68	53	51	51
query93	2812	551	552	551
query94	805	304	308	304
query95	353	253	251	251
query96	628	276	280	276
query97	2876	2707	2753	2707
query98	215	194	201	194
query99	1616	1313	1307	1307
Total cold run time: 323839 ms
Total hot run time: 197060 ms

@doris-robot
Copy link

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

query1	0.03	0.03	0.03
query2	0.07	0.03	0.04
query3	0.23	0.08	0.07
query4	1.61	0.10	0.10
query5	0.42	0.41	0.41
query6	1.14	0.67	0.65
query7	0.02	0.01	0.02
query8	0.04	0.03	0.03
query9	0.58	0.52	0.50
query10	0.55	0.55	0.56
query11	0.15	0.11	0.11
query12	0.14	0.12	0.11
query13	0.61	0.60	0.59
query14	2.72	2.83	2.88
query15	0.90	0.82	0.82
query16	0.37	0.36	0.38
query17	1.04	1.06	1.05
query18	0.24	0.22	0.20
query19	1.91	1.76	2.01
query20	0.02	0.00	0.02
query21	15.35	0.61	0.59
query22	2.47	2.02	2.74
query23	16.84	1.08	0.75
query24	3.44	1.79	0.90
query25	0.31	0.16	0.06
query26	0.59	0.14	0.14
query27	0.04	0.05	0.04
query28	9.91	1.10	1.07
query29	12.53	3.20	3.23
query30	0.25	0.07	0.07
query31	2.88	0.39	0.38
query32	3.26	0.47	0.46
query33	2.94	3.02	3.00
query34	17.02	4.51	4.51
query35	4.58	4.57	4.53
query36	0.66	0.48	0.49
query37	0.08	0.06	0.06
query38	0.05	0.04	0.04
query39	0.03	0.02	0.02
query40	0.17	0.13	0.14
query41	0.08	0.03	0.02
query42	0.03	0.02	0.02
query43	0.03	0.03	0.03
Total cold run time: 106.33 s
Total hot run time: 32.73 s

@rijeshkp
Copy link
Contributor Author

rijeshkp commented Dec 6, 2024

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17950	7650	7306	7306
q2	2074	181	166	166
q3	10673	1094	1268	1094
q4	10397	773	746	746
q5	7597	2733	2647	2647
q6	236	146	148	146
q7	994	637	615	615
q8	9267	1867	1884	1867
q9	6682	6493	6478	6478
q10	7019	2288	2293	2288
q11	474	253	262	253
q12	439	228	229	228
q13	17784	3081	3046	3046
q14	242	222	212	212
q15	576	533	526	526
q16	669	599	589	589
q17	984	547	510	510
q18	7400	6761	6622	6622
q19	1371	1047	917	917
q20	485	186	185	185
q21	4082	3266	3215	3215
q22	389	330	317	317
Total cold run time: 107784 ms
Total hot run time: 39973 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7311	7263	7326	7263
q2	334	230	233	230
q3	2960	2943	2958	2943
q4	2057	1809	1881	1809
q5	5681	5655	5691	5655
q6	232	140	142	140
q7	2249	1798	1773	1773
q8	3439	3571	3489	3489
q9	9005	8995	9066	8995
q10	3648	3559	3599	3559
q11	590	502	513	502
q12	821	630	611	611
q13	10653	3230	3243	3230
q14	310	278	275	275
q15	572	516	536	516
q16	683	645	648	645
q17	1889	1670	1653	1653
q18	8473	7817	7545	7545
q19	1697	1439	1561	1439
q20	2100	1870	1876	1870
q21	5648	5624	5490	5490
q22	667	600	611	600
Total cold run time: 71019 ms
Total hot run time: 60232 ms

starocean999
starocean999 previously approved these changes Dec 6, 2024
View reviewed changes
@github-actions github-actions bot added the approved Indicates a PR has been approved by one committer. label Dec 6, 2024
@github-actions GitHub Actions
Copy link
Contributor

github-actions bot commented Dec 6, 2024

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

@github-actions GitHub Actions
Copy link
Contributor

github-actions bot commented Dec 6, 2024

PR approved by anyone and no changes requested.

@doris-robot
Copy link

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

query1	1543	976	933	933
query2	6240	2084	2021	2021
query3	11107	4578	4568	4568
query4	33532	23552	23723	23552
query5	3551	499	472	472
query6	257	190	161	161
query7	3974	315	299	299
query8	282	224	221	221
query9	9408	2742	2761	2742
query10	455	265	258	258
query11	18012	15381	15476	15381
query12	139	104	111	104
query13	1561	416	412	412
query14	9104	7878	7520	7520
query15	278	216	196	196
query16	8031	493	517	493
query17	1689	604	610	604
query18	2070	326	307	307
query19	371	165	166	165
query20	117	114	110	110
query21	209	108	113	108
query22	4813	4512	4505	4505
query23	35678	34670	34822	34670
query24	10437	2610	2602	2602
query25	607	402	404	402
query26	1300	168	156	156
query27	2333	293	281	281
query28	7647	2535	2497	2497
query29	829	413	414	413
query30	228	147	156	147
query31	1065	836	857	836
query32	98	54	51	51
query33	762	303	286	286
query34	1200	518	548	518
query35	939	778	762	762
query36	1138	954	994	954
query37	137	75	70	70
query38	4590	4397	4387	4387
query39	1537	1469	1464	1464
query40	217	112	100	100
query41	47	42	44	42
query42	111	97	99	97
query43	539	499	516	499
query44	1339	849	822	822
query45	197	165	178	165
query46	1203	736	733	733
query47	2041	1904	1946	1904
query48	434	326	324	324
query49	1005	398	415	398
query50	841	418	396	396
query51	7318	7267	7134	7134
query52	111	100	95	95
query53	269	192	194	192
query54	1277	417	434	417
query55	88	86	79	79
query56	268	234	243	234
query57	1259	1096	1127	1096
query58	233	219	210	210
query59	3134	3054	3198	3054
query60	272	258	251	251
query61	116	101	106	101
query62	890	671	690	671
query63	217	198	188	188
query64	3949	666	616	616
query65	3294	3202	3243	3202
query66	873	302	296	296
query67	15898	15784	15662	15662
query68	4857	546	550	546
query69	445	251	278	251
query70	1246	1161	1134	1134
query71	341	259	245	245
query72	6373	4048	4050	4048
query73	772	370	367	367
query74	10569	9047	9118	9047
query75	3436	2777	2631	2631
query76	2761	1064	1098	1064
query77	373	278	267	267
query78	10345	9539	9453	9453
query79	2440	618	613	613
query80	1204	429	434	429
query81	557	236	233	233
query82	724	119	123	119
query83	246	151	140	140
query84	230	72	71	71
query85	1466	294	296	294
query86	460	298	309	298
query87	4705	4507	4596	4507
query88	4018	2232	2206	2206
query89	441	301	288	288
query90	2054	192	189	189
query91	137	105	102	102
query92	72	49	50	49
query93	2448	551	547	547
query94	961	300	297	297
query95	364	258	256	256
query96	638	287	281	281
query97	2881	2677	2711	2677
query98	226	191	228	191
query99	1567	1301	1325	1301
Total cold run time: 304065 ms
Total hot run time: 198747 ms

@LiBinfeng-01 LiBinfeng-01 self-requested a review December 6, 2024 13:12
@rijeshkp
Copy link
Contributor Author

rijeshkp commented Dec 7, 2024

run buildall

@rijeshkp rijeshkp force-pushed the ShowTableCreationCommand branch from a17a1c2 to d2dc2cc Compare December 7, 2024 07:40
@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17603	7421	7449	7421
q2	2045	170	169	169
q3	10875	1075	1236	1075
q4	10569	695	783	695
q5	7591	2668	2714	2668
q6	233	143	145	143
q7	1012	620	604	604
q8	9235	1824	1880	1824
q9	6714	6477	6447	6447
q10	6996	2295	2311	2295
q11	455	258	278	258
q12	433	218	219	218
q13	17775	3020	2980	2980
q14	243	219	219	219
q15	585	521	518	518
q16	651	572	562	562
q17	964	589	560	560
q18	7296	6760	6609	6609
q19	1331	958	1022	958
q20	452	181	177	177
q21	4019	3294	3220	3220
q22	386	317	314	314
Total cold run time: 107463 ms
Total hot run time: 39934 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7297	7213	7205	7205
q2	331	229	235	229
q3	2868	2811	2924	2811
q4	2113	1861	1909	1861
q5	5685	5678	5679	5678
q6	225	142	141	141
q7	2236	1830	1846	1830
q8	3353	3523	3466	3466
q9	8883	9049	8902	8902
q10	3597	3548	3579	3548
q11	597	506	525	506
q12	818	617	614	614
q13	10851	3203	3158	3158
q14	314	267	266	266
q15	566	532	521	521
q16	676	661	670	661
q17	1844	1621	1589	1589
q18	8378	7754	7649	7649
q19	1677	1414	1566	1414
q20	2092	1905	1867	1867
q21	5671	5408	5452	5408
q22	643	609	574	574
Total cold run time: 70715 ms
Total hot run time: 59898 ms

@rijeshkp
Copy link
Contributor Author

rijeshkp commented Dec 7, 2024

run buildall

@doris-robot
Copy link

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

query1	1288	978	936	936
query2	6237	2126	2037	2037
query3	10967	4416	4493	4416
query4	66739	28611	23667	23667
query5	4971	488	455	455
query6	451	202	179	179
query7	5610	313	306	306
query8	341	262	254	254
query9	8649	2648	2612	2612
query10	431	250	241	241
query11	16892	15428	15980	15428
query12	163	104	107	104
query13	1430	433	422	422
query14	10978	7847	7845	7845
query15	228	198	201	198
query16	7082	456	490	456
query17	1063	563	559	559
query18	1836	309	299	299
query19	207	164	155	155
query20	118	109	108	108
query21	206	104	102	102
query22	4762	4399	4611	4399
query23	35130	34723	34355	34355
query24	5512	2547	2632	2547
query25	516	398	393	393
query26	641	156	157	156
query27	1722	285	291	285
query28	4443	2493	2441	2441
query29	714	424	415	415
query30	206	158	152	152
query31	997	851	863	851
query32	62	56	54	54
query33	468	336	323	323
query34	1006	508	536	508
query35	909	785	793	785
query36	1144	965	997	965
query37	137	78	79	78
query38	4547	4444	4389	4389
query39	1527	1496	1635	1496
query40	222	108	109	108
query41	48	45	45	45
query42	115	104	104	104
query43	547	504	501	501
query44	1221	843	836	836
query45	197	174	211	174
query46	1270	764	744	744
query47	2043	1928	1936	1928
query48	419	321	324	321
query49	747	392	419	392
query50	926	400	408	400
query51	7326	7273	7006	7006
query52	99	90	88	88
query53	269	176	183	176
query54	523	403	386	386
query55	82	74	75	74
query56	260	270	242	242
query57	1305	1115	1108	1108
query58	230	212	225	212
query59	3295	3180	2965	2965
query60	269	251	251	251
query61	107	106	107	106
query62	805	658	645	645
query63	214	188	194	188
query64	1314	671	645	645
query65	3356	3215	3223	3215
query66	703	301	337	301
query67	16119	15669	15621	15621
query68	3834	592	569	569
query69	442	258	255	255
query70	1253	1127	1107	1107
query71	417	253	259	253
query72	6451	4290	4280	4280
query73	812	359	360	359
query74	10295	8987	9111	8987
query75	3507	2691	2654	2654
query76	1842	1136	1184	1136
query77	479	282	277	277
query78	10543	9535	9410	9410
query79	1350	605	595	595
query80	848	453	452	452
query81	483	247	240	240
query82	1300	130	122	122
query83	259	140	139	139
query84	281	70	72	70
query85	897	310	381	310
query86	338	309	298	298
query87	4806	4551	4738	4551
query88	3523	2173	2133	2133
query89	425	298	299	298
query90	2036	188	189	188
query91	141	106	103	103
query92	65	52	50	50
query93	1737	560	555	555
query94	788	307	251	251
query95	340	253	253	253
query96	685	287	280	280
query97	2931	2715	2698	2698
query98	226	192	192	192
query99	1622	1336	1295	1295
Total cold run time: 319317 ms
Total hot run time: 198513 ms

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17741	7528	7285	7285
q2	2047	189	178	178
q3	10619	1151	1150	1150
q4	10272	780	714	714
q5	7662	2737	2716	2716
q6	239	144	144	144
q7	1011	621	608	608
q8	9248	1844	1870	1844
q9	6812	6499	6541	6499
q10	7030	2340	2320	2320
q11	475	266	270	266
q12	504	219	226	219
q13	17772	3008	3014	3008
q14	248	220	218	218
q15	589	529	522	522
q16	674	606	575	575
q17	988	563	515	515
q18	7506	6899	6764	6764
q19	1328	983	1075	983
q20	462	182	185	182
q21	4063	3206	3212	3206
q22	388	319	321	319
Total cold run time: 107678 ms
Total hot run time: 40235 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7253	7223	7220	7220
q2	329	234	231	231
q3	2897	2795	2756	2756
q4	1993	1742	1753	1742
q5	5375	5414	5449	5414
q6	223	137	138	137
q7	2163	1733	1697	1697
q8	3272	3412	3435	3412
q9	8782	8692	8674	8674
q10	3509	3467	3464	3464
q11	576	495	497	495
q12	809	591	595	591
q13	12870	2967	3004	2967
q14	280	267	266	266
q15	575	508	510	508
q16	658	626	636	626
q17	1791	1594	1562	1562
q18	7963	7597	7353	7353
q19	1660	1597	1500	1500
q20	2032	1858	1838	1838
q21	5491	5269	5291	5269
q22	661	593	568	568
Total cold run time: 71162 ms
Total hot run time: 58290 ms

@doris-robot
Copy link

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

query1	973	384	381	381
query2	4846	2160	2028	2028
query3	6574	225	212	212
query4	33196	23620	23543	23543
query5	4075	470	442	442
query6	271	187	215	187
query7	4591	307	316	307
query8	297	241	254	241
query9	9347	2630	2600	2600
query10	484	262	245	245
query11	18059	15294	15264	15264
query12	152	104	109	104
query13	1658	406	417	406
query14	9288	7093	7442	7093
query15	309	182	186	182
query16	6256	447	480	447
query17	1803	590	567	567
query18	1122	310	295	295
query19	394	152	144	144
query20	118	120	110	110
query21	189	102	101	101
query22	4741	4480	4292	4292
query23	35002	34290	34345	34290
query24	10209	2414	2501	2414
query25	566	375	379	375
query26	1030	154	166	154
query27	2375	281	292	281
query28	7553	2402	2412	2402
query29	650	390	394	390
query30	295	145	147	145
query31	1025	792	824	792
query32	67	59	57	57
query33	769	298	282	282
query34	931	493	515	493
query35	865	766	721	721
query36	1103	945	945	945
query37	119	83	76	76
query38	4325	4322	4286	4286
query39	1462	1437	1409	1409
query40	205	96	101	96
query41	46	43	45	43
query42	108	95	97	95
query43	537	493	517	493
query44	1254	792	785	785
query45	184	165	165	165
query46	1160	713	696	696
query47	1965	1845	1840	1840
query48	409	304	303	303
query49	1105	383	374	374
query50	807	386	372	372
query51	7358	7166	7146	7146
query52	100	89	96	89
query53	256	181	177	177
query54	1208	403	400	400
query55	77	81	78	78
query56	268	249	237	237
query57	1241	1128	1115	1115
query58	226	211	241	211
query59	3236	3137	3055	3055
query60	272	260	236	236
query61	106	103	101	101
query62	915	678	664	664
query63	209	183	178	178
query64	3283	664	642	642
query65	3270	3214	3246	3214
query66	981	307	305	305
query67	15960	15783	15551	15551
query68	4955	555	544	544
query69	425	248	254	248
query70	1224	1131	1121	1121
query71	357	250	269	250
query72	6093	4163	4126	4126
query73	773	360	358	358
query74	10510	9020	9024	9020
query75	3444	2651	2650	2650
query76	2668	1079	1060	1060
query77	524	275	268	268
query78	10404	9538	9477	9477
query79	1573	586	604	586
query80	1039	418	413	413
query81	551	241	226	226
query82	960	117	115	115
query83	244	142	142	142
query84	235	69	66	66
query85	1353	298	325	298
query86	394	284	277	277
query87	4713	4547	4571	4547
query88	3343	2149	2081	2081
query89	401	294	293	293
query90	2007	183	183	183
query91	142	104	104	104
query92	63	48	51	48
query93	1174	541	558	541
query94	1025	261	292	261
query95	347	249	245	245
query96	634	282	280	280
query97	2809	2697	2672	2672
query98	223	194	193	193
query99	1466	1322	1305	1305
Total cold run time: 289908 ms
Total hot run time: 191362 ms

@doris-robot
Copy link

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

query1	0.03	0.03	0.03
query2	0.06	0.04	0.04
query3	0.22	0.08	0.07
query4	1.61	0.10	0.11
query5	0.43	0.43	0.41
query6	1.14	0.67	0.66
query7	0.02	0.02	0.01
query8	0.04	0.03	0.03
query9	0.56	0.51	0.51
query10	0.56	0.55	0.57
query11	0.14	0.10	0.10
query12	0.14	0.11	0.11
query13	0.61	0.59	0.61
query14	2.70	2.73	2.85
query15	0.91	0.83	0.83
query16	0.37	0.36	0.38
query17	1.04	1.02	1.05
query18	0.23	0.20	0.22
query19	1.81	1.87	2.03
query20	0.02	0.01	0.02
query21	15.36	0.59	0.57
query22	2.37	2.32	2.24
query23	16.82	1.12	0.84
query24	3.08	1.34	1.60
query25	0.22	0.12	0.08
query26	0.54	0.14	0.14
query27	0.05	0.05	0.04
query28	10.20	1.11	1.08
query29	12.60	3.21	3.22
query30	0.24	0.06	0.07
query31	2.87	0.38	0.38
query32	3.27	0.46	0.47
query33	2.99	3.13	3.06
query34	17.07	4.45	4.47
query35	4.54	4.56	4.53
query36	0.66	0.47	0.50
query37	0.09	0.06	0.06
query38	0.04	0.03	0.03
query39	0.03	0.02	0.02
query40	0.17	0.12	0.13
query41	0.08	0.02	0.03
query42	0.04	0.02	0.02
query43	0.04	0.03	0.02
Total cold run time: 106.01 s
Total hot run time: 33.47 s

Vallishp
Vallishp approved these changes Dec 8, 2024
View reviewed changes
Copy link
Contributor

@Vallishp Vallishp left a comment

Choose a reason for hiding this comment

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

LGTM

@rijeshkp rijeshkp force-pushed the ShowTableCreationCommand branch from d2dc2cc to 93020c4 Compare December 9, 2024 04:10
@rijeshkp
Copy link
Contributor Author

rijeshkp commented Dec 9, 2024

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17584	8157	7279	7279
q2	2049	186	173	173
q3	10814	1090	1220	1090
q4	10561	783	728	728
q5	7608	2761	2723	2723
q6	238	149	148	148
q7	1011	623	612	612
q8	9247	1910	1919	1910
q9	6714	6508	6495	6495
q10	7005	2303	2339	2303
q11	482	263	267	263
q12	413	225	218	218
q13	17773	3032	2995	2995
q14	238	214	224	214
q15	566	521	522	521
q16	645	586	581	581
q17	978	624	545	545
q18	7352	6620	6634	6620
q19	1338	1011	1050	1011
q20	463	175	175	175
q21	4003	3375	3295	3295
q22	387	311	310	310
Total cold run time: 107469 ms
Total hot run time: 40209 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7259	7242	7311	7242
q2	327	232	237	232
q3	2905	2930	2905	2905
q4	2133	1837	1806	1806
q5	5625	5666	5674	5666
q6	228	139	142	139
q7	2244	1814	1816	1814
q8	3386	3519	3552	3519
q9	9023	9122	9085	9085
q10	3614	3584	3535	3535
q11	604	497	503	497
q12	850	639	661	639
q13	11913	3204	3220	3204
q14	301	290	282	282
q15	562	522	524	522
q16	701	641	658	641
q17	1877	1640	1619	1619
q18	8396	7761	7544	7544
q19	1721	1605	1636	1605
q20	2129	1913	1886	1886
q21	5508	5545	5454	5454
q22	686	563	570	563
Total cold run time: 71992 ms
Total hot run time: 60399 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 197777 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 93020c424327a4bff6246d62692ba0987365e9f4, data reload: false

query1	1247	967	941	941
query2	6262	2032	2010	2010
query3	11029	4300	4349	4300
query4	67406	28795	23989	23989
query5	4928	465	441	441
query6	414	190	185	185
query7	5524	308	301	301
query8	327	245	241	241
query9	8873	2761	2711	2711
query10	448	249	241	241
query11	17212	15409	15939	15409
query12	155	102	106	102
query13	1462	409	407	407
query14	9987	7052	7292	7052
query15	205	190	201	190
query16	7293	482	481	481
query17	1221	613	592	592
query18	1873	326	317	317
query19	212	167	161	161
query20	119	114	110	110
query21	198	113	104	104
query22	4603	4526	4381	4381
query23	35050	34439	35222	34439
query24	5461	2514	2512	2512
query25	488	385	381	381
query26	632	154	158	154
query27	2045	286	281	281
query28	4251	2497	2459	2459
query29	683	441	454	441
query30	207	153	149	149
query31	991	843	866	843
query32	67	58	58	58
query33	406	290	304	290
query34	913	531	531	531
query35	935	799	776	776
query36	1083	953	991	953
query37	117	74	67	67
query38	4465	4425	4465	4425
query39	1499	1502	1450	1450
query40	204	101	101	101
query41	45	44	48	44
query42	111	104	103	103
query43	538	494	492	492
query44	1194	825	822	822
query45	192	175	182	175
query46	1181	715	749	715
query47	2030	1892	1918	1892
query48	423	330	317	317
query49	725	411	396	396
query50	860	420	415	415
query51	7454	7316	6958	6958
query52	99	92	92	92
query53	263	193	180	180
query54	526	396	391	391
query55	77	74	74	74
query56	256	242	237	237
query57	1258	1117	1135	1117
query58	216	226	227	226
query59	3310	3120	3042	3042
query60	267	244	247	244
query61	106	100	109	100
query62	783	680	690	680
query63	219	188	185	185
query64	1350	648	639	639
query65	3280	3246	3224	3224
query66	704	295	298	295
query67	15971	15605	15739	15605
query68	4240	570	571	570
query69	445	253	264	253
query70	1201	1107	1118	1107
query71	354	246	253	246
query72	6205	4125	4073	4073
query73	768	367	357	357
query74	10427	9007	9079	9007
query75	3391	2694	2645	2645
query76	1760	1140	1044	1044
query77	501	268	274	268
query78	10491	9458	9389	9389
query79	1111	643	588	588
query80	845	430	454	430
query81	500	235	238	235
query82	1355	124	118	118
query83	252	145	145	145
query84	282	84	77	77
query85	946	293	297	293
query86	332	272	298	272
query87	4617	4647	4712	4647
query88	3434	2232	2210	2210
query89	424	298	292	292
query90	2038	186	188	186
query91	146	107	104	104
query92	70	51	50	50
query93	1321	536	534	534
query94	812	299	307	299
query95	351	248	255	248
query96	630	276	290	276
query97	2848	2665	2686	2665
query98	209	191	202	191
query99	1613	1322	1331	1322
Total cold run time: 317852 ms
Total hot run time: 197777 ms

@doris-robot
Copy link

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

query1	0.03	0.02	0.04
query2	0.07	0.03	0.03
query3	0.22	0.08	0.07
query4	1.63	0.10	0.11
query5	0.41	0.41	0.42
query6	1.15	0.66	0.66
query7	0.01	0.02	0.02
query8	0.04	0.03	0.03
query9	0.58	0.51	0.50
query10	0.58	0.55	0.57
query11	0.14	0.11	0.11
query12	0.13	0.12	0.12
query13	0.60	0.61	0.60
query14	2.71	2.77	2.77
query15	0.91	0.81	0.81
query16	0.39	0.39	0.38
query17	1.04	0.97	1.06
query18	0.23	0.21	0.21
query19	1.99	1.83	1.96
query20	0.01	0.01	0.01
query21	15.37	0.60	0.59
query22	2.62	2.01	2.10
query23	17.04	0.90	0.84
query24	3.12	1.47	1.32
query25	0.41	0.09	0.15
query26	0.40	0.15	0.15
query27	0.05	0.04	0.04
query28	10.09	1.09	1.07
query29	12.57	3.31	3.29
query30	0.25	0.07	0.08
query31	2.84	0.38	0.39
query32	3.27	0.46	0.47
query33	3.03	3.07	3.04
query34	16.92	4.48	4.46
query35	4.52	4.48	4.54
query36	0.63	0.48	0.49
query37	0.09	0.06	0.06
query38	0.04	0.04	0.03
query39	0.02	0.02	0.02
query40	0.16	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: 106.46 s
Total hot run time: 33.27 s

@rijeshkp rijeshkp force-pushed the ShowTableCreationCommand branch from 93020c4 to c19a011 Compare December 9, 2024 07:24
@rijeshkp
Copy link
Contributor Author

rijeshkp commented Dec 9, 2024

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17795	7536	7340	7340
q2	2049	176	162	162
q3	10640	1154	1311	1154
q4	10286	746	742	742
q5	7619	2714	2750	2714
q6	238	149	146	146
q7	1011	628	616	616
q8	9246	1860	1940	1860
q9	6841	6560	6557	6557
q10	6970	2338	2331	2331
q11	457	269	256	256
q12	410	218	218	218
q13	17781	2992	3160	2992
q14	240	206	208	206
q15	566	518	518	518
q16	642	583	591	583
q17	976	528	551	528
q18	7460	6787	6800	6787
q19	1355	996	928	928
q20	483	180	178	178
q21	4018	3221	3290	3221
q22	373	313	317	313
Total cold run time: 107456 ms
Total hot run time: 40350 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7273	7304	7275	7275
q2	325	236	232	232
q3	2957	2916	3054	2916
q4	2126	1791	1812	1791
q5	5629	5703	5679	5679
q6	219	139	136	136
q7	2185	1783	1807	1783
q8	3419	3570	3549	3549
q9	8942	9034	9031	9031
q10	3593	3596	3540	3540
q11	601	497	525	497
q12	824	605	607	605
q13	12956	3150	3081	3081
q14	284	257	252	252
q15	557	519	518	518
q16	702	631	628	628
q17	1810	1624	1561	1561
q18	7897	7539	7387	7387
q19	1676	1605	1574	1574
q20	2028	1839	1845	1839
q21	5375	5398	5320	5320
q22	673	561	591	561
Total cold run time: 72051 ms
Total hot run time: 59755 ms

@doris-robot
Copy link

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

query1	972	384	372	372
query2	6538	2077	1991	1991
query3	6706	221	213	213
query4	33976	23609	23452	23452
query5	4322	488	458	458
query6	268	188	190	188
query7	4637	298	303	298
query8	279	228	220	220
query9	9594	2734	2735	2734
query10	443	246	249	246
query11	19796	15194	15347	15194
query12	153	106	103	103
query13	1645	432	398	398
query14	9307	7237	6825	6825
query15	243	175	178	175
query16	8065	431	440	431
query17	1633	583	573	573
query18	2099	305	299	299
query19	228	169	152	152
query20	120	113	115	113
query21	208	106	118	106
query22	4336	4375	4289	4289
query23	35058	34096	34172	34096
query24	11462	2476	2436	2436
query25	696	408	414	408
query26	1794	158	159	158
query27	3018	289	290	289
query28	8292	2471	2470	2470
query29	1031	403	392	392
query30	306	147	149	147
query31	1012	822	810	810
query32	95	57	57	57
query33	769	306	306	306
query34	987	512	539	512
query35	875	742	744	742
query36	1111	942	960	942
query37	287	72	78	72
query38	4326	4228	4159	4159
query39	1516	1441	1428	1428
query40	280	98	99	98
query41	47	43	45	43
query42	120	99	97	97
query43	524	491	487	487
query44	1230	795	785	785
query45	183	177	165	165
query46	1182	702	716	702
query47	1955	1850	1846	1846
query48	417	326	315	315
query49	1284	409	398	398
query50	804	381	380	380
query51	7228	7165	7066	7066
query52	100	89	86	86
query53	249	181	180	180
query54	1128	402	403	402
query55	75	81	78	78
query56	260	244	240	240
query57	1243	1135	1141	1135
query58	222	216	215	215
query59	3214	3198	3056	3056
query60	291	230	236	230
query61	109	109	111	109
query62	901	660	709	660
query63	219	186	190	186
query64	5242	645	680	645
query65	3268	3207	3256	3207
query66	1423	303	336	303
query67	15990	15867	15540	15540
query68	4786	546	550	546
query69	423	266	252	252
query70	1180	1150	1143	1143
query71	347	263	246	246
query72	6320	3951	4060	3951
query73	766	359	360	359
query74	10417	9005	8990	8990
query75	3467	2640	2661	2640
query76	3040	1052	1070	1052
query77	393	266	273	266
query78	10455	9542	9370	9370
query79	1352	601	603	601
query80	860	419	424	419
query81	521	229	222	222
query82	773	116	119	116
query83	267	150	140	140
query84	242	70	73	70
query85	1232	319	304	304
query86	365	310	303	303
query87	4759	4883	4605	4605
query88	3416	2250	2227	2227
query89	402	296	313	296
query90	2113	187	188	187
query91	138	104	104	104
query92	64	52	51	51
query93	1081	534	537	534
query94	989	302	299	299
query95	351	253	256	253
query96	626	281	284	281
query97	2890	2671	2707	2671
query98	212	199	203	199
query99	1589	1332	1314	1314
Total cold run time: 303227 ms
Total hot run time: 190919 ms

@doris-robot
Copy link

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

query1	0.03	0.03	0.04
query2	0.09	0.03	0.03
query3	0.23	0.08	0.07
query4	1.60	0.10	0.10
query5	0.45	0.42	0.42
query6	1.19	0.67	0.67
query7	0.02	0.01	0.02
query8	0.03	0.03	0.03
query9	0.55	0.52	0.47
query10	0.54	0.56	0.57
query11	0.14	0.11	0.11
query12	0.14	0.12	0.10
query13	0.61	0.60	0.60
query14	2.69	2.74	2.70
query15	0.90	0.83	0.83
query16	0.36	0.39	0.39
query17	1.02	1.02	1.03
query18	0.22	0.21	0.21
query19	1.84	1.79	1.81
query20	0.02	0.01	0.02
query21	15.37	0.56	0.58
query22	2.32	2.28	1.84
query23	17.04	1.06	0.92
query24	3.27	1.43	1.63
query25	0.24	0.22	0.21
query26	0.37	0.14	0.14
query27	0.04	0.04	0.05
query28	9.63	1.11	1.07
query29	12.56	3.30	3.24
query30	0.25	0.06	0.06
query31	2.87	0.37	0.38
query32	3.26	0.46	0.47
query33	2.99	3.12	3.10
query34	17.24	4.47	4.46
query35	4.49	4.55	4.55
query36	0.68	0.48	0.48
query37	0.09	0.07	0.07
query38	0.05	0.03	0.04
query39	0.03	0.02	0.02
query40	0.16	0.12	0.13
query41	0.08	0.03	0.03
query42	0.03	0.03	0.02
query43	0.04	0.03	0.02
Total cold run time: 105.77 s
Total hot run time: 33.39 s

@rijeshkp
Copy link
Contributor Author

rijeshkp commented Dec 9, 2024

run compile

@rijeshkp
Copy link
Contributor Author

rijeshkp commented Dec 9, 2024

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17587	7638	7305	7305
q2	2066	182	171	171
q3	10675	1074	1110	1074
q4	10571	746	695	695
q5	7887	2797	2716	2716
q6	239	149	149	149
q7	989	645	609	609
q8	9219	1828	1942	1828
q9	6656	6605	6444	6444
q10	6970	2295	2314	2295
q11	466	264	266	264
q12	427	229	221	221
q13	17777	3038	3067	3038
q14	250	209	213	209
q15	562	537	513	513
q16	650	577	570	570
q17	992	544	588	544
q18	7215	6735	6580	6580
q19	1344	1012	947	947
q20	480	182	182	182
q21	4126	3303	3133	3133
q22	381	319	324	319
Total cold run time: 107529 ms
Total hot run time: 39806 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7242	7221	7296	7221
q2	323	231	224	224
q3	2911	2826	2955	2826
q4	2088	1825	1838	1825
q5	5696	5699	5648	5648
q6	226	143	149	143
q7	2250	1826	1812	1812
q8	3367	3529	3472	3472
q9	9045	9127	9048	9048
q10	3601	3573	3527	3527
q11	626	512	496	496
q12	801	601	621	601
q13	9452	3242	3197	3197
q14	300	272	270	270
q15	578	523	531	523
q16	710	629	661	629
q17	1834	1626	1581	1581
q18	8281	7605	7637	7605
q19	1686	1593	1574	1574
q20	2128	1873	1876	1873
q21	5585	5563	5571	5563
q22	637	569	561	561
Total cold run time: 69367 ms
Total hot run time: 60219 ms

@doris-robot
Copy link

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

query1	1263	960	954	954
query2	6231	2080	2021	2021
query3	11097	4510	4455	4455
query4	67613	28594	23559	23559
query5	4926	499	454	454
query6	424	196	181	181
query7	5514	306	299	299
query8	326	243	251	243
query9	8448	2744	2724	2724
query10	448	249	272	249
query11	17358	15325	15887	15325
query12	150	109	117	109
query13	1452	460	428	428
query14	10677	7294	7719	7294
query15	224	197	187	187
query16	6949	467	489	467
query17	1404	576	590	576
query18	1800	291	292	291
query19	216	152	155	152
query20	117	112	114	112
query21	213	114	102	102
query22	4793	4459	4483	4459
query23	34909	34715	34573	34573
query24	5493	2480	2508	2480
query25	489	399	381	381
query26	636	153	156	153
query27	1878	292	286	286
query28	4513	2478	2499	2478
query29	669	432	430	430
query30	209	159	185	159
query31	1043	865	839	839
query32	68	65	54	54
query33	499	288	308	288
query34	932	525	529	525
query35	901	762	774	762
query36	1115	933	966	933
query37	120	68	76	68
query38	4546	4429	4433	4429
query39	1512	1508	1455	1455
query40	204	96	98	96
query41	44	41	46	41
query42	119	97	100	97
query43	535	499	496	496
query44	1221	840	834	834
query45	202	172	173	172
query46	1188	739	752	739
query47	2049	1906	1948	1906
query48	418	328	339	328
query49	746	383	390	383
query50	851	406	415	406
query51	7356	7146	7027	7027
query52	98	88	94	88
query53	255	173	187	173
query54	513	387	394	387
query55	77	77	79	77
query56	254	237	229	229
query57	1253	1122	1128	1122
query58	216	212	213	212
query59	3112	2918	3045	2918
query60	277	255	254	254
query61	146	100	104	100
query62	783	679	673	673
query63	221	187	196	187
query64	1360	663	630	630
query65	3313	3207	3193	3193
query66	706	302	291	291
query67	15950	15720	15629	15629
query68	4051	582	559	559
query69	419	257	257	257
query70	1201	1106	1127	1106
query71	366	249	244	244
query72	6356	4196	4043	4043
query73	762	358	356	356
query74	10316	9173	9037	9037
query75	3405	2636	2672	2636
query76	1923	1087	1138	1087
query77	470	297	267	267
query78	10466	9431	9457	9431
query79	1441	610	608	608
query80	872	438	420	420
query81	501	341	236	236
query82	1277	119	119	119
query83	254	149	149	149
query84	285	71	68	68
query85	879	295	303	295
query86	337	288	302	288
query87	4673	4587	4539	4539
query88	3679	2204	2175	2175
query89	419	300	299	299
query90	2000	190	190	190
query91	183	104	102	102
query92	62	50	49	49
query93	1771	545	540	540
query94	798	283	303	283
query95	349	252	249	249
query96	635	273	275	273
query97	2881	2681	2663	2663
query98	218	202	202	202
query99	1770	1329	1346	1329
Total cold run time: 319661 ms
Total hot run time: 197721 ms

@doris-robot
Copy link

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

query1	0.03	0.03	0.04
query2	0.06	0.04	0.03
query3	0.23	0.06	0.07
query4	1.63	0.10	0.10
query5	0.42	0.42	0.40
query6	1.16	0.64	0.66
query7	0.02	0.01	0.01
query8	0.04	0.04	0.03
query9	0.59	0.51	0.50
query10	0.55	0.56	0.55
query11	0.14	0.10	0.11
query12	0.14	0.11	0.12
query13	0.62	0.61	0.61
query14	2.70	2.86	2.72
query15	0.96	0.92	0.82
query16	0.38	0.39	0.37
query17	1.08	1.06	1.05
query18	0.22	0.21	0.21
query19	2.00	1.85	2.01
query20	0.01	0.01	0.01
query21	15.36	0.59	0.58
query22	2.41	2.50	1.91
query23	17.01	0.95	0.82
query24	2.97	0.79	1.07
query25	0.14	0.32	0.18
query26	0.33	0.13	0.14
query27	0.04	0.04	0.05
query28	11.13	1.10	1.06
query29	12.65	3.31	3.29
query30	0.25	0.07	0.06
query31	2.86	0.39	0.38
query32	3.30	0.46	0.47
query33	3.00	3.08	3.09
query34	17.23	4.50	4.48
query35	4.54	4.50	4.58
query36	0.67	0.50	0.49
query37	0.09	0.06	0.06
query38	0.04	0.03	0.03
query39	0.04	0.02	0.02
query40	0.17	0.13	0.13
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: 107.37 s
Total hot run time: 32.76 s

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

github-actions bot commented Dec 9, 2024

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

@starocean999 starocean999 merged commit 7b5b8db into apache:master Dec 9, 2024
25 of 26 checks passed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Reviewers

@LiBinfeng-01 LiBinfeng-01 LiBinfeng-01 left review comments

@starocean999 starocean999 starocean999 approved these changes

@Vallishp Vallishp Vallishp approved these changes

Assignees
No one assigned
Labels
approved Indicates a PR has been approved by one committer. reviewed
Projects
None yet
Milestone
No milestone
Development

Successfully merging this pull request may close these issues.

[Enhancement] (nereids)implement showTableCreationCommand in nereids
5 participants
@rijeshkp @doris-robot @Vallishp @starocean999 @LiBinfeng-01