Skip to main content
Version: 2.5

catalog

Description​

Returns the name of the current catalog. The catalog can be a StarRocks internal catalog or an external catalog that is mapped to an external data source. For more information about catalogs, see Catalog overview.

If no catalog is selected, the StarRocks internal catalog default_catalog is returned.

Syntax​

catalog()

Parameters​

This function does not require parameters.

Return value​

Returns the name of the current catalog as a string.

Examples​

Example 1: The current catalog is StarRocks internal catalog default_catalog.

select catalog();
+-----------------+
| CATALOG()       |
+-----------------+
| default_catalog |
+-----------------+
1 row in set (0.01 sec)

Example 2: The current catalog is an external catalog hudi_catalog.

-- Switch to an external catalog.
set catalog hudi_catalog;

-- Return the name of the current catalog.
select catalog();
+--------------+
| CATALOG()    |
+--------------+
| hudi_catalog |
+--------------+