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.…

Why I am getting this error when using JDBC input plugin of 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.

Topic		Replies	Views
LS not reading jdbc input for large dataset. Order By Clause is a Issue in Microsoft SQL Logstash	1	283	July 16, 2021
Order by class invalid in views, inline functions Logstash JDBC Logstash	2	505	March 4, 2020
ORDER BY in SQL query for Logstash JDBC Input Logstash	3	883	July 6, 2017
Logstash jdbc input mantain sql row order Logstash	9	391	March 3, 2023
Logstash JDBC file permission errors, cannot send data to elastic Logstash	6	874	March 12, 2021