SHOW CREATE CATALOG
更新时间：
复制 MD 格式
SHOW CREATE CATALOG returns the CREATE EXTERNAL CATALOG statement that was used to create the specified catalog, including its type and property configuration.
Syntax
SHOW CREATE CATALOG <catalog_name>;Parameters
|
Parameter |
Required |
Description |
|
|
Yes |
The name of the catalog. |
Output columns
|
Column |
Type |
Description |
|
Catalog |
VARCHAR |
The catalog name. |
|
Create Catalog |
VARCHAR |
The full |
Examples
View the creation statement of the Paimon Catalog paimon_catalog_dlf:
SHOW CREATE CATALOG paimon_catalog_dlf;Sample output:
+-------------------+---------------------------------------------------+
| Catalog | Create Catalog |
+-------------------+---------------------------------------------------+
| paimon_catalog_dlf| CREATE EXTERNAL CATALOG `paimon_catalog_dlf` |
| | PROPERTIES ( |
| | 'type'='paimon', |
| | 'paimon.catalog.type'='paimon', |
| | 'paimon.catalog.metastore'='rest', |
| | 'paimon.catalog.uri'='cn-beijing-vpc.dlf.aliyuncs.com', |
| | 'paimon.catalog.token.provider'='dlf', |
| | 'paimon.catalog.warehouse'='*****' |
| | ); |
+-------------------+---------------------------------------------------+
1 row in set (0.24 sec)Usage notes
-
This command is supported since AnalyticDB for MySQL 3.2.7.
-
Use this statement to review the property configuration of an External Catalog, which helps troubleshoot connection issues or replicate configurations.
-
This statement does not apply to the Managed Catalog (
adb).
Related documents
该文章对您有帮助吗？