I'm new to logstash, and at the moment I'm playing around with my sql-requests, the almost all of them are using temp variable. It
I'm running sql-request like
select my_id from table1 where date > $start and date < $end
$start and $end are timestamps which i'm setting before running this requests.
After executing a statement, I got a list with my id's and then I'm running new bunch of sql-requests like
select Max(message) from table2 where id_ba_fa = '$my_id'. ($my_id is variable which will be replaced with real my_id that I've got from first request.
So first I'm getting list of id's from time range, then I need exact data from every id I've become.
It approach works fine in my old tool, but since I want to use logstash, I don't understand how to config the same statements. Any suggestion, help?