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 alterCatalogRenameCommand in nereids #45163

Merged
merged 3 commits into from
Jan 2, 2025
Merged

[Enhancement] (nereids)implement alterCatalogRenameCommand in nereids #45163

merged 3 commits into from
Jan 2, 2025

Conversation

msridhar78
Copy link
Contributor

@msridhar78 msridhar78 commented Dec 8, 2024 •
edited
Loading

What problem does this PR solve?

Issue Number: close #42788

Related PR: #xxx

Problem Summary:
[Enhancement] (nereids)implement alterCatalogRenameCommand in nereids

Release note

None

Check List (For Author)

  • Test

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

  • Behavior changed:

    • No.
    • Yes.

  • Does this need documentation?

    • No.
    • Yes.

Check List (For Reviewer who merge this PR)

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

@doris-robot
Copy link

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

Please clearly describe your PR:

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

@msridhar78
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17567	7462	7314	7314
q2	2047	181	172	172
q3	10637	1087	1132	1087
q4	10568	780	690	690
q5	7599	2768	2750	2750
q6	236	146	150	146
q7	998	639	604	604
q8	9248	1856	1939	1856
q9	6677	6506	6476	6476
q10	6990	2334	2339	2334
q11	476	266	262	262
q12	425	221	225	221
q13	17786	3024	3005	3005
q14	242	203	208	203
q15	579	514	529	514
q16	659	588	589	588
q17	968	587	505	505
q18	7225	6636	6626	6626
q19	1331	1012	908	908
q20	464	179	180	179
q21	4015	3306	3185	3185
q22	384	312	322	312
Total cold run time: 107121 ms
Total hot run time: 39937 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7314	7248	7257	7248
q2	327	234	233	233
q3	2872	2790	2940	2790
q4	2029	1826	1797	1797
q5	5651	5643	5637	5637
q6	225	141	142	141
q7	2257	1778	1824	1778
q8	3345	3574	3464	3464
q9	9081	9044	9105	9044
q10	3564	3566	3567	3566
q11	604	541	496	496
q12	802	590	589	589
q13	12205	3269	3201	3201
q14	303	280	283	280
q15	587	527	534	527
q16	676	645	655	645
q17	1882	1606	1627	1606
q18	8460	7837	7460	7460
q19	2037	1540	1591	1540
q20	2146	1886	1844	1844
q21	5705	5510	5465	5465
q22	674	592	563	563
Total cold run time: 72746 ms
Total hot run time: 59914 ms

@doris-robot
Copy link

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

query1	1238	972	915	915
query2	6226	2107	2012	2012
query3	10994	4301	4485	4301
query4	66439	28633	23533	23533
query5	5023	465	456	456
query6	422	186	178	178
query7	5472	300	293	293
query8	331	230	230	230
query9	8583	2633	2621	2621
query10	439	242	235	235
query11	17486	15275	15801	15275
query12	175	103	103	103
query13	1508	420	399	399
query14	10112	6531	6733	6531
query15	213	196	188	188
query16	7226	465	447	447
query17	1087	580	581	580
query18	1909	322	305	305
query19	206	179	161	161
query20	119	114	115	114
query21	213	111	106	106
query22	5030	4585	4815	4585
query23	34772	34257	34316	34257
query24	5926	2625	2409	2409
query25	474	389	379	379
query26	650	150	150	150
query27	2374	279	285	279
query28	4722	2483	2457	2457
query29	683	439	409	409
query30	208	150	143	143
query31	1004	857	845	845
query32	69	58	57	57
query33	422	284	309	284
query34	922	511	523	511
query35	883	761	745	745
query36	1091	975	947	947
query37	121	79	76	76
query38	4502	4428	4300	4300
query39	1526	1486	1495	1486
query40	204	97	99	97
query41	43	40	46	40
query42	111	94	96	94
query43	555	491	498	491
query44	1192	810	831	810
query45	194	169	167	167
query46	1180	727	717	717
query47	2077	1924	1972	1924
query48	421	322	317	317
query49	719	417	387	387
query50	838	420	387	387
query51	7419	7133	6930	6930
query52	99	87	86	86
query53	250	178	185	178
query54	497	417	385	385
query55	75	74	79	74
query56	262	229	234	229
query57	1263	1134	1117	1117
query58	211	205	226	205
query59	3115	3056	3027	3027
query60	260	235	235	235
query61	110	137	119	119
query62	782	680	672	672
query63	212	187	183	183
query64	1401	662	636	636
query65	3282	3190	3215	3190
query66	705	301	297	297
query67	15977	15655	15599	15599
query68	4179	586	571	571
query69	408	248	244	244
query70	1221	1120	1169	1120
query71	339	248	241	241
query72	6432	4031	4023	4023
query73	751	347	348	347
query74	10066	9189	9174	9174
query75	3394	2660	2701	2660
query76	2001	1071	1039	1039
query77	482	276	270	270
query78	10441	9467	9487	9467
query79	1240	599	600	599
query80	736	431	427	427
query81	499	224	237	224
query82	1328	118	116	116
query83	168	141	147	141
query84	353	70	70	70
query85	784	293	304	293
query86	313	306	293	293
query87	4739	4782	4586	4586
query88	3324	2163	2118	2118
query89	423	287	297	287
query90	2093	183	178	178
query91	135	99	100	99
query92	57	48	47	47
query93	1252	542	550	542
query94	762	291	282	282
query95	341	245	247	245
query96	603	277	271	271
query97	2865	2703	2672	2672
query98	210	187	191	187
query99	1806	1321	1305	1305
Total cold run time: 317999 ms
Total hot run time: 196033 ms

@doris-robot
Copy link

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

query1	0.03	0.04	0.03
query2	0.07	0.03	0.03
query3	0.23	0.07	0.07
query4	1.62	0.11	0.11
query5	0.41	0.40	0.40
query6	1.15	0.66	0.64
query7	0.02	0.02	0.01
query8	0.04	0.03	0.03
query9	0.58	0.52	0.52
query10	0.55	0.56	0.55
query11	0.14	0.11	0.11
query12	0.13	0.12	0.11
query13	0.61	0.62	0.60
query14	2.85	2.81	2.72
query15	0.90	0.83	0.82
query16	0.39	0.39	0.39
query17	1.04	1.06	1.06
query18	0.23	0.21	0.20
query19	1.90	1.88	2.00
query20	0.02	0.01	0.01
query21	15.35	0.60	0.61
query22	3.01	2.46	1.72
query23	17.17	0.95	0.73
query24	3.05	1.80	1.54
query25	0.36	0.13	0.15
query26	0.44	0.14	0.13
query27	0.04	0.05	0.04
query28	9.58	1.10	1.06
query29	12.60	3.22	3.20
query30	0.25	0.07	0.07
query31	2.87	0.39	0.40
query32	3.24	0.47	0.47
query33	2.99	3.11	3.03
query34	17.23	4.44	4.43
query35	4.46	4.49	4.48
query36	0.65	0.49	0.48
query37	0.08	0.06	0.06
query38	0.05	0.04	0.03
query39	0.03	0.02	0.03
query40	0.17	0.13	0.14
query41	0.08	0.02	0.02
query42	0.03	0.02	0.02
query43	0.04	0.03	0.03
Total cold run time: 106.68 s
Total hot run time: 33.1 s

@starocean999
Copy link
Contributor

please refer comments of #45160

@msridhar78
Copy link
Contributor Author

run buildall

@msridhar78
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17639	7931	7286	7286
q2	2042	187	176	176
q3	10630	1087	1168	1087
q4	10560	683	752	683
q5	7597	2689	2627	2627
q6	232	149	145	145
q7	967	610	603	603
q8	9231	1833	1924	1833
q9	6502	6354	6398	6354
q10	7049	2272	2303	2272
q11	464	269	265	265
q12	423	227	227	227
q13	17783	2955	2919	2919
q14	253	216	204	204
q15	552	504	510	504
q16	668	592	579	579
q17	970	493	510	493
q18	7213	6692	6648	6648
q19	1354	998	1088	998
q20	460	186	183	183
q21	4042	3286	3197	3197
q22	383	313	308	308
Total cold run time: 107014 ms
Total hot run time: 39591 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7219	7209	7199	7199
q2	330	226	226	226
q3	2884	2809	2882	2809
q4	2060	1875	1832	1832
q5	5681	5671	5626	5626
q6	225	148	143	143
q7	2250	1811	1807	1807
q8	3392	3558	3475	3475
q9	8766	9029	8882	8882
q10	3576	3519	3539	3519
q11	600	525	503	503
q12	825	591	596	591
q13	13776	3061	3125	3061
q14	318	274	300	274
q15	562	531	515	515
q16	682	628	662	628
q17	1832	1607	1649	1607
q18	8385	7961	7700	7700
q19	1727	1540	1507	1507
q20	2072	1877	1880	1877
q21	5691	5566	5540	5540
q22	660	579	608	579
Total cold run time: 73513 ms
Total hot run time: 59900 ms

@doris-robot
Copy link

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

query1	1289	947	917	917
query2	6246	2257	2279	2257
query3	10996	4485	4492	4485
query4	33391	23565	23554	23554
query5	4046	471	458	458
query6	284	182	196	182
query7	3991	304	310	304
query8	312	249	240	240
query9	9534	2715	2722	2715
query10	477	258	250	250
query11	17655	15281	15430	15281
query12	150	101	102	101
query13	1558	419	402	402
query14	9810	7225	7862	7225
query15	257	184	193	184
query16	8300	441	414	414
query17	1593	594	585	585
query18	2157	304	315	304
query19	372	154	163	154
query20	125	116	115	115
query21	209	115	110	110
query22	4697	4423	4468	4423
query23	34688	33907	33886	33886
query24	10338	2621	2539	2539
query25	630	410	384	384
query26	1186	159	156	156
query27	2297	337	352	337
query28	7409	2440	2437	2437
query29	849	436	427	427
query30	235	164	155	155
query31	1043	837	846	837
query32	104	60	59	59
query33	767	297	318	297
query34	1058	511	519	511
query35	936	756	768	756
query36	1134	988	964	964
query37	146	84	83	83
query38	4319	4252	4207	4207
query39	1541	1460	1454	1454
query40	215	110	142	110
query41	45	42	44	42
query42	115	107	107	107
query43	559	500	481	481
query44	1319	856	835	835
query45	193	179	175	175
query46	1189	715	734	715
query47	2052	1894	1937	1894
query48	416	325	325	325
query49	907	404	396	396
query50	876	407	401	401
query51	7372	7266	7255	7255
query52	100	93	90	90
query53	273	183	184	183
query54	1150	415	421	415
query55	95	79	79	79
query56	257	244	254	244
query57	1298	1173	1154	1154
query58	231	229	222	222
query59	3290	3108	3092	3092
query60	297	254	258	254
query61	113	110	132	110
query62	875	707	692	692
query63	237	238	186	186
query64	4506	710	679	679
query65	3351	3241	3307	3241
query66	740	306	311	306
query67	16620	15579	15489	15489
query68	5918	549	532	532
query69	516	254	256	254
query70	1204	1132	1128	1128
query71	469	260	261	260
query72	7122	4087	4044	4044
query73	786	356	355	355
query74	10060	8776	8802	8776
query75	3656	2694	2679	2679
query76	3884	1104	1108	1104
query77	590	283	264	264
query78	10237	9447	9368	9368
query79	1904	597	582	582
query80	686	432	446	432
query81	509	239	235	235
query82	684	119	155	119
query83	181	148	157	148
query84	237	73	77	73
query85	1348	306	295	295
query86	436	305	293	293
query87	4511	4413	4319	4319
query88	3695	2220	2191	2191
query89	439	286	289	286
query90	1925	191	190	190
query91	139	114	105	105
query92	67	51	49	49
query93	2231	540	538	538
query94	744	283	289	283
query95	352	254	247	247
query96	641	280	283	280
query97	2859	2713	2721	2713
query98	218	200	196	196
query99	1572	1340	1349	1340
Total cold run time: 304640 ms
Total hot run time: 196999 ms

@doris-robot
Copy link

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

query1	0.03	0.03	0.03
query2	0.06	0.04	0.03
query3	0.24	0.07	0.08
query4	1.61	0.10	0.11
query5	0.43	0.39	0.39
query6	1.15	0.66	0.65
query7	0.02	0.02	0.01
query8	0.04	0.04	0.02
query9	0.58	0.50	0.50
query10	0.55	0.58	0.55
query11	0.14	0.10	0.10
query12	0.15	0.11	0.11
query13	0.61	0.60	0.59
query14	2.74	2.79	2.86
query15	0.90	0.82	0.82
query16	0.39	0.38	0.38
query17	1.04	1.06	1.04
query18	0.22	0.22	0.21
query19	1.96	1.88	2.00
query20	0.02	0.01	0.01
query21	15.36	0.59	0.59
query22	2.26	2.02	2.25
query23	16.91	1.06	0.85
query24	3.26	0.65	2.00
query25	0.22	0.13	0.08
query26	0.51	0.14	0.14
query27	0.04	0.04	0.05
query28	10.08	1.11	1.08
query29	12.60	3.29	3.23
query30	0.25	0.06	0.06
query31	2.85	0.39	0.40
query32	3.25	0.46	0.46
query33	3.15	3.11	3.15
query34	16.83	4.44	4.46
query35	4.48	4.46	4.47
query36	0.69	0.49	0.48
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.13	0.13
query41	0.08	0.03	0.03
query42	0.04	0.03	0.02
query43	0.04	0.03	0.03
Total cold run time: 106.1 s
Total hot run time: 32.68 s

starocean999
starocean999 previously approved these changes Dec 19, 2024
View reviewed changes
@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.

englefly
englefly previously approved these changes Dec 19, 2024
View reviewed changes
@msridhar78 msridhar78 dismissed stale reviews from englefly and starocean999 via 2a50fbb December 20, 2024 03:48
@msridhar78
Copy link
Contributor Author

run buildall

@github-actions github-actions bot removed the approved Indicates a PR has been approved by one committer. label Dec 20, 2024
@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17587	7395	7289	7289
q2	2068	185	176	176
q3	10577	1077	1154	1077
q4	10559	730	772	730
q5	7598	2669	2706	2669
q6	235	151	148	148
q7	1004	626	594	594
q8	9276	1866	1876	1866
q9	6792	6472	6463	6463
q10	7014	2274	2368	2274
q11	475	260	262	260
q12	417	218	215	215
q13	17803	2946	3023	2946
q14	249	214	206	206
q15	577	526	511	511
q16	684	580	584	580
q17	970	588	499	499
q18	7211	6757	6560	6560
q19	1350	1019	1061	1019
q20	463	185	183	183
q21	4130	3198	3197	3197
q22	381	325	319	319
Total cold run time: 107420 ms
Total hot run time: 39781 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7244	7272	7238	7238
q2	332	233	229	229
q3	2922	2826	2950	2826
q4	2050	1837	1797	1797
q5	5707	5658	5601	5601
q6	228	138	145	138
q7	2228	1833	1885	1833
q8	3386	3506	3494	3494
q9	8900	9023	8981	8981
q10	3594	3544	3550	3544
q11	614	493	520	493
q12	840	618	586	586
q13	12867	3157	3165	3157
q14	317	267	276	267
q15	553	528	507	507
q16	709	659	653	653
q17	1829	1616	1612	1612
q18	8365	7899	7771	7771
q19	1767	1501	1516	1501
q20	2079	1906	1851	1851
q21	5623	5588	5460	5460
q22	640	621	594	594
Total cold run time: 72794 ms
Total hot run time: 60133 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 196958 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 2a50fbb6e084fbd5c8544b4c8e5735fbb8d03296, data reload: false

query1	1347	963	903	903
query2	6221	2294	2403	2294
query3	11026	4523	4598	4523
query4	33037	23485	23426	23426
query5	4768	479	456	456
query6	294	209	193	193
query7	3995	302	320	302
query8	310	237	237	237
query9	9345	2721	2708	2708
query10	479	236	238	236
query11	18019	15027	15083	15027
query12	158	105	101	101
query13	1560	423	404	404
query14	9905	7081	7046	7046
query15	263	209	199	199
query16	8225	458	450	450
query17	1529	589	603	589
query18	2166	322	321	321
query19	309	158	165	158
query20	122	119	117	117
query21	209	117	108	108
query22	4726	4825	4387	4387
query23	35563	34233	34188	34188
query24	10345	2526	2478	2478
query25	625	395	425	395
query26	1327	158	154	154
query27	2698	337	344	337
query28	7559	2457	2472	2457
query29	845	430	433	430
query30	234	156	149	149
query31	1063	836	844	836
query32	98	59	58	58
query33	783	347	294	294
query34	1016	530	527	527
query35	922	774	783	774
query36	1097	984	978	978
query37	149	73	72	72
query38	4293	4128	4234	4128
query39	1515	1472	1450	1450
query40	217	108	106	106
query41	47	44	46	44
query42	119	103	103	103
query43	556	487	516	487
query44	1310	846	850	846
query45	200	172	174	172
query46	1163	735	722	722
query47	2040	1932	1939	1932
query48	432	331	329	329
query49	992	405	418	405
query50	840	412	403	403
query51	7302	7258	7327	7258
query52	108	100	102	100
query53	275	190	193	190
query54	1061	442	426	426
query55	90	83	90	83
query56	270	254	269	254
query57	1319	1177	1191	1177
query58	244	229	223	223
query59	3351	3186	3197	3186
query60	279	259	265	259
query61	138	107	105	105
query62	871	657	656	656
query63	222	192	190	190
query64	4112	667	637	637
query65	3236	3175	3216	3175
query66	717	296	312	296
query67	15978	15584	15538	15538
query68	4801	563	545	545
query69	417	270	270	270
query70	1182	1148	1162	1148
query71	390	254	258	254
query72	6562	4146	4129	4129
query73	807	369	370	369
query74	9737	8937	8781	8781
query75	3417	2652	2658	2652
query76	2780	1150	1052	1052
query77	396	278	295	278
query78	10469	9487	9390	9390
query79	2142	626	618	618
query80	953	433	433	433
query81	573	254	235	235
query82	991	125	120	120
query83	273	148	154	148
query84	235	75	72	72
query85	1277	324	311	311
query86	437	298	312	298
query87	4520	4512	4322	4322
query88	3802	2209	2189	2189
query89	425	352	294	294
query90	1911	189	189	189
query91	143	105	104	104
query92	65	52	52	52
query93	2526	546	540	540
query94	762	284	290	284
query95	352	257	257	257
query96	615	275	285	275
query97	2793	2656	2709	2656
query98	227	205	194	194
query99	1619	1322	1307	1307
Total cold run time: 303233 ms
Total hot run time: 196958 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 2a50fbb6e084fbd5c8544b4c8e5735fbb8d03296, data reload: false

query1	0.04	0.03	0.03
query2	0.08	0.04	0.03
query3	0.24	0.07	0.07
query4	1.60	0.10	0.10
query5	0.45	0.41	0.41
query6	1.16	0.66	0.65
query7	0.02	0.01	0.01
query8	0.04	0.04	0.04
query9	0.58	0.52	0.51
query10	0.56	0.58	0.55
query11	0.14	0.11	0.11
query12	0.14	0.12	0.10
query13	0.61	0.60	0.60
query14	2.85	2.73	2.73
query15	0.91	0.82	0.83
query16	0.39	0.39	0.39
query17	1.07	1.07	1.04
query18	0.23	0.21	0.21
query19	1.98	1.83	2.04
query20	0.02	0.02	0.01
query21	15.36	0.56	0.58
query22	2.87	2.17	1.81
query23	17.00	0.90	0.76
query24	3.04	1.15	1.54
query25	0.23	0.24	0.05
query26	0.56	0.14	0.13
query27	0.05	0.04	0.04
query28	10.20	1.10	1.07
query29	12.58	3.30	3.26
query30	0.25	0.07	0.06
query31	2.84	0.39	0.38
query32	3.24	0.46	0.46
query33	3.05	3.18	3.13
query34	16.98	4.47	4.43
query35	4.50	4.44	4.46
query36	0.66	0.47	0.49
query37	0.09	0.07	0.06
query38	0.05	0.04	0.03
query39	0.03	0.03	0.02
query40	0.17	0.13	0.12
query41	0.08	0.02	0.03
query42	0.04	0.03	0.02
query43	0.03	0.02	0.03
Total cold run time: 107.01 s
Total hot run time: 32.73 s

@msridhar78
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17796	8096	7826	7826
q2	2040	194	197	194
q3	10589	1184	1229	1184
q4	10260	810	790	790
q5	7643	2960	2888	2888
q6	254	149	145	145
q7	1073	632	602	602
q8	9248	1965	1991	1965
q9	7051	6817	6816	6816
q10	7014	2407	2357	2357
q11	473	259	271	259
q12	462	234	224	224
q13	17789	2900	2998	2900
q14	244	220	209	209
q15	553	510	492	492
q16	663	587	603	587
q17	1038	628	602	602
q18	7440	6722	6885	6722
q19	1355	1049	982	982
q20	493	186	181	181
q21	4281	3385	3413	3385
q22	393	311	326	311
Total cold run time: 108152 ms
Total hot run time: 41621 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7813	7786	7873	7786
q2	350	232	231	231
q3	3032	2912	2850	2850
q4	2078	1815	1701	1701
q5	5508	5388	5525	5388
q6	251	142	138	138
q7	2207	1762	1712	1712
q8	3494	3692	3719	3692
q9	8809	8754	8823	8754
q10	3627	3560	3530	3530
q11	621	494	500	494
q12	801	569	580	569
q13	11764	2972	2975	2972
q14	288	260	262	260
q15	565	499	496	496
q16	678	654	650	650
q17	1965	1696	1646	1646
q18	7954	7373	7557	7373
q19	1877	1776	1717	1717
q20	2111	1877	1808	1808
q21	5681	5443	5394	5394
q22	656	585	582	582
Total cold run time: 72130 ms
Total hot run time: 59743 ms

@doris-robot
Copy link

TPC-DS: Total hot run time: 191216 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 0670ddc8f9347bf84cc55b8e5906ef9f966165c3, data reload: false

query1	983	395	392	392
query2	6538	2472	2343	2343
query3	6713	222	215	215
query4	33907	23342	23480	23342
query5	4335	463	453	453
query6	284	180	189	180
query7	4630	313	324	313
query8	309	240	242	240
query9	9677	2735	2729	2729
query10	476	276	245	245
query11	18008	15191	15412	15191
query12	156	111	106	106
query13	1673	431	425	425
query14	9906	7981	7444	7444
query15	334	178	189	178
query16	8203	444	462	444
query17	1746	571	564	564
query18	2139	296	304	296
query19	367	153	148	148
query20	115	107	110	107
query21	214	103	106	103
query22	4577	4310	4348	4310
query23	34429	33661	33517	33517
query24	11474	2607	2481	2481
query25	683	397	378	378
query26	1822	156	160	156
query27	2930	325	329	325
query28	7981	2414	2443	2414
query29	1037	401	406	401
query30	301	149	148	148
query31	1051	811	851	811
query32	93	57	57	57
query33	787	309	306	306
query34	995	524	513	513
query35	871	742	733	733
query36	1124	954	979	954
query37	284	79	76	76
query38	4218	4122	4064	4064
query39	1492	1450	1439	1439
query40	280	103	103	103
query41	51	46	47	46
query42	116	103	113	103
query43	540	513	511	511
query44	1235	831	834	831
query45	186	170	170	170
query46	1177	752	714	714
query47	1917	1832	1831	1831
query48	403	318	329	318
query49	1271	376	399	376
query50	804	383	393	383
query51	7053	7010	6923	6923
query52	102	94	93	93
query53	252	184	194	184
query54	1231	409	419	409
query55	83	86	78	78
query56	257	242	244	242
query57	1244	1126	1118	1118
query58	242	219	221	219
query59	3153	3023	3212	3023
query60	274	249	250	249
query61	110	105	105	105
query62	901	688	655	655
query63	216	197	198	197
query64	5102	653	640	640
query65	3298	3234	3267	3234
query66	1406	319	312	312
query67	16156	15550	15601	15550
query68	5188	553	562	553
query69	435	252	253	252
query70	1195	1195	1156	1156
query71	450	256	310	256
query72	6361	4001	4142	4001
query73	779	363	368	363
query74	10435	8930	8939	8930
query75	3521	2624	2649	2624
query76	3156	1157	1161	1157
query77	546	269	280	269
query78	10156	9360	9373	9360
query79	1714	619	609	609
query80	1078	430	429	429
query81	539	229	226	226
query82	967	124	122	122
query83	267	151	154	151
query84	249	80	75	75
query85	1411	386	383	383
query86	437	298	309	298
query87	4910	4451	4509	4451
query88	3626	2213	2193	2193
query89	404	306	303	303
query90	2075	199	196	196
query91	139	103	102	102
query92	68	52	57	52
query93	1413	544	545	544
query94	1051	280	351	280
query95	369	255	258	255
query96	604	278	279	278
query97	2825	2696	2677	2677
query98	216	195	195	195
query99	1568	1329	1318	1318
Total cold run time: 304074 ms
Total hot run time: 191216 ms

@doris-robot
Copy link

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

query1	0.04	0.03	0.02
query2	0.07	0.03	0.03
query3	0.24	0.06	0.08
query4	1.63	0.11	0.11
query5	0.43	0.43	0.42
query6	1.15	0.65	0.65
query7	0.02	0.02	0.02
query8	0.04	0.03	0.03
query9	0.57	0.50	0.49
query10	0.56	0.59	0.55
query11	0.14	0.10	0.11
query12	0.14	0.12	0.11
query13	0.62	0.61	0.59
query14	2.72	2.84	2.72
query15	0.89	0.82	0.82
query16	0.36	0.38	0.39
query17	1.02	1.04	1.00
query18	0.22	0.20	0.21
query19	1.87	1.83	2.01
query20	0.01	0.02	0.01
query21	15.36	0.61	0.57
query22	2.84	1.97	2.05
query23	17.16	0.91	0.78
query24	3.33	1.19	1.97
query25	0.33	0.25	0.14
query26	0.27	0.14	0.14
query27	0.05	0.04	0.04
query28	9.64	1.10	1.08
query29	12.57	3.25	3.22
query30	0.24	0.06	0.06
query31	2.88	0.37	0.37
query32	3.26	0.46	0.46
query33	3.06	3.05	3.06
query34	16.89	4.43	4.49
query35	4.55	4.50	4.46
query36	0.65	0.49	0.51
query37	0.10	0.06	0.06
query38	0.04	0.03	0.04
query39	0.04	0.02	0.02
query40	0.17	0.13	0.12
query41	0.07	0.02	0.02
query42	0.04	0.02	0.02
query43	0.03	0.03	0.04
Total cold run time: 106.31 s
Total hot run time: 32.89 s

@msridhar78
Copy link
Contributor Author

run P0

@msridhar78
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17591	7403	7278	7278
q2	2049	179	186	179
q3	10602	1081	1141	1081
q4	10566	743	695	695
q5	7605	2706	2717	2706
q6	243	155	149	149
q7	983	643	607	607
q8	9245	1872	1918	1872
q9	6550	6418	6434	6418
q10	7025	2298	2310	2298
q11	464	262	269	262
q12	415	217	219	217
q13	17769	2944	2964	2944
q14	243	211	213	211
q15	560	513	511	511
q16	672	596	591	591
q17	981	529	592	529
q18	7229	6826	6969	6826
q19	1356	1076	1099	1076
q20	486	201	196	196
q21	4269	3143	3073	3073
q22	393	321	307	307
Total cold run time: 107296 ms
Total hot run time: 40026 ms

----- Round 2, with runtime_filter_mode=off -----
q1	7193	7238	7229	7229
q2	330	237	235	235
q3	2849	2786	3021	2786
q4	2057	1865	1861	1861
q5	5656	5636	5608	5608
q6	227	145	145	145
q7	2221	1780	1817	1780
q8	3365	3568	3491	3491
q9	8905	8997	8931	8931
q10	3592	3541	3541	3541
q11	612	512	529	512
q12	835	613	608	608
q13	12932	3133	3156	3133
q14	324	287	267	267
q15	560	496	504	496
q16	685	668	650	650
q17	1858	1667	1597	1597
q18	8344	7862	7844	7844
q19	1727	1494	1490	1490
q20	2081	1875	1826	1826
q21	5480	5617	5428	5428
q22	646	609	592	592
Total cold run time: 72479 ms
Total hot run time: 60050 ms

@doris-robot
Copy link

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

query1	1302	963	931	931
query2	6239	2489	2480	2480
query3	10985	4714	4740	4714
query4	33173	23443	23364	23364
query5	4303	466	487	466
query6	318	186	188	186
query7	3992	304	310	304
query8	309	239	247	239
query9	9490	2741	2745	2741
query10	459	252	261	252
query11	18137	15046	15200	15046
query12	152	104	101	101
query13	1572	412	433	412
query14	10316	6663	8049	6663
query15	270	200	200	200
query16	8315	444	439	439
query17	1847	621	601	601
query18	2188	331	339	331
query19	379	173	172	172
query20	122	113	134	113
query21	215	109	115	109
query22	4741	4546	4532	4532
query23	34638	33701	33842	33701
query24	10206	2472	2602	2472
query25	672	472	404	404
query26	1391	155	149	149
query27	2755	336	353	336
query28	7570	2484	2461	2461
query29	877	433	426	426
query30	225	146	153	146
query31	989	834	805	805
query32	109	61	61	61
query33	754	322	307	307
query34	1149	543	509	509
query35	900	780	848	780
query36	1122	983	976	976
query37	142	78	76	76
query38	4544	4379	4274	4274
query39	1514	1477	1486	1477
query40	260	108	100	100
query41	47	43	42	42
query42	111	103	110	103
query43	539	502	498	498
query44	1263	841	829	829
query45	187	169	173	169
query46	1219	710	743	710
query47	2030	1926	1931	1926
query48	420	339	318	318
query49	896	400	400	400
query50	813	411	409	409
query51	7303	7232	7371	7232
query52	105	95	102	95
query53	259	184	191	184
query54	1060	425	414	414
query55	82	84	81	81
query56	287	246	254	246
query57	1294	1164	1162	1162
query58	248	221	224	221
query59	3454	3158	3229	3158
query60	286	256	252	252
query61	115	104	106	104
query62	828	719	679	679
query63	222	192	189	189
query64	4129	694	661	661
query65	3272	3293	3344	3293
query66	881	314	308	308
query67	16635	15652	15617	15617
query68	5857	567	559	559
query69	484	260	253	253
query70	1223	1121	1055	1055
query71	501	268	255	255
query72	6634	4090	4009	4009
query73	797	379	368	368
query74	10239	8874	8882	8874
query75	3979	2674	2643	2643
query76	3726	1121	1111	1111
query77	685	294	302	294
query78	10228	9766	9469	9469
query79	1118	599	609	599
query80	774	460	432	432
query81	517	229	243	229
query82	632	124	120	120
query83	175	141	143	141
query84	242	73	72	72
query85	1259	355	295	295
query86	396	313	293	293
query87	4950	4370	4561	4370
query88	3272	2251	2224	2224
query89	425	289	292	289
query90	2026	191	187	187
query91	141	106	107	106
query92	61	52	54	52
query93	1535	565	547	547
query94	783	282	293	282
query95	357	251	255	251
query96	610	275	291	275
query97	2859	2741	2697	2697
query98	223	192	197	192
query99	1663	1326	1308	1308
Total cold run time: 304997 ms
Total hot run time: 197007 ms

@doris-robot
Copy link

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

query1	0.03	0.04	0.03
query2	0.07	0.03	0.03
query3	0.23	0.07	0.06
query4	1.62	0.11	0.10
query5	0.42	0.42	0.42
query6	1.14	0.65	0.66
query7	0.03	0.02	0.01
query8	0.04	0.04	0.03
query9	0.58	0.51	0.51
query10	0.56	0.59	0.57
query11	0.14	0.10	0.11
query12	0.13	0.11	0.11
query13	0.61	0.61	0.59
query14	2.71	2.76	2.72
query15	0.89	0.84	0.83
query16	0.38	0.40	0.38
query17	1.00	0.96	1.07
query18	0.22	0.20	0.21
query19	1.96	1.87	2.01
query20	0.01	0.01	0.02
query21	15.38	0.59	0.58
query22	3.20	2.90	1.82
query23	16.90	1.00	0.84
query24	3.48	1.36	1.59
query25	0.15	0.08	0.06
query26	0.61	0.14	0.15
query27	0.04	0.04	0.05
query28	9.64	1.11	1.07
query29	12.57	3.30	3.23
query30	0.25	0.07	0.06
query31	2.85	0.40	0.38
query32	3.25	0.46	0.45
query33	3.22	3.14	3.10
query34	17.21	4.42	4.50
query35	4.48	4.45	4.46
query36	0.65	0.47	0.48
query37	0.09	0.06	0.06
query38	0.05	0.04	0.03
query39	0.04	0.03	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.02	0.03
Total cold run time: 107.15 s
Total hot run time: 32.95 s

starocean999
starocean999 previously approved these changes Dec 24, 2024
View reviewed changes
@github-actions GitHub Actions
Copy link
Contributor

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

@github-actions github-actions bot added the approved Indicates a PR has been approved by one committer. label Dec 24, 2024
@github-actions github-actions bot removed the approved Indicates a PR has been approved by one committer. label Dec 27, 2024
@msridhar78
Copy link
Contributor Author

run buildall

@doris-robot
Copy link

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

------ Round 1 ----------------------------------
q1	17594	6121	6031	6031
q2	2040	306	190	190
q3	10402	1201	746	746
q4	10251	861	429	429
q5	8288	2148	1940	1940
q6	207	182	149	149
q7	890	762	598	598
q8	9251	1376	1202	1202
q9	5272	4958	4915	4915
q10	6763	2321	1865	1865
q11	481	277	257	257
q12	347	352	216	216
q13	17782	3614	2949	2949
q14	247	226	210	210
q15	551	501	499	499
q16	626	637	597	597
q17	583	855	343	343
q18	6888	6505	6386	6386
q19	1778	968	554	554
q20	315	317	189	189
q21	2914	2178	1971	1971
q22	361	337	301	301
Total cold run time: 103831 ms
Total hot run time: 32537 ms

----- Round 2, with runtime_filter_mode=off -----
q1	6259	6245	6180	6180
q2	235	329	230	230
q3	2235	2673	2319	2319
q4	1405	1815	1380	1380
q5	4339	4729	4821	4729
q6	187	181	149	149
q7	2047	1986	1834	1834
q8	2617	2778	2694	2694
q9	7250	7285	7270	7270
q10	3031	3358	2799	2799
q11	576	524	492	492
q12	647	698	603	603
q13	3447	3791	3134	3134
q14	287	298	293	293
q15	554	516	518	516
q16	679	688	650	650
q17	1237	1767	1267	1267
q18	7688	7544	7241	7241
q19	836	1101	1120	1101
q20	2011	2017	1931	1931
q21	5605	5331	4829	4829
q22	640	617	584	584
Total cold run time: 53812 ms
Total hot run time: 52225 ms

@doris-robot
Copy link

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

query1	1321	961	921	921
query2	6502	2383	2171	2171
query3	11074	4967	4696	4696
query4	32953	24253	23470	23470
query5	4711	625	451	451
query6	274	221	187	187
query7	3981	492	306	306
query8	304	232	234	232
query9	9391	2719	2723	2719
query10	471	303	241	241
query11	17801	15473	15310	15310
query12	161	104	102	102
query13	1571	545	413	413
query14	10093	7912	7404	7404
query15	239	226	189	189
query16	7746	666	471	471
query17	1558	744	575	575
query18	2001	410	312	312
query19	198	191	156	156
query20	119	124	113	113
query21	207	129	110	110
query22	4624	4699	4653	4653
query23	34443	33516	33623	33516
query24	6643	2352	2279	2279
query25	499	482	386	386
query26	818	277	161	161
query27	2012	462	331	331
query28	5374	2482	2419	2419
query29	544	582	422	422
query30	214	189	152	152
query31	984	959	797	797
query32	69	60	57	57
query33	512	362	302	302
query34	761	877	538	538
query35	791	869	765	765
query36	1033	1090	986	986
query37	115	103	76	76
query38	4233	4381	4313	4313
query39	1520	1514	1472	1472
query40	213	119	109	109
query41	47	51	46	46
query42	118	123	98	98
query43	518	542	496	496
query44	1367	826	855	826
query45	189	174	171	171
query46	881	1085	660	660
query47	1996	2000	1926	1926
query48	390	429	326	326
query49	714	470	388	388
query50	652	687	395	395
query51	7313	7325	7264	7264
query52	102	100	97	97
query53	231	257	196	196
query54	493	510	416	416
query55	91	84	90	84
query56	273	300	253	253
query57	1269	1240	1171	1171
query58	249	228	231	228
query59	3195	3308	3262	3262
query60	294	325	248	248
query61	108	104	112	104
query62	850	800	762	762
query63	231	190	190	190
query64	3043	1016	644	644
query65	3349	3312	3294	3294
query66	709	404	308	308
query67	16539	15784	15585	15585
query68	9066	733	507	507
query69	474	298	248	248
query70	1312	1100	1139	1100
query71	428	279	253	253
query72	6204	3854	3947	3854
query73	655	745	360	360
query74	10340	9016	9129	9016
query75	4544	3170	2658	2658
query76	5147	1216	785	785
query77	990	355	267	267
query78	10072	10174	9433	9433
query79	3193	892	609	609
query80	692	511	416	416
query81	484	275	229	229
query82	627	150	130	130
query83	182	175	146	146
query84	282	86	73	73
query85	775	369	367	367
query86	334	325	306	306
query87	4496	4377	4471	4377
query88	4415	2218	2254	2218
query89	415	337	298	298
query90	1841	185	195	185
query91	129	135	105	105
query92	72	54	51	51
query93	1540	861	517	517
query94	649	390	251	251
query95	332	268	253	253
query96	478	608	286	286
query97	2742	2789	2710	2710
query98	230	200	199	199
query99	1660	1537	1432	1432
Total cold run time: 298089 ms
Total hot run time: 197360 ms

@doris-robot
Copy link

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

query1	0.03	0.03	0.04
query2	0.08	0.03	0.03
query3	0.24	0.06	0.07
query4	1.60	0.10	0.10
query5	0.42	0.43	0.43
query6	1.21	0.67	0.69
query7	0.03	0.01	0.02
query8	0.04	0.03	0.03
query9	0.61	0.50	0.51
query10	0.56	0.60	0.57
query11	0.14	0.10	0.10
query12	0.14	0.11	0.11
query13	0.61	0.60	0.60
query14	2.73	2.75	2.76
query15	0.90	0.84	0.83
query16	0.39	0.40	0.39
query17	1.06	1.07	1.04
query18	0.22	0.21	0.21
query19	1.90	1.92	2.03
query20	0.01	0.01	0.01
query21	15.36	0.97	0.58
query22	0.76	0.87	0.71
query23	15.20	1.49	0.59
query24	3.23	1.19	0.89
query25	0.19	0.07	0.06
query26	0.39	0.15	0.13
query27	0.04	0.04	0.04
query28	13.60	1.54	1.05
query29	12.56	4.01	3.32
query30	0.25	0.10	0.06
query31	2.84	0.63	0.40
query32	3.24	0.56	0.47
query33	3.10	3.13	3.07
query34	16.77	5.19	4.54
query35	4.57	4.53	4.53
query36	0.65	0.49	0.48
query37	0.10	0.06	0.06
query38	0.05	0.04	0.03
query39	0.04	0.02	0.03
query40	0.17	0.14	0.14
query41	0.08	0.03	0.03
query42	0.03	0.03	0.02
query43	0.04	0.03	0.03
Total cold run time: 106.18 s
Total hot run time: 31.64 s

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

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

@starocean999 starocean999 merged commit bdd36f9 into apache:master Jan 2, 2025
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 approved these changes

@englefly englefly englefly left review comments

@starocean999 starocean999 Awaiting requested review from starocean999

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