I'm trying to join 2 indexes through term join in Elastic Maps but I'm having trouble retrieving results when I use a "fieldName.keyword" field as the left source of the join, meanwhile I'm not having any trouble retrieving the expected results when assigning the .keyword field value to a scripted field and using that as the left source.
When inspecting the query I can see that the response from the server is the same for both requests.
Included are screenshots from the responses (using both fields as sources) and the scripted field definition so you can see that both fields should have the same information.
- Term join using original field (fieldName.keyword):
- Term join using scripted field:
- Scripted field definition:
I can provide any additional information needed.
Thank you, cheers.