Skip to main content
Get StartedConsole GuideWork With DataRelease NotesReference
Resources
VeloDB Cloud 26.x·Apache Doris 4.x (up to 4.0 supported)·"Since X.Y" tags refer to Apache Doris versionsVersion mapping

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 (
  `<property>`, 
  [ , ... ]
);

Parameters​

1.<property>

The <property> format is <key> = <value>, and modifying the <value> where <key> equals 'type' is not supported.

The modified properties parameters can be referenced in the CREATE-RESOURCE section.

Examples​

  1. 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");
  1. Modify the maximum number of connections to the S3 resource named remote_s3:
ALTER RESOURCE 'remote_s3' PROPERTIES ("s3.connection.maximum" = "100");
  1. Modify information related to cold and hot separation S3 resources
  • Support
    • s3.access_key s3 ak
    • s3.secret_key s3 sk
    • s3.session_token s3 token
    • s3.connection.maximum default 50
    • s3.connection.timeout default 1000ms
    • s3.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");