This statement is used to switch catalog.
SWITCH <catalog_name>
1. <catalog_name>
The name of the catalog to switch to.
| Privilege | Object | Notes |
|---|---|---|
| SELECT_PRIV | Catalog | SELECT_PRIV privilege is required on the catalog to be switched to. |
Switch to the catalog hive
SWITCH hive;