Maybe the old mapping is still active?
This works here:
import org.elasticsearch.common.joda.FormatDateTimeFormatter;
import org.elasticsearch.common.joda.Joda;
import org.elasticsearch.common.joda.time.DateTime;
import org.testng.annotations.Test;
public class JodaTest {
@Test
public void joda() {
FormatDateTimeFormatter f = Joda.forPattern("MMM d',' YYYY KK:mm:ss
aa");
DateTime t = f.parser().parseDateTime("Oct 20, 2014 09:35:42 AM");
System.err.println(f.printer().print(t));
}
}
Jörg
On Mon, Oct 20, 2014 at 9:43 AM, Peter Litsegård <[email protected]
> wrote:
> Hi Jörg!
>
> Thanks for your response. However, IMHO I don't think this is the problem.
> I changed the Joda specifikation in (1) to "MMM d',' YYYY hh:mm:ss aa" and
> when I used this simple test code
>
> DateTime dt = new DateTime();
> DateTimeFormatter fmt = DateTimeFormat.forPattern("MMM
> d',' YYYY KK:mm:ss aa");
> System.out.println(json);
> String str = fmt.print(dt);
>
> I got the following printout:
>
> Oct 20, 2014 09:35:42 AM
>
> which corresponds nicely to the data I try to index:
> ...4","createdAt":"Oct 20, 2014 9:35:40 AM"... (just an extract from the
> complete JSON document)
>
> I changed the mapping for "createdAt" to "MMM d',' YYYY hh:mm:ss aa" BUT I
> still get exactly the same error...
>
> VERY frustrating...
>
> Cheers
>
>
>
> On Monday, October 20, 2014 9:06:44 AM UTC+2, Peter Litsegård 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/71744ebf-91ad-4fbe-bc5e-b7aa3f457881%40googlegroups.com
> <https://groups.google.com/d/msgid/elasticsearch/71744ebf-91ad-4fbe-bc5e-b7aa3f457881%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/CAKdsXoFY%3DCHihu97gGj%2B3Ds%3Dxk9q5LBWReFONg-U5rMmojyBEg%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
