Inserting into the same index


(Sreevatsa Vadiraj) #1

This is my logstash config file:
input {
jdbc {
jdbc_driver_library => "/home/vatsa/logstash/mysql-connector-java-5.1.38-bin.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"
jdbc_connection_string => "jdbc:mysql://localhost:3306/LC"
jdbc_user => "root"
jdbc_password => ""

statement => "select * from test where ID<=45000"

}
}
output {
elasticsearch {

    index => "det"
    document_type => "contact"
    document_id => "%{ID}"
    hosts => "localhost:9200"
}

}
and i run it using , logstash/bin/logstash -f /home/vatsa/logs/conts-jdbc.conf

Next time,if i change the query to ID>45000 AND ID<=90000 and i run it ,the data in previous index gets replaced by the data.
How do i add this data to the data present in the previous index?


(system) #2