Inner_hits with Kibana visualizations

Elastic Stack Kibana
1

Is there any possibility to use inner_hits in Kibana visualizations?? Is there any other solution to make join to use data from two documents in one axis?
Example:

{
"payment": "1000",
"user_id": "10"
}

{
"id": "10"
"name": "John Smith"
}

I'd like to make dashboard users name with their payments.
Thank you for help

2

I have pinged about this q to our team.
cc
/@ppisljar

3

My goal is to fetch child document with his parent(or fetch field from parent to the child document).

4

elastic search does not support joins, you would need to reindex your data with the name of user in the first document.

5

@ppisljar you mean, I need to send first data with this user name? You mean that I have to do the join on application side, not on elasticsearch?

6

i mean you should denormalize your data, (at index time, or reindex current data) so your documents look like this:

{
"payment": "1000",
"user_id": "10",
"user_name": "John Smith"
}