Skip to main content
Skip to main content

ALTER-CATALOG

ALTER-CATALOG

Name

Tips

This feature is supported since the Apache Doris 1.2 version

ALTER CATALOG

Description

This statement is used to set properties of the specified catalog. (administrator only)

1) Rename the catalog

ALTER CATALOG catalog_name RENAME new_catalog_name;

illustrate:

  • The builtin catalog internal cannot be renamed
  • Only the one who has at least Alter privilege can rename a catalog
  • After renaming the catalog, use the REVOKE and GRANT commands to modify the appropriate user permissions

2) Modify / add properties for the catalog

ALTER CATALOG catalog_name SET PROPERTIES ('key1' = 'value1' [, 'key' = 'value2']); 

Update values of specified keys. If a key does not exist in the catalog properties, it will be added.

illustrate:

  • property type cannot be modified.
  • properties of builtin catalog internal cannot be modified.

3) Modify comment for the catalog

ALTER CATALOG catalog_name MODIFY COMMENT "new catalog comment";

illustrate:

  • The builtin catalog internal cannot be modified

Example

  1. rename catalog ctlg_hive to hive
ALTER CATALOG ctlg_hive RENAME hive;
  1. modify property hive.metastore.uris of catalog hive
ALTER CATALOG hive SET PROPERTIES ('hive.metastore.uris'='thrift://172.21.0.1:9083');
  1. modify comment of catalog hive
ALTER CATALOG hive MODIFY COMMENT "new catalog comment";

Keywords

ALTER,CATALOG,RENAME,PROPERTY

Best Practice