json array with string and objects inside set mapping in Elasticsearch

Question

here are two jsons:

json 1:

{
  "organization": [
    "Univ Philippines",
    {
      "pref": "Y",
      "content": "University of the Philippines System"
    },
    {
      "pref": "Y",
      "content": "University of the Philippines Diliman"
    }
  ]
}

json 2:

{
   "organization": "Univ Philippines"
}

I need index them into Elasticsearch. how to set organization field mapping?

I had tried string and object type but all failed.

PUT sci_test
{
  "mappings": {
    "sci":{
      "properties": {
        "organization":{
          "type": "object"
        }
      }
    }
  }
}
PUT sci_test/sci/1
{
  "organization": [
    "Univ Philippines",
    {
      "pref": "Y",
      "content": "University of the Philippines System"
    },
    {
      "pref": "Y",
      "content": "University of the Philippines Diliman"
    }
  ]
}

error info:
{
  "error": {
    "root_cause": [
      {
        "type": "mapper_parsing_exception",
        "reason": "object mapping for [organization] tried to parse field [null] as object, but found a concrete value"
      }
    ],
    "type": "mapper_parsing_exception",
    "reason": "object mapping for [organization] tried to parse field [null] as object, but found a concrete value"
  },
  "status": 400
}

jaspreet chahal · Accepted Answer · 2020-04-21 03:10:22Z

2

All the fields must of of same type. You cannot mix string with object

"Univ Philippines",                                      --> text
 {                                                       --> object
      "pref": "Y",
      "content": "University of the Philippines System"
 }"

You need to define "Univ Philippines" as "University":"Univ Philippines"(add some key "university" etc).

answered Apr 21, 2020 at 3:10

jaspreet chahal

9,1492 gold badges14 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

json array with string and objects inside set mapping in Elasticsearch

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related