logstash抽取数据库发送到kafka，以及使用logstash的something

input {
    jdbc {
        jdbc_connection_string => "jdbc:mysql://ip:PORT/database?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf8&useSSL=false&allowMultiQueries
=true&zeroDateTimeBehavior=convertToNull"
        jdbc_user => ""
        jdbc_password => ""
        jdbc_driver_library => "/usr/share/java/mysql-connector-java.jar"
        jdbc_driver_class => "com.mysql.jdbc.Driver"
        statement => "SELECT jl.*,GROUP_CONCAT(jll.COMPANY_NAME) COMPANY_NAMES FROM (SELECT j.* FROM JUDRISK_LAWSUIT j WHERE j.ID > :sql_last_value LIMIT 15000) jl LEFT JOIN
 JUDRISK_LAWSUIT_LIST jll ON jl.ID = jll.JUDRISK_LAWSUIT_ID GROUP BY jl.ID ORDER BY jl.ID"
        schedule => "* 3-5 * * *" # 3点到5点跑
        record_last_run => true
        use_column_value => true
        jdbc_pa