Skip to main content
Version: 2.5

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.

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