Hi Team,
I am new to Elastic Search.I am using MYSQL database. I have 10 records and and i updated the existing record. But in elastic search i am not getting the updated table. below is my config file of logstash
input {
jdbc {
jdbc_connection_string => "jdbc:mysql://localhost:3306/masterdb"
jdbc_user => "venkat"
jdbc_validate_connection => true
jdbc_driver_library => "../jars/mysql.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"
statement => "SELECT * from orders"
}
}
output {
elasticsearch {
index => "orders"
document_type => "orders"
document_id => "%{orderid+''+productid}"
hosts => "localhost:9200"
}
}