ALTER RESOURCE

Description

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

Since 4.1.5, only root can modify or delete a newly created AI Resource marked as created by root; other ADMIN users cannot do so. Resources without this marker from before the upgrade are not retroactively restricted. See AI Resource permissions.

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");

2. Modify the maximum number of connections to the S3 resource named remote_s3:

ALTER RESOURCE 'remote_s3' PROPERTIES ("s3.connection.maximum" = "100");

3. 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");