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
