I have 500 documents and half of them contains "IP.keyword" and half contains "Pim_IP".keyword. Now I want to filter to get all the document which will have Pim_IP(from one docuement) == IP.keyword( from other document). How to achieve this please help.
You can't do this in Kibana, because it would require two sequential requests to construct this type of query. Kibana only uses parallel requests.
Because you can do this with two sequential requests, you can automate it using some kind of tool that is external to ES and Kibana, and then send the results back to Elasticsearch to visualize in Kibana.
edit: we are tracking requests like this for multi-step requests in Kibana, and will use this feedback as an example of one of the things that users are asking for while prioritizing work.
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.