Here is the query I had put in the logstash conf file: select a.ID, a.TransactionID, b.Result from MyDB.Result a inner join MyDB.ResultData b on a.ID=b.ID where a.ID < :sql_last_value and a.CreatedOn > '2020-01-01' order by a.ID This is warning I get: [2020-06-22T11:29:01,084][ERROR][logstash.…

Badger June 22, 2020, 1:42pm 8

I would ignore the error. It tries to do a count, if it fails then it stops trying. More details here.

LS not reading jdbc input for large dataset. Order By Clause is a Issue in Microsoft SQL

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.

Why I am getting this error when using JDBC input plugin of Logstash