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
- rename catalog ctlg_hive to hive
ALTER CATALOG ctlg_hive RENAME hive;
- modify property
hive.metastore.uris
of catalog hive
ALTER CATALOG hive SET PROPERTIES ('hive.metastore.uris'='thrift://172.21.0.1:9083');
- modify comment of catalog hive
ALTER CATALOG hive MODIFY COMMENT "new catalog comment";
Keywords
ALTER,CATALOG,RENAME,PROPERTY