i am trying to ingest the records with following timestamps 01.03.38.75894600 01.03.38.88577300 01.03.39.08149800 .but before that I have successfully ingested 100 rec which having same timestamp.so no w i have my sql last_value _as 01.01.12.23410000. so when the next run comes the above 3 reco…

Sql_last_value not working properly

jgabor (Jan) April 9, 2020, 7:38am 2

This looks like the problem I had two years ago: JDBC to ElasticSearch: duplicate records?

tldr: try to put an order_by updated_at to your query

1 Like

Topic		Replies	Views
Jdbc input plugin sql_last_value not updating Logstash	2	1820	December 10, 2019
JDBC Plugin - sql_last_value equals a not existing timestamp Logstash	3	2668	September 28, 2017
Sql_last_value doesn't refresh Logstash	2	986	May 10, 2018
Logstash 2.2 :sql_last_value Logstash	2	3518	July 6, 2017
Jdbc sql_last_value Logstash	2	1760	January 15, 2017

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

Sql_last_value not working properly

Related topics