# In this below query,the fieldname which is in string type.when i use GET query there is no issue but when i use PUT query it show a error(which attached below) v 6.4.0

**URL:** https://discuss.elastic.co/t/in-this-below-query-the-fieldname-which-is-in-string-type-when-i-use-get-query-there-is-no-issue-but-when-i-use-put-query-it-show-a-error-which-attached-below-v-6-4-0/187231
**Category:** Elasticsearch
**Created:** [June 25, 2019, 6:13am UTC](https://discuss.elastic.co/t/in-this-below-query-the-fieldname-which-is-in-string-type-when-i-use-get-query-there-is-no-issue-but-when-i-use-put-query-it-show-a-error-which-attached-below-v-6-4-0/187231 "2019-06-25T06:13:51Z")
**Posts on this page:** 3
**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 25, 2019, 6:13am UTC](https://discuss.elastic.co/t/in-this-below-query-the-fieldname-which-is-in-string-type-when-i-use-get-query-there-is-no-issue-but-when-i-use-put-query-it-show-a-error-which-attached-below-v-6-4-0/187231/1 "2019-06-25T06:13:52Z")

</div>

```
PUT elastic_queries/_doc/21019
{
  "queryName": "grade_2_olsat_report",
  "indexName": "t_student_grade_2_olsat_index",
  "query": {
    "sort": [
      {
        "school_year.keyword": {
          "order": "desc"
        }
      }
    ],
    "size": 999,
    "_source": {
      "excludes": [
        "@version",
        "@timestamp",
      
        "student_id"
      ]
    },
    "query": {
      "bool": {
        "filter": []
      }
    }
  }
}

```

error:

{  
"error": {  
"root\_cause": [  
{  
"type": "mapper\_parsing\_exception",  
"reason": "failed to parse field [query.sort.school\_year.keyword] of type [text] in document with id '21019'"  
}  
],  
"type": "mapper\_parsing\_exception",  
"reason": "failed to parse field [query.sort.school\_year.keyword] of type [text] in document with id '21019'",  
"caused\_by": {  
"type": "illegal\_state\_exception",  
"reason": "Can't get text on a START\_OBJECT at 7:32"  
}  
},  
"status": 400  
}

---

<div class="post-metadata">

### Author: ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)
#### Post date: [June 25, 2019, 6:26am UTC](https://discuss.elastic.co/t/in-this-below-query-the-fieldname-which-is-in-string-type-when-i-use-get-query-there-is-no-issue-but-when-i-use-put-query-it-show-a-error-which-attached-below-v-6-4-0/187231/2 "2019-06-25T06:26:49Z")

</div>

It's unclear what you are trying to do.  
You want to index a document or run a search query?

Here you called the index document API not the search API.

Could you provide a full recreation script as described in [About the Elasticsearch category](https://discuss.elastic.co/t/about-the-elasticsearch-category/21). It will help to better understand what you are doing. Please, try to keep the example as simple as possible.

A full reproduction script will help readers to understand, reproduce and if needed fix your problem. It will also most likely help to get a faster answer.

---

<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:26am UTC](https://discuss.elastic.co/t/in-this-below-query-the-fieldname-which-is-in-string-type-when-i-use-get-query-there-is-no-issue-but-when-i-use-put-query-it-show-a-error-which-attached-below-v-6-4-0/187231/3 "2019-07-23T06:26:50Z")

</div>

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