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.
My source is mysql DB
I am using mysql driver and simple query is working well
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 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.