Skip to main content

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​

FieldDescription
<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 insert

    | Field | 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 value

    | Field | 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 | |
+----------------+----------------+---------+-------------+--------------------------------------------+---------+--------------------------------------------------------------+---------------------+------------------+-----------------+-------------------+---------+