Is where condition supported with logstash-jdbc input plugin

Elastic Stack Logstash
1

Hi All

I am not able to create index if i provide a complex sql query like with where condition and join condition

But if i am providing simple "select * from table', it is working well

Please let me know if complex queries is supported by jdbc input plugin or not.

More Info
My source is mysql DB
I am using mysql driver and simple query is working well

Regards
Ritesh

2

The complexity of the query should not affect the behavior of the plugin. It is quite possible that the complex query is taking a long time, or some memory requirements are necessary and you are running into an out of memory exception. or, maybe that no results were returned from the specific query.

mind sharing the nature of your config and type of complex query you are running (exact private query is not necessary)

thanks!

3

Hi

Thanks for your reply.
The query doesn't work they way we use in sql . In sql we apply table alias and do join query

Here in logstash i applied explicitly table_name.column_name for all the fields. Then the query is working fine.