显示分区
描述
该
SHOW PARTITIONS
语句用于列出表的分区。可以指定一个可选的分区规范，以返回与提供的分区规范匹配的分区。
语法
SHOW PARTITIONS table_identifier [ partition_spec ]
参数
-
table_identifier
指定一个表名，可选地可以用数据库名进行限定。
语法:
[ database_name. ] table_name -
partition_spec
一个可选参数，指定一个以逗号分隔的键值对列表，用于分区。当指定时，将返回与分区规范匹配的分区。
语法:
PARTITION ( partition_col_name = partition_col_val [ , ... ] )
示例
-- 创建一个分区表并插入几行数据。
USE salesdb;
CREATE TABLE customer(id INT, name STRING) PARTITIONED BY (state STRING, city STRING);
INSERT INTO customer PARTITION (state = 'CA', city = 'Fremont') VALUES (100, 'John');
INSERT INTO customer PARTITION (state = 'CA', city = 'San Jose') VALUES (200, 'Marry');
INSERT INTO customer PARTITION (state = , city = ) VALUES (300, );
-- 列出表 `customer` 的所有分区
SHOW PARTITIONS customer;
+----------------------+
| partition|
+----------------------+
| state=AZ/city=Peoria|
| state=CA/city=Fremont|
|state=CA/city=San Jose|
+----------------------+
-- 列出合格表 `customer` 的所有分区
SHOW PARTITIONS salesdb.customer;
+----------------------+
| partition|
+----------------------+
| state=AZ/city=Peoria|
| state=CA/city=Fremont|
|state=CA/city=San Jose|
+----------------------+
-- 指定完整的分区规范以列出特定分区
SHOW PARTITIONS customer PARTITION (state = 'CA', city = 'Fremont');
+---------------------+
| partition|
+---------------------+
|state=CA/city=Fremont|
+---------------------+
-- 指定部分分区规范以列出特定分区
SHOW PARTITIONS customer PARTITION (state = );
+----------------------+
| partition|
+----------------------+
| state=CA/city=Fremont|
|state=CA/city=San Jose|
+----------------------+
-- 指定部分规范以列出特定分区
SHOW PARTITIONS customer PARTITION (city = );
+----------------------+
| partition|
+----------------------+
|state=CA/city=San Jose|
+----------------------+