ElasticSearch date parsing error while creating index with mappings

Question

I create ElasticSearch (7.7 version) index (with mappings) in cdk script. here is my mapping for the date field:

{
  "mappings": {
    "numeric_detection": true,
    "properties": {
      "approximateArrivalTime": {
        "type": "date",
        "format": "yyyy-MM-dd HH:mm:ss.SSSXXX"
      }, ......}

But I keep having this error message:

  {\"type\":\"illegal_argument_exception\",\"reason\":\"failed to parse date field [2020-11-23 11:48:20.472] with format [yyyy-MM-dd HH:mm:ss.SSSXXX]\",\"caused_by\":{\"type\":\"date_time_parse_exception\",\"reason\":\"Text \\u00272020-11-23 11:48:20.472\\u0027 could not be parsed at index 23\"}}}

What could be the reason?

Bhavya · Accepted Answer · 2020-11-24 12:45:05Z

1

The error clearly indicates that the data you are indexing in the approximateArrivalTime does not match with that of your date format specified in the index mapping.

Try indexing the document in the below format:

Index Mapping:

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

Index Data:

{
  "approximateArrivalTime":"2020-11-23 11:48:20.472"
}

edited Nov 24, 2020 at 12:45

answered Nov 23, 2020 at 12:49

Bhavya

16.2k3 gold badges23 silver badges52 bronze badges

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

10 Comments

Bhavya Over a year ago

@A.Di did you get a chance to go through my answer, looking forward to get feedback from you :)

A.Di Over a year ago

thanx for your answer, unfortunately, it didn't help. still the same error.

Bhavya Over a year ago

@A.Di I tried it locally also, and it's working fine. Can you please share the data you are indexing for approximateArrivalTime? And are you getting the error when running a search query on approximateArrivalTime ?

A.Di Over a year ago

2020-11-23 11:48:20.472 - I try to parse this date. The error says it cannot parse this field when I provide the field type in mappings. So I guess tries index data and then fails.

Bhavya Over a year ago

@A.Di You are indexing the same doc 2020-11-23 11:48:20.472 that you have provided in the question above. Please go through my answer, the data that you are indexing does not match with the date format you have mentioned in the index mapping. And therefore, you are getting parsing error

|

Collectives™ on Stack Overflow

ElasticSearch date parsing error while creating index with mappings

1 Answer 1

10 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related