# "root\_cause": \[ { "type": "mapper\_parsing\_exception", "reason": "failed to parse field \[query.sort.school\_year.keyword\] of type \[text\] in document with id '21019'" } \],

**URL:** <https://discuss.elastic.co/t/root-cause-type-mapper-parsing-exception-reason-failed-to-parse-field-query-sort-school-year-keyword-of-type-text-in-document-with-id-21019/187101>\
**Category:** Kibana\
**Created:** [June 24, 2019, 10:48am UTC](https://discuss.elastic.co/t/root-cause-type-mapper-parsing-exception-reason-failed-to-parse-field-query-sort-school-year-keyword-of-type-text-in-document-with-id-21019/187101 "2019-06-24T10:48:40Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sakthivanan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sakthivanan/32/77897_2.png) [@Sakthivanan](https://discuss.elastic.co/u/Sakthivanan)\
**Post date:** [June 24, 2019, 10:48am UTC](https://discuss.elastic.co/t/root-cause-type-mapper-parsing-exception-reason-failed-to-parse-field-query-sort-school-year-keyword-of-type-text-in-document-with-id-21019/187101/1 "2019-06-24T10:48:40Z")

</div>

```
"query": {
    "sort": [
      {
        "school_year.keyword": {
          "order": "desc"
        }
      }
    ],
    "size": 999,
    "_source": {
      "excludes": [
        "@version",
        "@timestamp",
      
        "student_id"
      ]
    },
    "query": {
      "bool": {
        "filter": []
      }
    }
  }
```

---

<div class="post-metadata">

**Author:** ![rashmi](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rashmi/32/16391_2.png) [@rashmi](https://discuss.elastic.co/u/rashmi)\
**Post date:** [June 24, 2019, 3:05pm UTC](https://discuss.elastic.co/t/root-cause-type-mapper-parsing-exception-reason-failed-to-parse-field-query-sort-school-year-keyword-of-type-text-in-document-with-id-21019/187101/2 "2019-06-24T15:05:32Z")

</div>

Hi ,  
Can you please elaborate more on your question. What is the complete command you issued?, logs, screenshots, what is your end goal, version etc. It would help us debug better.

Thanks  
Rashmi

---

<div class="post-metadata">

**Author:** ![Sakthivanan](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/sakthivanan/32/77897_2.png) [@Sakthivanan](https://discuss.elastic.co/u/Sakthivanan)\
**Post date:** [June 25, 2019, 6:02am UTC](https://discuss.elastic.co/t/root-cause-type-mapper-parsing-exception-reason-failed-to-parse-field-query-sort-school-year-keyword-of-type-text-in-document-with-id-21019/187101/3 "2019-06-25T06:02:24Z")

</div>

sure

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 23, 2019, 6:02am UTC](https://discuss.elastic.co/t/root-cause-type-mapper-parsing-exception-reason-failed-to-parse-field-query-sort-school-year-keyword-of-type-text-in-document-with-id-21019/187101/4 "2019-07-23T06:02:33Z")

</div>

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