Jdbcstreaming logstash filter plugin - parameters option is not working

Elastic Stack Logstash
1

Hi ,
I have a data in MySQL .So using Jdbc_streaming filter i can able to filter and parse to elastic search. While configuring the options for Jdbc_streaming filter , parameters option is not working for me . What was the mistake i did in the config file ??
Here the config for the filter plugin :

    jdbc_streaming {
    jdbc_connection_string => "jdbc:mysql://localhost:3306/smack" 
    jdbc_user => "root"
    jdbc_password => "smack"
    jdbc_driver_library => "/home/gomathi/Downloads/com.mysql.jdbc_5.1.5.jar"
    jdbc_driver_class => "com.mysql.jdbc.Driver"
    statement => "SELECT * FROM student where rollnumber = :Rollnumber"
    parameters => {"Rollnumber" => 130}
    target => "target"
    }

output:

output with empty target and tagged as defaultused

{
          "tags" => [
        [0] "_jdbcstreamingdefaultsused"
    ],
      "@version" => "1",
    "@timestamp" => 2019-04-24T04:57:44.376Z,
        "target" => [
        [0] {}
    ]
}

platform :
os : ubuntu 18.04
logstash_version : 6.7.1

Thanks in advance.

2

That is telling you the query returned an empty result set. That does not mean that the parameters option is not working.

3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.