catalogs

Name

catalogs

description

表函数，生成 catalogs 临时表，可以查看当前doris中的创建的 catalogs 信息。

该函数用于 from 子句中。

syntax

catalogs()

catalogs()表结构：

1. mysql> desc function catalogs();
2. +-------------+--------+------+-------+---------+-------+
3. | Field       | Type   | Null | Key   | Default | Extra |
4. +-------------+--------+------+-------+---------+-------+
5. | CatalogId   | BIGINT | No   | false | NULL    | NONE  |
6. | CatalogName | TEXT   | No   | false | NULL    | NONE  |
7. | CatalogType | TEXT   | No   | false | NULL    | NONE  |
8. | Property    | TEXT   | No   | false | NULL    | NONE  |
9. | Value       | TEXT   | No   | false | NULL    | NONE  |
10. +-------------+--------+------+-------+---------+-------+
11. 5 rows in set (0.04 sec)

catalogs() tvf展示的信息是综合了 show catalogs 与 show catalog xxx 语句的结果。

可以利用tvf生成的表去做过滤、join等操作。

example

1. mysql> select * from catalogs();
2. +-----------+-------------+-------------+--------------------------------------------+---------------------------------------------------------------------------+
3. | CatalogId | CatalogName | CatalogType | Property                                   | Value                                                                     |
4. +-----------+-------------+-------------+--------------------------------------------+---------------------------------------------------------------------------+
5. |     16725 | hive        | hms         | dfs.client.failover.proxy.provider.HANN    | org.apache.hadoop.hdfs.server.namenode.ha.ConfiguredFailoverProxyProvider |
6. |     16725 | hive        | hms         | dfs.ha.namenodes.HANN                      | nn1,nn2                                                                   |
7. |     16725 | hive        | hms         | create_time                                | 2023-07-13 16:24:38.968                                                   |
8. |     16725 | hive        | hms         | ipc.client.fallback-to-simple-auth-allowed | true                                                                      |
9. |     16725 | hive        | hms         | dfs.namenode.rpc-address.HANN.nn1          | nn1_host:rpc_port                                                         |
10. |     16725 | hive        | hms         | hive.metastore.uris                        | thrift://127.0.0.1:7004                                                   |
11. |     16725 | hive        | hms         | dfs.namenode.rpc-address.HANN.nn2          | nn2_host:rpc_port                                                         |
12. |     16725 | hive        | hms         | type                                       | hms                                                                       |
13. |     16725 | hive        | hms         | dfs.nameservices                           | HANN                                                                      |
14. |         0 | internal    | internal    | NULL                                       | NULL                                                                      |
15. |     16726 | es          | es          | create_time                                | 2023-07-13 16:24:44.922                                                   |
16. |     16726 | es          | es          | type                                       | es                                                                        |
17. |     16726 | es          | es          | hosts                                      | http://127.0.0.1:9200                                                     |
18. +-----------+-------------+-------------+--------------------------------------------+---------------------------------------------------------------------------+
19. 13 rows in set (0.01 sec)

keywords

1. catalogs