I'm using the most up to date version of Logstash (1:2.2.4-1) and the associated jdbc logstash plugin. My one SQL statement is configured and operating on schedule as expected, querying a MS SQL instance every minute. However, I'm wanting to run multiple SQL statements at the same time, as my business need is to pull data from ~ten different tables. Furthermore, much of this data is more-static and thus doesn't have to be queried as often. It appears I can link my SQL queries back-to-back and not receive a warning, but the second statement never executes.. I've also tried multiple 'statement' blocks inside the jdbc filter, but then no data gets pulled from the MS SQL instance. I'd prefer a more-elegant way to query all the data I need rather than placing it in a view or doing some weird unions.
- Is there a way to run multiple SQL queries inside the jdbc plugin? What's the workaround if I can only have one SQL statement per jdbc input class?
1a. Is there a way to add different schedules for different statements?
- Where is the '.sql_last_value' kept in Unix? I found it about a week ago and haven't came across it since.
Apologies if the answers to my questions are common knowledge -- I looked all over the net before asking the community.