[feature](cloud) Support rename compute group sql

[deardeng]

doc https://github.com/apache/doris-website/pull/1777/files

What problem does this PR solve?

Issue Number: close #xxx

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.
    https://github.com/apache/doris-website/pull/1777/files

Check List (For Reviewer who merge this PR)

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

[hello-stephen]

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?

[deardeng]

wait add regression case

[deardeng]

run buildall

[doris-robot]

TPC-H: Total hot run time: 33015 ms

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit b08a6c13a6ec879671677db1b5e9179387d71044, data reload: false

------ Round 1 ----------------------------------
q1	17576	6162	6061	6061
q2	2044	295	172	172
q3	10420	1310	756	756
q4	10226	890	435	435
q5	7531	2265	1992	1992
q6	206	184	147	147
q7	927	753	611	611
q8	9239	1407	1261	1261
q9	5280	4897	5050	4897
q10	6768	2321	1900	1900
q11	482	283	268	268
q12	351	369	216	216
q13	17780	3772	3167	3167
q14	232	238	230	230
q15	569	508	497	497
q16	647	624	591	591
q17	624	867	348	348
q18	7318	6562	6426	6426
q19	1305	971	555	555
q20	313	322	192	192
q21	2946	2241	1983	1983
q22	364	327	310	310
Total cold run time: 103148 ms
Total hot run time: 33015 ms

----- Round 2, with runtime_filter_mode=off -----
q1	6258	6242	6299	6242
q2	235	323	228	228
q3	2266	2688	2339	2339
q4	1415	1886	1349	1349
q5	4376	4831	4914	4831
q6	187	174	142	142
q7	2128	1983	1808	1808
q8	2634	2827	2719	2719
q9	7405	7323	7260	7260
q10	3076	3357	2858	2858
q11	600	517	512	512
q12	652	744	580	580
q13	3521	3824	3138	3138
q14	281	317	296	296
q15	576	527	520	520
q16	653	676	648	648
q17	1235	1743	1272	1272
q18	7941	7343	7108	7108
q19	804	1004	1136	1004
q20	1883	1974	1794	1794
q21	5363	5045	4924	4924
q22	636	581	593	581
Total cold run time: 54125 ms
Total hot run time: 52153 ms

[doris-robot]

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

query1	1009	389	393	389
query2	7836	2538	2511	2511
query3	6728	213	211	211
query4	33655	23720	23404	23404
query5	4323	671	469	469
query6	291	204	203	203
query7	4619	531	308	308
query8	306	252	246	246
query9	9462	2666	2672	2666
query10	481	321	276	276
query11	18084	15228	15283	15228
query12	161	108	106	106
query13	1684	549	428	428
query14	9599	7307	7662	7307
query15	278	193	197	193
query16	8239	633	479	479
query17	1581	773	578	578
query18	2130	394	293	293
query19	229	178	152	152
query20	117	112	149	112
query21	209	121	106	106
query22	4386	4361	4393	4361
query23	34778	33417	33495	33417
query24	6338	2332	2305	2305
query25	486	452	395	395
query26	1203	279	151	151
query27	2221	473	342	342
query28	5121	2445	2399	2399
query29	751	562	411	411
query30	229	191	153	153
query31	993	897	817	817
query32	100	65	57	57
query33	514	357	299	299
query34	787	865	505	505
query35	806	825	746	746
query36	1007	1029	940	940
query37	122	109	77	77
query38	4147	4345	4331	4331
query39	1500	1488	1449	1449
query40	207	116	103	103
query41	46	45	46	45
query42	119	101	103	101
query43	559	545	500	500
query44	1352	823	795	795
query45	187	172	165	165
query46	911	1050	669	669
query47	1897	1925	1828	1828
query48	377	413	335	335
query49	780	483	402	402
query50	671	664	395	395
query51	7131	7269	7078	7078
query52	102	103	93	93
query53	229	262	197	197
query54	483	477	415	415
query55	85	82	77	77
query56	262	260	249	249
query57	1240	1163	1114	1114
query58	242	241	234	234
query59	3167	3217	3095	3095
query60	271	266	255	255
query61	111	125	110	110
query62	910	799	734	734
query63	231	197	199	197
query64	4592	1011	710	710
query65	3322	3221	3255	3221
query66	1086	415	314	314
query67	16108	15865	15456	15456
query68	8775	716	513	513
query69	469	294	254	254
query70	1249	1211	1057	1057
query71	417	289	255	255
query72	6220	3838	4039	3838
query73	672	752	352	352
query74	10160	9361	8948	8948
query75	4286	3144	2665	2665
query76	3957	1176	766	766
query77	809	383	278	278
query78	10053	10196	9469	9469
query79	3443	837	585	585
query80	708	518	440	440
query81	526	266	226	226
query82	617	151	120	120
query83	197	166	147	147
query84	342	87	72	72
query85	794	360	315	315
query86	361	333	296	296
query87	4720	4518	4409	4409
query88	3686	2163	2146	2146
query89	424	334	300	300
query90	1900	197	188	188
query91	139	138	105	105
query92	69	58	54	54
query93	1005	877	537	537
query94	650	409	267	267
query95	343	266	258	258
query96	488	597	274	274
query97	2942	2992	2797	2797
query98	241	209	200	200
query99	1722	1599	1467	1467
Total cold run time: 295572 ms
Total hot run time: 191305 ms

[doris-robot]

ClickBench: Total hot run time: 31.59 s

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit b08a6c13a6ec879671677db1b5e9179387d71044, data reload: false

query1	0.03	0.03	0.02
query2	0.09	0.02	0.04
query3	0.24	0.07	0.06
query4	1.62	0.10	0.11
query5	0.44	0.42	0.43
query6	1.15	0.66	0.65
query7	0.03	0.01	0.01
query8	0.04	0.02	0.03
query9	0.57	0.49	0.52
query10	0.56	0.57	0.55
query11	0.15	0.09	0.10
query12	0.14	0.10	0.11
query13	0.61	0.61	0.59
query14	2.74	2.76	2.82
query15	0.90	0.84	0.83
query16	0.39	0.38	0.41
query17	1.05	1.05	1.08
query18	0.23	0.21	0.21
query19	1.97	1.87	1.94
query20	0.01	0.01	0.01
query21	15.37	0.97	0.60
query22	0.76	0.74	0.75
query23	15.25	1.38	0.56
query24	2.94	0.96	1.84
query25	0.17	0.18	0.15
query26	0.20	0.14	0.14
query27	0.06	0.05	0.08
query28	14.19	1.50	1.05
query29	12.57	3.90	3.30
query30	0.25	0.09	0.06
query31	2.81	0.58	0.38
query32	3.23	0.55	0.46
query33	3.04	3.08	3.07
query34	16.64	5.16	4.55
query35	4.56	4.49	4.56
query36	0.82	0.49	0.49
query37	0.10	0.06	0.06
query38	0.05	0.03	0.04
query39	0.04	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.04	0.03	0.03
Total cold run time: 106.34 s
Total hot run time: 31.59 s

[github-actions]

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

[github-actions]

PR approved by anyone and no changes requested.

[deardeng]

run buildall

[doris-robot]

TPC-H: Total hot run time: 33229 ms

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 16dd89a81b04661533f9fdfdc8842dc9a1a626ed, data reload: false

------ Round 1 ----------------------------------
q1	17654	6233	6164	6164
q2	2054	327	187	187
q3	10497	1237	781	781
q4	10211	870	442	442
q5	7571	2213	2018	2018
q6	208	177	145	145
q7	897	747	608	608
q8	9247	1405	1244	1244
q9	5399	5022	4928	4928
q10	6771	2335	1878	1878
q11	495	277	272	272
q12	352	360	223	223
q13	17764	3747	3070	3070
q14	234	242	229	229
q15	576	513	502	502
q16	630	619	573	573
q17	591	866	332	332
q18	7289	6639	6552	6552
q19	1836	970	542	542
q20	312	327	196	196
q21	3037	2275	2030	2030
q22	378	344	313	313
Total cold run time: 104003 ms
Total hot run time: 33229 ms

----- Round 2, with runtime_filter_mode=off -----
q1	6335	6294	6300	6294
q2	248	333	233	233
q3	2244	2677	2327	2327
q4	1442	1819	1359	1359
q5	4383	4810	4913	4810
q6	189	177	141	141
q7	2065	2055	1812	1812
q8	2675	2918	2740	2740
q9	7378	7326	7358	7326
q10	3082	3257	2780	2780
q11	606	518	518	518
q12	675	759	615	615
q13	3498	3925	3253	3253
q14	292	306	282	282
q15	575	515	523	515
q16	661	701	654	654
q17	1241	1757	1268	1268
q18	7907	7444	7459	7444
q19	833	1183	1137	1137
q20	1987	2020	1942	1942
q21	5848	5182	5125	5125
q22	651	628	612	612
Total cold run time: 54815 ms
Total hot run time: 53187 ms

[doris-robot]

TPC-DS: Total hot run time: 195426 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 16dd89a81b04661533f9fdfdc8842dc9a1a626ed, data reload: false

query1	1294	987	943	943
query2	6293	2347	2307	2307
query3	11165	4705	4681	4681
query4	32867	23440	23689	23440
query5	4383	645	463	463
query6	327	181	189	181
query7	3989	503	316	316
query8	306	247	215	215
query9	9553	2738	2756	2738
query10	485	313	263	263
query11	18105	15172	14943	14943
query12	158	107	109	107
query13	1556	549	393	393
query14	10069	7266	7275	7266
query15	246	204	185	185
query16	8047	681	484	484
query17	1554	804	599	599
query18	2177	434	333	333
query19	207	192	176	176
query20	127	123	113	113
query21	212	129	152	129
query22	4600	4531	4454	4454
query23	34107	33263	33309	33263
query24	6438	2438	2388	2388
query25	494	482	416	416
query26	780	286	156	156
query27	2082	487	346	346
query28	5585	2519	2511	2511
query29	628	565	423	423
query30	222	193	150	150
query31	989	892	830	830
query32	103	62	64	62
query33	506	363	290	290
query34	761	861	498	498
query35	811	829	729	729
query36	1024	1071	968	968
query37	122	98	73	73
query38	4263	4153	4134	4134
query39	1499	1479	1482	1479
query40	214	116	109	109
query41	62	63	49	49
query42	117	101	100	100
query43	510	530	492	492
query44	1408	840	856	840
query45	181	180	173	173
query46	887	1107	655	655
query47	1959	1902	1868	1868
query48	406	410	332	332
query49	712	500	401	401
query50	679	705	399	399
query51	7107	7026	6909	6909
query52	99	99	104	99
query53	227	253	181	181
query54	515	515	413	413
query55	85	82	83	82
query56	246	263	266	263
query57	1271	1217	1142	1142
query58	244	231	233	231
query59	3212	3247	3319	3247
query60	294	270	263	263
query61	119	112	118	112
query62	873	779	784	779
query63	229	193	203	193
query64	3563	1020	654	654
query65	3306	3341	3223	3223
query66	967	407	308	308
query67	16217	15764	15525	15525
query68	8794	702	511	511
query69	478	295	248	248
query70	1210	1178	1069	1069
query71	439	280	251	251
query72	6531	3800	3939	3800
query73	665	746	362	362
query74	9977	9123	8672	8672
query75	4058	3129	2655	2655
query76	3643	1197	739	739
query77	764	364	264	264
query78	10131	9971	9249	9249
query79	3868	783	603	603
query80	785	519	423	423
query81	558	276	238	238
query82	654	160	122	122
query83	209	179	153	153
query84	288	101	72	72
query85	773	350	321	321
query86	402	315	317	315
query87	4277	4474	4354	4354
query88	4864	2200	2202	2200
query89	423	326	294	294
query90	1766	191	191	191
query91	143	137	105	105
query92	72	55	51	51
query93	2448	868	523	523
query94	649	406	283	283
query95	340	263	249	249
query96	506	633	279	279
query97	2898	2943	2778	2778
query98	222	199	196	196
query99	1603	1527	1369	1369
Total cold run time: 298281 ms
Total hot run time: 195426 ms

[doris-robot]

ClickBench: Total hot run time: 31.57 s

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 16dd89a81b04661533f9fdfdc8842dc9a1a626ed, data reload: false

query1	0.04	0.03	0.02
query2	0.09	0.04	0.05
query3	0.24	0.05	0.05
query4	1.65	0.07	0.08
query5	0.43	0.40	0.42
query6	1.16	0.68	0.66
query7	0.02	0.01	0.01
query8	0.05	0.04	0.05
query9	0.56	0.49	0.53
query10	0.54	0.57	0.56
query11	0.16	0.12	0.12
query12	0.15	0.13	0.13
query13	0.61	0.60	0.60
query14	2.73	2.73	2.76
query15	0.91	0.83	0.82
query16	0.38	0.38	0.39
query17	1.07	1.07	1.07
query18	0.19	0.18	0.20
query19	1.94	1.76	2.02
query20	0.02	0.01	0.01
query21	15.37	0.97	0.68
query22	0.77	0.78	0.70
query23	14.94	1.54	0.69
query24	2.21	0.38	0.21
query25	0.15	0.08	0.08
query26	0.29	0.19	0.18
query27	0.08	0.08	0.08
query28	13.45	1.79	1.13
query29	12.68	4.15	3.40
query30	0.25	0.08	0.06
query31	2.84	0.61	0.41
query32	3.22	0.58	0.48
query33	3.11	3.18	3.14
query34	16.69	5.18	4.57
query35	4.62	4.62	4.54
query36	0.82	0.47	0.49
query37	0.21	0.16	0.16
query38	0.16	0.15	0.16
query39	0.05	0.04	0.04
query40	0.17	0.14	0.12
query41	0.10	0.05	0.05
query42	0.07	0.06	0.05
query43	0.06	0.04	0.05
Total cold run time: 105.25 s
Total hot run time: 31.57 s

[github-actions]

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

[deardeng]

run buildall

[doris-robot]

TPC-H: Total hot run time: 32843 ms

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
Tpch sf100 test result on commit 06912b025d6cdf3709b46865b28990be40ee0bc3, data reload: false

------ Round 1 ----------------------------------
q1	17662	6154	6036	6036
q2	2049	309	177	177
q3	10487	1266	729	729
q4	10217	865	435	435
q5	7648	2263	1997	1997
q6	211	181	152	152
q7	896	770	607	607
q8	9233	1424	1180	1180
q9	5257	4925	4945	4925
q10	6772	2295	1853	1853
q11	482	271	258	258
q12	348	368	224	224
q13	17760	3721	3070	3070
q14	249	237	215	215
q15	568	522	501	501
q16	658	620	602	602
q17	584	851	332	332
q18	7191	6563	6499	6499
q19	2581	975	560	560
q20	308	328	189	189
q21	2854	2297	1985	1985
q22	385	344	317	317
Total cold run time: 104400 ms
Total hot run time: 32843 ms

----- Round 2, with runtime_filter_mode=off -----
q1	6318	6206	6246	6206
q2	242	333	233	233
q3	2297	2689	2368	2368
q4	1366	1828	1426	1426
q5	4375	4759	5005	4759
q6	191	173	138	138
q7	2159	1935	1804	1804
q8	2582	2789	2761	2761
q9	7352	7249	7273	7249
q10	3052	3335	2781	2781
q11	582	534	499	499
q12	714	788	596	596
q13	3508	3860	3197	3197
q14	302	296	287	287
q15	571	503	513	503
q16	643	686	633	633
q17	1207	1754	1274	1274
q18	7721	7345	7302	7302
q19	792	1090	1102	1090
q20	1999	2049	1853	1853
q21	5692	5334	4893	4893
q22	581	610	568	568
Total cold run time: 54246 ms
Total hot run time: 52420 ms

[doris-robot]

TPC-DS: Total hot run time: 188688 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 06912b025d6cdf3709b46865b28990be40ee0bc3, data reload: false

query1	984	386	381	381
query2	6550	2435	2331	2331
query3	6706	212	216	212
query4	33428	23411	23772	23411
query5	4292	613	468	468
query6	312	190	184	184
query7	4609	494	304	304
query8	294	236	225	225
query9	9213	2661	2664	2661
query10	457	319	255	255
query11	18361	15242	15673	15242
query12	156	113	105	105
query13	1657	523	376	376
query14	9385	6515	7635	6515
query15	317	197	208	197
query16	8617	589	436	436
query17	1566	734	581	581
query18	2092	398	288	288
query19	218	178	153	153
query20	119	113	110	110
query21	208	133	101	101
query22	4329	4284	4128	4128
query23	33906	33180	33099	33099
query24	6357	2320	2256	2256
query25	485	457	385	385
query26	1208	275	157	157
query27	2477	435	334	334
query28	5657	2413	2451	2413
query29	695	538	410	410
query30	233	185	153	153
query31	960	860	797	797
query32	76	68	64	64
query33	509	374	297	297
query34	740	844	513	513
query35	791	803	736	736
query36	1008	1024	934	934
query37	121	99	85	85
query38	4118	4252	4140	4140
query39	1455	1583	1412	1412
query40	212	117	101	101
query41	53	51	53	51
query42	128	103	103	103
query43	509	541	480	480
query44	1271	819	814	814
query45	177	172	164	164
query46	861	1023	637	637
query47	1805	1826	1783	1783
query48	370	386	314	314
query49	774	484	390	390
query50	615	639	397	397
query51	6913	7019	6798	6798
query52	110	105	92	92
query53	222	249	191	191
query54	489	489	429	429
query55	84	78	79	78
query56	293	282	259	259
query57	1146	1165	1099	1099
query58	253	231	235	231
query59	3117	3251	2939	2939
query60	276	266	258	258
query61	118	114	122	114
query62	864	787	713	713
query63	221	190	193	190
query64	4234	1020	673	673
query65	3232	3197	3182	3182
query66	1067	415	307	307
query67	15707	15597	15337	15337
query68	7181	713	519	519
query69	468	290	257	257
query70	1175	1127	1216	1127
query71	396	298	261	261
query72	6112	4035	3846	3846
query73	653	742	361	361
query74	9590	9048	8857	8857
query75	3572	3137	2646	2646
query76	3412	1199	784	784
query77	785	368	281	281
query78	9935	9883	9455	9455
query79	3084	805	593	593
query80	687	529	457	457
query81	506	277	289	277
query82	466	148	117	117
query83	164	174	157	157
query84	249	86	73	73
query85	793	366	301	301
query86	395	325	284	284
query87	4556	4539	4547	4539
query88	5005	2146	2123	2123
query89	389	333	296	296
query90	1857	189	191	189
query91	136	138	124	124
query92	65	61	58	58
query93	2552	859	524	524
query94	686	397	292	292
query95	335	259	270	259
query96	478	630	283	283
query97	2877	2942	2833	2833
query98	230	200	206	200
query99	1458	1544	1342	1342
Total cold run time: 290034 ms
Total hot run time: 188688 ms

[doris-robot]

ClickBench: Total hot run time: 31.18 s

machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
ClickBench test result on commit 06912b025d6cdf3709b46865b28990be40ee0bc3, data reload: false

query1	0.03	0.03	0.04
query2	0.07	0.04	0.04
query3	0.24	0.06	0.07
query4	1.62	0.10	0.10
query5	0.42	0.39	0.40
query6	1.17	0.64	0.66
query7	0.02	0.02	0.02
query8	0.05	0.03	0.04
query9	0.56	0.48	0.51
query10	0.55	0.56	0.58
query11	0.14	0.10	0.10
query12	0.14	0.11	0.11
query13	0.61	0.60	0.59
query14	2.73	2.74	2.76
query15	0.90	0.83	0.82
query16	0.40	0.39	0.38
query17	1.04	1.07	1.06
query18	0.24	0.21	0.21
query19	1.90	1.99	1.87
query20	0.01	0.01	0.01
query21	15.38	0.99	0.58
query22	0.74	0.74	0.61
query23	15.39	1.44	0.50
query24	3.02	0.88	1.60
query25	0.15	0.20	0.17
query26	0.23	0.15	0.14
query27	0.05	0.04	0.06
query28	13.74	1.51	1.05
query29	12.67	4.08	3.33
query30	0.25	0.09	0.06
query31	2.83	0.59	0.38
query32	3.22	0.55	0.45
query33	3.16	3.07	3.06
query34	16.75	5.08	4.46
query35	4.49	4.46	4.47
query36	0.81	0.48	0.47
query37	0.09	0.06	0.06
query38	0.04	0.03	0.04
query39	0.03	0.02	0.02
query40	0.16	0.12	0.12
query41	0.07	0.02	0.02
query42	0.04	0.02	0.02
query43	0.04	0.03	0.03
Total cold run time: 106.19 s
Total hot run time: 31.18 s

[github-actions]

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

[dataroaring]

LGTM