You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "catpineapple (via GitHub)" <gi...@apache.org> on 2026/01/08 11:12:04 UTC

[PR] [fix](nereids) show columns type hide Column Version [doris]

catpineapple opened a new pull request, #59684:
URL: https://github.com/apache/doris/pull/59684

   ### What problem does this PR solve?
   
   This update fixes an issue where the `SHOW FULL COLUMNS` statement still displayed `version` for `date`, `datetime`, and `decimal` data types. This change aims for better compatibility with MySQL behavior and BI applications.
   
   ```txt
   MySQL [(none)]> SHOW FULL COLUMNS FROM `doris_all_types_demo` FROM `tpch`;
   +---------------------------+---------------+-----------+------+------+---------+-------+------------+-----------------------------------------------------+
   | Field                     | Type          | Collation | Null | Key  | Default | Extra | Privileges | Comment                                             |
   +---------------------------+---------------+-----------+------+------+---------+-------+------------+-----------------------------------------------------+
   | col_09_decimal            | decimal(10,2) |           | YES  | NO   | NULL    | NONE  |            | DECIMAL: exact decimal (precision, scale)           |
   | col_14_date               | date          |           | YES  | NO   | NULL    | NONE  |            | DATE: date format YYYY-MM-DD                        |
   | col_15_datetime           | datetime      |           | YES  | NO   | NULL    | NONE  |            | DATETIME: datetime format YYYY-MM-DD HH:MM:SS       |
   | col_16_datetime_precision | datetime(3)   |           | YES  | NO   | NULL    | NONE  |            | DATETIME(3): datetime with millisecond precision    |
   +---------------------------+---------------+-----------+------+------+---------+-------+------------+-----------------------------------------------------+
   ```
   
   Related PR: #xxx
   
   Problem Summary:
   
   ### Release note
   
   None
   
   ### Check List (For Author)
   
   - Test <!-- At least one of them must be included. -->
       - [ ] 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 <!-- Add your reason?  -->
   
   - Behavior changed:
       - [ ] No.
       - [ ] Yes. <!-- Explain the behavior change -->
   
   - Does this need documentation?
       - [ ] No.
       - [ ] Yes. <!-- Add document PR link here. eg: https://github.com/apache/doris-website/pull/1214 -->
   
   ### Check List (For Reviewer who merge this PR)
   
   - [ ] Confirm the release note
   - [ ] Confirm test cases
   - [ ] Confirm document
   - [ ] Add branch pick label <!-- Add branch pick label that this PR should merge into -->
   
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](nereids) show columns type hide Column Version [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3728066097

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 31826 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit a256adced53008ce73727361d10276c9ae2ed7f6, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17632	4232	4019	4019
   q2	2061	352	240	240
   q3	10125	1271	756	756
   q4	10219	863	315	315
   q5	7538	2143	1825	1825
   q6	188	170	140	140
   q7	928	791	668	668
   q8	9286	1452	1153	1153
   q9	4833	4669	4456	4456
   q10	6752	1844	1411	1411
   q11	520	305	297	297
   q12	688	758	601	601
   q13	17826	3824	3085	3085
   q14	290	299	269	269
   q15	566	513	514	513
   q16	685	686	640	640
   q17	677	806	480	480
   q18	6577	6467	6673	6467
   q19	1184	1094	673	673
   q20	417	417	256	256
   q21	3291	2592	2503	2503
   q22	1162	1114	1059	1059
   Total cold run time: 103445 ms
   Total hot run time: 31826 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4311	4371	4274	4274
   q2	325	401	333	333
   q3	2299	2748	2546	2546
   q4	1400	1835	1440	1440
   q5	4365	4327	4300	4300
   q6	213	169	129	129
   q7	2010	1963	1759	1759
   q8	2709	2393	2351	2351
   q9	6995	7365	7022	7022
   q10	2506	2679	2303	2303
   q11	539	451	474	451
   q12	680	778	595	595
   q13	3583	4128	3357	3357
   q14	295	306	273	273
   q15	513	489	516	489
   q16	672	687	638	638
   q17	1174	1317	1382	1317
   q18	7436	7234	7239	7234
   q19	815	779	784	779
   q20	1888	1985	1785	1785
   q21	4563	4187	4101	4101
   q22	1115	1051	995	995
   Total cold run time: 50406 ms
   Total hot run time: 48471 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](nereids) show columns type hide Column Version [doris]

Posted by "catpineapple (via GitHub)" <gi...@apache.org>.
catpineapple commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3748933616

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](nereids) show columns type hide Column Version [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3742492048

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 31021 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 80a3b1ac9395a9ded6fdb852e8c64d1824ced92a, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17615	4220	4043	4043
   q2	2097	357	247	247
   q3	10210	1327	693	693
   q4	10228	916	320	320
   q5	7576	2022	1902	1902
   q6	190	173	138	138
   q7	912	796	659	659
   q8	9272	1418	1165	1165
   q9	4905	4558	4546	4546
   q10	6801	1826	1425	1425
   q11	536	295	269	269
   q12	712	723	561	561
   q13	17766	3885	3039	3039
   q14	291	292	271	271
   q15	598	531	498	498
   q16	682	664	617	617
   q17	650	812	460	460
   q18	6620	6505	6225	6225
   q19	1129	947	568	568
   q20	370	342	254	254
   q21	2968	2394	2157	2157
   q22	1033	1010	964	964
   Total cold run time: 103161 ms
   Total hot run time: 31021 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4119	4019	4032	4019
   q2	316	384	314	314
   q3	2106	2618	2162	2162
   q4	1333	1723	1341	1341
   q5	4058	3930	3961	3930
   q6	213	170	129	129
   q7	1807	1793	1696	1696
   q8	2798	2525	2416	2416
   q9	7401	7120	7194	7120
   q10	2456	2700	2340	2340
   q11	562	478	466	466
   q12	714	781	601	601
   q13	3605	4002	3396	3396
   q14	297	306	282	282
   q15	555	578	525	525
   q16	661	667	642	642
   q17	1137	1345	1414	1345
   q18	7950	7987	7693	7693
   q19	892	865	829	829
   q20	2086	2085	1854	1854
   q21	4937	4247	4145	4145
   q22	1089	1021	1016	1016
   Total cold run time: 51092 ms
   Total hot run time: 48261 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](nereids) show columns type hide Column Version [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3749117596

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 172944 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit 7696ecc58116fee112e99948b0d658a9961d4953, data reload: false
   
   query5	4451	620	478	478
   query6	341	230	223	223
   query7	4244	461	268	268
   query8	347	259	243	243
   query9	8749	2881	2864	2864
   query10	468	370	319	319
   query11	15250	15203	14998	14998
   query12	179	119	116	116
   query13	1250	479	394	394
   query14	6245	2997	2759	2759
   query14_1	2669	2638	2682	2638
   query15	206	192	178	178
   query16	985	472	396	396
   query17	1104	683	562	562
   query18	2472	440	336	336
   query19	224	227	219	219
   query20	119	117	111	111
   query21	215	140	117	117
   query22	3974	3964	4014	3964
   query23	16119	15576	15460	15460
   query23_1	15626	15583	15552	15552
   query24	7126	1535	1182	1182
   query24_1	1175	1172	1162	1162
   query25	553	477	431	431
   query26	1234	268	161	161
   query27	2747	445	275	275
   query28	4562	2149	2129	2129
   query29	795	545	449	449
   query30	317	248	218	218
   query31	769	655	574	574
   query32	84	76	78	76
   query33	577	349	300	300
   query34	900	886	516	516
   query35	720	751	666	666
   query36	847	871	845	845
   query37	128	95	89	89
   query38	2713	2706	2604	2604
   query39	764	755	740	740
   query39_1	697	720	713	713
   query40	215	136	121	121
   query41	82	61	60	60
   query42	104	99	97	97
   query43	422	460	413	413
   query44	1297	717	732	717
   query45	182	182	172	172
   query46	826	964	564	564
   query47	1487	1468	1436	1436
   query48	309	312	247	247
   query49	613	421	360	360
   query50	598	258	203	203
   query51	3773	3792	3785	3785
   query52	100	110	94	94
   query53	283	316	268	268
   query54	290	269	248	248
   query55	85	79	77	77
   query56	312	300	318	300
   query57	1053	1044	958	958
   query58	273	252	253	252
   query59	2085	2178	2047	2047
   query60	336	348	313	313
   query61	153	154	153	153
   query62	413	382	313	313
   query63	297	258	267	258
   query64	4976	1284	993	993
   query65	3841	3765	3759	3759
   query66	1453	426	324	324
   query67	15272	15315	14848	14848
   query68	5964	989	696	696
   query69	518	356	325	325
   query70	1037	966	890	890
   query71	346	308	287	287
   query72	5716	3237	2618	2618
   query73	775	706	299	299
   query74	8676	8727	8572	8572
   query75	2805	2784	2441	2441
   query76	3336	1059	656	656
   query77	509	377	293	293
   query78	9760	9732	9160	9160
   query79	1731	898	563	563
   query80	747	584	504	504
   query81	550	261	235	235
   query82	419	145	108	108
   query83	276	259	238	238
   query84	262	115	98	98
   query85	920	533	474	474
   query86	441	297	287	287
   query87	2833	2840	2747	2747
   query88	3464	2569	2572	2569
   query89	380	350	323	323
   query90	2021	167	164	164
   query91	171	163	138	138
   query92	79	77	73	73
   query93	1545	912	520	520
   query94	631	321	294	294
   query95	581	384	326	326
   query96	635	504	224	224
   query97	2316	2394	2305	2305
   query98	242	201	195	195
   query99	582	603	519	519
   Total cold run time: 252292 ms
   Total hot run time: 172944 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](nereids) show columns type hide Column Version [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3742546020

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 173235 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit 80a3b1ac9395a9ded6fdb852e8c64d1824ced92a, data reload: false
   
   query5	4431	642	476	476
   query6	340	236	211	211
   query7	4208	462	256	256
   query8	355	258	254	254
   query9	8709	2903	2886	2886
   query10	518	375	350	350
   query11	15245	15051	14838	14838
   query12	173	120	117	117
   query13	1261	498	399	399
   query14	6439	3054	2781	2781
   query14_1	2723	2734	2695	2695
   query15	200	188	170	170
   query16	970	499	462	462
   query17	1073	650	549	549
   query18	2558	422	320	320
   query19	222	218	194	194
   query20	127	116	117	116
   query21	211	140	124	124
   query22	3761	3998	3885	3885
   query23	15912	15453	15421	15421
   query23_1	15403	15514	15458	15458
   query24	7128	1525	1185	1185
   query24_1	1179	1142	1179	1142
   query25	529	450	395	395
   query26	1236	273	155	155
   query27	2759	432	267	267
   query28	4573	2137	2120	2120
   query29	751	559	457	457
   query30	321	243	216	216
   query31	820	633	545	545
   query32	93	80	78	78
   query33	535	361	306	306
   query34	921	884	526	526
   query35	726	761	677	677
   query36	892	890	787	787
   query37	137	105	85	85
   query38	2710	2688	2649	2649
   query39	794	753	769	753
   query39_1	719	722	701	701
   query40	221	141	124	124
   query41	78	68	100	68
   query42	107	104	108	104
   query43	497	478	392	392
   query44	1354	731	727	727
   query45	185	187	176	176
   query46	837	953	590	590
   query47	1424	1493	1394	1394
   query48	301	324	238	238
   query49	607	420	340	340
   query50	613	312	195	195
   query51	3813	3808	3733	3733
   query52	104	115	99	99
   query53	292	327	275	275
   query54	285	263	265	263
   query55	85	79	75	75
   query56	304	306	311	306
   query57	991	1000	907	907
   query58	273	260	255	255
   query59	2131	2191	1910	1910
   query60	343	320	311	311
   query61	158	153	158	153
   query62	374	353	328	328
   query63	302	276	274	274
   query64	4892	1293	982	982
   query65	3798	3737	3779	3737
   query66	1420	430	326	326
   query67	15259	14829	15499	14829
   query68	2787	1006	744	744
   query69	464	353	323	323
   query70	990	950	920	920
   query71	326	314	293	293
   query72	5946	3379	3627	3379
   query73	585	732	309	309
   query74	8816	8791	8551	8551
   query75	2764	2815	2476	2476
   query76	2644	1069	666	666
   query77	530	412	331	331
   query78	9603	9921	9170	9170
   query79	917	918	563	563
   query80	653	594	524	524
   query81	504	264	238	238
   query82	327	151	116	116
   query83	280	266	247	247
   query84	256	124	96	96
   query85	1004	522	482	482
   query86	343	291	292	291
   query87	2843	2853	2777	2777
   query88	2989	2143	2121	2121
   query89	387	360	336	336
   query90	1970	175	167	167
   query91	173	165	141	141
   query92	73	76	67	67
   query93	941	895	538	538
   query94	581	336	308	308
   query95	576	336	372	336
   query96	574	509	201	201
   query97	2360	2375	2296	2296
   query98	212	199	200	199
   query99	588	561	482	482
   Total cold run time: 245514 ms
   Total hot run time: 173235 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](nereids) show columns type hide Column Version [doris]

Posted by "catpineapple (via GitHub)" <gi...@apache.org>.
catpineapple commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3770818207

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](nereids) show columns type hide Column Version [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3749136608

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 26.75 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit 7696ecc58116fee112e99948b0d658a9961d4953, data reload: false
   
   query1	0.06	0.05	0.05
   query2	0.10	0.05	0.05
   query3	0.25	0.08	0.09
   query4	1.60	0.12	0.12
   query5	0.28	0.26	0.27
   query6	1.16	0.66	0.66
   query7	0.03	0.02	0.02
   query8	0.05	0.04	0.04
   query9	0.56	0.51	0.51
   query10	0.55	0.55	0.55
   query11	0.14	0.09	0.11
   query12	0.14	0.11	0.11
   query13	0.61	0.58	0.58
   query14	0.95	0.95	0.94
   query15	0.79	0.78	0.79
   query16	0.40	0.39	0.39
   query17	1.05	1.06	0.99
   query18	0.22	0.20	0.20
   query19	1.96	1.82	1.87
   query20	0.05	0.02	0.01
   query21	15.43	0.24	0.14
   query22	5.16	0.06	0.05
   query23	15.97	0.28	0.10
   query24	1.40	0.50	0.22
   query25	0.08	0.08	0.09
   query26	0.15	0.13	0.14
   query27	0.09	0.05	0.08
   query28	4.09	1.08	0.88
   query29	12.53	3.85	3.15
   query30	0.28	0.15	0.12
   query31	2.82	0.65	0.40
   query32	3.25	0.55	0.45
   query33	3.02	3.02	3.02
   query34	15.92	5.14	4.45
   query35	4.45	4.44	4.46
   query36	0.66	0.50	0.48
   query37	0.11	0.06	0.07
   query38	0.08	0.03	0.04
   query39	0.04	0.03	0.03
   query40	0.17	0.15	0.13
   query41	0.08	0.04	0.03
   query42	0.05	0.03	0.03
   query43	0.05	0.03	0.04
   Total cold run time: 96.83 s
   Total hot run time: 26.75 s
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](nereids) show columns type hide Column Version [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3770912265

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 174023 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit f06505305ef125755265835e28d064f6476fe03e, data reload: false
   
   query5	4951	608	474	474
   query6	335	237	219	219
   query7	4222	464	267	267
   query8	344	259	242	242
   query9	8780	2919	2853	2853
   query10	544	398	349	349
   query11	15298	15115	14879	14879
   query12	193	115	121	115
   query13	1251	508	374	374
   query14	6719	3014	2763	2763
   query14_1	2677	2727	2628	2628
   query15	203	193	169	169
   query16	987	511	479	479
   query17	1086	622	535	535
   query18	2680	420	319	319
   query19	218	214	183	183
   query20	123	115	108	108
   query21	209	131	114	114
   query22	3971	4201	3951	3951
   query23	16148	15627	15437	15437
   query23_1	15445	15458	15354	15354
   query24	7116	1538	1166	1166
   query24_1	1172	1148	1155	1148
   query25	502	413	388	388
   query26	1235	274	148	148
   query27	2751	442	279	279
   query28	4545	2184	2163	2163
   query29	790	496	413	413
   query30	305	238	204	204
   query31	779	604	567	567
   query32	79	76	72	72
   query33	522	336	313	313
   query34	898	886	532	532
   query35	724	764	682	682
   query36	896	914	835	835
   query37	137	98	91	91
   query38	2654	2748	2613	2613
   query39	794	760	752	752
   query39_1	721	715	725	715
   query40	217	132	116	116
   query41	64	61	62	61
   query42	101	102	97	97
   query43	432	437	406	406
   query44	1309	747	752	747
   query45	183	183	176	176
   query46	826	936	576	576
   query47	1441	1462	1458	1458
   query48	304	326	236	236
   query49	604	426	337	337
   query50	616	260	197	197
   query51	3749	3750	3803	3750
   query52	106	107	92	92
   query53	289	313	269	269
   query54	304	291	280	280
   query55	81	79	78	78
   query56	301	296	322	296
   query57	1033	1019	885	885
   query58	266	249	262	249
   query59	2156	2223	2051	2051
   query60	333	327	301	301
   query61	147	145	143	143
   query62	377	354	309	309
   query63	308	268	266	266
   query64	4913	1259	968	968
   query65	3812	3751	3713	3713
   query66	1383	418	323	323
   query67	15380	15550	15470	15470
   query68	2342	1100	778	778
   query69	450	359	365	359
   query70	971	907	946	907
   query71	326	312	287	287
   query72	5271	3352	3284	3284
   query73	603	719	317	317
   query74	8675	8778	8580	8580
   query75	2774	2828	2447	2447
   query76	2291	1053	647	647
   query77	370	404	307	307
   query78	9820	9752	9237	9237
   query79	1053	902	572	572
   query80	815	597	525	525
   query81	501	259	238	238
   query82	1347	147	112	112
   query83	356	245	236	236
   query84	248	109	90	90
   query85	867	512	411	411
   query86	363	296	315	296
   query87	2852	2823	2768	2768
   query88	3476	2579	2554	2554
   query89	386	346	313	313
   query90	1853	172	164	164
   query91	159	160	127	127
   query92	72	76	72	72
   query93	938	900	540	540
   query94	593	332	292	292
   query95	581	399	314	314
   query96	668	505	231	231
   query97	2372	2387	2319	2319
   query98	202	203	202	202
   query99	608	603	536	536
   Total cold run time: 248034 ms
   Total hot run time: 174023 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](nereids) show columns type hide Column Version [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3728110934

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 172961 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpcds-tools
   TPC-DS sf100 test result on commit a256adced53008ce73727361d10276c9ae2ed7f6, data reload: false
   
   query5	5323	593	435	435
   query6	335	220	200	200
   query7	4240	450	266	266
   query8	343	244	228	228
   query9	8773	2656	2610	2610
   query10	555	364	346	346
   query11	15142	15092	14844	14844
   query12	193	112	118	112
   query13	1276	507	362	362
   query14	7082	3100	2730	2730
   query14_1	2637	2618	2655	2618
   query15	200	193	173	173
   query16	986	462	440	440
   query17	1113	659	567	567
   query18	2702	434	328	328
   query19	229	238	198	198
   query20	125	116	116	116
   query21	225	141	121	121
   query22	3816	3998	3805	3805
   query23	15994	15648	15403	15403
   query23_1	15311	15675	15433	15433
   query24	7178	1547	1159	1159
   query24_1	1189	1172	1189	1172
   query25	524	453	389	389
   query26	1243	260	151	151
   query27	2776	458	283	283
   query28	4576	2130	2092	2092
   query29	766	531	427	427
   query30	307	234	208	208
   query31	814	633	535	535
   query32	74	68	65	65
   query33	535	322	279	279
   query34	893	880	513	513
   query35	752	778	698	698
   query36	874	869	884	869
   query37	127	105	83	83
   query38	2732	2712	2672	2672
   query39	773	760	730	730
   query39_1	718	718	718	718
   query40	218	130	118	118
   query41	68	63	64	63
   query42	105	101	103	101
   query43	435	447	412	412
   query44	1327	719	714	714
   query45	186	184	173	173
   query46	850	951	576	576
   query47	1409	1438	1363	1363
   query48	310	324	244	244
   query49	605	421	334	334
   query50	637	298	205	205
   query51	3770	3750	3738	3738
   query52	109	107	96	96
   query53	294	333	282	282
   query54	280	255	240	240
   query55	77	75	72	72
   query56	301	290	295	290
   query57	1033	1033	972	972
   query58	265	252	250	250
   query59	2150	2166	1993	1993
   query60	325	311	303	303
   query61	165	156	169	156
   query62	383	376	337	337
   query63	298	276	274	274
   query64	4989	1406	1097	1097
   query65	3795	3720	3752	3720
   query66	1396	430	321	321
   query67	15582	15658	15358	15358
   query68	2750	1013	754	754
   query69	474	363	320	320
   query70	1008	971	938	938
   query71	327	300	283	283
   query72	6386	3591	3429	3429
   query73	586	725	301	301
   query74	8792	8758	8613	8613
   query75	2750	2801	2445	2445
   query76	2880	1070	645	645
   query77	346	378	272	272
   query78	9822	10013	9162	9162
   query79	1040	918	606	606
   query80	1163	595	488	488
   query81	576	261	234	234
   query82	419	152	112	112
   query83	366	253	237	237
   query84	264	115	102	102
   query85	943	512	454	454
   query86	434	319	320	319
   query87	2877	2904	2753	2753
   query88	3251	2240	2233	2233
   query89	387	333	333	333
   query90	1989	156	141	141
   query91	168	164	141	141
   query92	72	68	64	64
   query93	1097	911	528	528
   query94	667	330	291	291
   query95	604	381	302	302
   query96	601	474	217	217
   query97	2376	2364	2302	2302
   query98	209	205	198	198
   query99	581	590	513	513
   Total cold run time: 250053 ms
   Total hot run time: 172961 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](nereids) show columns type hide Column Version [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3749215398

   # FE UT Coverage Report
   Increment line coverage `  0.00% (0/2)` :tada:
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/59684_7696ecc58116fee112e99948b0d658a9961d4953/fe_increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/59684_7696ecc58116fee112e99948b0d658a9961d4953/fe_report/index.html)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](nereids) show columns type hide Column Version [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3770924821

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 26.5 s</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/clickbench-tools
   ClickBench test result on commit f06505305ef125755265835e28d064f6476fe03e, data reload: false
   
   query1	0.05	0.05	0.05
   query2	0.10	0.04	0.04
   query3	0.26	0.08	0.08
   query4	1.61	0.12	0.11
   query5	0.28	0.25	0.25
   query6	1.14	0.67	0.65
   query7	0.03	0.02	0.03
   query8	0.05	0.04	0.04
   query9	0.55	0.51	0.51
   query10	0.55	0.54	0.55
   query11	0.13	0.10	0.10
   query12	0.14	0.11	0.10
   query13	0.59	0.59	0.59
   query14	0.96	0.93	0.94
   query15	0.80	0.76	0.77
   query16	0.40	0.41	0.41
   query17	0.99	1.00	1.02
   query18	0.22	0.21	0.21
   query19	1.92	1.73	1.78
   query20	0.05	0.01	0.02
   query21	15.43	0.26	0.15
   query22	5.21	0.06	0.04
   query23	16.08	0.28	0.10
   query24	0.93	0.57	0.18
   query25	0.13	0.09	0.08
   query26	0.14	0.13	0.13
   query27	0.09	0.05	0.05
   query28	3.73	1.07	0.89
   query29	12.57	3.90	3.11
   query30	0.27	0.14	0.12
   query31	2.83	0.64	0.40
   query32	3.24	0.56	0.47
   query33	2.99	3.04	2.97
   query34	16.22	5.10	4.42
   query35	4.52	4.42	4.50
   query36	0.65	0.50	0.49
   query37	0.10	0.06	0.06
   query38	0.07	0.04	0.04
   query39	0.05	0.03	0.03
   query40	0.17	0.15	0.14
   query41	0.09	0.04	0.03
   query42	0.04	0.03	0.02
   query43	0.05	0.04	0.03
   Total cold run time: 96.42 s
   Total hot run time: 26.5 s
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](nereids) show columns type hide Column Version [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3771194852

   # FE Regression Coverage Report
   Increment line coverage `  100.00% (2/2)` :tada:
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/59684_f06505305ef125755265835e28d064f6476fe03e_merge_fe/increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/59684_f06505305ef125755265835e28d064f6476fe03e_merge_fe/report/index.html)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](nereids) show columns type hide Column Version [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3749080339

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 31318 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit 7696ecc58116fee112e99948b0d658a9961d4953, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17615	4230	4042	4042
   q2	2069	347	227	227
   q3	10153	1253	694	694
   q4	10227	898	303	303
   q5	7558	2104	1797	1797
   q6	187	179	140	140
   q7	930	763	645	645
   q8	9259	1409	1126	1126
   q9	4839	4522	4527	4522
   q10	6766	1778	1405	1405
   q11	520	299	278	278
   q12	687	733	603	603
   q13	17793	3800	3085	3085
   q14	285	303	276	276
   q15	584	512	505	505
   q16	689	690	640	640
   q17	646	781	483	483
   q18	6601	6487	6523	6487
   q19	1125	973	593	593
   q20	397	360	242	242
   q21	2944	2426	2256	2256
   q22	1045	1022	969	969
   Total cold run time: 102919 ms
   Total hot run time: 31318 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4078	4035	4009	4009
   q2	330	414	336	336
   q3	2058	2557	2223	2223
   q4	1286	1758	1344	1344
   q5	4188	3998	4035	3998
   q6	222	168	129	129
   q7	1931	1828	1630	1630
   q8	2820	2505	2495	2495
   q9	7311	7184	7091	7091
   q10	2561	2748	2395	2395
   q11	594	488	447	447
   q12	709	766	663	663
   q13	3589	4076	3504	3504
   q14	298	301	278	278
   q15	533	517	509	509
   q16	643	672	628	628
   q17	1150	1347	1567	1347
   q18	8104	7682	7947	7682
   q19	877	824	828	824
   q20	2007	2122	1915	1915
   q21	4512	4223	4177	4177
   q22	1076	1059	986	986
   Total cold run time: 50877 ms
   Total hot run time: 48610 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](nereids) show columns type hide Column Version [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3770988431

   # FE UT Coverage Report
   Increment line coverage `  0.00% (0/2)` :tada:
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/59684_f06505305ef125755265835e28d064f6476fe03e/fe_increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/59684_f06505305ef125755265835e28d064f6476fe03e/fe_report/index.html)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](nereids) show columns type hide Column Version [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3771538705

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


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](nereids) show columns type hide Column Version [doris]

Posted by "Thearas (via GitHub)" <gi...@apache.org>.
Thearas commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3723386402

   
   Thank you for your contribution to Apache Doris.
   Don't know what should be done next? See [How to process your PR](https://cwiki.apache.org/confluence/display/DORIS/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?
       


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](nereids) show columns type hide Column Version [doris]

Posted by "catpineapple (via GitHub)" <gi...@apache.org>.
catpineapple merged PR #59684:
URL: https://github.com/apache/doris/pull/59684


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](nereids) show columns type hide Column Version [doris]

Posted by "catpineapple (via GitHub)" <gi...@apache.org>.
catpineapple commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3770817697

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](nereids) show columns type hide Column Version [doris]

Posted by "doris-robot (via GitHub)" <gi...@apache.org>.
doris-robot commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3770880666

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 31291 ms</b></summary>
   
   ```
   machine: 'aliyun_ecs.c7a.8xlarge_32C64G'
   scripts: https://github.com/apache/doris/tree/master/tools/tpch-tools
   Tpch sf100 test result on commit f06505305ef125755265835e28d064f6476fe03e, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17616	4254	4046	4046
   q2	2139	381	239	239
   q3	10070	1271	713	713
   q4	10192	795	313	313
   q5	7524	2110	1817	1817
   q6	195	171	137	137
   q7	922	791	647	647
   q8	9272	1369	1111	1111
   q9	4863	4659	4544	4544
   q10	6726	1807	1404	1404
   q11	499	298	288	288
   q12	680	744	603	603
   q13	17787	3777	3117	3117
   q14	296	295	277	277
   q15	609	512	511	511
   q16	691	689	635	635
   q17	648	763	587	587
   q18	6724	6240	6324	6240
   q19	1237	979	592	592
   q20	400	361	251	251
   q21	2990	2508	2254	2254
   q22	1066	1022	965	965
   Total cold run time: 103146 ms
   Total hot run time: 31291 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4125	4058	4043	4043
   q2	333	376	333	333
   q3	2135	2607	2229	2229
   q4	1361	1763	1319	1319
   q5	4111	3977	4017	3977
   q6	213	174	131	131
   q7	1841	1792	1673	1673
   q8	2787	2491	2581	2491
   q9	7302	7196	7197	7196
   q10	2745	2755	2278	2278
   q11	564	539	449	449
   q12	710	791	648	648
   q13	3631	3977	3336	3336
   q14	290	296	290	290
   q15	539	513	495	495
   q16	664	680	633	633
   q17	1224	1303	1488	1303
   q18	8184	7944	7913	7913
   q19	891	819	807	807
   q20	2054	2048	2021	2021
   q21	4749	4691	4444	4444
   q22	1056	1052	972	972
   Total cold run time: 51509 ms
   Total hot run time: 48981 ms
   ```
   </details>
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](nereids) show columns type hide Column Version [doris]

Posted by "github-actions[bot] (via GitHub)" <gi...@apache.org>.
github-actions[bot] commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3771538822

   PR approved by anyone and no changes requested.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](nereids) show columns type hide Column Version [doris]

Posted by "catpineapple (via GitHub)" <gi...@apache.org>.
catpineapple commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3742321711

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](nereids) show columns type hide Column Version [doris]

Posted by "hello-stephen (via GitHub)" <gi...@apache.org>.
hello-stephen commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3728282861

   # FE UT Coverage Report
   Increment line coverage `  0.00% (0/1)` :tada:
   [Increment coverage report](http://coverage.selectdb-in.cc/coverage/59684_a256adced53008ce73727361d10276c9ae2ed7f6/fe_increment_report/index.html)
   [Complete coverage report](http://coverage.selectdb-in.cc/coverage/59684_a256adced53008ce73727361d10276c9ae2ed7f6/fe_report/index.html)
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org


Re: [PR] [fix](nereids) show columns type hide Column Version [doris]

Posted by "catpineapple (via GitHub)" <gi...@apache.org>.
catpineapple commented on PR #59684:
URL: https://github.com/apache/doris/pull/59684#issuecomment-3727956263

   run buildall


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org