> For the complete documentation index, see [llms.txt](https://docs.starrocks.io/llms.txt). This page is also available as Markdown at its `.md` URL.

# ALTER RESOURCE

Use the ALTER RESOURCE statement to modify the properties of a resource.

## Syntax[​](#syntax "Direct link to Syntax")

```sql
ALTER RESOURCE 'resource_name' SET PROPERTIES ("key"="value", ...)

```

## Parameters[​](#parameters "Direct link to Parameters")

* `resource_name`: the name of the resource to be modified.

* `PROPERTIES ("key"="value", ...)`: the properties of the resource. You can modify different properties based on resource types. Currently, StarRocks supports modifying the URI of the Hive metastore of the following resources.

  * Apache Iceberg resources support modifying the following properties:

    * `iceberg.catalog-impl`: the fully qualified class name of [custom catalog](https://docs.starrocks.io/docs/data_source/External_table.md).
    * `iceberg.catalog.hive.metastore.uris`: the URI of the Hive metastore.

  * Apache Hive™ resources and Apache Hudi resources support modifying `hive.metastore.uris`, which indicates the URI of the Hive metastore.

## Usage notes[​](#usage-notes "Direct link to Usage notes")

After you reference a resource to create an external table, if you modify the URI of the Hive metastore of this resource, the external table becomes unavailable. If you still want to use the external table to query data, make sure that the new metastore contains a table whose name and schema are the same as that in the original metastore.

## Examples[​](#examples "Direct link to Examples")

Modify the URI of the Hive metastore of Hive resource `hive0`.

```sql
ALTER RESOURCE 'hive0' SET PROPERTIES ("hive.metastore.uris" = "thrift://xx.xx.xx.xx:9083")

```