Elastic search recommends against structuring data such that joins are needed for indexes, yet the OpenTelemetry data is put in multiple indexes. There's doesn't appear to be a way to configure the data to go to a single index. This seems to mean that some processing will have to be done outside of Kibana visualizations. One critical example: querying the original transactions that an error was for. I cant seem to find how that can be queried without pulling the data down and performing two queries local (one to get errors, then to query again using the transaction.id from that other index).
Any examples of how to "join" the multiple open-telemetry indexes for querying stats like this?