queries

Name

SinceVersion dev

queries

description

Table-Value-Function, generate a temporary table named queries. This tvf is used to view the information of running queries and history queries in doris cluster.

This function is used in FROM clauses.

syntax

queries()

queries() table schema：

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