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

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
}

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. 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.

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