面试被问到Azkaban的job历史信息存在那张表中
概述
- Azkaban3 共 15 张表,分别用于存储任务调度,定时任务,触发器,项目 Project,工作 Flows,作业 Jobs 等。
-
整体概述如下:
总体概述
各表详细说明
1-active_executing_flows
active_executing_flows.PNG
- 字段:status =50 (成功);status=70(失败failed)
2-active_sla
active_sla.PNG
3-executions_flows
executions_flows.PNG
4-executions_jobs
executions_jobs.PNG
5-execution_logs
execution_logs.PNG
6-project_events
project_events.PNG
7-project_files
project_files.PNG
8-project_flows
project_flows.PNG
9-project_permissionions
project_permissionions.PNG
10-project_properties
project_properties.PNG
11-project_version
project_version.PNG
12-projects
projects.PNG
13-properties
properties.PNG
14-schedules
schedules.PNG
15-trigger
trriger.PNG
参考博客:Azkaban元数据库分析