JOBS
Description
Table function, generating a temporary task table, which can view job information in a certain task type.
Syntax
JOBS(
"type"="<type>"
)
Required Parameters
| Field | Description |
|---|---|
<type> | The type of the job: insert: Insert into type job. mv: Materialized view job. |
Return Value
-
jobs("type"="insert")Job return value of type insertField Description Id Job ID Name Job name Definer Job definer ExecuteType Execution type RecurringStrategy Recurring strategy Status Job status ExecuteSql Execution SQL CreateTime Job creation time SucceedTaskCount Number of successful tasks FailedTaskCount Number of failed tasks CanceledTaskCount Number of canceled tasks Comment Job comment -
jobs("type"="mv")MV type job return valueField Description Id job ID Name job name MvId Materialized View ID MvName Materialized View Name MvDatabaseId DB ID of the materialized view MvDatabaseName Name of the database to which the materialized view belongs ExecuteType Execution type RecurringStrategy Loop strategy Status Job status CreateTime Task creation time
Examples
View jobs in all materialized views
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 |
+-------+------------------+-------+--------------------------+--------------+--------------------------------------------------------+-------------+-------------------+---------+---------------------+
View all insert jobs
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 | |
+----------------+----------------+---------+-------------+--------------------------------------------+---------+--------------------------------------------------------------+---------------------+------------------+-----------------+-------------------+---------+