{

    "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" ]

            }

        ]

    }

}