ALTER-CATALOG
ALTER-CATALOGβ
Nameβ
ALTER CATALOG
Descriptionβ
This statement is used to set properties of the specified catalog. (administrator only)
- 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
- 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.
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');
Keywordsβ
ALTER,CATALOG,RENAME,PROPERTY