Term query with join doesn't work, but works individually

OpenSearch
1

Versions (relevant - OpenSearch/Dashboard/Server OS/Browser):

7.10

Describe the issue:

  • Doc contains an array of strings with following mapping
"FieldName" : {
           "type" : "text",
           "fields" : {
             "keyword" : {
              "type" : "keyword",
             "ignore_above" : 256
             }
           }
         }
  • Below term query is able to filter out documents from array matching.
{
  "query": {
    "term": {
        "Field": "value"
    }
  }
}
  • But the following query returns empty result.
    Note: Below query with match alone returns required doc
{
	"query": {
		"has_parent": {
			"parent_type": "ParentType",
			"query": {
				"bool": {
					"must": [
					  {
							"term": {
                                                           "Field": "value"
                                                           }
						},
						{
							"match": {
								"Field": "Value"
							}
						}
						
					]		
				}
			}
		}
	}
}

Configuration:
Default new index

Relevant Logs or Screenshots: NA