SHOW-CATALOGS
SHOW-CATALOGS
Name
SHOW CATALOGS
Description
This statement is used for view created catalogs
Syntax:
SHOW CATALOGS [LIKE]
illustrate:
- LIKE: Fuzzy query can be performed according to the catalog name
Return result:
- CatalogId: Unique ID of the catalog
- CatalogName: Catalog name. where "internal" is the default built-in catalog, which cannot be modified.
- Type: Catalog type.
- IsCurrent: Show yes on the line of current using catalog.
Example
View the data catalogs that have been created currently
SHOW CATALOGS;
+-----------+-------------+----------+-----------+
| CatalogId | CatalogName | Type | IsCurrent |
+-----------+-------------+----------+-----------+
| 130100 | hive | hms | |
| 0 | internal | internal | yes |
+-----------+-------------+----------+-----------+
```Fuzzy query by catalog name
SHOW CATALOGS LIKE 'hi%';
+-----------+-------------+----------+-----------+
| CatalogId | CatalogName | Type | IsCurrent |
+-----------+-------------+----------+-----------+
| 130100 | hive | hms | |
+-----------+-------------+----------+-----------+
```
Keywords
SHOW, CATALOG, CATALOGS