Logstash JDBC input queries.

Why Logstash queries were written so complex?

Refer: https://www.elastic.co/guide/en/elasticsearch/guide/master/relations.html

The preferred way was to denormalize data so that we can use ElasticSearch to its full potential.

For Simple Search, I tried to write a query which is as optimized as it can be.

As we have one to many, many to many relationships in tables, to denormalize it, the cost was the redundancy of data to avoid writing the nested query in ElasticSearch which requires more computation and time consuming.