You have a comma in "Oct 20, 2014 8:42:41 AM" "Oct 20 2014 8:42:41 AM" will work.
Jörg On Mon, Oct 20, 2014 at 9:06 AM, Peter Litsegård <[email protected] > wrote: > Hi! > > I've been struggling with two date formats. I'll give you a sample and the > corresponding date format I've used: > > 1. "Oct 20, 2014 8:42:41 AM" : MMM d YYYY hh:mm:ss aa > 2. "Mon Oct 20 06:42:41 +0000 2014" : EEE MMM d HH:mm:ss Z YYYY > > I've used the following mapping: > > { > "settings" : { > "index" : { > "number_of_shards" : 1, > "number_of_replicas" : 1 > } > }, > "mappings" : { > "envelope_v1" : { > "_all" : { "enabled" : true }, > "_id" : { "index" : "not_analyzed", "store" : false, "path" : > "id" }, > "_timestamp" : { "enabled" : true, "path" : "createdAt" }, > "_ttl" : { "enabled" : true, "default" : "30d" }, > "properties" : { > "id" : { "type" : "string", "store" : false, "index" : > "no" }, > "createdAt" : { "type" : "date", "format" : "MMM d YYYY > hh:mm:ss aa", "store" : false, "index" : "no" }, > "ref" : { "type" : "string", "store" : false, "index" : > "no" }, > "sourceType" : { "type" : "string", "store" : false, > "index" : "no" }, > "search" : { "type" : "string", "store" : false, "index" : > "no" }, > "source.created_at" : { "type" : "date", "format" : "EEE > MMM d HH:mm:ss Z YYYY", "store" : false, "index" : "no" }, > "source.timestamp_ms" : { "type" : "date", "store" : > false, "index" : "no" }, > "source.user.created_at" : { "type" : "date", "format" : > "EEE MMM d HH:mm:ss Z YYYY", "store" : false, "index" : "no" }, > "source.analysis.nlp" : { "type" : "object", "store" : > false, "index" : "no" } > } > } > } > } > > While adding data I get the following exception: > > java.lang.IllegalArgumentException: Invalid format: "Mon Oct 20 06:30:52 > +0000 2014" > at > org.elasticsearch.common.joda.time.format.DateTimeFormatter.parseMillis(DateTimeFormatter.java:754) > > What am I doing wrong here? > > Cheers > > -- > You received this message because you are subscribed to the Google Groups > "elasticsearch" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/elasticsearch/87eb26ef-6a72-4049-a62a-cfa504acd2ca%40googlegroups.com > <https://groups.google.com/d/msgid/elasticsearch/87eb26ef-6a72-4049-a62a-cfa504acd2ca%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "elasticsearch" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAKdsXoFe8BPBRN%2BVgC_x-8r-vGk%3Djvz9aBhcSSyr66Qk7QHT7w%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
