Auto-detect dates when dynamically creating ElasticSearch indexes

Question

I've just started using the rest api to put documents into ElasticSearch having always used Logstash to do this in the past.

How do I get ES to recognise dates when I pass it a string or integer? I've tried both 13 digit "millis since epoc" (as string and integer) format and yyyyMMddTHHmmss.SSSZ (ISO 8601) format. Neither seem to get parsed.

Looking at documents that Logstash has successfully indexed, it seems to use the "millis since epoc" method, and I know those indexes are dynamically created. Submitting mappings for each index is not an option for me.

Any ideas? Thanks.

SurrealAnalysis · Accepted Answer · 2016-10-25 17:17:27Z

2

Date detection is covered in detail in the dynamic field mapping section of the documentation.

By default, either yyyy/MM/dd HH:mm:ss Z or yyyy/MM/dd Z can be used, but you can customize that further on a per-index basis if you want.

answered Oct 25, 2016 at 17:17

SurrealAnalysis

3031 silver badge5 bronze badges

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

1 Comment

DisplayName Over a year ago

Cheers, that's done it .NET: DateTime.ToString("O") is picked up correctly.

Collectives™ on Stack Overflow

Auto-detect dates when dynamically creating ElasticSearch indexes

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related