Skip to content

[Feat](Nereids) support show views command - #48905

Merged
starocean999 merged 5 commits into
apache:masterfrom
xiedeyantu:view
Mar 13, 2025
Merged

[Feat](Nereids) support show views command#48905
starocean999 merged 5 commits into
apache:masterfrom
xiedeyantu:view

Conversation

@xiedeyantu

@xiedeyantu xiedeyantu commented Mar 11, 2025

Copy link
Copy Markdown
Member

What problem does this PR solve?

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

Thearas commented Mar 11, 2025

Copy link
Copy Markdown
Contributor

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?

@xiedeyantu

xiedeyantu commented Mar 11, 2025

Copy link
Copy Markdown
Member Author

run buildall

@doris-robot

doris-robot commented Mar 11, 2025

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

------ Round 1 ----------------------------------
q1	17637	5147	5070	5070
q2	2058	297	172	172
q3	10579	1322	695	695
q4	10257	1024	514	514
q5	7830	2321	2468	2321
q6	187	167	134	134
q7	887	735	612	612
q8	9303	1314	1129	1129
q9	4928	4783	4916	4783
q10	6813	2309	1917	1917
q11	480	269	252	252
q12	337	351	213	213
q13	17762	3692	3069	3069
q14	224	222	205	205
q15	540	479	488	479
q16	617	600	606	600
q17	591	858	352	352
q18	6964	6401	6364	6364
q19	1209	969	559	559
q20	322	319	201	201
q21	2854	2107	1913	1913
q22	1085	1043	964	964
Total cold run time: 103464 ms
Total hot run time: 32518 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5142	5139	5134	5134
q2	241	326	229	229
q3	2164	2705	2272	2272
q4	1413	1854	1398	1398
q5	4222	4098	4122	4098
q6	213	165	123	123
q7	1865	1967	1778	1778
q8	2664	2786	2600	2600
q9	7229	7357	7132	7132
q10	2981	3218	2758	2758
q11	585	506	506	506
q12	693	745	611	611
q13	3556	3873	3308	3308
q14	287	292	261	261
q15	526	494	480	480
q16	657	679	651	651
q17	1145	1605	1375	1375
q18	7773	7595	7384	7384
q19	834	869	952	869
q20	1960	2037	1835	1835
q21	5312	4950	4948	4948
q22	1127	1037	1017	1017
Total cold run time: 52589 ms
Total hot run time: 50767 ms

@doris-robot

doris-robot commented Mar 11, 2025

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

query1	1404	1041	986	986
query2	6173	1992	1976	1976
query3	11173	4684	4633	4633
query4	26042	23960	22996	22996
query5	4770	690	510	510
query6	318	209	199	199
query7	4004	509	304	304
query8	303	263	240	240
query9	8529	2519	2542	2519
query10	436	289	259	259
query11	15451	15061	14930	14930
query12	155	105	104	104
query13	1550	507	396	396
query14	8738	6506	6964	6506
query15	201	197	164	164
query16	7216	654	489	489
query17	1138	734	602	602
query18	1968	439	324	324
query19	198	196	165	165
query20	123	125	123	123
query21	211	132	112	112
query22	4677	4793	4573	4573
query23	34514	33750	33418	33418
query24	7793	2507	2492	2492
query25	559	492	423	423
query26	1194	285	171	171
query27	2868	485	407	407
query28	5118	2441	2457	2441
query29	745	569	450	450
query30	278	222	198	198
query31	938	869	808	808
query32	74	62	65	62
query33	562	363	315	315
query34	806	873	531	531
query35	827	902	773	773
query36	993	1009	885	885
query37	116	106	105	105
query38	4229	4165	4081	4081
query39	1463	1460	1448	1448
query40	218	118	108	108
query41	55	53	50	50
query42	124	112	108	108
query43	517	524	498	498
query44	1354	804	800	800
query45	181	179	167	167
query46	885	1050	684	684
query47	1875	1877	1818	1818
query48	415	419	322	322
query49	759	514	424	424
query50	724	751	432	432
query51	4322	4350	4264	4264
query52	102	108	101	101
query53	246	271	197	197
query54	495	507	437	437
query55	83	80	83	80
query56	273	290	280	280
query57	1231	1216	1141	1141
query58	245	249	230	230
query59	2993	3054	2819	2819
query60	290	318	258	258
query61	125	121	124	121
query62	775	773	764	764
query63	249	198	196	196
query64	4323	1045	669	669
query65	4433	4336	4347	4336
query66	1026	395	289	289
query67	16203	15599	15808	15599
query68	8503	894	495	495
query69	483	301	259	259
query70	1214	1107	1109	1107
query71	464	290	260	260
query72	5740	3782	3786	3782
query73	771	750	351	351
query74	9096	9219	8930	8930
query75	3792	3194	2681	2681
query76	3754	1223	790	790
query77	794	377	285	285
query78	10187	10344	9387	9387
query79	2644	834	594	594
query80	628	525	457	457
query81	478	259	224	224
query82	728	128	96	96
query83	195	173	155	155
query84	246	98	74	74
query85	791	443	315	315
query86	376	319	278	278
query87	4534	4528	4370	4370
query88	3732	2280	2254	2254
query89	429	319	295	295
query90	1815	220	240	220
query91	139	140	118	118
query92	76	62	53	53
query93	1878	1069	588	588
query94	663	424	293	293
query95	358	277	265	265
query96	489	564	286	286
query97	3351	3345	3322	3322
query98	223	207	200	200
query99	1335	1412	1277	1277
Total cold run time: 282282 ms
Total hot run time: 193371 ms

@doris-robot

doris-robot commented Mar 11, 2025

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

query1	0.04	0.03	0.03
query2	0.07	0.03	0.04
query3	0.24	0.06	0.06
query4	1.62	0.10	0.11
query5	0.56	0.56	0.55
query6	1.20	0.72	0.72
query7	0.02	0.02	0.02
query8	0.04	0.03	0.04
query9	0.59	0.55	0.51
query10	0.58	0.59	0.58
query11	0.15	0.10	0.11
query12	0.14	0.12	0.11
query13	0.61	0.60	0.60
query14	2.70	2.80	2.83
query15	0.93	0.84	0.86
query16	0.40	0.39	0.38
query17	1.03	1.04	1.02
query18	0.21	0.20	0.20
query19	1.92	1.87	2.01
query20	0.01	0.01	0.01
query21	15.36	0.90	0.57
query22	0.75	1.18	0.60
query23	15.01	1.37	0.60
query24	6.83	2.14	0.52
query25	0.52	0.15	0.19
query26	0.62	0.16	0.14
query27	0.05	0.05	0.05
query28	8.75	0.89	0.44
query29	12.56	4.05	3.32
query30	0.25	0.09	0.06
query31	2.82	0.59	0.39
query32	3.22	0.55	0.47
query33	2.99	3.02	3.08
query34	15.90	5.19	4.55
query35	4.58	4.57	4.54
query36	0.70	0.49	0.48
query37	0.12	0.06	0.06
query38	0.04	0.03	0.04
query39	0.03	0.02	0.02
query40	0.17	0.14	0.13
query41	0.08	0.02	0.02
query42	0.04	0.02	0.02
query43	0.03	0.03	0.03
Total cold run time: 104.48 s
Total hot run time: 30.77 s

@xiedeyantu

xiedeyantu commented Mar 11, 2025

Copy link
Copy Markdown
Member Author

run buildall

@doris-robot

doris-robot commented Mar 11, 2025

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

------ Round 1 ----------------------------------
q1	17582	5183	4998	4998
q2	2042	303	173	173
q3	10396	1250	765	765
q4	10236	1003	535	535
q5	7504	2412	2344	2344
q6	193	160	130	130
q7	894	759	605	605
q8	9590	1297	1121	1121
q9	4910	4859	4770	4770
q10	6856	2331	1910	1910
q11	487	276	263	263
q12	350	356	217	217
q13	20492	3757	3210	3210
q14	223	232	210	210
q15	539	475	477	475
q16	617	626	585	585
q17	561	871	343	343
q18	6866	6546	6407	6407
q19	1302	965	543	543
q20	321	332	195	195
q21	2828	2175	1949	1949
q22	1025	1002	963	963
Total cold run time: 105814 ms
Total hot run time: 32711 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5173	5190	5193	5190
q2	241	333	231	231
q3	2141	2645	2418	2418
q4	1521	1882	1452	1452
q5	4420	4336	4381	4336
q6	217	172	131	131
q7	2061	2023	1798	1798
q8	2726	2625	2635	2625
q9	7546	7316	7155	7155
q10	3041	3242	2793	2793
q11	577	511	482	482
q12	643	759	584	584
q13	3596	3918	3252	3252
q14	269	290	282	282
q15	504	474	502	474
q16	661	680	632	632
q17	1151	1587	1370	1370
q18	7762	7488	7497	7488
q19	817	858	932	858
q20	1962	2026	1880	1880
q21	5368	4931	4730	4730
q22	1082	1033	1012	1012
Total cold run time: 53479 ms
Total hot run time: 51173 ms

@doris-robot

doris-robot commented Mar 11, 2025

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

query1	1393	1006	973	973
query2	6336	1926	1930	1926
query3	10978	4483	4503	4483
query4	55813	26019	23205	23205
query5	5137	580	481	481
query6	369	207	195	195
query7	4982	522	292	292
query8	319	259	242	242
query9	6431	2657	2659	2657
query10	430	323	259	259
query11	15257	15033	15328	15033
query12	171	110	111	110
query13	1144	517	389	389
query14	10349	6568	6757	6568
query15	208	214	188	188
query16	7189	670	495	495
query17	1083	748	596	596
query18	1629	423	347	347
query19	207	199	170	170
query20	132	127	118	118
query21	214	122	108	108
query22	4392	4482	4287	4287
query23	33945	33291	33417	33291
query24	6183	2443	2479	2443
query25	465	455	394	394
query26	717	276	159	159
query27	2057	491	334	334
query28	3002	2498	2454	2454
query29	645	575	436	436
query30	278	219	187	187
query31	883	854	815	815
query32	70	63	60	60
query33	460	367	297	297
query34	821	864	518	518
query35	812	830	754	754
query36	942	1022	909	909
query37	122	101	79	79
query38	4228	4176	4174	4174
query39	1493	1447	1463	1447
query40	214	124	107	107
query41	57	52	53	52
query42	125	109	107	107
query43	515	508	485	485
query44	1344	811	811	811
query45	186	174	161	161
query46	873	1056	657	657
query47	1840	1854	1767	1767
query48	390	428	308	308
query49	736	504	406	406
query50	739	785	426	426
query51	4225	4324	4241	4241
query52	104	107	107	107
query53	242	274	193	193
query54	491	542	430	430
query55	85	83	87	83
query56	279	279	246	246
query57	1183	1190	1079	1079
query58	253	234	257	234
query59	2708	2732	2807	2732
query60	297	283	256	256
query61	118	119	114	114
query62	758	730	669	669
query63	253	200	199	199
query64	2218	1034	698	698
query65	4557	4454	4498	4454
query66	851	408	299	299
query67	15604	15591	15236	15236
query68	7954	877	501	501
query69	537	303	259	259
query70	1152	1082	1109	1082
query71	494	299	285	285
query72	5923	3706	3409	3409
query73	1194	762	343	343
query74	9115	9072	9087	9072
query75	3824	3184	2711	2711
query76	4180	1183	747	747
query77	624	347	285	285
query78	9919	10129	9294	9294
query79	2480	840	598	598
query80	656	572	447	447
query81	475	266	218	218
query82	471	125	91	91
query83	285	169	159	159
query84	281	96	78	78
query85	799	349	335	335
query86	354	310	285	285
query87	4504	4560	4335	4335
query88	3257	2281	2280	2280
query89	411	395	287	287
query90	1958	212	211	211
query91	145	142	108	108
query92	71	57	59	57
query93	1219	1063	585	585
query94	709	399	308	308
query95	349	268	260	260
query96	481	578	282	282
query97	3333	3414	3272	3272
query98	221	206	198	198
query99	1450	1444	1311	1311
Total cold run time: 301356 ms
Total hot run time: 192123 ms

@doris-robot

doris-robot commented Mar 11, 2025

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

query1	0.04	0.03	0.03
query2	0.07	0.04	0.03
query3	0.24	0.07	0.07
query4	1.62	0.10	0.10
query5	0.56	0.54	0.55
query6	1.19	0.71	0.72
query7	0.02	0.02	0.01
query8	0.05	0.03	0.03
query9	0.59	0.52	0.52
query10	0.60	0.58	0.60
query11	0.16	0.11	0.10
query12	0.14	0.12	0.11
query13	0.61	0.60	0.60
query14	2.80	2.71	2.67
query15	0.92	0.85	0.85
query16	0.39	0.39	0.38
query17	1.04	1.01	1.02
query18	0.22	0.20	0.20
query19	1.96	1.80	2.00
query20	0.01	0.01	0.01
query21	15.36	0.92	0.56
query22	0.74	1.18	0.62
query23	14.99	1.40	0.62
query24	6.95	1.72	0.97
query25	0.55	0.24	0.19
query26	0.64	0.17	0.13
query27	0.05	0.05	0.06
query28	9.42	0.91	0.44
query29	12.57	4.06	3.32
query30	0.25	0.09	0.06
query31	2.83	0.57	0.38
query32	3.23	0.54	0.46
query33	2.96	3.06	3.01
query34	15.73	5.18	4.48
query35	4.53	4.54	4.51
query36	0.65	0.49	0.47
query37	0.09	0.06	0.07
query38	0.05	0.04	0.04
query39	0.03	0.02	0.03
query40	0.16	0.13	0.13
query41	0.08	0.02	0.02
query42	0.03	0.03	0.02
query43	0.03	0.03	0.03
Total cold run time: 105.15 s
Total hot run time: 30.94 s

@xiedeyantu

xiedeyantu commented Mar 12, 2025

Copy link
Copy Markdown
Member Author

run buildall

@doris-robot

doris-robot commented Mar 12, 2025

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

------ Round 1 ----------------------------------
q1	17595	5231	5118	5118
q2	2037	300	164	164
q3	10409	1314	705	705
q4	10219	1000	553	553
q5	7505	2439	2334	2334
q6	184	163	132	132
q7	906	717	616	616
q8	9293	1287	1051	1051
q9	4925	4770	4808	4770
q10	6866	2305	1884	1884
q11	473	274	252	252
q12	338	355	217	217
q13	17776	3762	3098	3098
q14	245	220	206	206
q15	533	493	479	479
q16	626	624	567	567
q17	577	854	336	336
q18	6986	6537	6368	6368
q19	1095	945	538	538
q20	306	350	203	203
q21	2941	2090	1966	1966
q22	1036	1038	1012	1012
Total cold run time: 102871 ms
Total hot run time: 32569 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5165	5153	5120	5120
q2	236	329	229	229
q3	2169	2648	2304	2304
q4	1464	1833	1389	1389
q5	4263	4135	4172	4135
q6	203	163	125	125
q7	1883	1920	1808	1808
q8	2570	2592	2596	2592
q9	7381	7116	7160	7116
q10	3038	3215	2772	2772
q11	575	497	487	487
q12	698	819	622	622
q13	3478	3963	3248	3248
q14	279	299	262	262
q15	502	470	464	464
q16	644	700	639	639
q17	1125	1608	1336	1336
q18	7770	7651	7436	7436
q19	791	769	817	769
q20	1929	2030	1861	1861
q21	5430	4991	5008	4991
q22	1160	1090	1028	1028
Total cold run time: 52753 ms
Total hot run time: 50733 ms

@doris-robot

doris-robot commented Mar 12, 2025

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

query1	1005	396	377	377
query2	6535	1908	1869	1869
query3	6800	220	220	220
query4	26512	23765	23377	23377
query5	4880	659	481	481
query6	295	197	189	189
query7	4602	497	294	294
query8	299	253	258	253
query9	8637	2622	2630	2622
query10	486	319	265	265
query11	15707	15246	14982	14982
query12	164	111	108	108
query13	1655	539	406	406
query14	9647	6492	6959	6492
query15	208	194	175	175
query16	7587	653	494	494
query17	1297	703	572	572
query18	1973	407	308	308
query19	194	191	169	169
query20	124	121	117	117
query21	206	125	107	107
query22	4184	4030	4243	4030
query23	33910	32936	33024	32936
query24	7449	2374	2371	2371
query25	530	439	384	384
query26	1205	270	153	153
query27	2430	473	328	328
query28	4253	2439	2378	2378
query29	711	536	452	452
query30	291	213	190	190
query31	954	840	766	766
query32	75	65	67	65
query33	554	367	319	319
query34	801	846	511	511
query35	772	823	732	732
query36	942	985	906	906
query37	118	102	78	78
query38	4168	4105	4072	4072
query39	1483	1435	1387	1387
query40	207	121	102	102
query41	55	52	50	50
query42	119	102	104	102
query43	481	516	470	470
query44	1325	776	779	776
query45	206	170	164	164
query46	827	1034	630	630
query47	1727	1789	1725	1725
query48	380	413	305	305
query49	783	491	434	434
query50	713	726	414	414
query51	4195	4244	4152	4152
query52	107	101	98	98
query53	238	264	195	195
query54	493	501	408	408
query55	86	80	81	80
query56	263	270	269	269
query57	1117	1131	1077	1077
query58	246	239	266	239
query59	2565	2607	2555	2555
query60	291	285	272	272
query61	127	126	156	126
query62	787	731	657	657
query63	232	195	198	195
query64	4386	1018	678	678
query65	4429	4374	4374	4374
query66	1043	404	301	301
query67	15820	15254	15171	15171
query68	8312	886	511	511
query69	461	300	267	267
query70	1240	1100	1139	1100
query71	464	298	262	262
query72	5579	3600	3835	3600
query73	803	763	359	359
query74	8889	9198	8750	8750
query75	3812	3176	2705	2705
query76	3734	1183	756	756
query77	774	377	285	285
query78	9942	10279	9364	9364
query79	2347	821	591	591
query80	675	530	450	450
query81	466	261	225	225
query82	657	129	100	100
query83	184	168	155	155
query84	313	94	71	71
query85	781	366	314	314
query86	335	320	287	287
query87	4413	4492	4463	4463
query88	2927	2286	2293	2286
query89	398	312	287	287
query90	1936	222	223	222
query91	140	140	109	109
query92	82	59	57	57
query93	1129	1069	577	577
query94	684	405	306	306
query95	362	270	264	264
query96	494	554	331	331
query97	3402	3451	3259	3259
query98	220	203	209	203
query99	1424	1420	1300	1300
Total cold run time: 274270 ms
Total hot run time: 185770 ms

@doris-robot

doris-robot commented Mar 12, 2025

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

query1	0.04	0.03	0.03
query2	0.06	0.04	0.03
query3	0.24	0.06	0.06
query4	1.62	0.11	0.10
query5	0.57	0.54	0.54
query6	1.21	0.71	0.72
query7	0.02	0.02	0.01
query8	0.04	0.04	0.03
query9	0.59	0.52	0.51
query10	0.58	0.61	0.59
query11	0.16	0.11	0.10
query12	0.14	0.11	0.11
query13	0.61	0.61	0.59
query14	2.82	2.67	2.82
query15	0.93	0.84	0.83
query16	0.44	0.39	0.38
query17	0.99	1.02	1.03
query18	0.21	0.19	0.19
query19	1.97	1.79	2.03
query20	0.01	0.01	0.02
query21	15.36	0.92	0.53
query22	0.77	1.22	0.60
query23	14.93	1.41	0.59
query24	7.57	1.55	0.83
query25	0.54	0.16	0.09
query26	0.57	0.14	0.12
query27	0.05	0.05	0.05
query28	9.73	0.84	0.42
query29	12.54	3.97	3.29
query30	0.24	0.10	0.07
query31	2.81	0.58	0.38
query32	3.22	0.54	0.47
query33	3.06	3.06	3.06
query34	15.65	5.18	4.51
query35	4.55	4.61	4.55
query36	0.67	0.50	0.51
query37	0.10	0.06	0.06
query38	0.04	0.04	0.04
query39	0.03	0.03	0.02
query40	0.17	0.13	0.13
query41	0.08	0.02	0.03
query42	0.04	0.03	0.02
query43	0.04	0.03	0.04
Total cold run time: 106.01 s
Total hot run time: 30.68 s

@xiedeyantu

xiedeyantu commented Mar 12, 2025

Copy link
Copy Markdown
Member Author

run buildall

@doris-robot

doris-robot commented Mar 12, 2025

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

------ Round 1 ----------------------------------
q1	17597	5163	5090	5090
q2	2038	304	162	162
q3	10406	1243	748	748
q4	10203	1028	539	539
q5	7522	2343	2359	2343
q6	192	162	133	133
q7	901	757	618	618
q8	9311	1302	1182	1182
q9	4947	4811	4672	4672
q10	6803	2303	1862	1862
q11	473	275	257	257
q12	348	355	219	219
q13	17771	3718	3152	3152
q14	232	233	215	215
q15	532	475	478	475
q16	612	631	589	589
q17	605	857	337	337
q18	6819	6360	6302	6302
q19	1245	966	558	558
q20	327	349	208	208
q21	2919	2194	1977	1977
q22	1011	995	982	982
Total cold run time: 102814 ms
Total hot run time: 32620 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5201	5128	5114	5114
q2	236	324	232	232
q3	2147	2662	2318	2318
q4	1445	1813	1396	1396
q5	4289	4122	4163	4122
q6	205	165	126	126
q7	1889	1930	1742	1742
q8	2645	2635	2589	2589
q9	7218	7132	7111	7111
q10	3028	3235	2785	2785
q11	574	496	490	490
q12	726	802	620	620
q13	3478	4003	3297	3297
q14	275	290	266	266
q15	521	479	473	473
q16	625	706	664	664
q17	1151	1524	1401	1401
q18	7794	7522	7498	7498
q19	834	941	988	941
q20	1997	2061	1873	1873
q21	5626	4905	4766	4766
q22	1067	1064	1012	1012
Total cold run time: 52971 ms
Total hot run time: 50836 ms

@doris-robot

doris-robot commented Mar 12, 2025

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

query1	1408	1021	1000	1000
query2	6222	1897	1876	1876
query3	11017	4489	4387	4387
query4	25580	23740	22933	22933
query5	4534	673	497	497
query6	307	202	205	202
query7	4001	524	295	295
query8	321	266	266	266
query9	8513	2649	2643	2643
query10	479	318	265	265
query11	15837	15194	14823	14823
query12	172	110	111	110
query13	1570	535	401	401
query14	9711	6466	6975	6466
query15	225	201	180	180
query16	7630	687	512	512
query17	1501	784	588	588
query18	2124	425	323	323
query19	202	212	177	177
query20	130	133	125	125
query21	205	130	106	106
query22	4565	4414	4407	4407
query23	34448	33406	33209	33209
query24	7792	2458	2428	2428
query25	495	460	392	392
query26	859	290	166	166
query27	2203	524	345	345
query28	4238	2474	2440	2440
query29	611	578	440	440
query30	274	224	189	189
query31	926	860	788	788
query32	75	64	66	64
query33	562	376	306	306
query34	828	895	529	529
query35	819	900	781	781
query36	1031	1018	913	913
query37	130	97	73	73
query38	4170	4210	4163	4163
query39	1475	1424	1433	1424
query40	212	121	108	108
query41	53	52	49	49
query42	122	105	102	102
query43	528	527	498	498
query44	1390	817	813	813
query45	182	180	173	173
query46	880	1042	673	673
query47	1887	1844	1791	1791
query48	385	443	321	321
query49	723	508	423	423
query50	725	771	436	436
query51	4435	4355	4261	4261
query52	117	117	108	108
query53	250	273	204	204
query54	503	517	414	414
query55	81	80	84	80
query56	267	266	254	254
query57	1155	1206	1104	1104
query58	245	245	239	239
query59	2534	2757	2735	2735
query60	300	288	273	273
query61	127	138	158	138
query62	776	740	690	690
query63	240	191	209	191
query64	3218	1112	667	667
query65	4584	4494	4426	4426
query66	913	416	311	311
query67	16188	15310	15241	15241
query68	9786	901	499	499
query69	480	311	267	267
query70	1228	1149	1145	1145
query71	483	295	266	266
query72	5140	3519	3743	3519
query73	802	740	369	369
query74	8963	9394	8678	8678
query75	4362	3128	2661	2661
query76	4712	1188	866	866
query77	1010	380	280	280
query78	9970	10088	9234	9234
query79	2444	892	581	581
query80	695	528	459	459
query81	486	258	224	224
query82	664	124	91	91
query83	192	169	157	157
query84	287	94	78	78
query85	782	357	307	307
query86	343	302	302	302
query87	4479	4491	4402	4402
query88	3236	2274	2262	2262
query89	408	313	284	284
query90	1906	224	221	221
query91	137	140	108	108
query92	69	61	57	57
query93	1225	1059	591	591
query94	666	405	303	303
query95	350	270	264	264
query96	490	559	279	279
query97	3294	3356	3320	3320
query98	218	204	200	200
query99	1453	1381	1283	1283
Total cold run time: 280970 ms
Total hot run time: 191512 ms

@doris-robot

doris-robot commented Mar 12, 2025

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

query1	0.04	0.03	0.03
query2	0.07	0.03	0.03
query3	0.23	0.06	0.06
query4	1.61	0.10	0.11
query5	0.56	0.54	0.55
query6	1.20	0.70	0.71
query7	0.02	0.02	0.02
query8	0.04	0.03	0.03
query9	0.60	0.51	0.52
query10	0.57	0.59	0.58
query11	0.15	0.11	0.11
query12	0.15	0.11	0.11
query13	0.61	0.61	0.59
query14	2.81	2.81	2.74
query15	0.90	0.86	0.85
query16	0.38	0.38	0.38
query17	1.01	1.02	1.02
query18	0.21	0.20	0.20
query19	1.92	1.81	1.96
query20	0.01	0.01	0.02
query21	15.38	0.90	0.57
query22	0.75	1.11	0.66
query23	15.02	1.39	0.59
query24	6.61	2.25	1.47
query25	0.51	0.20	0.12
query26	0.65	0.16	0.14
query27	0.05	0.04	0.04
query28	9.81	0.81	0.43
query29	12.55	3.90	3.25
query30	0.25	0.10	0.07
query31	2.81	0.61	0.40
query32	3.23	0.55	0.47
query33	3.01	3.02	3.02
query34	15.81	5.14	4.51
query35	4.52	4.50	4.50
query36	0.69	0.48	0.47
query37	0.09	0.06	0.06
query38	0.05	0.04	0.04
query39	0.03	0.02	0.02
query40	0.17	0.12	0.13
query41	0.08	0.03	0.03
query42	0.03	0.02	0.02
query43	0.04	0.03	0.03
Total cold run time: 105.23 s
Total hot run time: 31.45 s

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

github-actions Bot commented Mar 13, 2025

Copy link
Copy Markdown
Contributor

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

@github-actions

github-actions Bot commented Mar 13, 2025

Copy link
Copy Markdown
Contributor

PR approved by anyone and no changes requested.

@starocean999
starocean999 merged commit a9921a2 into apache:master Mar 13, 2025
koarz pushed a commit to koarz/doris that referenced this pull request Jun 4, 2025
@xiedeyantu koarz
[Feat](Nereids) support show views command (apache#48905)
768ae66
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

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

Assignees

No one assigned

Labels

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

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

5 participants

@xiedeyantu @Thearas @doris-robot @starocean999 @LiBinfeng-01