DROP CATALOG

Description

Deletes an external catalog. The internal catalog cannot be deleted. A CelerData cloud account has only one internal catalog named default_catalog.

Syntax

DROP CATALOG <catalog_name>

Parameters

catalog_name: the name of the 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;