CODEWITHSUNDEEP
elasticsearchmappingaggregation
Nacho Nieva
Nacho Nieva

Reputation: 181

ElasticSearch 5.1 Fielddata is disabled in text field by default [ERROR: trying to use aggregation on field]

Having this field in my mapping

"answer": {
        "type": "text",
        "fields": {
          "keyword": {
            "type": "keyword",
            "ignore_above": 256
          }
        }
      },

i try to execute this aggregation 

"aggs": {
"answer": {
  "terms": {
    "field": "answer"
  }
},

but i get this error

"type": "illegal_argument_exception",
      "reason": "Fielddata is disabled on text fields by default. Set fielddata=true on [answer] in order to load fielddata in memory by uninverting the inverted index. Note that this can however use significant memory."

Do i have to change my mapping or am i using the wrong aggregation ? (just updated from 2.x to 5.1)

Upvotes: 12

Views: 17637

Answers (3)

yogitha
yogitha

Reputation: 29

In Aggregation, just add keyword to answer.It worked for me. For text fields we need to add keyword. "field": "answer.keyword"

Upvotes: 2

Kulasangar
Kulasangar

Reputation: 9444

Adding to @Val's answer, you can also set the fielddata to true during your mapping itself:

"answer": {
        "type": "text",
        "fielddata": true, <-- add this line
        "fields": {
          "keyword": {
            "type": "keyword",                
            "ignore_above": 256
          }
        }
      },

Upvotes: 1

Val
Val

Reputation: 217424

You need to aggregate on the keyword sub-field, like this:

"aggs": {
"answer": {
  "terms": {
    "field": "answer.keyword"
  }
},

That will work.

Upvotes: 31

Related Questions