Hello, I have a JDBC driver with SQL Server ELK ... I have an error message with a syntax problem with the FROM when doing a ./logstash -f /etc/logstash/conf.d/file.conf. I want to add several tables in the same FROM. There are inner joins to link the tables. Is it possible ? Or should I make an input for a table?
Logstash doesn't care about what your SQL statement looks like. It's up to the underlying database and possibly the JDBC driver.
Yes. But why I have an error of syntaxe from "FROM". Can I create a file .sql with my request ?
input {
jdbc {
statement => "file.sql"
}
}
According to the docs Jdbc input plugin you can create a sql file which contains the query and load it into the input with statement_filepath => 'full path to sql file'
If you are getting a syntax error on FROM you should create a test your query separately from this input as combining the the 2 adds to the complexity.
I do not know what type of DB you are connecting to with jdbc but generally databases support join's so that should be doable in you sql statement.
I do not know what type and my database. I tried the statement_filepath and it seems to work. Thank you.
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.