I wanted to visualize data from two distinct indexes that do not share a common substring.
Let's say I have Index A and Index B, both distinct names with no same substring.
Both indexes have one common element "uniqueID".
However, Index B has some extra data I want to pull for visualizations alongside some data from Index A. I want them to be matched on basis of uniqueID.
Since these two have distinct names, I cannot just use an index pattern.
I planned on creating the same alias for both indexes, and then create an index pattern out of that alias.
Finally, use that merged index pattern to create my visualizations with data pulled from both indexes.
Would this work? Is there a better way to do this?
You're after a join, which is't possible to do in Elasticsearch or Kibana. Your best approach would be to reindex the data and merge both indices together so they are in a single index with all attributes in each document.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.