JOBS

描述

表函数，生成任务临时表，可以查看某个任务类型中的job信息。

语法

JOBS(
    "type"="<type>"
)

必填参数 (Required Parameters)

字段名	描述
<type>	任务的类型： insert：insert into 类型的任务。 mv：物化视图类型的任务。

返回值

• jobs("type"="insert") insert 类型的 job 返回值

  | 字段名 | 描述 | |--------------------|--------------------------------| | Id | job id | | Name | job名称 | | Definer | job定义者 | | ExecuteType | 执行类型 | | RecurringStrategy | 循环策略 | | Status | job状态 | | ExecuteSql | 执行SQL | | CreateTime | job 创建时间 | | SucceedTaskCount | 成功任务数量 | | FailedTaskCount | 失败任务数量 | | CanceledTaskCount | 取消任务数量 | | Comment | job 注释 |

• jobs("type"="mv") MV 类型的 job 返回值

  | 字段名 | 描述 | |---------------------|--------------------------------------| | Id | job id | | Name | job名称 | | MvId | 物化视图id | | MvName | 物化视图名称 | | MvDatabaseId | 物化视图所属db id | | MvDatabaseName | 物化视图所属db名称 | | ExecuteType | 执行类型 | | RecurringStrategy | 循环策略 | | Status | job状态 | | CreateTime | task创建时间 |

示例

查看所有物化视图的job

select * from jobs("type"="mv");

+-------+------------------+-------+--------------------------+--------------+--------------------------------------------------------+-------------+-------------------+---------+---------------------+
| Id    | Name             | MvId  | MvName                   | MvDatabaseId | MvDatabaseName                                         | ExecuteType | RecurringStrategy | Status  | CreateTime          |
+-------+------------------+-------+--------------------------+--------------+--------------------------------------------------------+-------------+-------------------+---------+---------------------+
| 23369 | inner_mtmv_23363 | 23363 | range_date_up_union_mv1  | 21805        | regression_test_nereids_rules_p0_mv_create_part_and_up | MANUAL      | MANUAL TRIGGER    | RUNNING | 2025-01-08 18:19:10 |
| 23377 | inner_mtmv_23371 | 23371 | range_date_up_union_mv2  | 21805        | regression_test_nereids_rules_p0_mv_create_part_and_up | MANUAL      | MANUAL TRIGGER    | RUNNING | 2025-01-08 18:19:10 |
| 21794 | inner_mtmv_21788 | 21788 | test_tablet_type_mtmv_mv | 16016        | zd                                                     | MANUAL      | MANUAL TRIGGER    | RUNNING | 2025-01-08 12:26:06 |
| 19508 | inner_mtmv_19494 | 19494 | mv1                      | 16016        | zd                                                     | MANUAL      | MANUAL TRIGGER    | RUNNING | 2025-01-07 22:13:31 |
+-------+------------------+-------+--------------------------+--------------+--------------------------------------------------------+-------------+-------------------+---------+---------------------+

查看所有 insert 任务的 job

select * from jobs("type"="insert");

+----------------+----------------+---------+-------------+--------------------------------------------+---------+--------------------------------------------------------------+---------------------+------------------+-----------------+-------------------+---------+
| Id             | Name           | Definer | ExecuteType | RecurringStrategy                          | Status  | ExecuteSql                                                   | CreateTime          | SucceedTaskCount | FailedTaskCount | CanceledTaskCount | Comment |
+----------------+----------------+---------+-------------+--------------------------------------------+---------+--------------------------------------------------------------+---------------------+------------------+-----------------+-------------------+---------+
| 78533940810334 | insert_tab_job | root    | RECURRING   | EVERY 10 MINUTE STARTS 2025-01-17 14:42:53 | RUNNING | INSERT INTO test.insert_tab SELECT * FROM test.example_table | 2025-01-17 14:32:53 | 0                | 0               | 0                 |         |
+----------------+----------------+---------+-------------+--------------------------------------------+---------+--------------------------------------------------------------+---------------------+------------------+-----------------+-------------------+---------+