CREATE EXTERNAL CATALOG
Description
Creates an external catalog. You can use external catalogs to query data in external data sources without loading data into StarRocks or creating external tables. Currently, you can create the following types of external catalogs:
- Hive catalog: used for querying data from Apache Hive™.
- Iceberg catalog: used for querying data from Apache Iceberg.
- Hudi catalog: used for querying data from Apache Hudi.
- Delta Lake catalog: used to query data from Delta Lake.
- JDBC catalog: used to query data from JDBC-compatible data sources.
- Elasticsearch catalog: used to query data from Elasticsearch. Elasticsearch catalogs are supported from v3.1 onwards.
- Paimon catalog: used to query data from Apache Paimon. Paimon catalogs are supported from v3.1 onwards.
- Unified catalog: used to query data from from Hive, Iceberg, Hudi, and Delta Lake data sources as a unified data source. Unified catalogs are supported from v3.2 onwards.
NOTE
- In v3.0 and later, this statement requires SYSTEM-level CREATE EXTERNAL CATALOG privilege.
- Before you create external catalogs, configure your StarRocks cluster to meet the requirements of the data storage system (such as Amazon S3), metadata service (such as Hive metastore), and authenticating service (such as Kerberos) of external data sources. For more information, see the "Before you begin" section in each external catalog topic.
Syntax
CREATE EXTERNAL CATALOG <catalog_name>
[COMMENT <comment>]
PROPERTIES ("key"="value", ...)