Logstash- JDBC plugin

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"

document_id => "%{orderid+''+productid}"

I'm pretty sure this means all your documents will literally have the id "%{orderid+''+productid}". You probably mean this:

document_id => "%{orderid}%{productid}"