Arrays & SearchHit java API

Hi, We are storing arrays in elastic search (5.4.x) with a naming convension of column, and would like to retrieve array values in search API. We are using SearchRequestBuilder and noticing the following error.

 {
 "error" : "Can not start an object, expecting field name (context: Object)"
 }

   "string_arrays": {
        "match": "*__sa",
        "match_mapping_type": "*",
        "mapping": {
          "type": "keyword",
          "doc_values": true,
          "index": "not_analyzed",
          "null_value": "[]"
       }
    }

The values that are persisted in ES can be retreived by document id, but fail to use SearchHit api.

The sample values in ES :

columnName__sa : ["abc", "def", "ghi"]

Please advice me on how to retreive column values in the search api.

Thanks,
Suresh

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