This is an automated email from the ASF dual-hosted git repository.
yiguolei 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 f4bb8b037b [docs]remove outdated resource params (#708)
f4bb8b037b is described below
commit f4bb8b037b25736fa2a8c730001b7ef5ff31ed77
Author: wangbo <youseebiggirl_...@qq.com>
AuthorDate: Tue Jun 4 12:48:52 2024 +0800
[docs]remove outdated resource params (#708)
remove outdated resource params
---
.../Account-Management-Statements/SET-PROPERTY.md | 84 +++------------------
.../Account-Management-Statements/SET-PROPERTY.md | 74 ++-----------------
.../Account-Management-Statements/SET-PROPERTY.md | 72 ++----------------
.../admin-manual/config/user-property.md | 4 -
.../Account-Management-Statements/SET-PROPERTY.md | 76 ++-----------------
.../Account-Management-Statements/SET-PROPERTY.md | 72 ++----------------
.../Account-Management-Statements/SET-PROPERTY.md | 86 ++++------------------
7 files changed, 52 insertions(+), 416 deletions(-)
diff --git
a/docs/sql-manual/sql-statements/Account-Management-Statements/SET-PROPERTY.md
b/docs/sql-manual/sql-statements/Account-Management-Statements/SET-PROPERTY.md
index aa16dbbed9..9c829c6b73 100644
---
a/docs/sql-manual/sql-statements/Account-Management-Statements/SET-PROPERTY.md
+++
b/docs/sql-manual/sql-statements/Account-Management-Statements/SET-PROPERTY.md
@@ -36,7 +36,7 @@ Set user attributes, including resources assigned to users,
importing clusters,
```sql
SET PROPERTY [FOR 'user'] 'key' = 'value' [, 'key' = 'value']
-````
+```
The user attribute set here is for user, not user_identity. That is, if two
users 'jack'@'%' and 'jack'@'192.%' are created through the CREATE USER
statement, the SET PROPERTY statement can only be used for the user jack, not
'jack'@'% ' or 'jack'@'192.%'
@@ -54,115 +54,55 @@ Super user privileges:
exec_mem_limit: Limit the memory usage of the query. See the introduction to
the session variable `exec_mem_limit` for details. -1 means not set.
- resource.cpu_share: CPU resource allocation. (obsolete)
-
- load_cluster.{cluster_name}.priority: Assign priority to the specified
cluster, which can be HIGH or NORMAL
-
resource_tags: Specifies the user's resource tag permissions.
query_timeout: Specifies the user's query timeout permissions.
Note: If the attributes `cpu_resource_limit`, `exec_mem_limit` are not
set, the value in the session variable will be used by default.
-Ordinary user rights:
-
- quota.normal: resource allocation at the normal level.
-
- quota.high: High-level resource allocation.
-
- quota.low: resource allocation at low level.
-
- load_cluster.{cluster_name}.hadoop_palo_path: The hadoop directory used by
palo, which needs to store the etl program and the intermediate data generated
by etl for Doris to import. After the import is completed, the intermediate
will be automatically cleaned up
-
-Data, etl program automatically retains the next use.
-
- load_cluster.{cluster_name}.hadoop_configs: The configuration of hadoop,
where fs.default.name, mapred.job.tracker, hadoop.job.ugi must be filled in.
-
- load_cluster.{cluster_name}.hadoop_http_port: hadoop hdfs name node http
port. Where hdfs defaults to 8070, afs defaults to 8010.
-
- default_load_cluster: The default import cluster.
-
### Example
1. Modify the maximum number of user jack connections to 1000
```sql
SET PROPERTY FOR 'jack' 'max_user_connections' = '1000';
- ````
-
-2. Modify the cpu_share of user jack to 1000
-
- ```sql
- SET PROPERTY FOR 'jack' 'resource.cpu_share' = '1000';
- ````
-
-3. Modify the weight of the jack user's normal group
-
- ```sql
- SET PROPERTY FOR 'jack' 'quota.normal' = '400';
- ````
+ ```
-4. Add import cluster for user jack
-
- ```sql
- SET PROPERTY FOR 'jack'
- 'load_cluster.{cluster_name}.hadoop_palo_path' =
'/user/doris/doris_path',
- 'load_cluster.{cluster_name}.hadoop_configs' =
'fs.default.name=hdfs://dpp.cluster.com:port;mapred.job.tracker=dpp.cluster.com:port;hadoop.job.ugi=user
,password;mapred.job.queue.name=job_queue_name_in_hadoop;mapred.job.priority=HIGH;';
- ````
-
-5. Delete the imported cluster under user jack.
-
- ```sql
- SET PROPERTY FOR 'jack' 'load_cluster.{cluster_name}' = '';
- ````
-
-6. Modify the default import cluster of user jack
-
- ```sql
- SET PROPERTY FOR 'jack' 'default_load_cluster' = '{cluster_name}';
- ````
-
-7. Change the cluster priority of user jack to HIGH
-
- ```sql
- SET PROPERTY FOR 'jack' 'load_cluster.{cluster_name}.priority' = 'HIGH';
- ````
-
-8. Modify the number of available instances for user jack's query to 3000
+2. Modify the number of available instances for user jack's query to 3000
```sql
SET PROPERTY FOR 'jack' 'max_query_instances' = '3000';
````
-9. Modify the sql block rule of user jack
+3. Modify the sql block rule of user jack
```sql
SET PROPERTY FOR 'jack' 'sql_block_rules' = 'rule1, rule2';
- ````
+ ```
-10. Modify the cpu usage limit of user jack
+4. Modify the cpu usage limit of user jack
```sql
SET PROPERTY FOR 'jack' 'cpu_resource_limit' = '2';
````
-11. Modify the user's resource tag permissions
+5. Modify the user's resource tag permissions
```sql
SET PROPERTY FOR 'jack' 'resource_tags.location' = 'group_a, group_b';
- ````
+ ```
-12. Modify the user's query memory usage limit, in bytes
+6. Modify the user's query memory usage limit, in bytes
```sql
SET PROPERTY FOR 'jack' 'exec_mem_limit' = '2147483648';
- ````
+ ```
-13. Modify the user's query timeout limit, in second
+7. Modify the user's query timeout limit, in second
```sql
SET PROPERTY FOR 'jack' 'query_timeout' = '500';
- ````
+ ```
### Keywords
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Account-Management-Statements/SET-PROPERTY.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Account-Management-Statements/SET-PROPERTY.md
index 7929edfd32..3b82054e1f 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Account-Management-Statements/SET-PROPERTY.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Account-Management-Statements/SET-PROPERTY.md
@@ -54,34 +54,12 @@ key:
exec_mem_limit: 限制查询的内存使用。详见会话变量 `exec_mem_limit` 的介绍。-1 表示未设置。
- resource.cpu_share: cpu资源分配。（已废弃）
-
- load_cluster.{cluster_name}.priority: 为指定的cluster分配优先级，可以为 HIGH 或
NORMAL
-
resource_tags：指定用户的资源标签权限。
query_timeout：指定用户的查询超时权限。
注：`cpu_resource_limit`, `exec_mem_limit` 两个属性如果未设置，则默认使用会话变量中值。
-普通用户权限：
-
- quota.normal: normal级别的资源分配。
-
- quota.high: high级别的资源分配。
-
- quota.low: low级别的资源分配。
-
- load_cluster.{cluster_name}.hadoop_palo_path:
palo使用的hadoop目录，需要存放etl程序及etl生成的中间数据供Doris导入。导入完成后会自动清理中间
-
-数据，etl程序自动保留下次使用。
-
- load_cluster.{cluster_name}.hadoop_configs:
hadoop的配置，其中fs.default.name、mapred.job.tracker、hadoop.job.ugi必须填写。
-
- load_cluster.{cluster_name}.hadoop_http_port: hadoop hdfs name node
http端口。其中 hdfs 默认为8070，afs 默认 8010。
-
- default_load_cluster: 默认的导入cluster。
-
### Example
1. 修改用户 jack 最大连接数为1000
@@ -90,75 +68,37 @@ key:
SET PROPERTY FOR 'jack' 'max_user_connections' = '1000';
```
-2. 修改用户 jack 的cpu_share为1000
-
- ```sql
- SET PROPERTY FOR 'jack' 'resource.cpu_share' = '1000';
- ```
-
-3. 修改 jack 用户的normal组的权重
-
- ```sql
- SET PROPERTY FOR 'jack' 'quota.normal' = '400';
- ```
-
-4. 为用户 jack 添加导入cluster
-
- ```sql
- SET PROPERTY FOR 'jack'
- 'load_cluster.{cluster_name}.hadoop_palo_path' =
'/user/doris/doris_path',
- 'load_cluster.{cluster_name}.hadoop_configs' =
'fs.default.name=hdfs://dpp.cluster.com:port;mapred.job.tracker=dpp.cluster.com:port;hadoop.job.ugi=user,password;mapred.job.queue.name=job_queue_name_in_hadoop;mapred.job.priority=HIGH;';
- ```
-
-5. 删除用户 jack 下的导入cluster。
-
- ```sql
- SET PROPERTY FOR 'jack' 'load_cluster.{cluster_name}' = '';
- ```
-
-6. 修改用户 jack 默认的导入cluster
-
- ```sql
- SET PROPERTY FOR 'jack' 'default_load_cluster' = '{cluster_name}';
- ```
-
-7. 修改用户 jack 的集群优先级为 HIGH
-
- ```sql
- SET PROPERTY FOR 'jack' 'load_cluster.{cluster_name}.priority' = 'HIGH';
- ```
-
-8. 修改用户jack的查询可用instance个数为3000
+2. 修改用户jack的查询可用instance个数为3000
```sql
SET PROPERTY FOR 'jack' 'max_query_instances' = '3000';
```
-9. 修改用户jack的sql block rule
+3. 修改用户jack的sql block rule
```sql
SET PROPERTY FOR 'jack' 'sql_block_rules' = 'rule1, rule2';
```
-
-10. 修改用户jack的 cpu 使用限制
+
+4. 修改用户jack的 cpu 使用限制
```sql
SET PROPERTY FOR 'jack' 'cpu_resource_limit' = '2';
```
-11. 修改用户的资源标签权限
+5. 修改用户的资源标签权限
```sql
SET PROPERTY FOR 'jack' 'resource_tags.location' = 'group_a, group_b';
```
-12. 修改用户的查询内存使用限制，单位字节
+6. 修改用户的查询内存使用限制，单位字节
```sql
SET PROPERTY FOR 'jack' 'exec_mem_limit' = '2147483648';
```
-13. 修改用户的查询超时限制，单位秒
+7. 修改用户的查询超时限制，单位秒
```sql
SET PROPERTY FOR 'jack' 'query_timeout' = '500';
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-reference/Account-Management-Statements/SET-PROPERTY.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-reference/Account-Management-Statements/SET-PROPERTY.md
index 7929edfd32..8b61868962 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-reference/Account-Management-Statements/SET-PROPERTY.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/sql-manual/sql-reference/Account-Management-Statements/SET-PROPERTY.md
@@ -54,34 +54,12 @@ key:
exec_mem_limit: 限制查询的内存使用。详见会话变量 `exec_mem_limit` 的介绍。-1 表示未设置。
- resource.cpu_share: cpu资源分配。（已废弃）
-
- load_cluster.{cluster_name}.priority: 为指定的cluster分配优先级，可以为 HIGH 或
NORMAL
-
resource_tags：指定用户的资源标签权限。
query_timeout：指定用户的查询超时权限。
注：`cpu_resource_limit`, `exec_mem_limit` 两个属性如果未设置，则默认使用会话变量中值。
-普通用户权限：
-
- quota.normal: normal级别的资源分配。
-
- quota.high: high级别的资源分配。
-
- quota.low: low级别的资源分配。
-
- load_cluster.{cluster_name}.hadoop_palo_path:
palo使用的hadoop目录，需要存放etl程序及etl生成的中间数据供Doris导入。导入完成后会自动清理中间
-
-数据，etl程序自动保留下次使用。
-
- load_cluster.{cluster_name}.hadoop_configs:
hadoop的配置，其中fs.default.name、mapred.job.tracker、hadoop.job.ugi必须填写。
-
- load_cluster.{cluster_name}.hadoop_http_port: hadoop hdfs name node
http端口。其中 hdfs 默认为8070，afs 默认 8010。
-
- default_load_cluster: 默认的导入cluster。
-
### Example
1. 修改用户 jack 最大连接数为1000
@@ -90,75 +68,37 @@ key:
SET PROPERTY FOR 'jack' 'max_user_connections' = '1000';
```
-2. 修改用户 jack 的cpu_share为1000
-
- ```sql
- SET PROPERTY FOR 'jack' 'resource.cpu_share' = '1000';
- ```
-
-3. 修改 jack 用户的normal组的权重
-
- ```sql
- SET PROPERTY FOR 'jack' 'quota.normal' = '400';
- ```
-
-4. 为用户 jack 添加导入cluster
-
- ```sql
- SET PROPERTY FOR 'jack'
- 'load_cluster.{cluster_name}.hadoop_palo_path' =
'/user/doris/doris_path',
- 'load_cluster.{cluster_name}.hadoop_configs' =
'fs.default.name=hdfs://dpp.cluster.com:port;mapred.job.tracker=dpp.cluster.com:port;hadoop.job.ugi=user,password;mapred.job.queue.name=job_queue_name_in_hadoop;mapred.job.priority=HIGH;';
- ```
-
-5. 删除用户 jack 下的导入cluster。
-
- ```sql
- SET PROPERTY FOR 'jack' 'load_cluster.{cluster_name}' = '';
- ```
-
-6. 修改用户 jack 默认的导入cluster
-
- ```sql
- SET PROPERTY FOR 'jack' 'default_load_cluster' = '{cluster_name}';
- ```
-
-7. 修改用户 jack 的集群优先级为 HIGH
-
- ```sql
- SET PROPERTY FOR 'jack' 'load_cluster.{cluster_name}.priority' = 'HIGH';
- ```
-
-8. 修改用户jack的查询可用instance个数为3000
+2. 修改用户jack的查询可用instance个数为3000
```sql
SET PROPERTY FOR 'jack' 'max_query_instances' = '3000';
```
-9. 修改用户jack的sql block rule
+3. 修改用户jack的sql block rule
```sql
SET PROPERTY FOR 'jack' 'sql_block_rules' = 'rule1, rule2';
```
-10. 修改用户jack的 cpu 使用限制
+4. 修改用户jack的 cpu 使用限制
```sql
SET PROPERTY FOR 'jack' 'cpu_resource_limit' = '2';
```
-11. 修改用户的资源标签权限
+5. 修改用户的资源标签权限
```sql
SET PROPERTY FOR 'jack' 'resource_tags.location' = 'group_a, group_b';
```
-12. 修改用户的查询内存使用限制，单位字节
+6. 修改用户的查询内存使用限制，单位字节
```sql
SET PROPERTY FOR 'jack' 'exec_mem_limit' = '2147483648';
```
-13. 修改用户的查询超时限制，单位秒
+7. 修改用户的查询超时限制，单位秒
```sql
SET PROPERTY FOR 'jack' 'query_timeout' = '500';
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/admin-manual/config/user-property.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/admin-manual/config/user-property.md
index 84dfb3a4a0..48cc70e550 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/admin-manual/config/user-property.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/admin-manual/config/user-property.md
@@ -67,7 +67,3 @@ User 级别的配置项只会对指定用户生效，并不会影响其他用户
### resource
### quota
-
-### default_load_cluster
-
-### load_cluster
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/Account-Management-Statements/SET-PROPERTY.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/Account-Management-Statements/SET-PROPERTY.md
index 7929edfd32..aec48fe329 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/Account-Management-Statements/SET-PROPERTY.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/Account-Management-Statements/SET-PROPERTY.md
@@ -54,34 +54,12 @@ key:
exec_mem_limit: 限制查询的内存使用。详见会话变量 `exec_mem_limit` 的介绍。-1 表示未设置。
- resource.cpu_share: cpu资源分配。（已废弃）
-
- load_cluster.{cluster_name}.priority: 为指定的cluster分配优先级，可以为 HIGH 或
NORMAL
-
resource_tags：指定用户的资源标签权限。
query_timeout：指定用户的查询超时权限。
注：`cpu_resource_limit`, `exec_mem_limit` 两个属性如果未设置，则默认使用会话变量中值。
-普通用户权限：
-
- quota.normal: normal级别的资源分配。
-
- quota.high: high级别的资源分配。
-
- quota.low: low级别的资源分配。
-
- load_cluster.{cluster_name}.hadoop_palo_path:
palo使用的hadoop目录，需要存放etl程序及etl生成的中间数据供Doris导入。导入完成后会自动清理中间
-
-数据，etl程序自动保留下次使用。
-
- load_cluster.{cluster_name}.hadoop_configs:
hadoop的配置，其中fs.default.name、mapred.job.tracker、hadoop.job.ugi必须填写。
-
- load_cluster.{cluster_name}.hadoop_http_port: hadoop hdfs name node
http端口。其中 hdfs 默认为8070，afs 默认 8010。
-
- default_load_cluster: 默认的导入cluster。
-
### Example
1. 修改用户 jack 最大连接数为1000
@@ -89,76 +67,38 @@ key:
```sql
SET PROPERTY FOR 'jack' 'max_user_connections' = '1000';
```
-
-2. 修改用户 jack 的cpu_share为1000
-
- ```sql
- SET PROPERTY FOR 'jack' 'resource.cpu_share' = '1000';
- ```
-
-3. 修改 jack 用户的normal组的权重
-
- ```sql
- SET PROPERTY FOR 'jack' 'quota.normal' = '400';
- ```
-
-4. 为用户 jack 添加导入cluster
-
- ```sql
- SET PROPERTY FOR 'jack'
- 'load_cluster.{cluster_name}.hadoop_palo_path' =
'/user/doris/doris_path',
- 'load_cluster.{cluster_name}.hadoop_configs' =
'fs.default.name=hdfs://dpp.cluster.com:port;mapred.job.tracker=dpp.cluster.com:port;hadoop.job.ugi=user,password;mapred.job.queue.name=job_queue_name_in_hadoop;mapred.job.priority=HIGH;';
- ```
-
-5. 删除用户 jack 下的导入cluster。
-
- ```sql
- SET PROPERTY FOR 'jack' 'load_cluster.{cluster_name}' = '';
- ```
-
-6. 修改用户 jack 默认的导入cluster
-
- ```sql
- SET PROPERTY FOR 'jack' 'default_load_cluster' = '{cluster_name}';
- ```
-
-7. 修改用户 jack 的集群优先级为 HIGH
-
- ```sql
- SET PROPERTY FOR 'jack' 'load_cluster.{cluster_name}.priority' = 'HIGH';
- ```
-
-8. 修改用户jack的查询可用instance个数为3000
+
+2. 修改用户jack的查询可用instance个数为3000
```sql
SET PROPERTY FOR 'jack' 'max_query_instances' = '3000';
```
-9. 修改用户jack的sql block rule
+3. 修改用户jack的sql block rule
```sql
SET PROPERTY FOR 'jack' 'sql_block_rules' = 'rule1, rule2';
```
-
-10. 修改用户jack的 cpu 使用限制
+
+4. 修改用户jack的 cpu 使用限制
```sql
SET PROPERTY FOR 'jack' 'cpu_resource_limit' = '2';
```
-11. 修改用户的资源标签权限
+5. 修改用户的资源标签权限
```sql
SET PROPERTY FOR 'jack' 'resource_tags.location' = 'group_a, group_b';
```
-12. 修改用户的查询内存使用限制，单位字节
+6. 修改用户的查询内存使用限制，单位字节
```sql
SET PROPERTY FOR 'jack' 'exec_mem_limit' = '2147483648';
```
-13. 修改用户的查询超时限制，单位秒
+7. 修改用户的查询超时限制，单位秒
```sql
SET PROPERTY FOR 'jack' 'query_timeout' = '500';
diff --git
a/versioned_docs/version-2.0/sql-manual/sql-reference/Account-Management-Statements/SET-PROPERTY.md
b/versioned_docs/version-2.0/sql-manual/sql-reference/Account-Management-Statements/SET-PROPERTY.md
index aa16dbbed9..b842346dc9 100644
---
a/versioned_docs/version-2.0/sql-manual/sql-reference/Account-Management-Statements/SET-PROPERTY.md
+++
b/versioned_docs/version-2.0/sql-manual/sql-reference/Account-Management-Statements/SET-PROPERTY.md
@@ -54,34 +54,12 @@ Super user privileges:
exec_mem_limit: Limit the memory usage of the query. See the introduction to
the session variable `exec_mem_limit` for details. -1 means not set.
- resource.cpu_share: CPU resource allocation. (obsolete)
-
- load_cluster.{cluster_name}.priority: Assign priority to the specified
cluster, which can be HIGH or NORMAL
-
resource_tags: Specifies the user's resource tag permissions.
query_timeout: Specifies the user's query timeout permissions.
Note: If the attributes `cpu_resource_limit`, `exec_mem_limit` are not
set, the value in the session variable will be used by default.
-Ordinary user rights:
-
- quota.normal: resource allocation at the normal level.
-
- quota.high: High-level resource allocation.
-
- quota.low: resource allocation at low level.
-
- load_cluster.{cluster_name}.hadoop_palo_path: The hadoop directory used by
palo, which needs to store the etl program and the intermediate data generated
by etl for Doris to import. After the import is completed, the intermediate
will be automatically cleaned up
-
-Data, etl program automatically retains the next use.
-
- load_cluster.{cluster_name}.hadoop_configs: The configuration of hadoop,
where fs.default.name, mapred.job.tracker, hadoop.job.ugi must be filled in.
-
- load_cluster.{cluster_name}.hadoop_http_port: hadoop hdfs name node http
port. Where hdfs defaults to 8070, afs defaults to 8010.
-
- default_load_cluster: The default import cluster.
-
### Example
1. Modify the maximum number of user jack connections to 1000
@@ -90,75 +68,37 @@ Data, etl program automatically retains the next use.
SET PROPERTY FOR 'jack' 'max_user_connections' = '1000';
````
-2. Modify the cpu_share of user jack to 1000
-
- ```sql
- SET PROPERTY FOR 'jack' 'resource.cpu_share' = '1000';
- ````
-
-3. Modify the weight of the jack user's normal group
-
- ```sql
- SET PROPERTY FOR 'jack' 'quota.normal' = '400';
- ````
-
-4. Add import cluster for user jack
-
- ```sql
- SET PROPERTY FOR 'jack'
- 'load_cluster.{cluster_name}.hadoop_palo_path' =
'/user/doris/doris_path',
- 'load_cluster.{cluster_name}.hadoop_configs' =
'fs.default.name=hdfs://dpp.cluster.com:port;mapred.job.tracker=dpp.cluster.com:port;hadoop.job.ugi=user
,password;mapred.job.queue.name=job_queue_name_in_hadoop;mapred.job.priority=HIGH;';
- ````
-
-5. Delete the imported cluster under user jack.
-
- ```sql
- SET PROPERTY FOR 'jack' 'load_cluster.{cluster_name}' = '';
- ````
-
-6. Modify the default import cluster of user jack
-
- ```sql
- SET PROPERTY FOR 'jack' 'default_load_cluster' = '{cluster_name}';
- ````
-
-7. Change the cluster priority of user jack to HIGH
-
- ```sql
- SET PROPERTY FOR 'jack' 'load_cluster.{cluster_name}.priority' = 'HIGH';
- ````
-
-8. Modify the number of available instances for user jack's query to 3000
+2. Modify the number of available instances for user jack's query to 3000
```sql
SET PROPERTY FOR 'jack' 'max_query_instances' = '3000';
````
-9. Modify the sql block rule of user jack
+3. Modify the sql block rule of user jack
```sql
SET PROPERTY FOR 'jack' 'sql_block_rules' = 'rule1, rule2';
````
-10. Modify the cpu usage limit of user jack
+4. Modify the cpu usage limit of user jack
```sql
SET PROPERTY FOR 'jack' 'cpu_resource_limit' = '2';
````
-11. Modify the user's resource tag permissions
+5. Modify the user's resource tag permissions
```sql
SET PROPERTY FOR 'jack' 'resource_tags.location' = 'group_a, group_b';
````
-12. Modify the user's query memory usage limit, in bytes
+6. Modify the user's query memory usage limit, in bytes
```sql
SET PROPERTY FOR 'jack' 'exec_mem_limit' = '2147483648';
````
-13. Modify the user's query timeout limit, in second
+7. Modify the user's query timeout limit, in second
```sql
SET PROPERTY FOR 'jack' 'query_timeout' = '500';
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/Account-Management-Statements/SET-PROPERTY.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/Account-Management-Statements/SET-PROPERTY.md
index aa16dbbed9..978691f339 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/Account-Management-Statements/SET-PROPERTY.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/Account-Management-Statements/SET-PROPERTY.md
@@ -54,115 +54,55 @@ Super user privileges:
exec_mem_limit: Limit the memory usage of the query. See the introduction to
the session variable `exec_mem_limit` for details. -1 means not set.
- resource.cpu_share: CPU resource allocation. (obsolete)
-
- load_cluster.{cluster_name}.priority: Assign priority to the specified
cluster, which can be HIGH or NORMAL
-
resource_tags: Specifies the user's resource tag permissions.
query_timeout: Specifies the user's query timeout permissions.
Note: If the attributes `cpu_resource_limit`, `exec_mem_limit` are not
set, the value in the session variable will be used by default.
-Ordinary user rights:
-
- quota.normal: resource allocation at the normal level.
-
- quota.high: High-level resource allocation.
-
- quota.low: resource allocation at low level.
-
- load_cluster.{cluster_name}.hadoop_palo_path: The hadoop directory used by
palo, which needs to store the etl program and the intermediate data generated
by etl for Doris to import. After the import is completed, the intermediate
will be automatically cleaned up
-
-Data, etl program automatically retains the next use.
-
- load_cluster.{cluster_name}.hadoop_configs: The configuration of hadoop,
where fs.default.name, mapred.job.tracker, hadoop.job.ugi must be filled in.
-
- load_cluster.{cluster_name}.hadoop_http_port: hadoop hdfs name node http
port. Where hdfs defaults to 8070, afs defaults to 8010.
-
- default_load_cluster: The default import cluster.
-
### Example
1. Modify the maximum number of user jack connections to 1000
```sql
SET PROPERTY FOR 'jack' 'max_user_connections' = '1000';
- ````
-
-2. Modify the cpu_share of user jack to 1000
-
- ```sql
- SET PROPERTY FOR 'jack' 'resource.cpu_share' = '1000';
- ````
-
-3. Modify the weight of the jack user's normal group
-
- ```sql
- SET PROPERTY FOR 'jack' 'quota.normal' = '400';
- ````
-
-4. Add import cluster for user jack
-
- ```sql
- SET PROPERTY FOR 'jack'
- 'load_cluster.{cluster_name}.hadoop_palo_path' =
'/user/doris/doris_path',
- 'load_cluster.{cluster_name}.hadoop_configs' =
'fs.default.name=hdfs://dpp.cluster.com:port;mapred.job.tracker=dpp.cluster.com:port;hadoop.job.ugi=user
,password;mapred.job.queue.name=job_queue_name_in_hadoop;mapred.job.priority=HIGH;';
- ````
-
-5. Delete the imported cluster under user jack.
-
- ```sql
- SET PROPERTY FOR 'jack' 'load_cluster.{cluster_name}' = '';
- ````
-
-6. Modify the default import cluster of user jack
-
- ```sql
- SET PROPERTY FOR 'jack' 'default_load_cluster' = '{cluster_name}';
- ````
-
-7. Change the cluster priority of user jack to HIGH
-
- ```sql
- SET PROPERTY FOR 'jack' 'load_cluster.{cluster_name}.priority' = 'HIGH';
- ````
+ ```
-8. Modify the number of available instances for user jack's query to 3000
+2. Modify the number of available instances for user jack's query to 3000
```sql
SET PROPERTY FOR 'jack' 'max_query_instances' = '3000';
- ````
+ ```
-9. Modify the sql block rule of user jack
+3. Modify the sql block rule of user jack
```sql
SET PROPERTY FOR 'jack' 'sql_block_rules' = 'rule1, rule2';
- ````
+ ```
-10. Modify the cpu usage limit of user jack
+4. Modify the cpu usage limit of user jack
```sql
SET PROPERTY FOR 'jack' 'cpu_resource_limit' = '2';
- ````
+ ```
-11. Modify the user's resource tag permissions
+5. Modify the user's resource tag permissions
```sql
SET PROPERTY FOR 'jack' 'resource_tags.location' = 'group_a, group_b';
- ````
+ ```
-12. Modify the user's query memory usage limit, in bytes
+6. Modify the user's query memory usage limit, in bytes
```sql
SET PROPERTY FOR 'jack' 'exec_mem_limit' = '2147483648';
- ````
+ ```
-13. Modify the user's query timeout limit, in second
+7. Modify the user's query timeout limit, in second
```sql
SET PROPERTY FOR 'jack' 'query_timeout' = '500';
- ````
+ ```
### Keywords
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
