Joda problem!

Elastic Stack Elasticsearch
1

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 elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/87eb26ef-6a72-4049-a62a-cfa504acd2ca%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

2

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 <peter.litsegaard@gmail.com

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 elasticsearch+unsubscribe@googlegroups.com.
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 elasticsearch+unsubscribe@googlegroups.com.
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.

3

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 elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/71744ebf-91ad-4fbe-bc5e-b7aa3f457881%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

4

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 <peter.litsegaard@gmail.com

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 elasticsearch+unsubscribe@googlegroups.com.
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 elasticsearch+unsubscribe@googlegroups.com.
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.

5

Just to give you a sample.

Partial doc JSON:

{
"id": "524107608429699072",
"createdAt": "Oct 20, 2014 9:59:25 AM",
"source": {
"created_at": "Mon Oct 20 07:59:25 +0000 2014",
"source": "<a href="http://ElwynRoad.com" rel="nofollow">Elwyn
Road",
"retweet_count": 0,
"retweeted": false,
"filter_level": "medium",
"id_str": "524107608429699072",
...

As you can see "createdAt" conforms nicely to 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
KK:mm:ss aa", "store" : true, "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" }
}
}
}
}

Still ES throws:

ElasticsearchParseException[failed to parse doc to extract
routing/timestamp/id]; nested: TimestampParsingException[failed to parse
timestamp [Oct 20, 2014 9:59:25 AM]];

Sigh...

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 elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/8afad408-5c12-4831-80d5-83ea37294547%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

6

I decided to drop this for now and provide the timestamp field (createdAt)
in milliseconds...

Thanks for your help though...

/Peter

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 elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/1726a6b2-eebe-42ae-a3f6-16bf4c59e006%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

7

I works here

PUT /myindex

PUT /myindex/test/_mapping
{
"test": {
"properties": {
"created": {
"type" : "date",
"format" : "MMM d',' YYYY KK:mm:ss aa",
"store" : true,
"index" : "no"
}
}
}
}

PUT /myindex/test/1
{
"created" : "Oct 20, 2014 9:59:25 AM"
}

GET /myindex/test/1

{
"_index": "myindex",
"_type": "test",
"_id": "1",
"_version": 1,
"found": true,
"_source": {
"created": "Oct 20, 2014 9:59:25 AM"
}
}

Jörg

On Mon, Oct 20, 2014 at 10:50 AM, Peter Litsegård <
peter.litsegaard@gmail.com> wrote:

I decided to drop this for now and provide the timestamp field (createdAt)
in milliseconds...

Thanks for your help though...

/Peter

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 elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/1726a6b2-eebe-42ae-a3f6-16bf4c59e006%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/1726a6b2-eebe-42ae-a3f6-16bf4c59e006%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 elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAKdsXoGt-vt%2BhN%3Da5VBG1fmpG%2BJcj%2BuU7LcBsYjCXcjLA9iPaQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

8

Strange!!!! I decided to drop this for now due to a presentation tomorrow.
Will pick it up afterwards...:slight_smile:

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 elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/2fa70c14-4d2c-42fe-b025-04d15f3bae0d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.