Elasticsearch failed to parse date field format

Question

I 'm new with ealsticsearch and I use a third party ealsticsearch im trying to make query using spring data it's work with all of string fields but when i try to make query with a timestamps field I get an error :

this my query :

{
...
  "transmissionTime": "2021-09-08 11:53:00.000",
...
}

this's my field mapping

@JsonFormat(
        shape = JsonFormat.Shape.STRING, pattern = "yyyy-MM-dd@HH:mm:ss.SSSZ", locale = "fr_FR")
private Timestamp transmission_date_and_time;

when I execute my query i get this error :

Caused by: org.elasticsearch.ElasticsearchException: Elasticsearch exception [type=illegal_argument_exception, reason=failed to parse date field [1631098380000] with format [yyyy-MM-dd@HH:mm:ss.SSSZ]]

Spring Data Elasticsearch does not use Jackson annotations (at least not since version 4.0). Which version do you use? — Abacus
– Abacus, Commented Apr 2, 2021 at 17:29

Bhavya · Accepted Answer · 2021-04-02 17:24:14Z

2

Modify your index mapping as

{
  "mappings": {
    "properties": {
      "timestamp": {
        "type": "date",
        "format": "yyyy-MM-dd HH:mm:ss.SSS"
      }
    }
  }
}

answered Apr 2, 2021 at 17:24

Bhavya

16.2k3 gold badges23 silver badges52 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Elasticsearch failed to parse date field format

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related