jobs
Name
jobs
description
表函数,生成任务临时表,可以查看某个任务类型中的job信息。
该函数用于 from 子句中。
syntax
jobs("type"="")
jobs(“type”=”mv”)表结构:
mysql> desc function jobs("type"="mv");
+-------------------+------+------+-------+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+------+------+-------+---------+-------+
| Id | TEXT | No | false | NULL | NONE |
| Name | TEXT | No | false | NULL | NONE |
| MvId | TEXT | No | false | NULL | NONE |
| MvName | TEXT | No | false | NULL | NONE |
| MvDatabaseId | TEXT | No | false | NULL | NONE |
| MvDatabaseName | TEXT | No | false | NULL | NONE |
| ExecuteType | TEXT | No | false | NULL | NONE |
| RecurringStrategy | TEXT | No | false | NULL | NONE |
| Status | TEXT | No | false | NULL | NONE |
| CreateTime | TEXT | No | false | NULL | NONE |
+-------------------+------+------+-------+---------+-------+
10 rows in set (0.00 sec)
- Id:job id.
- Name:job名称.
- MvId:物化视图id
- MvName:物化视图名称
- MvDatabaseId:物化视图所属db id
- MvDatabaseName:物化视图所属db名称
- ExecuteType:执行类型
- RecurringStrategy:循环策略
- Status:job状态
- CreateTime:task创建时间
example
- 查看所有物化视图的job
mysql> select * from jobs("type"="mv");
- 查看name为
inner_mtmv_75043
的job
mysql> select * from jobs("type"="mv") where Name="inner_mtmv_75043";
keywords
jobs