- 1：海豚调度器元数据库连接方式
- url :
- jdbc:mysql://hadoops03:3306/dolphinscheduler?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai
- 用户名：
- xxx
- 密码：
- xxx
- url :
- 查询任务运行时长排序
select
name,
start_time ,
end_time ,
timediff(end_time,start_time) as time_difference
from dolphinscheduler.t_ds_process_instance
where DATE(start_time) = DATE_SUB(DATE(CURDATE()),interval 1 DAY)
order by time_difference desc
limit 10
作者 admin
张宴银，大数据开发工程师