queries

Name

SinceVersion dev

queries

description

表函数，生成queries临时表，可以查看当前doris集群中正在运行的以及历史的 query 信息。

该函数用于from子句中。

syntax

queries()

queries()表结构：

1. mysql> desc function queries();
2. +------------------+--------+------+-------+---------+-------+
3. | Field            | Type   | Null | Key   | Default | Extra |
4. +------------------+--------+------+-------+---------+-------+
5. | QueryId          | TEXT   | No   | false | NULL    | NONE  |
6. | StartTime        | BIGINT | No   | false | NULL    | NONE  |
7. | EndTime          | BIGINT | Yes  | false | NULL    | NONE  |
8. | EventTime        | BIGINT | Yes  | false | NULL    | NONE  |
9. | Latency          | BIGINT | No   | false | NULL    | NONE  |
10. | State            | TEXT   | No   | false | NULL    | NONE  |
11. | Database         | TEXT   | Yes  | false | NULL    | NONE  |
12. | Sql              | TEXT   | No   | false | NULL    | NONE  |
13. | FrontendInstance | TEXT   | No   | false | NULL    | NONE  |
14. +------------------+--------+------+-------+---------+-------+
15. 9 rows in set (0.00 sec)

example

1. mysql> select* from queries();
2. +-----------------------------------+---------------+---------------+---------------+---------+----------+----------+------------------------+------------------+
3. | QueryId                           | StartTime     | EndTime       | EventTime     | Latency | State    | Database | Sql                    | FrontendInstance |
4. +-----------------------------------+---------------+---------------+---------------+---------+----------+----------+------------------------+------------------+
5. | e1293f2ed2a5427a-982301c462586043 | 1699255138730 | 1699255139823 | 1699255139823 |    1093 | FINISHED | demo     | select* from queries() | localhost        |
6. | 46fa3ad0e7814ebd-b1cd34940a29b1e9 | 1699255143588 |            -1 | 1699255143588 |      20 | RUNNING  | demo     | select* from queries() | localhost        |
7. +-----------------------------------+---------------+---------------+---------------+---------+----------+----------+------------------------+------------------+
8. 2 rows in set (0.04 sec)

keywords

1. queries