Versions (relevant - OpenSearch/Dashboard/Server OS/Browser):
OpenSearch Service in AWS,
Chrome last version
Describe the issue:
We need to do joins and aggegations before visualize results in a dashboard. We cannot rely on batch processing and It seems that only DSL is available as a way to filter data.
Could we use SQL sentences (OpenSearch dialect), join-like capabilities in DSL o PPL?
Relevant Logs or Screenshots: