SHOW CATALOGS

Description

Query all catalogs in the current CelerData cloud account, including the internal catalog and external catalogs.

Syntax

SHOW CATALOGS

Output

+----------+--------+----------+
| Catalog  | Type   | Comment  |
+----------+--------+----------+

The following table describes the fields returned by this statement.

FieldDescription
CatalogThe catalog name.
TypeThe catalog type. Internal is returned if the catalog is default_catalog. The corresponding catalog type is returned if the catalog is an external catalog, such as Hive, Hudi, or Iceberg.
CommentThe comments of a catalog. CelerData does not support adding comments to an external catalog. Therefore, the value is NULL for an external catalog. If the catalog is default_catalog, the comment is An internal catalog contains this CelerData cloud account's managed tables. by default. default_catalog is the only internal catalog in a CelerData cloud account.

Examples

Query all catalogs in the current CelerData cloud account.

SHOW CATALOGS\G
*************************** 1. row ***************************
Catalog: default_catalog
   Type: Internal
Comment: An internal catalog contains this CelerData cloud account's managed tables.
*************************** 2. row ***************************
Catalog: hudi_catalog
   Type: Hudi
Comment: NULL
*************************** 3. row ***************************
Catalog: iceberg_catalog
   Type: Iceberg
Comment: NULL
In this article
Copyright © 2024 CelerData