SHOW STORAGE POLICY USING
Description
View all tables and partitions associated with a specified storage policy.
Syntax
SHOW STORAGE POLICY USING [FOR <some_policy>]
Optional Parameters
| Parameter Name | Description |
|---|---|
<policy_name> | Specifies the name of the storage policy to query. If provided, only the details of the specified storage policy will be displayed; if not provided, information for all storage policies will be shown. |
Examples
-
View all objects with a storage policy enabled
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 |
+-----------------------+-----------------------------------------+----------------------------------------+------------+ -
View objects that use the storage policy 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 |
+---------------------+-----------+---------------------------------+------------+
