ALTER-RESOURCE
ALTER-RESOURCE
Tips
This feature is supported since the Apache Doris 1.2 version
Name
ALTER RESOURCE
Description
This statement is used to modify an existing resource. Only the root or admin user can modify resources. Syntax:
ALTER RESOURCE 'resource_name'
PROPERTIES ("key"="value", ...);
Note: The resource type does not support modification.
Example
- Modify the working directory of the Spark resource named spark0:
ALTER RESOURCE 'spark0' PROPERTIES ("working_dir" = "hdfs://127.0.0.1:10000/tmp/doris_new");
- Modify the maximum number of connections to the S3 resource named remote_s3:
ALTER RESOURCE 'remote_s3' PROPERTIES ("s3.connection.maximum" = "100");
- Modify information related to cold and hot separation S3 resources
- Support
s3.access_key
s3 aks3.secret_key
s3 sks3.session_token
s3 tokens3.connection.maximum
default 50s3.connection.timeout
default 1000mss3.connection.request.timeout
default 3000ms
- Not Support
s3.region
s3.bucket"
s3.root.path
s3.endpoint
ALTER RESOURCE "showPolicy_1_resource" PROPERTIES("s3.connection.maximum" = "1111");
Keywords
ALTER, RESOURCE