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 showDataTypesCommand in nereids #44299

Merged
merged 1 commit into from
Dec 19, 2024
Merged

[Enhancement] (nereids)implement showDataTypesCommand in nereids #44299

merged 1 commit into from
Dec 19, 2024

Conversation

msridhar78
Copy link
Contributor

What problem does this PR solve?

Issue Number: close #42743

[Enhancement] (nereids)implement showDataTypesCommand in nereids

Related PR: #xxx

Problem Summary:

Release note

None

Check List (For Author)

  • Test

    • Regression test
    • Unit Test
    • Manual test (add detailed scripts or steps below)
    • No need to test or manual test. Explain why:
      • This is a refactor/code format and no logic has been changed.
      • Previous test can cover this change.
      • No code files have been changed.
      • Other reason

  • Behavior changed:

    • No.
    • Yes.

  • Does this need documentation?

    • No.
    • Yes.

Check List (For Reviewer who merge this PR)

  • Confirm the release note
  • Confirm test cases
  • Confirm document
  • Add branch pick label

@doris-robot
Copy link

Thank you for your contribution to Apache Doris.
Don't know what should be done next? See How to process your PR.

Please clearly describe your PR:

  1. What problem was fixed (it's best to include specific error reporting information). How it was fixed.
  2. Which behaviors were modified. What was the previous behavior, what is it now, why was it modified, and what possible impacts might there be.
  3. What features were added. Why was this function added?
  4. Which code was refactored and why was this part of the code refactored?
  5. Which functions were optimized and what is the difference before and after the optimization?

@msridhar78
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17585	7435	7267	7267
q2	2247	1159	1165	1159
q3	9964	1171	1153	1153
q4	10212	738	770	738
q5	7615	2679	2706	2679
q6	242	151	150	150
q7	986	629	605	605
q8	9366	2363	2354	2354
q9	6602	6444	6427	6427
q10	7003	2292	2305	2292
q11	474	259	261	259
q12	418	220	225	220
q13	17764	3097	3076	3076
q14	232	208	214	208
q15	566	529	516	516
q16	662	593	575	575
q17	973	646	597	597
q18	7376	6740	6698	6698
q19	1338	939	1071	939
q20	2916	2672	2693	2672
q21	3967	3260	3125	3125
q22	1399	1367	1347	1347
Total cold run time: 109907 ms
Total hot run time: 45056 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7342	7274	7340	7274
q2	342	234	242	234
q3	3075	2942	2880	2880
q4	2030	1863	1780	1780
q5	5661	5620	5467	5467
q6	216	139	140	139
q7	2159	1774	1766	1766
q8	3305	3477	3480	3477
q9	8666	8626	8543	8543
q10	3526	3488	3430	3430
q11	603	511	485	485
q12	791	587	575	575
q13	9881	3063	3081	3063
q14	292	261	258	258
q15	571	505	518	505
q16	666	632	636	632
q17	1809	1583	1553	1553
q18	7911	7447	7538	7447
q19	1691	1584	1601	1584
q20	2050	1820	1833	1820
q21	5407	5218	5369	5218
q22	631	551	544	544
Total cold run time: 68625 ms
Total hot run time: 58674 ms

@doris-robot
Copy link

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

query1	0.04	0.03	0.03
query2	0.06	0.03	0.04
query3	0.23	0.07	0.06
query4	1.61	0.10	0.10
query5	0.42	0.44	0.41
query6	1.17	0.65	0.65
query7	0.02	0.01	0.01
query8	0.04	0.04	0.03
query9	0.59	0.51	0.52
query10	0.55	0.57	0.57
query11	0.14	0.10	0.10
query12	0.14	0.11	0.12
query13	0.61	0.61	0.60
query14	2.69	2.83	2.85
query15	0.92	0.82	0.81
query16	0.40	0.38	0.37
query17	1.08	1.04	1.07
query18	0.23	0.21	0.21
query19	1.96	1.88	2.00
query20	0.01	0.02	0.01
query21	15.37	0.59	0.58
query22	2.73	2.32	1.85
query23	17.19	0.96	0.82
query24	2.90	1.30	1.26
query25	0.27	0.13	0.06
query26	0.57	0.13	0.13
query27	0.05	0.04	0.05
query28	10.35	1.09	1.06
query29	12.55	3.25	3.23
query30	0.27	0.07	0.06
query31	2.84	0.40	0.38
query32	3.25	0.47	0.47
query33	2.92	2.98	3.04
query34	17.02	4.44	4.52
query35	4.73	4.54	4.54
query36	0.66	0.50	0.48
query37	0.09	0.06	0.06
query38	0.04	0.04	0.04
query39	0.03	0.02	0.03
query40	0.17	0.13	0.12
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: 107.05 s
Total hot run time: 33.05 s

@msridhar78
Copy link
Contributor Author

run buildall

@msridhar78
Copy link
Contributor Author

run p0

@msridhar78
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17595	7595	7350	7350
q2	2051	187	175	175
q3	10680	1116	1261	1116
q4	10542	800	766	766
q5	7612	2759	2787	2759
q6	243	151	149	149
q7	990	635	612	612
q8	9264	1887	1979	1887
q9	6633	6433	6424	6424
q10	7045	2297	2353	2297
q11	462	275	267	267
q12	423	220	228	220
q13	17763	3046	3037	3037
q14	242	215	217	215
q15	579	527	522	522
q16	674	581	594	581
q17	994	495	542	495
q18	7269	6767	6721	6721
q19	1337	1045	1011	1011
q20	485	193	189	189
q21	4038	3255	3256	3255
q22	391	316	312	312
Total cold run time: 107312 ms
Total hot run time: 40360 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7307	7318	7296	7296
q2	328	232	233	232
q3	2950	2916	2944	2916
q4	2051	1822	1847	1822
q5	5759	5723	5718	5718
q6	225	142	151	142
q7	2238	1859	1828	1828
q8	3422	3553	3593	3553
q9	8806	8940	8902	8902
q10	3617	3561	3607	3561
q11	623	508	518	508
q12	880	630	663	630
q13	11394	3289	3277	3277
q14	299	277	281	277
q15	571	539	536	536
q16	680	633	661	633
q17	1875	1698	1595	1595
q18	8397	7741	7661	7661
q19	1937	1691	1555	1555
q20	2146	1866	1892	1866
q21	5671	5398	5530	5398
q22	665	608	651	608
Total cold run time: 71841 ms
Total hot run time: 60514 ms

@doris-robot
Copy link

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

query1	1223	968	926	926
query2	6239	2192	2207	2192
query3	10802	4040	4072	4040
query4	67436	29697	23681	23681
query5	4943	490	491	490
query6	404	192	172	172
query7	5637	297	294	294
query8	304	220	228	220
query9	9130	2675	2680	2675
query10	452	260	258	258
query11	17576	15528	15870	15528
query12	156	104	114	104
query13	1564	439	448	439
query14	10524	7558	7356	7356
query15	206	178	198	178
query16	7051	425	477	425
query17	990	568	540	540
query18	1799	284	291	284
query19	191	149	143	143
query20	119	112	109	109
query21	199	100	103	100
query22	4440	4394	4394	4394
query23	34629	34288	34249	34249
query24	5385	2405	2449	2405
query25	483	393	377	377
query26	640	153	154	153
query27	1715	283	300	283
query28	4181	2462	2419	2419
query29	657	409	415	409
query30	215	150	146	146
query31	991	837	827	827
query32	67	53	56	53
query33	418	272	278	272
query34	911	528	517	517
query35	832	714	732	714
query36	1056	979	970	970
query37	121	74	71	71
query38	4431	4199	4234	4199
query39	1505	1449	1437	1437
query40	203	98	94	94
query41	47	43	42	42
query42	110	99	97	97
query43	562	508	510	508
query44	1161	818	818	818
query45	177	167	166	166
query46	1155	697	687	687
query47	1974	1865	1827	1827
query48	414	304	318	304
query49	724	383	385	383
query50	802	383	398	383
query51	7264	7146	7178	7146
query52	99	85	94	85
query53	250	178	179	178
query54	511	405	387	387
query55	82	79	81	79
query56	254	253	236	236
query57	1284	1186	1171	1171
query58	240	220	229	220
query59	3272	3245	3196	3196
query60	290	265	260	260
query61	132	135	130	130
query62	791	690	691	690
query63	221	195	190	190
query64	1448	680	629	629
query65	3276	3230	3214	3214
query66	674	313	319	313
query67	15971	15679	15815	15679
query68	4042	563	560	560
query69	427	252	259	252
query70	1102	1155	1171	1155
query71	349	245	250	245
query72	6417	4056	4088	4056
query73	752	356	361	356
query74	10184	8994	8970	8970
query75	3387	2724	2695	2695
query76	1815	1050	1110	1050
query77	471	289	272	272
query78	10578	9555	9367	9367
query79	2039	595	604	595
query80	1371	417	426	417
query81	525	245	238	238
query82	1318	125	116	116
query83	229	149	147	147
query84	292	75	68	68
query85	989	300	344	300
query86	420	306	308	306
query87	4807	4611	4679	4611
query88	3710	2212	2179	2179
query89	423	296	298	296
query90	1935	195	188	188
query91	139	105	103	103
query92	63	52	50	50
query93	2839	552	547	547
query94	837	290	275	275
query95	358	251	257	251
query96	644	277	293	277
query97	2874	2676	2695	2676
query98	209	203	202	202
query99	1591	1330	1302	1302
Total cold run time: 320146 ms
Total hot run time: 197283 ms

@doris-robot
Copy link

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

query1	0.03	0.03	0.03
query2	0.07	0.03	0.03
query3	0.23	0.08	0.08
query4	1.61	0.11	0.11
query5	0.45	0.41	0.40
query6	1.15	0.65	0.67
query7	0.02	0.01	0.01
query8	0.04	0.03	0.03
query9	0.56	0.52	0.51
query10	0.55	0.56	0.56
query11	0.14	0.10	0.10
query12	0.13	0.11	0.11
query13	0.62	0.60	0.61
query14	2.72	2.75	2.73
query15	0.91	0.84	0.83
query16	0.39	0.40	0.36
query17	1.05	1.05	1.08
query18	0.20	0.20	0.20
query19	1.92	1.89	2.01
query20	0.01	0.02	0.01
query21	15.36	0.58	0.59
query22	2.77	2.05	1.36
query23	17.02	0.90	0.81
query24	3.40	1.53	1.59
query25	0.25	0.21	0.06
query26	0.61	0.14	0.13
query27	0.04	0.04	0.04
query28	10.03	1.11	1.08
query29	12.54	3.19	3.19
query30	0.24	0.06	0.06
query31	2.86	0.38	0.39
query32	3.27	0.48	0.47
query33	3.01	3.05	3.03
query34	16.98	4.43	4.48
query35	4.55	4.48	4.49
query36	0.67	0.50	0.47
query37	0.09	0.06	0.05
query38	0.05	0.04	0.04
query39	0.04	0.03	0.02
query40	0.16	0.13	0.12
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.9 s
Total hot run time: 32.69 s

@msridhar78
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17601	7395	7237	7237
q2	2033	172	172	172
q3	10594	1070	1199	1070
q4	10547	716	675	675
q5	7575	2665	2725	2665
q6	247	147	147	147
q7	973	617	602	602
q8	9244	1829	1898	1829
q9	6519	6346	6362	6346
q10	7022	2290	2342	2290
q11	467	257	255	255
q12	431	215	222	215
q13	17758	2980	3027	2980
q14	243	211	207	207
q15	573	535	530	530
q16	678	605	591	591
q17	989	548	556	548
q18	7155	6669	6660	6660
q19	1322	1054	1037	1037
q20	461	184	179	179
q21	4049	3166	3036	3036
q22	370	316	327	316
Total cold run time: 106851 ms
Total hot run time: 39587 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7291	7250	7181	7181
q2	320	230	232	230
q3	2908	2805	2916	2805
q4	2035	1758	1741	1741
q5	5691	5658	5679	5658
q6	232	145	145	145
q7	2267	1827	1824	1824
q8	3346	3527	3466	3466
q9	8828	8879	8884	8879
q10	3588	3515	3554	3515
q11	598	514	530	514
q12	812	629	617	617
q13	11680	3233	3243	3233
q14	298	273	298	273
q15	571	530	518	518
q16	721	639	636	636
q17	1830	1647	1613	1613
q18	8271	7862	7604	7604
q19	1771	1577	1544	1544
q20	2137	1847	1948	1847
q21	5518	5215	5432	5215
q22	641	566	609	566
Total cold run time: 71354 ms
Total hot run time: 59624 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 197379 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 993fa7272dc07d0601343d8cde96a9421e635bec, data reload: false

query1	1288	959	925	925
query2	6235	2074	2027	2027
query3	10896	4174	4014	4014
query4	67735	28783	23558	23558
query5	5029	476	469	469
query6	412	181	176	176
query7	5531	301	297	297
query8	306	227	227	227
query9	8883	2770	2769	2769
query10	449	251	266	251
query11	17351	15361	15777	15361
query12	149	106	108	106
query13	1470	452	398	398
query14	10156	7526	7098	7098
query15	206	179	206	179
query16	7133	447	462	447
query17	1296	562	593	562
query18	1781	332	293	293
query19	198	152	187	152
query20	124	108	111	108
query21	213	103	101	101
query22	4826	4530	4640	4530
query23	35392	34573	34500	34500
query24	5468	2501	2500	2500
query25	478	392	394	392
query26	652	150	148	148
query27	2006	287	288	287
query28	4329	2529	2493	2493
query29	704	472	439	439
query30	232	157	148	148
query31	1003	842	876	842
query32	97	56	57	56
query33	397	292	295	292
query34	927	514	523	514
query35	873	772	762	762
query36	1089	962	963	962
query37	119	75	77	75
query38	4485	4434	4423	4423
query39	1501	1456	1450	1450
query40	212	95	98	95
query41	48	44	46	44
query42	121	102	104	102
query43	529	493	486	486
query44	1154	831	810	810
query45	188	168	173	168
query46	1163	699	720	699
query47	2076	1933	1954	1933
query48	430	321	311	311
query49	745	387	384	384
query50	845	408	407	407
query51	7332	7287	7100	7100
query52	96	89	95	89
query53	248	175	178	175
query54	503	395	403	395
query55	73	73	76	73
query56	249	250	235	235
query57	1302	1204	1158	1158
query58	216	212	221	212
query59	3098	3003	2939	2939
query60	271	248	246	246
query61	131	174	109	109
query62	762	674	661	661
query63	207	193	194	193
query64	1371	678	632	632
query65	3251	3185	3201	3185
query66	710	308	308	308
query67	16044	15843	15696	15696
query68	3769	591	579	579
query69	416	256	252	252
query70	1218	1105	1058	1058
query71	345	244	242	242
query72	6346	4408	4234	4234
query73	769	366	376	366
query74	10095	9053	9061	9053
query75	3396	2686	2661	2661
query76	1776	1210	1047	1047
query77	501	288	276	276
query78	10559	9460	9433	9433
query79	1993	598	607	598
query80	1397	432	431	431
query81	523	243	228	228
query82	1238	116	113	113
query83	279	151	153	151
query84	283	74	67	67
query85	1045	297	302	297
query86	391	306	285	285
query87	4697	4500	4621	4500
query88	3596	2240	2206	2206
query89	420	295	286	286
query90	1994	186	187	186
query91	140	102	112	102
query92	71	50	51	50
query93	2540	540	543	540
query94	895	292	346	292
query95	358	241	246	241
query96	621	282	283	282
query97	2939	2662	2641	2641
query98	239	189	190	189
query99	1658	1317	1318	1317
Total cold run time: 321301 ms
Total hot run time: 197379 ms

@doris-robot
Copy link

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

query1	0.04	0.03	0.03
query2	0.07	0.04	0.04
query3	0.24	0.06	0.07
query4	1.64	0.10	0.11
query5	0.43	0.40	0.41
query6	1.17	0.67	0.66
query7	0.02	0.02	0.02
query8	0.03	0.03	0.03
query9	0.58	0.51	0.50
query10	0.56	0.56	0.56
query11	0.14	0.11	0.11
query12	0.13	0.11	0.10
query13	0.62	0.61	0.60
query14	2.79	2.75	2.73
query15	0.91	0.83	0.82
query16	0.38	0.38	0.38
query17	1.04	1.00	1.01
query18	0.22	0.19	0.20
query19	1.98	1.76	2.03
query20	0.01	0.01	0.01
query21	15.37	0.60	0.60
query22	2.79	2.87	1.48
query23	16.85	1.02	0.80
query24	2.89	1.61	1.28
query25	0.20	0.19	0.04
query26	0.54	0.13	0.13
query27	0.05	0.04	0.05
query28	10.20	1.09	1.08
query29	12.58	3.25	3.28
query30	0.25	0.06	0.06
query31	2.87	0.40	0.37
query32	3.27	0.46	0.47
query33	3.00	2.99	3.04
query34	17.06	4.45	4.45
query35	4.56	4.51	4.47
query36	0.65	0.47	0.47
query37	0.09	0.06	0.06
query38	0.05	0.03	0.04
query39	0.04	0.02	0.02
query40	0.17	0.12	0.13
query41	0.08	0.02	0.02
query42	0.04	0.03	0.02
query43	0.04	0.03	0.03
Total cold run time: 106.64 s
Total hot run time: 32.37 s

@msridhar78
Copy link
Contributor Author

run buildall

4 similar comments
@msridhar78
Copy link
Contributor Author

run buildall

@starocean999
Copy link
Contributor

run buildall

@msridhar78
Copy link
Contributor Author

run buildall

@msridhar78
Copy link
Contributor Author

run buildall

@msridhar78
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17589	7489	7306	7306
q2	2050	186	170	170
q3	10554	1114	1178	1114
q4	10225	746	665	665
q5	7615	2734	2636	2636
q6	240	150	151	150
q7	998	629	613	613
q8	9257	1856	1910	1856
q9	6634	6449	6383	6383
q10	6942	2273	2292	2273
q11	460	263	265	263
q12	441	227	226	226
q13	17778	2993	2979	2979
q14	249	226	217	217
q15	552	510	512	510
q16	645	602	586	586
q17	973	575	543	543
q18	7264	6806	6704	6704
q19	1334	957	1002	957
q20	456	190	186	186
q21	4325	3297	3165	3165
q22	387	311	312	311
Total cold run time: 106968 ms
Total hot run time: 39813 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7328	7282	7330	7282
q2	335	233	233	233
q3	2898	2772	3031	2772
q4	2117	1877	1789	1789
q5	5610	5647	5577	5577
q6	221	143	142	142
q7	2210	1858	1748	1748
q8	3309	3552	3486	3486
q9	8842	8895	8884	8884
q10	3585	3586	3537	3537
q11	619	520	500	500
q12	788	625	562	562
q13	13029	3153	3121	3121
q14	314	280	278	278
q15	561	523	513	513
q16	688	627	642	627
q17	1785	1601	1584	1584
q18	7854	7477	7339	7339
q19	1645	1572	1471	1471
q20	2033	1839	1799	1799
q21	5329	5212	5258	5212
q22	634	572	626	572
Total cold run time: 71734 ms
Total hot run time: 59028 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 189520 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 09be3f21cdc8b684d0fb6ea1e185e9d1b40e16a6, data reload: false

query1	991	382	380	380
query2	6529	2336	2217	2217
query3	6718	226	225	225
query4	33644	23361	23366	23361
query5	4349	493	461	461
query6	273	184	184	184
query7	4622	311	306	306
query8	296	232	225	225
query9	9592	2709	2697	2697
query10	480	255	250	250
query11	18041	15148	15160	15148
query12	168	110	107	107
query13	1666	429	432	429
query14	10396	7853	6854	6854
query15	256	193	184	184
query16	7752	431	460	431
query17	1651	576	544	544
query18	1426	298	291	291
query19	371	152	151	151
query20	122	111	109	109
query21	209	108	103	103
query22	4354	4407	4199	4199
query23	34648	33519	33441	33441
query24	11467	2466	2496	2466
query25	660	385	401	385
query26	1786	154	148	148
query27	2577	324	323	323
query28	7801	2431	2431	2431
query29	935	431	403	403
query30	299	151	161	151
query31	1033	812	824	812
query32	94	56	59	56
query33	765	300	291	291
query34	989	513	522	513
query35	877	744	738	738
query36	1108	948	958	948
query37	206	74	75	74
query38	4174	4047	4010	4010
query39	1535	1444	1433	1433
query40	296	103	100	100
query41	51	44	48	44
query42	113	100	104	100
query43	534	515	482	482
query44	1185	823	814	814
query45	185	166	166	166
query46	1173	710	702	702
query47	1938	1853	1823	1823
query48	426	325	314	314
query49	1289	396	386	386
query50	808	386	398	386
query51	7215	6954	7133	6954
query52	104	99	122	99
query53	252	186	182	182
query54	1365	409	411	409
query55	84	81	78	78
query56	261	249	255	249
query57	1244	1113	1122	1113
query58	243	234	222	222
query59	3199	2846	2858	2846
query60	275	241	249	241
query61	112	108	111	108
query62	868	670	663	663
query63	216	193	187	187
query64	5344	673	647	647
query65	3277	3198	3221	3198
query66	1223	317	309	309
query67	15648	15528	15432	15432
query68	5058	549	535	535
query69	430	257	259	257
query70	1170	1050	1148	1050
query71	349	250	255	250
query72	6422	4235	4274	4235
query73	758	358	357	357
query74	10214	8862	8833	8833
query75	3358	2630	2637	2630
query76	2955	1092	1029	1029
query77	535	280	282	280
query78	10220	9443	9399	9399
query79	2349	615	613	613
query80	1162	431	434	431
query81	529	246	242	242
query82	699	120	119	119
query83	249	149	143	143
query84	331	74	65	65
query85	1611	311	302	302
query86	481	320	293	293
query87	4477	4514	4334	4334
query88	4210	2215	2190	2190
query89	406	294	292	292
query90	2030	192	191	191
query91	141	104	108	104
query92	70	54	51	51
query93	1572	537	536	536
query94	888	300	292	292
query95	365	257	255	255
query96	612	284	281	281
query97	2835	2691	2680	2680
query98	219	197	193	193
query99	1540	1353	1325	1325
Total cold run time: 302033 ms
Total hot run time: 189520 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 09be3f21cdc8b684d0fb6ea1e185e9d1b40e16a6, data reload: false

query1	0.04	0.05	0.03
query2	0.07	0.04	0.03
query3	0.24	0.07	0.07
query4	1.60	0.11	0.11
query5	0.43	0.40	0.43
query6	1.16	0.65	0.66
query7	0.02	0.01	0.01
query8	0.04	0.03	0.03
query9	0.59	0.50	0.50
query10	0.55	0.58	0.57
query11	0.14	0.10	0.10
query12	0.13	0.11	0.11
query13	0.62	0.60	0.60
query14	2.79	2.86	2.76
query15	0.90	0.81	0.83
query16	0.37	0.40	0.39
query17	0.99	1.06	1.04
query18	0.22	0.23	0.21
query19	1.97	1.86	2.02
query20	0.01	0.01	0.01
query21	15.37	0.59	0.59
query22	2.47	1.96	2.05
query23	17.00	1.09	0.72
query24	3.58	0.80	1.62
query25	0.13	0.24	0.21
query26	0.47	0.14	0.13
query27	0.05	0.05	0.03
query28	9.83	1.10	1.08
query29	12.58	3.22	3.23
query30	0.25	0.06	0.07
query31	2.86	0.40	0.39
query32	3.23	0.46	0.46
query33	3.12	3.06	3.06
query34	17.04	4.46	4.51
query35	4.57	4.47	4.51
query36	0.64	0.49	0.49
query37	0.09	0.06	0.06
query38	0.04	0.03	0.03
query39	0.03	0.02	0.02
query40	0.16	0.14	0.13
query41	0.08	0.03	0.02
query42	0.03	0.02	0.02
query43	0.03	0.03	0.03
Total cold run time: 106.53 s
Total hot run time: 32.73 s

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

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

@github-actions GitHub Actions
Copy link
Contributor

PR approved by anyone and no changes requested.

@starocean999 starocean999 merged commit a9de07b into apache:master Dec 19, 2024
28 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 approved these changes

@starocean999 starocean999 starocean999 approved these changes

@englefly englefly englefly 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 showDataTypesCommand in nereids
5 participants
@msridhar78 @doris-robot @starocean999 @englefly @LiBinfeng-01