ElasticSearch mapping dates

Question

First time using ElasticSearch, I'm having trouble indexing a document due to the mapping of dates.

in my DB dates are DATETIME and look like this 2014-02-04 14:04:39. I'm trying to parse this in ElasticSearch but it's telling me that

[Invalid format: \"2014-02-04 14:04:39\" is malformed at \" 14:04:39\"]

I've tried setting the format quite a few different ways:

'date_added' => array(
        'type' => 'date',
        'format' => 'yyyy-MM-dd HH:mm:ss'
        )

and also like this:

yyyy-MM-ddTHH:mm:ss

yyyy-MM-ddTHH:mm:ssZZ

What is the correct format for this?

Did you check if your mapping was successful? Did you apply the mapping before inserting any data? — Thorsten
– Thorsten, Commented Apr 23, 2014 at 15:26

BlackPOP · Accepted Answer · 2014-04-23 15:44:28Z

1

In mapping, configure the field to date and also the format you need.. For syntax refer

http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/mapping-core-types.html#date

The date format that are supported by elasticsearch refer the following link..

http://www.elasticsearch.org/guide/en/elasticsearch/reference/current/mapping-date-format.html

answered Apr 23, 2014 at 15:44

BlackPOP

5,7572 gold badges36 silver badges49 bronze badges

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

3 Comments

Jonnny Over a year ago

thanks for those, I had looked at them but I don't see what is wrong with my format that I've tried. But obviously it is wrong, but I don't know what the correct format should be.

BlackPOP Over a year ago

To change mapping.. Refer stackoverflow.com/questions/23238972/…

Jonnny Over a year ago

I changed my format to 'format' => 'yyyy-MM-dd HH:mm:ss' and this worked for me.

Collectives™ on Stack Overflow

ElasticSearch mapping dates

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related