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.


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