You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by "zddr (via GitHub)" <gi...@apache.org> on 2024/06/18 10:01:07 UTC

[PR] [enhance](mtmv)support partition tvf [doris]

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

   only support olap table
    ```
   mysql> select * from partitions("database"="zd","table"="ss")\G
   *************************** 1. row ***************************
                PartitionId: 14004
              PartitionName: p1
             VisibleVersion: 1
         VisibleVersionTime: 2024-06-18 17:41:07
                      State: NORMAL
               PartitionKey: k3
                      Range: [types: [INT]; keys: [1]; ]
            DistributionKey: k2
                    Buckets: 2
             ReplicationNum: 1
              StorageMedium: HDD
               CooldownTime: 9999-12-31 23:59:59
        RemoteStoragePolicy: 
   LastConsistencyCheckTime: \N
                   DataSize: 0.000 
                 IsInMemory: 0
          ReplicaAllocation: tag.location.default: 1
                  IsMutable: 1
         SyncWithBaseTables: 1
               UnsyncTables: \N
   1 row in set (0.02 sec)
   ```
   
   


-- 
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] [enhance](mtmv)support partition tvf [doris]

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

   clang-tidy review says "All clean, LGTM! :+1:"


-- 
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] [enhance](mtmv)support partition tvf [doris]

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

   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] [enhance](mtmv)support partition tvf [doris]

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

   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)
   
   Since 2024-03-18, the Document has been moved to [doris-website](https://github.com/apache/doris-website).
   See [Doris Document](https://cwiki.apache.org/confluence/display/DORIS/Doris+Document).


-- 
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] [enhance](mtmv)support partition tvf [doris]

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

   
   <details>
   <summary>ClickBench: <b>Total hot run time: 31.12 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 4a3df1d7d2f6f9c6d0b319f7b72f1542fc311d55, data reload: false
   
   query1	0.04	0.03	0.03
   query2	0.08	0.03	0.04
   query3	0.22	0.04	0.04
   query4	1.68	0.10	0.07
   query5	0.51	0.49	0.50
   query6	1.13	0.73	0.73
   query7	0.02	0.01	0.01
   query8	0.04	0.04	0.04
   query9	0.54	0.48	0.49
   query10	0.55	0.54	0.55
   query11	0.15	0.11	0.11
   query12	0.15	0.12	0.12
   query13	0.59	0.59	0.59
   query14	0.76	0.79	0.78
   query15	0.84	0.82	0.82
   query16	0.38	0.36	0.38
   query17	0.99	1.04	1.03
   query18	0.22	0.23	0.24
   query19	1.77	1.74	1.78
   query20	0.01	0.01	0.01
   query21	15.42	0.66	0.66
   query22	3.77	7.29	2.36
   query23	18.28	1.29	1.20
   query24	2.06	0.25	0.22
   query25	0.16	0.08	0.08
   query26	0.26	0.18	0.18
   query27	0.08	0.08	0.08
   query28	13.26	1.02	0.99
   query29	12.60	3.36	3.30
   query30	0.25	0.06	0.05
   query31	2.87	0.40	0.38
   query32	3.27	0.48	0.46
   query33	2.93	2.88	2.94
   query34	17.10	4.47	4.45
   query35	4.53	4.50	4.51
   query36	0.65	0.48	0.49
   query37	0.18	0.16	0.15
   query38	0.14	0.14	0.14
   query39	0.04	0.04	0.03
   query40	0.17	0.14	0.14
   query41	0.08	0.05	0.05
   query42	0.05	0.05	0.05
   query43	0.04	0.04	0.04
   Total cold run time: 108.86 s
   Total hot run time: 31.12 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] [enhance](mtmv)support partition tvf [doris]

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

   clang-tidy review says "All clean, LGTM! :+1:"


-- 
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] [enhance](mtmv)support partition tvf [doris]

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

   TeamCity be ut coverage result:
    Function Coverage: 36.48% (9003/24680) 
    Line Coverage: 28.02% (73758/263201)
    Region Coverage: 27.50% (38316/139340)
    Branch Coverage: 24.19% (19526/80708)
    Coverage Report: http://coverage.selectdb-in.cc/coverage/f40e9dc8539aa2cc6f8a7bf9336d327cd57d44a5_f40e9dc8539aa2cc6f8a7bf9336d327cd57d44a5/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] [enhance](mtmv)support partition tvf [doris]

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

   
   <details>
   <summary>TPC-H: <b>Total hot run time: 40081 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 4a3df1d7d2f6f9c6d0b319f7b72f1542fc311d55, data reload: false
   
   ------ Round 1 ----------------------------------
   q1	17756	4621	4293	4293
   q2	2010	195	191	191
   q3	10536	1198	1116	1116
   q4	10202	831	800	800
   q5	7469	2683	2625	2625
   q6	220	136	137	136
   q7	955	615	603	603
   q8	9227	2082	2073	2073
   q9	8952	6517	6495	6495
   q10	9009	3752	3788	3752
   q11	463	266	240	240
   q12	433	227	221	221
   q13	18620	3023	3004	3004
   q14	283	222	222	222
   q15	523	488	478	478
   q16	498	372	384	372
   q17	970	682	704	682
   q18	8129	7466	7651	7466
   q19	6864	1441	1422	1422
   q20	655	319	348	319
   q21	4963	3222	3930	3222
   q22	399	349	353	349
   Total cold run time: 119136 ms
   Total hot run time: 40081 ms
   
   ----- Round 2, with runtime_filter_mode=off -----
   q1	4457	4438	4316	4316
   q2	391	265	267	265
   q3	3200	2938	2924	2924
   q4	2042	1790	1759	1759
   q5	5511	5481	5535	5481
   q6	232	132	132	132
   q7	2256	1848	1848	1848
   q8	3317	3460	3458	3458
   q9	8713	8893	8721	8721
   q10	4032	3764	4086	3764
   q11	590	504	506	504
   q12	847	645	636	636
   q13	17599	3191	3199	3191
   q14	295	267	276	267
   q15	525	496	474	474
   q16	497	438	442	438
   q17	1828	1499	1491	1491
   q18	8151	8008	7886	7886
   q19	1847	1730	1675	1675
   q20	3082	1864	1845	1845
   q21	5209	4910	5013	4910
   q22	673	596	569	569
   Total cold run time: 75294 ms
   Total hot run time: 56554 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] [enhance](mtmv)support partition tvf [doris]

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

   
   <details>
   <summary>TPC-DS: <b>Total hot run time: 174041 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 4a3df1d7d2f6f9c6d0b319f7b72f1542fc311d55, data reload: false
   
   query1	932	379	407	379
   query2	6364	2390	2214	2214
   query3	6630	199	201	199
   query4	20965	17338	17199	17199
   query5	3685	469	470	469
   query6	248	154	167	154
   query7	4581	298	294	294
   query8	317	298	301	298
   query9	8748	2465	2467	2465
   query10	543	305	277	277
   query11	10555	9996	10064	9996
   query12	116	87	81	81
   query13	1643	367	378	367
   query14	9447	7680	7007	7007
   query15	244	186	183	183
   query16	7696	288	307	288
   query17	1400	542	523	523
   query18	1938	272	274	272
   query19	189	147	149	147
   query20	87	80	83	80
   query21	206	132	125	125
   query22	4388	4170	4026	4026
   query23	34008	33731	33898	33731
   query24	11304	2968	2882	2882
   query25	607	383	367	367
   query26	731	152	155	152
   query27	2349	329	325	325
   query28	6027	2161	2176	2161
   query29	868	637	612	612
   query30	274	159	156	156
   query31	936	765	765	765
   query32	87	54	57	54
   query33	762	306	291	291
   query34	1024	479	481	479
   query35	750	639	654	639
   query36	1089	994	983	983
   query37	147	74	82	74
   query38	2941	2847	2890	2847
   query39	890	841	849	841
   query40	204	129	130	129
   query41	54	54	51	51
   query42	119	98	99	98
   query43	597	536	542	536
   query44	1205	744	727	727
   query45	194	159	159	159
   query46	1094	716	721	716
   query47	1869	1774	1765	1765
   query48	374	299	304	299
   query49	882	401	405	401
   query50	762	397	419	397
   query51	6969	6819	6804	6804
   query52	102	94	93	93
   query53	356	295	280	280
   query54	918	452	443	443
   query55	75	73	75	73
   query56	278	260	256	256
   query57	1118	1021	1052	1021
   query58	262	234	241	234
   query59	3561	3169	3256	3169
   query60	300	274	266	266
   query61	91	92	95	92
   query62	618	450	440	440
   query63	316	282	286	282
   query64	8644	2322	1746	1746
   query65	3150	3111	3136	3111
   query66	738	329	332	329
   query67	15333	14959	15039	14959
   query68	4495	543	552	543
   query69	466	308	312	308
   query70	1125	1165	1176	1165
   query71	389	279	271	271
   query72	7159	5705	5135	5135
   query73	747	330	325	325
   query74	5949	5492	5499	5492
   query75	3392	2671	2671	2671
   query76	2152	911	933	911
   query77	487	311	312	311
   query78	10407	9870	9913	9870
   query79	2448	517	508	508
   query80	1331	459	459	459
   query81	596	224	224	224
   query82	697	101	105	101
   query83	248	171	170	170
   query84	249	88	87	87
   query85	1745	290	270	270
   query86	482	300	316	300
   query87	3328	3095	3106	3095
   query88	3720	2453	2452	2452
   query89	463	375	373	373
   query90	1730	189	191	189
   query91	133	100	101	100
   query92	65	52	48	48
   query93	2393	518	519	518
   query94	1090	196	188	188
   query95	416	323	327	323
   query96	587	271	274	271
   query97	3255	3039	3052	3039
   query98	223	201	199	199
   query99	1306	847	855	847
   Total cold run time: 269172 ms
   Total hot run time: 174041 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] [enhance](mtmv)support partition tvf [doris]

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

   clang-tidy review says "All clean, LGTM! :+1:"


-- 
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] [enhance](mtmv)support partition tvf [doris]

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

   clang-tidy review says "All clean, LGTM! :+1:"


-- 
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] [enhance](mtmv)support partition tvf [doris]

Posted by "morningman (via GitHub)" <gi...@apache.org>.
morningman commented on code in PR #36479:
URL: https://github.com/apache/doris/pull/36479#discussion_r1650338603


##########
fe/fe-core/src/main/java/org/apache/doris/tablefunction/PartitionsTableValuedFunction.java:
##########
@@ -0,0 +1,243 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements.  See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership.  The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License.  You may obtain a copy of the License at
+//
+//   http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied.  See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+package org.apache.doris.tablefunction;
+
+import org.apache.doris.catalog.Column;
+import org.apache.doris.catalog.DatabaseIf;
+import org.apache.doris.catalog.Env;
+import org.apache.doris.catalog.PrimitiveType;
+import org.apache.doris.catalog.ScalarType;
+import org.apache.doris.catalog.TableIf;
+import org.apache.doris.catalog.TableIf.TableType;
+import org.apache.doris.common.ErrorCode;
+import org.apache.doris.common.MetaNotFoundException;
+import org.apache.doris.datasource.CatalogIf;
+import org.apache.doris.datasource.InternalCatalog;
+import org.apache.doris.datasource.hive.HMSExternalCatalog;
+import org.apache.doris.datasource.hive.HMSExternalTable;
+import org.apache.doris.datasource.maxcompute.MaxComputeExternalCatalog;
+import org.apache.doris.datasource.maxcompute.MaxComputeExternalTable;
+import org.apache.doris.mysql.privilege.PrivPredicate;
+import org.apache.doris.nereids.exceptions.AnalysisException;
+import org.apache.doris.qe.ConnectContext;
+import org.apache.doris.thrift.TMetaScanRange;
+import org.apache.doris.thrift.TMetadataTableRequestParams;
+import org.apache.doris.thrift.TMetadataType;
+import org.apache.doris.thrift.TPartitionsMetadataParams;
+
+import com.google.common.collect.ImmutableList;
+import com.google.common.collect.ImmutableMap;
+import com.google.common.collect.ImmutableSet;
+import com.google.common.collect.Maps;
+import org.apache.commons.collections.CollectionUtils;
+import org.apache.commons.lang3.StringUtils;
+import org.apache.logging.log4j.LogManager;
+import org.apache.logging.log4j.Logger;
+
+import java.util.List;
+import java.util.Map;
+import java.util.Optional;
+
+/**
+ * The Implement of table valued function
+ * partitions("database" = "db1","table" = "table1").
+ */
+public class PartitionsTableValuedFunction extends MetadataTableValuedFunction {
+    private static final Logger LOG = LogManager.getLogger(PartitionsTableValuedFunction.class);
+
+    public static final String NAME = "partitions";
+
+    private static final String CATALOG = "catalog";
+    private static final String DB = "database";
+    private static final String TABLE = "table";
+
+    private static final ImmutableSet<String> PROPERTIES_SET = ImmutableSet.of(CATALOG, DB, TABLE);
+
+    private static final ImmutableList<Column> SCHEMA = ImmutableList.of(

Review Comment:
   ```suggestion
       private static final ImmutableList<Column> SCHEMA_FOR_OLAP_TABLE = ImmutableList.of(
   ```



##########
fe/fe-core/src/main/java/org/apache/doris/tablefunction/PartitionsTableValuedFunction.java:
##########
@@ -0,0 +1,243 @@
+// Licensed to the Apache Software Foundation (ASF) under one
+// or more contributor license agreements.  See the NOTICE file
+// distributed with this work for additional information
+// regarding copyright ownership.  The ASF licenses this file
+// to you under the Apache License, Version 2.0 (the
+// "License"); you may not use this file except in compliance
+// with the License.  You may obtain a copy of the License at
+//
+//   http://www.apache.org/licenses/LICENSE-2.0
+//
+// Unless required by applicable law or agreed to in writing,
+// software distributed under the License is distributed on an
+// "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+// KIND, either express or implied.  See the License for the
+// specific language governing permissions and limitations
+// under the License.
+
+package org.apache.doris.tablefunction;
+
+import org.apache.doris.catalog.Column;
+import org.apache.doris.catalog.DatabaseIf;
+import org.apache.doris.catalog.Env;
+import org.apache.doris.catalog.PrimitiveType;
+import org.apache.doris.catalog.ScalarType;
+import org.apache.doris.catalog.TableIf;
+import org.apache.doris.catalog.TableIf.TableType;
+import org.apache.doris.common.ErrorCode;
+import org.apache.doris.common.MetaNotFoundException;
+import org.apache.doris.datasource.CatalogIf;
+import org.apache.doris.datasource.InternalCatalog;
+import org.apache.doris.datasource.hive.HMSExternalCatalog;
+import org.apache.doris.datasource.hive.HMSExternalTable;
+import org.apache.doris.datasource.maxcompute.MaxComputeExternalCatalog;
+import org.apache.doris.datasource.maxcompute.MaxComputeExternalTable;
+import org.apache.doris.mysql.privilege.PrivPredicate;
+import org.apache.doris.nereids.exceptions.AnalysisException;
+import org.apache.doris.qe.ConnectContext;
+import org.apache.doris.thrift.TMetaScanRange;
+import org.apache.doris.thrift.TMetadataTableRequestParams;
+import org.apache.doris.thrift.TMetadataType;
+import org.apache.doris.thrift.TPartitionsMetadataParams;
+
+import com.google.common.collect.ImmutableList;
+import com.google.common.collect.ImmutableMap;
+import com.google.common.collect.ImmutableSet;
+import com.google.common.collect.Maps;
+import org.apache.commons.collections.CollectionUtils;
+import org.apache.commons.lang3.StringUtils;
+import org.apache.logging.log4j.LogManager;
+import org.apache.logging.log4j.Logger;
+
+import java.util.List;
+import java.util.Map;
+import java.util.Optional;
+
+/**
+ * The Implement of table valued function
+ * partitions("database" = "db1","table" = "table1").
+ */
+public class PartitionsTableValuedFunction extends MetadataTableValuedFunction {
+    private static final Logger LOG = LogManager.getLogger(PartitionsTableValuedFunction.class);
+
+    public static final String NAME = "partitions";
+
+    private static final String CATALOG = "catalog";
+    private static final String DB = "database";
+    private static final String TABLE = "table";
+
+    private static final ImmutableSet<String> PROPERTIES_SET = ImmutableSet.of(CATALOG, DB, TABLE);
+
+    private static final ImmutableList<Column> SCHEMA = ImmutableList.of(
+            new Column("PartitionId", ScalarType.createType(PrimitiveType.BIGINT)),
+            new Column("PartitionName", ScalarType.createStringType()),
+            new Column("VisibleVersion", ScalarType.createType(PrimitiveType.BIGINT)),
+            new Column("VisibleVersionTime", ScalarType.createStringType()),
+            new Column("State", ScalarType.createStringType()),
+            new Column("PartitionKey", ScalarType.createStringType()),
+            new Column("Range", ScalarType.createStringType()),
+            new Column("DistributionKey", ScalarType.createStringType()),
+            new Column("Buckets", ScalarType.createType(PrimitiveType.INT)),
+            new Column("ReplicationNum", ScalarType.createType(PrimitiveType.INT)),
+            new Column("StorageMedium", ScalarType.createStringType()),
+            new Column("CooldownTime", ScalarType.createStringType()),
+            new Column("RemoteStoragePolicy", ScalarType.createStringType()),
+            new Column("LastConsistencyCheckTime", ScalarType.createStringType()),
+            new Column("DataSize", ScalarType.createStringType()),
+            new Column("IsInMemory", ScalarType.createType(PrimitiveType.BOOLEAN)),
+            new Column("ReplicaAllocation", ScalarType.createStringType()),
+            new Column("IsMutable", ScalarType.createType(PrimitiveType.BOOLEAN)),
+            new Column("SyncWithBaseTables", ScalarType.createType(PrimitiveType.BOOLEAN)),
+            new Column("UnsyncTables", ScalarType.createStringType()));
+
+    private static final ImmutableList<Column> OTHER_SCHEMA = ImmutableList.of(

Review Comment:
   ```suggestion
       private static final ImmutableList<Column> SCHEMA_FOR_EXTERNAL_TABLE = ImmutableList.of(
   ```



-- 
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] [enhance](mtmv)support partition tvf [doris]

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

   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] [enhance](mtmv)support partition tvf [doris]

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

   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] [enhance](mtmv)support partition tvf [doris]

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

   clang-tidy review says "All clean, LGTM! :+1:"


-- 
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] [enhance](mtmv)support partition tvf [doris]

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

   run performance


-- 
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] [enhance](mtmv)support partition tvf [doris]

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

   clang-tidy review says "All clean, LGTM! :+1:"


-- 
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