Elastic search date query problem with format

Elastic Stack Elasticsearch
1

I am not able to search with date formats elastic-search

I created an index and the field mapping is showing as date-format,but the query is failing.

Before loading data,i created an index with mappings and loaded my data into elastic search.

"mappings": {
"workers": {
"person.birthDate": {
"full_name": "person.birthDate",
"mapping": {
"birthDate": {
"type": "date",
"format": "yyyy-MM-dd||epoch_millis"
}
}
}
My Input query is as below

POST _search
{
"query": {

"bool" : {
"must" : [ {
"match" : {
"person.birthDate" : {
"query" : "1968-06-15",
"type" : "date"
}
}
} ]
}

},
"from": 0,
"size": 10,
"sort": [],
"aggs": {}
}
and output is

{
"error": {
"root_cause": [
{
"type": "query_parsing_exception",
"reason": "[match] query does not support type date",
"index": "index1",
"line": 9,
"col": 33
}
],
"type": "search_phase_execution_exception",
"reason": "all shards failed",
"phase": "query",
"grouped": true,
"failed_shards": [
{
"shard": 0,
"index": "index1",
"node": "RewaFar_TsGVGz1RmgOxlA",
"reason": {
"type": "query_parsing_exception",
"reason": "[match] query does not support type date",
"index": "index1",
"line": 9,
"col": 33
}
}
]
},
"status": 400
}

if i treat the date as string ,am getting data,bu the problem is i cannot do range queries if this is string
Any help on this would be appreciated. Please note am very new to elastic search.

2

First of all, the mapping in the post doesn't make much sense. I assume this is just a typo in the post, but if this is indeed the mapping that you are trying to apply to your index, make sure that the mapping is getting applied by getting it back from the index by running:

GET /index1/workers/_mapping

The second issue is in the query. The field type in the query indicates the type of the query, not the type of the field that his query is operation on. The type of the field is determined automatically from the mapping. So, if mapping is correctly specified, the following query (with "type" omitted) should work:

{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "person.birthDate": {
              "query": "1968-06-15"
            }
          }
        }
      ]
    }
  },
  "from": 0,
  "size": 10,
  "sort": [],
  "aggs": {}
}
3

thanks for the answer,sorry for late acceptence.it worked perfect for me.
I was using that as string,it worked.I was not able to use < or > operators.I figured tht now.But your solution guided me in right direction