CATALOGS
catalogs
Name
catalogs
description
The table function generates a temporary table of catalogs to view the information of the catalogs created in the current Doris.
This function is used in the from clause.
syntax
catalogs()
Catalogs () table structure:
mysql> desc function catalogs();
+-------------+--------+------+-------+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+--------+------+-------+---------+-------+
| CatalogId | BIGINT | No | false | NULL | NONE |
| CatalogName | TEXT | No | false | NULL | NONE |
| CatalogType | TEXT | No | false | NULL | NONE |
| Property | TEXT | No | false | NULL | NONE |
| Value | TEXT | No | false | NULL | NONE |
+-------------+--------+------+-------+---------+-------+
5 rows in set (0.04 sec)
The information presented by catalogs() tvf is the result of synthesizing show catalogs and show catalog xxx statements.
The table generated by tvf can be used for filtering, join and other operations.
example
mysql> select * from catalogs();
+-----------+-------------+-------------+--------------------------------------------+---------------------------------------------------------------------------+
| CatalogId | CatalogName | CatalogType | Property | Value |
+-----------+-------------+-------------+--------------------------------------------+---------------------------------------------------------------------------+
| 16725 | hive | hms | dfs.client.failover.proxy.provider.HANN | org.apache.hadoop.hdfs.server.namenode.ha.ConfiguredFailoverProxyProvider |
| 16725 | hive | hms | dfs.ha.namenodes.HANN | nn1,nn2 |
| 16725 | hive | hms | create_time | 2023-07-13 16:24:38.968 |
| 16725 | hive | hms | ipc.client.fallback-to-simple-auth-allowed | true |
| 16725 | hive | hms | dfs.namenode.rpc-address.HANN.nn1 | nn1_host:rpc_port |
| 16725 | hive | hms | hive.metastore.uris | thrift://127.0.0.1:7004 |
| 16725 | hive | hms | dfs.namenode.rpc-address.HANN.nn2 | nn2_host:rpc_port |
| 16725 | hive | hms | type | hms |
| 16725 | hive | hms | dfs.nameservices | HANN |
| 0 | internal | internal | NULL | NULL |
| 16726 | es | es | create_time | 2023-07-13 16:24:44.922 |
| 16726 | es | es | type | es |
| 16726 | es | es | hosts | http://127.0.0.1:9200 |
+-----------+-------------+-------------+--------------------------------------------+---------------------------------------------------------------------------+
13 rows in set (0.01 sec)
keywords
catalogs
