ALTER-CATALOG

Name

SinceVersion 1.2

ALTER CATALOG

Description

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

1) Rename the catalog

  1. 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

  1. 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

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

Keywords

ALTER,CATALOG,RENAME,PROPERTY

Best Practice