Hi ,
Please try with some ID Value first in where condition.
input {
jdbc {
jdbc_driver_library => "D:/Softwares/logstash/lib/com.mysql.jdbc_5.1.5.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"
jdbc_connection_string => "jdbc:mysql://localhost:3306/testdb"
jdbc_user => "root"
jdbc_password => "root"
statement => "SELECT id,name FROM sample where id > 1"
tracking_column => "id"
last_run_metadata_path => "C:/Users/XXXXXX/.logstash_jdbc_last_run"
schedule => "*/1 * * * *"
}
}
output {
elasticsearch {
hosts => ["localhost:9200"]
index => "idx_mysqldata"
}
stdout { codec => rubydebug }
}
Then check your results first.