I'm trying to use jdbc input filter to query Oracle DB and to template a schema name. My statement looks like this:
select count(1) from :schema.my_table
And my logstash config is like this:
input {
[...connection attributes...]
jdbc {
statement => "select count(1) from :schema.my_table"
parameters => {"schema" => "my_schema"}
}
}
And the the resulting query going to Oracle is like this:
select count(1) from 'my_schema'.my_table
So it adds a single quotes to my parameters making my query to fail with "ORA-00903: invalid table name".
How do I get rid of single qoutes added by logstash? Or, at least, to replace it with double quotes instead?