How to compare index pattern values?

Elastic Stack Elasticsearch
1

Hello. I want to compare index patterns and as a result find the same ones.

So for example I have index pattern1 where I have indexes with columns like -->

|pattern1* [index-1, index-2]
| col1 | col2 | col3 |
======|=====|======
| row1 | row1 | row1 |
| row2 | row2 | row2 |
| row5 | row5 | row5 |
| row6 | row6 | row6 |
======|=====|======

| pattern2* [index-3, index-4]
|col2 | col3 | col4 |
======|=====|======
|row2 | row2 | row2 |
| row5 | row5 | row5 |
| row7 | row7 | row7 |
======|=====|======

So I want to compare col2 and col3 in pattern1* with col2 and col3 in pattern2*. So as the result I will have col2 and col3 with its row values like pattern1* col2 and col3 values are in pattern2* col2 and col3. As a result I have ==>

| col2 | col3 |
======|======
| row2 | row2 |
| row7 | row7 |
======|======

Is it possible with Kibana or with Elasticsearch-py ?
or how to get all documents from index patterns to compare them later with python ?
Thank you.

2

I suppose this post is quite similar to your previous unsolved post. That's better to continue the previous post to avoid any confusion caused by splitting related discussions.

3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.