Problem when use ElasticSearch with SQLServer

I don't know whether when we update data in SqlServer to ES by Logstash, ES will reindex all or not ?

Welcome!

I moved your question to #logstash.

The jdbc input plugin runs the query you defined. If the query does not include any timestamp like SELECT * FROM TABLE, then everything gets read again and reindexed.

Have a look at https://www.elastic.co/guide/en/logstash/current/plugins-inputs-jdbc.html#_state to see how you can use a column to read only the last changes, supposing that you have this information in your tables.

Okay I got it. Thank you very much. It's useful for me

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