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 | +---------------------+-----------+---------------------------------+------------+