SHOW CATALOGS

Description

Query all catalogs in the current StarRocks cluster, including the internal catalog and external catalogs.

Syntax

SHOW CATALOGS

Output

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

The following table describes the fields returned by this statement.

Field	Description
Catalog	The catalog name.
Type	The 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.
Comment	The comments of a catalog. StarRocks 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 cluster's self-managed tables. by default. default_catalog is the only internal catalog in a StarRocks cluster.

Examples

Query all catalogs in the current cluster.

SHOW CATALOGS\G
*************************** 1. row ***************************
Catalog: default_catalog
   Type: Internal
Comment: An internal catalog contains this cluster's self-managed tables.
*************************** 2. row ***************************
Catalog: hudi_catalog
   Type: Hudi
Comment: NULL
*************************** 3. row ***************************
Catalog: iceberg_catalog
   Type: Iceberg
Comment: NULL