This is an automated email from the ASF dual-hosted git repository.
kassiez pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new b580d12739c [improve](stoarge-policy)Add a storage policy statement
with a usage description. (#2077)
b580d12739c is described below
commit b580d12739c8a01dad182a7ef04aea290bdec988
Author: Petrichor <1401597...@qq.com>
AuthorDate: Fri Feb 21 20:15:20 2025 +0800
[improve](stoarge-policy)Add a storage policy statement with a usage
description. (#2077)
## Versions
- [x] dev
- [x] 3.0
- [x] 2.1
- [ ] 2.0
## Languages
- [x] Chinese
- [x] English
## Docs Checklist
- [ ] Checked by AI
- [ ] Test Cases Built
---
.../storage-management/SHOW-STORAGE-POLICY.md | 77 ++++++++++++--------
.../storage-management/SHOW-STORAGE-POLICY.md | 75 +++++++++++--------
.../storage-management/SHOW STORAGE POLICY.md | 62 ++++++++++------
.../storage-management/SHOW-STORAGE-POLICY.md | 85 +++++++++++++---------
.../storage-management/SHOW-STORAGE-POLICY.md | 77 ++++++++++++--------
.../storage-management/SHOW-STORAGE-POLICY.md | 77 ++++++++++++--------
6 files changed, 281 insertions(+), 172 deletions(-)
diff --git
a/docs/sql-manual/sql-statements/cluster-management/storage-management/SHOW-STORAGE-POLICY.md
b/docs/sql-manual/sql-statements/cluster-management/storage-management/SHOW-STORAGE-POLICY.md
index 1eebeca109a..a1b4af25bf1 100644
---
a/docs/sql-manual/sql-statements/cluster-management/storage-management/SHOW-STORAGE-POLICY.md
+++
b/docs/sql-manual/sql-statements/cluster-management/storage-management/SHOW-STORAGE-POLICY.md
@@ -1,7 +1,7 @@
---
{
- "title": "SHOW STORAGE POLICY",
- "language": "en"
+ "title": "SHOW STORAGE POLICY",
+ "language": "en"
}
---
@@ -31,7 +31,7 @@ View tables and partitions associated with all/specified
storage policies.
## Syntax
```sql
-SHOW STORAGE POLICY USING [FOR <storage_policy_name>]
+SHOW STORAGE POLICY [ USING [ FOR <storage_policy_name> ] ]
```
## Required Parameters
@@ -40,37 +40,56 @@ SHOW STORAGE POLICY USING [FOR <storage_policy_name>]
> The name of the storage policy to view.
-The prerequisite for successfully executing this SQL command is to have
ADMIN_PRIV privileges. Please refer to the privilege document.
+The prerequisite for successfully executing this SQL command is to have
ADMIN_PRIV privileges. Please refer to the
+privilege document.
| Privilege (Privilege) | Object (Object) | Notes (Notes)
|
-| --------------------- | ------------------------------------ |
------------------------------- |
+|-----------------------|--------------------------------------|---------------------------------|
| ADMIN_PRIV | Entire cluster management privileges | All
privileges except NODE_PRIV |
## Example
1. View all objects with enabled storage policies.
- ```sql
- mysql> 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 |
-
+-----------------------+-----------------------------------------+----------------------------------------+------------+
- ```
-
-1. View objects using the storage policy test_storage_policy.
-
- ```sql
- mysql> 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
|
-
+---------------------+-----------+---------------------------------+------------+
- ```
+ ```sql
+ show storage policy using;
+ ```
+ ```text
+
+-----------------------+-----------------------------------------+----------------------------------------+------------+
+ | 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 |
+
+-----------------------+-----------------------------------------+----------------------------------------+------------+
+ ```
+
+2. View objects using the storage policy test_storage_policy.
+
+ ```sql
+ show storage policy using for test_storage_policy;
+ ```
+ ```text
+
+---------------------+-----------+---------------------------------+------------+
+ | 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
|
+
+---------------------+-----------+---------------------------------+------------+
+ ```
+
+3. View the properties of all storage policies.
+
+ ```sql
+ show storage policy;
+ ```
+ ```text
+
+-------------+----------+---------+---------+-----------------+------------------+-------------+
+ | 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 |
+
+-------------+----------+---------+---------+-----------------+------------------+-------------+
+ ```
\ No newline at end of file
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/cluster-management/storage-management/SHOW-STORAGE-POLICY.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/cluster-management/storage-management/SHOW-STORAGE-POLICY.md
index 3251af26b4b..2c2aac05cb0 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/cluster-management/storage-management/SHOW-STORAGE-POLICY.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/cluster-management/storage-management/SHOW-STORAGE-POLICY.md
@@ -23,6 +23,7 @@ KIND, either express or implied. See the License for the
specific language governing permissions and limitations
under the License.
-->
+
## 描述
查看所有/指定存储策略关联的表和分区。
@@ -30,14 +31,12 @@ under the License.
## 语法
```sql
-SHOW STORAGE POLICY USING [FOR <storage_policy_name>]
+SHOW STORAGE POLICY [ USING [ FOR <storage_policy_name> ] ]
```
-## 必选参数
-
-<storage_policy_name>
+## 必选参数（Required Parameters）
-> 要查看的存储策略的名字。
+`<storage_policy_name>`: 要查看的存储策略的名字。
## 权限控制
@@ -51,27 +50,45 @@ SHOW STORAGE POLICY USING [FOR <storage_policy_name>]
1. 查看所有启用了存储策略的对象。
- ```sql
- mysql> 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 |
-
+-----------------------+-----------------------------------------+----------------------------------------+------------+
- ```
-
-1. 查看使用存储策略 test_storage_policy 的对象。
-
- ```sql
- mysql> 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
|
-
+---------------------+-----------+---------------------------------+------------+
- ```
\ No newline at end of file
+ ```sql
+ show storage policy using;
+ ```
+ ```text
+
+-----------------------+-----------------------------------------+----------------------------------------+------------+
+ | 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 |
+
+-----------------------+-----------------------------------------+----------------------------------------+------------+
+ ```
+
+2. 查看使用存储策略 `test_storage_policy` 的对象。
+
+ ```sql
+ show storage policy using for test_storage_policy;
+ ```
+ ```text
+
+---------------------+-----------+---------------------------------+------------+
+ | 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
|
+
+---------------------+-----------+---------------------------------+------------+
+ ```
+
+3. 查看所有存储策略的属性。
+
+ ```sql
+ show storage policy;
+ ```
+ ```text
+
+-------------+----------+---------+---------+-----------------+------------------+-------------+
+ | 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 |
+
+-------------+----------+---------+---------+-----------------+------------------+-------------+
+ ```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/cluster-management/storage-management/SHOW
STORAGE POLICY.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/cluster-management/storage-management/SHOW
STORAGE POLICY.md
index 2a7bb6a7bfc..2c2aac05cb0 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/cluster-management/storage-management/SHOW
STORAGE POLICY.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/cluster-management/storage-management/SHOW
STORAGE POLICY.md
@@ -31,7 +31,7 @@ under the License.
## 语法
```sql
-SHOW STORAGE POLICY USING [FOR <storage_policy_name>]
+SHOW STORAGE POLICY [ USING [ FOR <storage_policy_name> ] ]
```
## 必选参数（Required Parameters）
@@ -50,27 +50,45 @@ SHOW STORAGE POLICY USING [FOR <storage_policy_name>]
1. 查看所有启用了存储策略的对象。
- ```sql
- mysql> 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 |
-
+-----------------------+-----------------------------------------+----------------------------------------+------------+
- ```
+ ```sql
+ show storage policy using;
+ ```
+ ```text
+
+-----------------------+-----------------------------------------+----------------------------------------+------------+
+ | 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 |
+
+-----------------------+-----------------------------------------+----------------------------------------+------------+
+ ```
2. 查看使用存储策略 `test_storage_policy` 的对象。
- ```sql
- mysql> 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
|
-
+---------------------+-----------+---------------------------------+------------+
- ```
\ No newline at end of file
+ ```sql
+ show storage policy using for test_storage_policy;
+ ```
+ ```text
+
+---------------------+-----------+---------------------------------+------------+
+ | 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
|
+
+---------------------+-----------+---------------------------------+------------+
+ ```
+
+3. 查看所有存储策略的属性。
+
+ ```sql
+ show storage policy;
+ ```
+ ```text
+
+-------------+----------+---------+---------+-----------------+------------------+-------------+
+ | 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 |
+
+-------------+----------+---------+---------+-----------------+------------------+-------------+
+ ```
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-statements/cluster-management/storage-management/SHOW-STORAGE-POLICY.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-statements/cluster-management/storage-management/SHOW-STORAGE-POLICY.md
index 3251af26b4b..689830a3698 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-statements/cluster-management/storage-management/SHOW-STORAGE-POLICY.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/sql-manual/sql-statements/cluster-management/storage-management/SHOW-STORAGE-POLICY.md
@@ -1,7 +1,7 @@
---
{
- "title": "SHOW STORAGE POLICY",
- "language": "zh-CN"
+ "title": "SHOW STORAGE POLICY",
+ "language": "zh-CN"
}
---
@@ -23,6 +23,7 @@ KIND, either express or implied. See the License for the
specific language governing permissions and limitations
under the License.
-->
+
## 描述
查看所有/指定存储策略关联的表和分区。
@@ -30,48 +31,64 @@ under the License.
## 语法
```sql
-SHOW STORAGE POLICY USING [FOR <storage_policy_name>]
+SHOW STORAGE POLICY [ USING [ FOR <storage_policy_name> ] ]
```
-## 必选参数
-
-<storage_policy_name>
+## 必选参数（Required Parameters）
-> 要查看的存储策略的名字。
+`<storage_policy_name>`: 要查看的存储策略的名字。
## 权限控制
执行此 SQL 命令成功的前置条件是，拥有 ADMIN_PRIV 权限，参考权限文档。
-| 权限（Privilege） | 对象（Object） | 说明（Notes） |
-| :---------------- | :--------------- | :-------------------------- |
-| ADMIN_PRIV | 整个集群管理权限 | 除 NODE_PRIV 以外的所有权限 |
+| 权限（Privilege） | 对象（Object） | 说明（Notes） |
+|:--------------|:-----------|:--------------------|
+| ADMIN_PRIV | 整个集群管理权限 | 除 NODE_PRIV 以外的所有权限 |
## 示例
1. 查看所有启用了存储策略的对象。
- ```sql
- mysql> 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 |
-
+-----------------------+-----------------------------------------+----------------------------------------+------------+
- ```
-
-1. 查看使用存储策略 test_storage_policy 的对象。
-
- ```sql
- mysql> 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
|
-
+---------------------+-----------+---------------------------------+------------+
- ```
\ No newline at end of file
+ ```sql
+ show storage policy using;
+ ```
+ ```text
+
+-----------------------+-----------------------------------------+----------------------------------------+------------+
+ | 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 |
+
+-----------------------+-----------------------------------------+----------------------------------------+------------+
+ ```
+
+2. 查看使用存储策略 `test_storage_policy` 的对象。
+
+ ```sql
+ show storage policy using for test_storage_policy;
+ ```
+ ```text
+
+---------------------+-----------+---------------------------------+------------+
+ | 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
|
+
+---------------------+-----------+---------------------------------+------------+
+ ```
+
+3. 查看所有存储策略的属性。
+
+ ```sql
+ show storage policy;
+ ```
+ ```text
+
+-------------+----------+---------+---------+-----------------+------------------+-------------+
+ | 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 |
+
+-------------+----------+---------+---------+-----------------+------------------+-------------+
+ ```
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/cluster-management/storage-management/SHOW-STORAGE-POLICY.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/cluster-management/storage-management/SHOW-STORAGE-POLICY.md
index 1eebeca109a..a1b4af25bf1 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/cluster-management/storage-management/SHOW-STORAGE-POLICY.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/cluster-management/storage-management/SHOW-STORAGE-POLICY.md
@@ -1,7 +1,7 @@
---
{
- "title": "SHOW STORAGE POLICY",
- "language": "en"
+ "title": "SHOW STORAGE POLICY",
+ "language": "en"
}
---
@@ -31,7 +31,7 @@ View tables and partitions associated with all/specified
storage policies.
## Syntax
```sql
-SHOW STORAGE POLICY USING [FOR <storage_policy_name>]
+SHOW STORAGE POLICY [ USING [ FOR <storage_policy_name> ] ]
```
## Required Parameters
@@ -40,37 +40,56 @@ SHOW STORAGE POLICY USING [FOR <storage_policy_name>]
> The name of the storage policy to view.
-The prerequisite for successfully executing this SQL command is to have
ADMIN_PRIV privileges. Please refer to the privilege document.
+The prerequisite for successfully executing this SQL command is to have
ADMIN_PRIV privileges. Please refer to the
+privilege document.
| Privilege (Privilege) | Object (Object) | Notes (Notes)
|
-| --------------------- | ------------------------------------ |
------------------------------- |
+|-----------------------|--------------------------------------|---------------------------------|
| ADMIN_PRIV | Entire cluster management privileges | All
privileges except NODE_PRIV |
## Example
1. View all objects with enabled storage policies.
- ```sql
- mysql> 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 |
-
+-----------------------+-----------------------------------------+----------------------------------------+------------+
- ```
-
-1. View objects using the storage policy test_storage_policy.
-
- ```sql
- mysql> 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
|
-
+---------------------+-----------+---------------------------------+------------+
- ```
+ ```sql
+ show storage policy using;
+ ```
+ ```text
+
+-----------------------+-----------------------------------------+----------------------------------------+------------+
+ | 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 |
+
+-----------------------+-----------------------------------------+----------------------------------------+------------+
+ ```
+
+2. View objects using the storage policy test_storage_policy.
+
+ ```sql
+ show storage policy using for test_storage_policy;
+ ```
+ ```text
+
+---------------------+-----------+---------------------------------+------------+
+ | 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
|
+
+---------------------+-----------+---------------------------------+------------+
+ ```
+
+3. View the properties of all storage policies.
+
+ ```sql
+ show storage policy;
+ ```
+ ```text
+
+-------------+----------+---------+---------+-----------------+------------------+-------------+
+ | 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 |
+
+-------------+----------+---------+---------+-----------------+------------------+-------------+
+ ```
\ No newline at end of file
diff --git
a/versioned_docs/version-3.0/sql-manual/sql-statements/cluster-management/storage-management/SHOW-STORAGE-POLICY.md
b/versioned_docs/version-3.0/sql-manual/sql-statements/cluster-management/storage-management/SHOW-STORAGE-POLICY.md
index 1eebeca109a..a1b4af25bf1 100644
---
a/versioned_docs/version-3.0/sql-manual/sql-statements/cluster-management/storage-management/SHOW-STORAGE-POLICY.md
+++
b/versioned_docs/version-3.0/sql-manual/sql-statements/cluster-management/storage-management/SHOW-STORAGE-POLICY.md
@@ -1,7 +1,7 @@
---
{
- "title": "SHOW STORAGE POLICY",
- "language": "en"
+ "title": "SHOW STORAGE POLICY",
+ "language": "en"
}
---
@@ -31,7 +31,7 @@ View tables and partitions associated with all/specified
storage policies.
## Syntax
```sql
-SHOW STORAGE POLICY USING [FOR <storage_policy_name>]
+SHOW STORAGE POLICY [ USING [ FOR <storage_policy_name> ] ]
```
## Required Parameters
@@ -40,37 +40,56 @@ SHOW STORAGE POLICY USING [FOR <storage_policy_name>]
> The name of the storage policy to view.
-The prerequisite for successfully executing this SQL command is to have
ADMIN_PRIV privileges. Please refer to the privilege document.
+The prerequisite for successfully executing this SQL command is to have
ADMIN_PRIV privileges. Please refer to the
+privilege document.
| Privilege (Privilege) | Object (Object) | Notes (Notes)
|
-| --------------------- | ------------------------------------ |
------------------------------- |
+|-----------------------|--------------------------------------|---------------------------------|
| ADMIN_PRIV | Entire cluster management privileges | All
privileges except NODE_PRIV |
## Example
1. View all objects with enabled storage policies.
- ```sql
- mysql> 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 |
-
+-----------------------+-----------------------------------------+----------------------------------------+------------+
- ```
-
-1. View objects using the storage policy test_storage_policy.
-
- ```sql
- mysql> 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
|
-
+---------------------+-----------+---------------------------------+------------+
- ```
+ ```sql
+ show storage policy using;
+ ```
+ ```text
+
+-----------------------+-----------------------------------------+----------------------------------------+------------+
+ | 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 |
+
+-----------------------+-----------------------------------------+----------------------------------------+------------+
+ ```
+
+2. View objects using the storage policy test_storage_policy.
+
+ ```sql
+ show storage policy using for test_storage_policy;
+ ```
+ ```text
+
+---------------------+-----------+---------------------------------+------------+
+ | 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
|
+
+---------------------+-----------+---------------------------------+------------+
+ ```
+
+3. View the properties of all storage policies.
+
+ ```sql
+ show storage policy;
+ ```
+ ```text
+
+-------------+----------+---------+---------+-----------------+------------------+-------------+
+ | 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 |
+
+-------------+----------+---------+---------+-----------------+------------------+-------------+
+ ```
\ No newline at end of file
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
