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