SHOW STORAGE POLICY
描述
查看所有/指定存储策略关联的表和分区。
语法
SHOW STORAGE POLICY [ USING [ FOR <storage_policy_name> ] ]
必选参数（Required Parameters）
<storage_policy_name>: 要查看的存储策略的名字。
权限控制
执行此 SQL 命令成功的前置条件是，拥有 ADMIN_PRIV 权限，参考权限文档。
| 权限（Privilege） | 对象（Object） | 说明（Notes） |
|---|---|---|
| ADMIN_PRIV | 整个集群管理权限 | 除 NODE_PRIV 以外的所有权限 |
示例
-
查看所有启用了存储策略的对象。
show storage policy using;+-----------------------+-----------------------------------------+----------------------------------------+------------+
| PolicyName | Database | Table | Partitions |
+-----------------------+-----------------------------------------+----------------------------------------+------------+
| test_storage_policy | regression_test_cold_heat_separation_p2 | table_with_storage_policy_1 | ALL |
| test_storage_policy | regression_test_cold_heat_separation_p2 | partition_with_multiple_storage_policy | p201701 |
| test_storage_policy_2 | regression_test_cold_heat_separation_p2 | partition_with_multiple_storage_policy | p201702 |
| test_storage_policy_2 | regression_test_cold_heat_separation_p2 | table_with_storage_policy_2 | ALL |
| test_policy | db2 | db2_test_1 | ALL |
+-----------------------+-----------------------------------------+----------------------------------------+------------+ -
查看使用存储策略
test_storage_policy的对象。show storage policy using for test_storage_policy;+---------------------+-----------+---------------------------------+------------+
| PolicyName | Database | Table | Partitions |
+---------------------+-----------+---------------------------------+------------+
| test_storage_policy | db_1 | partition_with_storage_policy_1 | p201701 |
| test_storage_policy | db_1 | table_with_storage_policy_1 | ALL |
+---------------------+-----------+---------------------------------+------------+ -
查看所有存储策略的属性。
show storage policy;+-------------+----------+---------+---------+-----------------+------------------+-------------+
| PolicyName | Id | Version | Type | StorageResource | CooldownDatetime | CooldownTtl |
+-------------+----------+---------+---------+-----------------+------------------+-------------+
| test_policy | 14589252 | 0 | STORAGE | remote_s3 | -1 | 300 |
| dev_policy | 14589521 | 0 | STORAGE | remote_s3 | -1 | 3000 |
+-------------+----------+---------+---------+-----------------+------------------+-------------+
