ALTER-RESOURCE
ALTER-RESOURCE
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