PARTITIONS
partitions
Name
partitions
Description
表函数，生成分区临时表，可以查看某个 TABLE 的分区列表。
该函数用于 From 子句中。
该函数自 2.1.5 版本开始支持。
Syntax
partitions("catalog"="","database"="","table"="")
partitions()表结构：
mysql> desc function partitions("catalog"="internal","database"="zd","table"="user");
+--------------------------+---------+------+-------+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------------+---------+------+-------+---------+-------+
| PartitionId | BIGINT | No | false | NULL | NONE |
| PartitionName | TEXT | No | false | NULL | NONE |
| VisibleVersion | BIGINT | No | false | NULL | NONE |
| VisibleVersionTime | TEXT | No | false | NULL | NONE |
| State | TEXT | No | false | NULL | NONE |
| PartitionKey | TEXT | No | false | NULL | NONE |
| Range | TEXT | No | false | NULL | NONE |
| DistributionKey | TEXT | No | false | NULL | NONE |
| Buckets | INT | No | false | NULL | NONE |
| ReplicationNum | INT | No | false | NULL | NONE |
| StorageMedium | TEXT | No | false | NULL | NONE |
| CooldownTime | TEXT | No | false | NULL | NONE |
| RemoteStoragePolicy | TEXT | No | false | NULL | NONE |
| LastConsistencyCheckTime | TEXT | No | false | NULL | NONE |
| DataSize | TEXT | No | false | NULL | NONE |
| IsInMemory | BOOLEAN | No | false | NULL | NONE |
| ReplicaAllocation | TEXT | No | false | NULL | NONE |
| IsMutable | BOOLEAN | No | false | NULL | NONE |
| SyncWithBaseTables | BOOLEAN | No | false | NULL | NONE |
| UnsyncTables | TEXT | No | false | NULL | NONE |
+--------------------------+---------+------+-------+---------+-------+
20 rows in set (0.02 sec)
- PartitionId：分区id
- PartitionName：分区名字
- VisibleVersion：分区版本
- VisibleVersionTime：分区版本提交时间
- State：分区状态
- PartitionKey：分区key
- Range：分区范围
- DistributionKey：分布key
- Buckets：分桶数量
- ReplicationNum：副本数
- StorageMedium：存储介质
- CooldownTime：cooldown时间
- RemoteStoragePolicy：远程存储策略
- LastConsistencyCheckTime：上次一致性检查时间
- DataSize：数据大小
- IsInMemory：是否存在内存
- ReplicaAllocation：分布策略
- IsMutable：是否可变
- SyncWithBaseTables：是否和基表数据同步（针对异步物化视图的分区）
- UnsyncTables：和哪个基表数据不同步（针对异步物化视图的分区）
mysql> desc function partitions("catalog"="hive","database"="zdtest","table"="com2");
+-----------+------+------+-------+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------+------+------+-------+---------+-------+
| Partition | TEXT | No | false | NULL | NONE |
+-----------+------+------+-------+---------+-------+
1 row in set (0.11 sec)
- Partition：分区名字
Example
- 查看 internal CATALOG 下 db1 的 table1 的分区列表
mysql> select * from partitions("catalog"="internal","database"="db1","table"="table1");
- 查看 table1 下的分区名称为 partition1 的分区信息
mysql> select * from partitions("catalog"="internal","database"="db1","table"="table1") where PartitionName = "partition1";
- 查看 table1 下的分区名称为 partition1 的分区 id
mysql> select PartitionId from partitions("catalog"="internal","database"="db1","table"="table1") where PartitionName = "partition1";
Keywords
partitions
