Update / Delete rows in DB using Logstash JDBC input plugin

Elastic Stack Logstash
1

Hi,
is it possible to use SQL operations like UPDATE or DELETE in statement parameter of Logstash JDBC input plugin? Or only SELECT operation is enabled?

Regads,
Vasek

2

I found out that it is possible:

statement => "UPDATE logs SET marked_by_logstash = true WHERE marked_by_logstash = false"
statement => "DELETE FROM logs WHERE marked_by_logstash = true"
3

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