[Chore](nereids) Remove remaining showstmt

[codeDing18]

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.

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?

[codeDing18]

run buildall

[doris-robot]

TPC-H: Total hot run time: 33712 ms

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

------ Round 1 ----------------------------------
q1	17595	5137	4994	4994
q2	1919	267	183	183
q3	10321	1262	713	713
q4	10211	1020	501	501
q5	7552	2327	2332	2327
q6	174	161	132	132
q7	883	713	602	602
q8	9317	1230	1059	1059
q9	6728	5017	5069	5017
q10	6905	2363	1992	1992
q11	467	307	291	291
q12	341	351	209	209
q13	17773	3729	3087	3087
q14	237	237	207	207
q15	560	482	485	482
q16	430	427	383	383
q17	599	842	397	397
q18	7545	7218	6977	6977
q19	1390	935	556	556
q20	341	339	233	233
q21	3740	3138	2414	2414
q22	1035	977	956	956
Total cold run time: 106063 ms
Total hot run time: 33712 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5072	5049	5017	5017
q2	248	318	218	218
q3	2130	2652	2259	2259
q4	1369	1809	1366	1366
q5	4197	4089	4231	4089
q6	208	168	128	128
q7	1988	1954	1733	1733
q8	2534	2496	2427	2427
q9	7215	7057	7164	7057
q10	3035	3255	2812	2812
q11	574	507	490	490
q12	659	778	616	616
q13	3555	3771	3292	3292
q14	277	292	261	261
q15	537	475	464	464
q16	441	481	457	457
q17	1125	1509	1370	1370
q18	7656	7123	6982	6982
q19	767	760	800	760
q20	1921	1995	1820	1820
q21	4788	4337	4298	4298
q22	1067	1030	988	988
Total cold run time: 51363 ms
Total hot run time: 48904 ms

[doris-robot]

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

query1	1021	404	403	403
query2	6532	1794	1849	1794
query3	6743	236	231	231
query4	26441	23711	23542	23542
query5	4338	620	451	451
query6	309	208	204	204
query7	4614	487	305	305
query8	274	222	235	222
query9	8641	2601	2625	2601
query10	491	344	279	279
query11	15728	15224	14833	14833
query12	165	108	108	108
query13	1650	537	419	419
query14	9167	5989	6025	5989
query15	191	189	170	170
query16	7195	612	492	492
query17	1170	715	551	551
query18	1966	387	295	295
query19	183	184	155	155
query20	118	115	114	114
query21	213	121	112	112
query22	4167	4196	4126	4126
query23	33782	33143	33034	33034
query24	8449	2331	2356	2331
query25	546	442	389	389
query26	1234	267	152	152
query27	2774	504	339	339
query28	4342	2098	2085	2085
query29	763	567	430	430
query30	282	211	188	188
query31	971	826	770	770
query32	70	63	63	63
query33	574	352	315	315
query34	793	842	523	523
query35	776	809	722	722
query36	965	969	875	875
query37	111	99	81	81
query38	4062	4077	4030	4030
query39	1472	1426	1446	1426
query40	204	122	110	110
query41	62	60	59	59
query42	130	107	110	107
query43	500	479	462	462
query44	1317	822	833	822
query45	190	175	168	168
query46	843	1032	621	621
query47	1796	1817	1737	1737
query48	392	420	314	314
query49	773	487	409	409
query50	676	671	398	398
query51	4089	4183	4121	4121
query52	113	106	97	97
query53	222	248	184	184
query54	560	553	496	496
query55	86	87	81	81
query56	311	319	271	271
query57	1189	1207	1147	1147
query58	266	278	252	252
query59	2637	2659	2467	2467
query60	326	312	314	312
query61	126	123	125	123
query62	795	716	657	657
query63	223	181	189	181
query64	4328	980	658	658
query65	4207	4113	4208	4113
query66	1131	411	307	307
query67	15963	15370	15694	15370
query68	7853	888	529	529
query69	475	307	262	262
query70	1195	1151	1082	1082
query71	438	333	297	297
query72	5513	4625	4750	4625
query73	643	605	353	353
query74	8977	9164	8991	8991
query75	3605	3208	2682	2682
query76	3434	1175	735	735
query77	776	369	306	306
query78	10005	10064	9339	9339
query79	1810	836	577	577
query80	587	508	440	440
query81	500	273	223	223
query82	190	125	95	95
query83	254	247	228	228
query84	247	105	92	92
query85	749	350	315	315
query86	373	307	268	268
query87	4392	4521	4469	4469
query88	3044	2280	2295	2280
query89	379	308	287	287
query90	1953	206	208	206
query91	140	144	112	112
query92	76	61	61	61
query93	1815	958	596	596
query94	646	406	310	310
query95	385	295	323	295
query96	480	563	278	278
query97	2644	2775	2667	2667
query98	227	208	200	200
query99	1314	1393	1258	1258
Total cold run time: 271857 ms
Total hot run time: 185651 ms

[doris-robot]

ClickBench: Total hot run time: 29.61 s

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

query1	0.04	0.04	0.03
query2	0.08	0.03	0.03
query3	0.23	0.07	0.07
query4	1.61	0.10	0.10
query5	0.43	0.43	0.40
query6	1.16	0.65	0.66
query7	0.03	0.02	0.01
query8	0.04	0.03	0.04
query9	0.58	0.52	0.52
query10	0.59	0.58	0.57
query11	0.16	0.11	0.11
query12	0.15	0.12	0.12
query13	0.63	0.62	0.61
query14	0.83	0.82	0.82
query15	0.89	0.87	0.86
query16	0.41	0.38	0.38
query17	1.07	1.07	1.13
query18	0.23	0.21	0.21
query19	2.00	1.89	1.84
query20	0.01	0.02	0.01
query21	15.39	0.90	0.55
query22	0.75	1.16	0.68
query23	14.93	1.37	0.62
query24	7.53	0.85	0.87
query25	0.49	0.19	0.07
query26	0.71	0.17	0.13
query27	0.06	0.06	0.05
query28	9.47	0.88	0.46
query29	12.53	3.94	3.27
query30	0.26	0.09	0.06
query31	2.83	0.59	0.41
query32	3.23	0.55	0.47
query33	3.12	3.11	3.09
query34	15.98	5.40	4.81
query35	4.77	4.82	4.82
query36	0.70	0.50	0.50
query37	0.09	0.07	0.07
query38	0.05	0.04	0.03
query39	0.03	0.02	0.02
query40	0.17	0.15	0.14
query41	0.09	0.02	0.02
query42	0.04	0.03	0.02
query43	0.04	0.03	0.04
Total cold run time: 104.43 s
Total hot run time: 29.61 s

[hello-stephen]

FE UT Coverage Report

Increment line coverage 9.09% (1/11) :tada: Increment coverage report Complete coverage report

[codeDing18]

run buildall

[doris-robot]

TPC-H: Total hot run time: 34281 ms

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

------ Round 1 ----------------------------------
q1	17642	5146	4977	4977
q2	1933	300	198	198
q3	10272	1336	750	750
q4	10240	1025	557	557
q5	7587	2384	2383	2383
q6	194	165	132	132
q7	914	751	621	621
q8	9339	1480	1158	1158
q9	6788	5210	5093	5093
q10	6887	2404	2014	2014
q11	478	292	280	280
q12	343	360	221	221
q13	17787	3662	3082	3082
q14	240	235	221	221
q15	583	489	483	483
q16	432	456	391	391
q17	616	863	386	386
q18	7873	7231	7216	7216
q19	1357	941	550	550
q20	352	365	229	229
q21	3832	3181	2359	2359
q22	1000	1015	980	980
Total cold run time: 106689 ms
Total hot run time: 34281 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5084	5012	5042	5012
q2	246	322	223	223
q3	2198	2672	2324	2324
q4	1395	1794	1389	1389
q5	4258	4160	4525	4160
q6	213	174	126	126
q7	2092	1964	1815	1815
q8	2657	2532	2463	2463
q9	7089	7222	7205	7205
q10	3136	3324	2836	2836
q11	662	516	488	488
q12	711	772	583	583
q13	3502	3981	3353	3353
q14	283	311	282	282
q15	534	470	468	468
q16	433	501	436	436
q17	1207	1564	1366	1366
q18	7707	7498	7373	7373
q19	837	842	826	826
q20	2040	2062	1895	1895
q21	4857	4595	4448	4448
q22	1007	969	988	969
Total cold run time: 52148 ms
Total hot run time: 50040 ms

[doris-robot]

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

query1	1027	405	411	405
query2	6526	1937	1940	1937
query3	6755	232	225	225
query4	25925	23766	23398	23398
query5	4354	638	467	467
query6	305	242	228	228
query7	4620	520	293	293
query8	266	239	235	235
query9	8604	2723	2772	2723
query10	471	335	290	290
query11	15243	15402	15091	15091
query12	161	109	108	108
query13	1649	534	400	400
query14	9284	6169	6272	6169
query15	205	193	175	175
query16	7223	606	489	489
query17	1213	737	635	635
query18	1969	407	312	312
query19	198	187	159	159
query20	123	124	117	117
query21	219	125	110	110
query22	4130	4221	4034	4034
query23	34063	33194	33363	33194
query24	8461	2365	2429	2365
query25	563	459	407	407
query26	1238	280	151	151
query27	2747	508	352	352
query28	4294	2216	2206	2206
query29	787	558	431	431
query30	284	218	200	200
query31	944	887	772	772
query32	73	68	65	65
query33	569	355	307	307
query34	807	863	550	550
query35	797	815	727	727
query36	980	998	894	894
query37	114	101	83	83
query38	4181	4266	4113	4113
query39	1494	1438	1413	1413
query40	226	124	115	115
query41	71	69	68	68
query42	128	116	117	116
query43	520	546	484	484
query44	1344	858	858	858
query45	189	177	168	168
query46	856	1031	658	658
query47	1785	1842	1773	1773
query48	407	443	319	319
query49	769	492	437	437
query50	664	680	423	423
query51	4273	4205	4100	4100
query52	127	112	110	110
query53	239	269	191	191
query54	604	636	523	523
query55	84	108	89	89
query56	302	294	298	294
query57	1175	1236	1138	1138
query58	265	269	270	269
query59	2788	2695	2737	2695
query60	328	330	319	319
query61	133	125	127	125
query62	807	749	656	656
query63	225	187	191	187
query64	4336	1013	683	683
query65	4301	4175	4306	4175
query66	1149	426	316	316
query67	15986	15783	15416	15416
query68	8620	911	550	550
query69	471	311	263	263
query70	1262	1158	1153	1153
query71	472	331	307	307
query72	5454	4894	4798	4798
query73	778	616	363	363
query74	9083	9103	8712	8712
query75	4041	3207	2708	2708
query76	3701	1186	788	788
query77	806	391	291	291
query78	10227	10340	9481	9481
query79	2210	808	604	604
query80	634	560	446	446
query81	486	264	225	225
query82	471	129	96	96
query83	290	264	236	236
query84	298	116	93	93
query85	804	355	320	320
query86	331	307	307	307
query87	4465	4470	4389	4389
query88	2975	2354	2320	2320
query89	408	320	290	290
query90	1950	211	211	211
query91	149	141	114	114
query92	80	60	59	59
query93	1208	972	631	631
query94	677	413	307	307
query95	394	307	298	298
query96	509	580	285	285
query97	2738	2803	2617	2617
query98	237	210	213	210
query99	1433	1403	1266	1266
Total cold run time: 274609 ms
Total hot run time: 187673 ms

[doris-robot]

ClickBench: Total hot run time: 30.02 s

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

query1	0.04	0.03	0.03
query2	0.07	0.04	0.04
query3	0.24	0.07	0.07
query4	1.62	0.10	0.10
query5	0.42	0.44	0.43
query6	1.18	0.66	0.66
query7	0.02	0.02	0.02
query8	0.05	0.03	0.05
query9	0.59	0.54	0.51
query10	0.58	0.57	0.56
query11	0.16	0.12	0.12
query12	0.16	0.12	0.11
query13	0.65	0.61	0.61
query14	0.82	0.83	0.83
query15	0.92	0.88	0.88
query16	0.40	0.40	0.40
query17	1.06	1.06	1.07
query18	0.23	0.22	0.22
query19	1.96	1.86	1.95
query20	0.01	0.01	0.02
query21	15.40	0.91	0.55
query22	0.75	1.25	0.80
query23	14.74	1.38	0.63
query24	7.30	1.70	0.79
query25	0.52	0.18	0.12
query26	0.62	0.18	0.15
query27	0.06	0.05	0.05
query28	9.31	0.94	0.46
query29	12.53	4.07	3.46
query30	0.25	0.10	0.07
query31	2.81	0.61	0.41
query32	3.24	0.58	0.48
query33	3.09	3.08	3.13
query34	16.01	5.43	4.80
query35	4.82	4.82	4.80
query36	0.70	0.54	0.50
query37	0.09	0.07	0.06
query38	0.05	0.04	0.03
query39	0.03	0.02	0.03
query40	0.18	0.15	0.15
query41	0.08	0.03	0.02
query42	0.04	0.02	0.02
query43	0.04	0.03	0.02
Total cold run time: 103.84 s
Total hot run time: 30.02 s

[hello-stephen]

FE UT Coverage Report

Increment line coverage 9.09% (1/11) :tada: Increment coverage report Complete coverage report

[codeDing18]

run buildall

[hello-stephen]

FE UT Coverage Report

Increment line coverage 9.09% (1/11) :tada: Increment coverage report Complete coverage report

[codeDing18]

run buildall

[codeDing18]

run buildall

[doris-robot]

TPC-H: Total hot run time: 34012 ms

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

------ Round 1 ----------------------------------
q1	17595	5153	5087	5087
q2	1955	302	195	195
q3	10252	1281	714	714
q4	10228	982	539	539
q5	7547	2361	2365	2361
q6	182	162	134	134
q7	897	742	609	609
q8	9326	1218	1016	1016
q9	6741	5067	5141	5067
q10	6888	2364	1994	1994
q11	476	293	284	284
q12	342	353	222	222
q13	17786	3702	3106	3106
q14	238	233	222	222
q15	569	491	482	482
q16	425	431	377	377
q17	583	877	367	367
q18	7726	7232	7109	7109
q19	1412	953	564	564
q20	337	340	220	220
q21	4059	3217	2382	2382
q22	1053	990	961	961
Total cold run time: 106617 ms
Total hot run time: 34012 ms

----- Round 2, with runtime_filter_mode=off -----
q1	5197	5085	5126	5085
q2	248	322	227	227
q3	2211	2617	2273	2273
q4	1330	1864	1408	1408
q5	4212	4124	4410	4124
q6	224	175	136	136
q7	1991	1904	1794	1794
q8	2550	2487	2480	2480
q9	7198	7155	7075	7075
q10	3055	3257	2808	2808
q11	584	525	487	487
q12	687	772	630	630
q13	3584	3937	3324	3324
q14	279	302	281	281
q15	508	477	495	477
q16	454	483	448	448
q17	1163	1546	1380	1380
q18	7502	7210	7094	7094
q19	789	778	909	778
q20	1898	1967	1817	1817
q21	4829	4437	4266	4266
q22	1069	1028	997	997
Total cold run time: 51562 ms
Total hot run time: 49389 ms

[doris-robot]

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

query1	1006	399	391	391
query2	6542	1798	1770	1770
query3	6747	220	227	220
query4	26368	23968	23776	23776
query5	4494	617	484	484
query6	334	214	199	199
query7	4637	492	289	289
query8	268	230	219	219
query9	8660	2627	2650	2627
query10	466	340	286	286
query11	15798	15101	14770	14770
query12	163	106	102	102
query13	1649	522	411	411
query14	9439	6085	6128	6085
query15	194	187	168	168
query16	7449	629	493	493
query17	1195	698	569	569
query18	1986	402	304	304
query19	192	186	156	156
query20	122	114	115	114
query21	213	129	106	106
query22	4173	4202	3869	3869
query23	33923	33002	33196	33002
query24	8419	2341	2367	2341
query25	529	488	406	406
query26	1243	268	154	154
query27	2764	514	346	346
query28	4331	2116	2098	2098
query29	782	569	463	463
query30	291	229	205	205
query31	944	837	768	768
query32	76	72	66	66
query33	577	377	320	320
query34	810	852	535	535
query35	782	816	742	742
query36	930	977	889	889
query37	110	105	79	79
query38	4130	4163	4085	4085
query39	1486	1436	1392	1392
query40	214	124	112	112
query41	69	64	67	64
query42	127	114	111	111
query43	473	504	479	479
query44	1294	833	882	833
query45	185	169	166	166
query46	844	1032	622	622
query47	1769	1782	1708	1708
query48	375	435	306	306
query49	741	462	401	401
query50	620	681	408	408
query51	4132	4105	4058	4058
query52	149	107	96	96
query53	221	250	185	185
query54	572	561	499	499
query55	87	84	85	84
query56	318	307	292	292
query57	1177	1192	1149	1149
query58	272	268	254	254
query59	2550	2692	2591	2591
query60	316	311	301	301
query61	129	125	132	125
query62	787	744	644	644
query63	222	188	191	188
query64	4294	1009	702	702
query65	4260	4156	4157	4156
query66	1123	405	316	316
query67	15854	15731	15719	15719
query68	8485	868	519	519
query69	471	300	275	275
query70	1221	1081	1083	1081
query71	465	319	306	306
query72	5469	4756	4871	4756
query73	719	635	357	357
query74	9266	9078	8687	8687
query75	3959	3191	2691	2691
query76	3683	1227	745	745
query77	793	375	278	278
query78	10077	10258	9348	9348
query79	2246	822	565	565
query80	618	540	436	436
query81	484	268	233	233
query82	416	134	98	98
query83	283	249	236	236
query84	298	115	81	81
query85	788	364	332	332
query86	339	307	301	301
query87	4424	4457	4347	4347
query88	3109	2324	2285	2285
query89	384	318	288	288
query90	1943	211	205	205
query91	138	141	114	114
query92	84	67	62	62
query93	1062	913	577	577
query94	665	403	301	301
query95	381	295	287	287
query96	495	556	281	281
query97	2742	2729	2676	2676
query98	252	200	204	200
query99	1449	1372	1288	1288
Total cold run time: 274604 ms
Total hot run time: 186104 ms

[doris-robot]

ClickBench: Total hot run time: 29.28 s

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

query1	0.04	0.04	0.03
query2	0.07	0.04	0.04
query3	0.24	0.07	0.07
query4	1.64	0.10	0.11
query5	0.43	0.42	0.41
query6	1.19	0.67	0.65
query7	0.02	0.02	0.01
query8	0.05	0.03	0.04
query9	0.59	0.51	0.52
query10	0.56	0.58	0.57
query11	0.15	0.11	0.11
query12	0.14	0.12	0.12
query13	0.63	0.62	0.61
query14	0.80	0.82	0.81
query15	0.92	0.88	0.89
query16	0.40	0.38	0.42
query17	1.09	1.07	1.09
query18	0.22	0.21	0.22
query19	2.01	1.90	1.81
query20	0.01	0.01	0.01
query21	15.42	0.90	0.56
query22	0.77	1.10	0.62
query23	15.03	1.38	0.63
query24	7.51	0.82	0.34
query25	0.42	0.27	0.16
query26	0.56	0.17	0.15
query27	0.06	0.05	0.06
query28	9.24	0.94	0.47
query29	12.53	4.01	3.34
query30	0.26	0.10	0.07
query31	2.82	0.62	0.40
query32	3.22	0.56	0.46
query33	3.10	3.09	3.18
query34	16.19	5.45	4.81
query35	4.84	4.90	4.91
query36	0.71	0.50	0.48
query37	0.10	0.07	0.07
query38	0.04	0.04	0.03
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.03	0.02
query43	0.04	0.03	0.03
Total cold run time: 104.38 s
Total hot run time: 29.28 s

[github-actions[bot]]

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

[github-actions[bot]]

PR approved by anyone and no changes requested.