ALTER-RESOURCE

SinceVersion 1.2.0

Name

ALTER RESOURCE

Description

This statement is used to modify an existing resource. Only the root or admin user can modify resources. Syntax:

1. ALTER RESOURCE 'resource_name'
2. PROPERTIES ("key"="value", ...);

Note: The resource type does not support modification.

Example

  1. Modify the working directory of the Spark resource named spark0:
1. ALTER RESOURCE 'spark0' PROPERTIES ("working_dir" = "hdfs://127.0.0.1:10000/tmp/doris_new");
  1. Modify the maximum number of connections to the S3 resource named remote_s3:
1. ALTER RESOURCE 'remote_s3' PROPERTIES ("s3.connection.maximum" = "100");

  1. Modify information related to cold and hot separation S3 resources

  2. Support

  3. s3.access_key s3 ak
  4. s3.secret_key s3 sk
  5. s3.session_token s3 token
  6. s3.connection.maximum default 50
  7. s3.connection.timeout default 1000ms
  8. s3.connection.request.timeout default 3000ms
  9. Not Support
  10. s3.region
  11. s3.bucket"
  12. s3.root.path
  13. s3.endpoint
1. ALTER RESOURCE "showPolicy_1_resource" PROPERTIES("s3.connection.maximum" = "1111");

Keywords

1. ALTER, RESOURCE

Best Practice