Inner_hits with Kibana visualizations

[mPanasiewicz (Maciej Panasiewicz)]

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

[rashmi (kulkarni)]

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

[mPanasiewicz (Maciej Panasiewicz)]

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

[ppisljar (Peter Pisljar)]

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

[mPanasiewicz (Maciej Panasiewicz)]

@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?

[ppisljar (Peter Pisljar)]

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"
}