PARTITIONS
更新时间：2025-10-16
描述
表函数，生成分区临时表，可以查看某个 TABLE 的分区列表。
语法
SQL
1PARTITIONS(
2 "catalog"="<catalog>",
3 "database"="<database>",
4 "table"="<table>"
5)必填参数 (Required Parameters)
| 字段 | 描述 |
|---|---|
<catalog> |
指定需要查询的集群 catalog 名。 |
<database> |
指定需要查询的集群数据库名。 |
<table> |
指定需要查询的集群表名。 |
返回值
| 字段名 | 描述 |
|---|---|
| PartitionId | 分区 ID |
| PartitionName | 分区名称 |
| VisibleVersion | 分区版本 |
| VisibleVersionTime | 分区版本提交时间 |
| State | 分区状态 |
| PartitionKey | 分区键 |
| Range | 分区范围 |
| DistributionKey | 分布键 |
| Buckets | 分桶数量 |
| ReplicationNum | 副本数 |
| StorageMedium | 存储介质 |
| CooldownTime | 冷却时间 |
| RemoteStoragePolicy | 远程存储策略 |
| LastConsistencyCheckTime | 上次一致性检查时间 |
| DataSize | 数据大小 |
| IsInMemory | 是否存在内存 |
| ReplicaAllocation | 分布策略 |
| IsMutable | 是否可变 |
| SyncWithBaseTables | 是否和基表数据同步（针对异步物化视图的分区） |
| UnsyncTables | 和哪个基表数据不同步（针对异步物化视图的分区） |
示例
查看 internal CATALOG 下 test 的 example_table 的分区列表
SQL
1select * from partitions("catalog"="internal","database"="test","table"="example_table");
Text
1+-------------+---------------+----------------+---------------------+--------+--------------+--------------------------------------------------------------------------------+-----------------+---------+----------------+---------------+---------------------+---------------------+--------------------------+----------+------------+-------------------------+-----------+--------------------+--------------+
2| PartitionId | PartitionName | VisibleVersion | VisibleVersionTime | State | PartitionKey | Range | DistributionKey | Buckets | ReplicationNum | StorageMedium | CooldownTime | RemoteStoragePolicy | LastConsistencyCheckTime | DataSize | IsInMemory | ReplicaAllocation | IsMutable | SyncWithBaseTables | UnsyncTables |
3+-------------+---------------+----------------+---------------------+--------+--------------+--------------------------------------------------------------------------------+-----------------+---------+----------------+---------------+---------------------+---------------------+--------------------------+----------+------------+-------------------------+-----------+--------------------+--------------+
4| 43209 | p1 | 1 | 2025-01-17 12:35:22 | NORMAL | created_at | [types: [DATEV2]; keys: [0000-01-01]; ..types: [DATEV2]; keys: [2023-01-01]; ) | id | 10 | 1 | HDD | 9999-12-31 23:59:59 | | \N | 0.000 | 0 | tag.location.default: 1 | 1 | 1 | \N |
5| 43210 | p2 | 1 | 2025-01-17 12:35:22 | NORMAL | created_at | [types: [DATEV2]; keys: [2023-01-01]; ..types: [DATEV2]; keys: [2024-01-01]; ) | id | 10 | 1 | HDD | 9999-12-31 23:59:59 | | \N | 0.000 | 0 | tag.location.default: 1 | 1 | 1 | \N |
6| 43211 | p3 | 1 | 2025-01-17 12:35:22 | NORMAL | created_at | [types: [DATEV2]; keys: [2024-01-01]; ..types: [DATEV2]; keys: [2025-01-01]; ) | id | 10 | 1 | HDD | 9999-12-31 23:59:59 | | \N | 0.000 | 0 | tag.location.default: 1 | 1 | 1 | \N |
7| 43212 | p4 | 1 | 2025-01-17 12:35:22 | NORMAL | created_at | [types: [DATEV2]; keys: [2025-01-01]; ..types: [DATEV2]; keys: [2026-01-01]; ) | id | 10 | 1 | HDD | 9999-12-31 23:59:59 | | \N | 0.000 | 0 | tag.location.default: 1 | 1 | 1 | \N |
8+-------------+---------------+----------------+---------------------+--------+--------------+--------------------------------------------------------------------------------+-----------------+---------+----------------+---------------+---------------------+---------------------+--------------------------+----------+------------+-------------------------+-----------+--------------------+--------------+查看 example_table 下的分区名称为 partition1 的分区信息
SQL
1select * from partitions("catalog"="internal","database"="test","table"="example_table") where PartitionName = "p1";
Text
1+-------------+---------------+----------------+---------------------+--------+--------------+--------------------------------------------------------------------------------+-----------------+---------+----------------+---------------+---------------------+---------------------+--------------------------+----------+------------+-------------------------+-----------+--------------------+--------------+
2| PartitionId | PartitionName | VisibleVersion | VisibleVersionTime | State | PartitionKey | Range | DistributionKey | Buckets | ReplicationNum | StorageMedium | CooldownTime | RemoteStoragePolicy | LastConsistencyCheckTime | DataSize | IsInMemory | ReplicaAllocation | IsMutable | SyncWithBaseTables | UnsyncTables |
3+-------------+---------------+----------------+---------------------+--------+--------------+--------------------------------------------------------------------------------+-----------------+---------+----------------+---------------+---------------------+---------------------+--------------------------+----------+------------+-------------------------+-----------+--------------------+--------------+
4| 43209 | p1 | 1 | 2025-01-17 12:35:22 | NORMAL | created_at | [types: [DATEV2]; keys: [0000-01-01]; ..types: [DATEV2]; keys: [2023-01-01]; ) | id | 10 | 1 | HDD | 9999-12-31 23:59:59 | | \N | 0.000 | 0 | tag.location.default: 1 | 1 | 1 | \N |
5+-------------+---------------+----------------+---------------------+--------+--------------+--------------------------------------------------------------------------------+-----------------+---------+----------------+---------------+---------------------+---------------------+--------------------------+----------+------------+-------------------------+-----------+--------------------+--------------+查看 user_tab 下的分区名称为 partition1 的分区 id
SQL
1select PartitionId from partitions("catalog"="internal","database"="test","table"="example_table") where PartitionName = "p1";
Text
1+-------------+
2| PartitionId |
3+-------------+
4| 43209 |
5+-------------+