Logstash update an existing row without a duplicate

Im using the Below JDBC code in Logstash for updating the already existing index in Elasticsearch, without duplicating rows or adding the updated row as another new row.

So my issue is,
The updated old row does not get updated. It is getting created as a new row.

Versions: Elasticsearch, Logstash and Kibana are v7.1.0.

input {
    jdbc {
        jdbc_connection_string => "jdbc:sqlserver://DB01:1433;databasename=mydb;integratedSecurity=true"
        jdbc_driver_class =>  "com.microsoft.sqlserver.jdbc.SQLServerDriver"
    jdbc_driver_library => "C:\Program Files\sqljdbc_6.2\enu\mssql-jdbc-6.2.2.jre8.jar"
        jdbc_user => nil
        statement => "SELECT * from data WHERE updated_on > :sql_last_value ORDER BY updated_on"
    use_column_value =>true
        tracking_column =>updated_on
        tracking_column_type => "timestamp"
output {
          elasticsearch { hosts => ["localhost:9200"] 
        index => "datau" 
            document_id => "%{id}"
            doc_as_upsert =>true}
          stdout { codec => rubydebug }

Where am i going wrong?

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