How to allow ElasticSearch to accept empty date fields?

Question

I have a Python script that I use to load some data into ElasticSearch.

One of the fields I am loading is a date field, which on some rare occasions can be empty.

In my code, if there is no date, I assign it the string "null":

details["start_time"] = project_detail.get("start_time", "null")

In this case, I am getting the following error:

***search.BadRequestError: BadRequestError(400, 'mapper_parsing_exception', "failed to parse field [start_time] of type [date] in document with id '1'. Preview of field's value: 'null'")

How can I make ES accept empty fields for this date field?

Val · Accepted Answer · 2022-10-12 06:41:32Z

1

"null" (string) is not the same as null. ES will not be able to parse "null" as a date. You should probably just assign None instead so that the date field will just be missing.

answered Oct 12, 2022 at 6:41

Val

218k14 gold badges377 silver badges384 bronze badges

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

Collectives™ on Stack Overflow

How to allow ElasticSearch to accept empty date fields?

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