Hi, I'm using the jdbc_streaming filter plugin to get data from query. But in some case query return empty result or null value. parameters => { "firstName" => "firstName" } statement => "SELECT DISTINCT TOP 1 userid FROM employee where first_name=:firstName " t…

If you set the default_hash option on the jdbc_streaming filter then if no rows match it will return that default hash in the target array. So the array will always exist and you can do your mutate{ add_field => { "userId" => "%{[user][0][userid]}" } remove_field => ["user"] } uncon…

How to handle empty result in jdbc_streaming filter plugin in Logstash

Elastic Stack Logstash

naveen007 (Neo) August 25, 2020, 7:19pm 4

I am not getting your point. Where should I write this code and what about condition ?
I want to check user is empty or not. Below is the output when query return empty

 "user" => [
        [0] {}
]

Please let me know if you have any queries.

Logstash how to handle null value with jdbc_streaming

Topic		Replies	Views
Logstash how to handle null value with jdbc_streaming Logstash	1	388	August 22, 2022
Jdbc_streaming filter plugin returns an empty set using parameters option Logstash	3	531	August 20, 2018
Sql query returns nothing , but output file udpated Logstash	4	172	January 17, 2024
Problem handling null value with jdbc_streaming filter Logstash	1	197	September 30, 2022
Logstash filter jdbc_streaming: how to get the target value Logstash	3	3344	November 3, 2017

How to handle empty result in jdbc_streaming filter plugin in Logstash

Related topics