INFO-实时相关sql汇总

适用模块

实时计算

具体说明

实时计算相关指标查询

使用示例

1、查询jar任务

select * from sloth.draft_job  sloth join rts_ops.job_info rts on sloth.job_id=rts.job_id limit 10 \G;

2、查询任务失败日志

select * from rts_submitter.submitter_job_log where job_id =246 and event_type = 'STOP' order by create_time desc limit 1 \G;

3、查询任务运行状态

select * from rts_ops.job_status where job_id=xxx \G;

作者：林帅