{ "type" : "jdbc", "statefile" : "statefile.json", "jdbc": { "url" : "jdbc:mysql://", "user" : "", "password" : "", "type" : "actor", "index": "test", "schedule" : "0 * * * * ?", "metrics" : { "lastexecutionstart" : "0", "lastexecutionend" : "0", "counter" : "1" }, "sql" : [ { "statement" : "select a.actor_id as _id ,a.*,GROUP_CONCAT(b.tag_name ) as tag_name from ( ( gd_actor_info as a left join gd_actor_tag as ab on a.actor_id = ab.actor_id ) left join gd_tag_actor as b on ab.tag_id = b.tag_id) where a.update_time >? or ab.update_time > ? group by a.actor_id ", "parameter" : [ "$metrics.lastexecutionstart" ,"$metrics.lastexecutionstart" ] } ] } }