But every time it prints the same data. I have only two records and I am expected just ones . every 20 seconds its prints same two records
I tried with setting below conf in logstash.yml
You are executing the same query every 20 minutes, so you get the same data every 20 minutes – both entries. That's the expected behavior. If you don't want to read these entries again, you'll have to adjust the query accordingly, e.g. with a time range, if there is a field in your entries that indicates their age.
@Jenni Thanks for quick response. I dont have a timestamp field . This is test data to verify whether logstash keeps tracks of read records,but looks its not.
BTW I am executing in every 20 seconds.
I am looking something similar to since_db in elastic input
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.