Skip to main content
Version: Stable-3.1

DROP CATALOG

Description

Deletes an external catalog. The internal catalog cannot be deleted. A StarRocks cluster has only one internal catalog named default_catalog.

Syntax

DROP CATALOG <catalog_name>

Parameters

catalog_name: The name of an external catalog.

Examples

Create a Hive catalog named hive1.

CREATE EXTERNAL CATALOG hive1
PROPERTIES(
"type"="hive",
"hive.metastore.uris"="thrift://xx.xx.xx.xx:9083"
);

Delete the Hive catalog.

DROP CATALOG hive1;