# ElasticSearch thinks my Map\<String,String\> should be datetime, and fails

**URL:** <https://discuss.elastic.co/t/elasticsearch-thinks-my-map-string-string-should-be-datetime-and-fails/8547>\
**Category:** Elasticsearch\
**Created:** [July 27, 2012, 10:10pm UTC](https://discuss.elastic.co/t/elasticsearch-thinks-my-map-string-string-should-be-datetime-and-fails/8547 "2012-07-27T22:10:37Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![job](https://avatars.discourse-cdn.com/v4/letter/j/6a8cbe/32.png) [@job](https://discuss.elastic.co/u/job)\
**Post date:** [July 27, 2012, 10:10pm UTC](https://discuss.elastic.co/t/elasticsearch-thinks-my-map-string-string-should-be-datetime-and-fails/8547/1 "2012-07-27T22:10:37Z")

</div>

I have a Java class:  
public class Audit {  
public Map\<String,String\> newValues = new HashMap\<String,String\>();  
...  
Which I turn to JSON:  
{"newValues":{"data":"sjab",...},...}

I get this error  
Failed to parse [newValues.data]

Caused by: org.elasticsearch.index.mapper.MapperParsingException: Failed to  
parse [newValues.data]  
at  
org.elasticsearch.index.mapper.core.AbstractFieldMapper.parse(AbstractFieldMapper.java:327)  
at  
org.elasticsearch.index.mapper.object.ObjectMapper.serializeValue(ObjectMapper.java:585)  
at  
org.elasticsearch.index.mapper.object.ObjectMapper.parse(ObjectMapper.java:449)  
at  
org.elasticsearch.index.mapper.object.ObjectMapper.serializeObject(ObjectMapper.java:497)  
at  
org.elasticsearch.index.mapper.object.ObjectMapper.parse(ObjectMapper.java:439)  
at  
org.elasticsearch.index.mapper.DocumentMapper.parse(DocumentMapper.java:493)  
at  
org.elasticsearch.index.mapper.DocumentMapper.parse(DocumentMapper.java:437)  
at  
org.elasticsearch.index.shard.service.InternalIndexShard.prepareIndex(InternalIndexShard.java:311)  
at  
org.elasticsearch.action.index.TransportIndexAction.shardOperationOnPrimary(TransportIndexAction.java:202)  
at  
org.elasticsearch.action.support.replication.TransportShardReplicationOperationAction$AsyncShardOperationAction.performOnPrimary(TransportShardReplicationOperationAction.java:532)  
at  
org.elasticsearch.action.support.replication.TransportShardReplicationOperationAction$AsyncShardOperationAction$1.run(TransportShardReplicationOperationAction.java:430)  
at  
java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)  
at  
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)  
... 1 more  
Caused by: org.elasticsearch.index.mapper.MapperParsingException: failed to  
parse date field [true], tried both date format [dateOptionalTime], and  
timestamp number  
at  
org.elasticsearch.index.mapper.core.DateFieldMapper.parseStringValue(DateFieldMapper.java:425)  
at  
org.elasticsearch.index.mapper.core.DateFieldMapper.parseCreateField(DateFieldMapper.java:354)  
at  
org.elasticsearch.index.mapper.core.AbstractFieldMapper.parse(AbstractFieldMapper.java:314)  
... 13 more  
Caused by: java.lang.IllegalArgumentException: Invalid format: "true"  
at  
org.elasticsearch.common.joda.time.format.DateTimeFormatter.parseMillis(DateTimeFormatter.java:747)  
at  
org.elasticsearch.index.mapper.core.DateFieldMapper.parseStringValue(DateFieldMapper.java:419)

I tried putting various elements in schema.xml, but still get the error:

What to do?

(Other top-level fields work fine, but not the Strings in my map. It was  
working earlier, then stopped!)

--Job

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [July 27, 2012, 10:17pm UTC](https://discuss.elastic.co/t/elasticsearch-thinks-my-map-string-string-should-be-datetime-and-fails/8547/2 "2012-07-27T22:17:27Z")

</div>

You can set the mapping for this field to String before sending the first doc.  
I suppose that you sent a first doc with something like "2000-12" and that ES auto mapping thought it was a date.

So if you specify mapping first, ES will apply it.

HTH  
David

--

Le 28 juil. 2012 à 00:10, job [ob@b20nine.com](mailto:ob@b20nine.com) a écrit :

> I have a Java class:  
> public class Audit {  
> public Map\<String,String\> newValues = new HashMap\<String,String\>();  
> ...  
> Which I turn to JSON:  
> {"newValues":{"data":"sjab",...},...}
> 
> I get this error  
> Failed to parse [newValues.data]
> 
> Caused by: org.elasticsearch.index.mapper.MapperParsingException: Failed to parse [newValues.data]  
> at org.elasticsearch.index.mapper.core.AbstractFieldMapper.parse(AbstractFieldMapper.java:327)  
> at org.elasticsearch.index.mapper.object.ObjectMapper.serializeValue(ObjectMapper.java:585)  
> at org.elasticsearch.index.mapper.object.ObjectMapper.parse(ObjectMapper.java:449)  
> at org.elasticsearch.index.mapper.object.ObjectMapper.serializeObject(ObjectMapper.java:497)  
> at org.elasticsearch.index.mapper.object.ObjectMapper.parse(ObjectMapper.java:439)  
> at org.elasticsearch.index.mapper.DocumentMapper.parse(DocumentMapper.java:493)  
> at org.elasticsearch.index.mapper.DocumentMapper.parse(DocumentMapper.java:437)  
> at org.elasticsearch.index.shard.service.InternalIndexShard.prepareIndex(InternalIndexShard.java:311)  
> at org.elasticsearch.action.index.TransportIndexAction.shardOperationOnPrimary(TransportIndexAction.java:202)  
> at org.elasticsearch.action.support.replication.TransportShardReplicationOperationAction$AsyncShardOperationAction.performOnPrimary(TransportShardReplicationOperationAction.java:532)  
> at org.elasticsearch.action.support.replication.TransportShardReplicationOperationAction$AsyncShardOperationAction$1.run(TransportShardReplicationOperationAction.java:430)  
> at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)  
> at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)  
> ... 1 more  
> Caused by: org.elasticsearch.index.mapper.MapperParsingException: failed to parse date field [true], tried both date format [dateOptionalTime], and timestamp number  
> at org.elasticsearch.index.mapper.core.DateFieldMapper.parseStringValue(DateFieldMapper.java:425)  
> at org.elasticsearch.index.mapper.core.DateFieldMapper.parseCreateField(DateFieldMapper.java:354)  
> at org.elasticsearch.index.mapper.core.AbstractFieldMapper.parse(AbstractFieldMapper.java:314)  
> ... 13 more  
> Caused by: java.lang.IllegalArgumentException: Invalid format: "true"  
> at org.elasticsearch.common.joda.time.format.DateTimeFormatter.parseMillis(DateTimeFormatter.java:747)  
> at org.elasticsearch.index.mapper.core.DateFieldMapper.parseStringValue(DateFieldMapper.java:419)
> 
> I tried putting various elements in schema.xml, but still get the error:
> 
> What to do?
> 
> (Other top-level fields work fine, but not the Strings in my map. It was working earlier, then stopped!)
> 
> --Job

---

<div class="post-metadata">

**Author:** ![job](https://avatars.discourse-cdn.com/v4/letter/j/6a8cbe/32.png) [@job](https://discuss.elastic.co/u/job)\
**Post date:** [July 27, 2012, 11:11pm UTC](https://discuss.elastic.co/t/elasticsearch-thinks-my-map-string-string-should-be-datetime-and-fails/8547/3 "2012-07-27T23:11:06Z")

</div>

> Ah, auto mapping.

How do I set the type programmatically from Java? At the moment, I  
inherited code like  
client.prepareIndex(INDEX, "event", "abc123")  
.setSource(json)  
.execute()  
.actionGet();

I'm a bit new here...

--Job

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [July 28, 2012, 2:35am UTC](https://discuss.elastic.co/t/elasticsearch-thinks-my-map-string-string-should-be-datetime-and-fails/8547/4 "2012-07-28T02:35:15Z")

</div>

Have a look here : [https://github.com/dadoonet/spring-elasticsearch/blob/master/src/main/java/fr/pilato/spring/elasticsearch/ElasticsearchAbstractClientFactoryBean.java](https://github.com/dadoonet/spring-elasticsearch/blob/master/src/main/java/fr/pilato/spring/elasticsearch/ElasticsearchAbstractClientFactoryBean.java)

It should help.

--

Le 28 juil. 2012 à 01:11, job [ob@b20nine.com](mailto:ob@b20nine.com) a écrit :

> Ah, auto mapping.
> 
> How do I set the type programmatically from Java? At the moment, I inherited code like  
> client.prepareIndex(INDEX, "event", "abc123")  
> .setSource(json)  
> .execute()  
> .actionGet();
> 
> I'm a bit new here...
> 
> --Job

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [July 28, 2012, 2:36am UTC](https://discuss.elastic.co/t/elasticsearch-thinks-my-map-string-string-should-be-datetime-and-fails/8547/5 "2012-07-28T02:36:24Z")

</div>

[https://github.com/dadoonet/spring-elasticsearch/blob/master/src/main/java/fr/pilato/spring/elasticsearch/ElasticsearchAbstractClientFactoryBean.java#L616](https://github.com/dadoonet/spring-elasticsearch/blob/master/src/main/java/fr/pilato/spring/elasticsearch/ElasticsearchAbstractClientFactoryBean.java#L616)

Sorry. Line number was missing...

David

--

Le 28 juil. 2012 à 04:35, David Pilato [david@pilato.fr](mailto:david@pilato.fr) a écrit :

> Have a look here : [https://github.com/dadoonet/spring-elasticsearch/blob/master/src/main/java/fr/pilato/spring/elasticsearch/ElasticsearchAbstractClientFactoryBean.java](https://github.com/dadoonet/spring-elasticsearch/blob/master/src/main/java/fr/pilato/spring/elasticsearch/ElasticsearchAbstractClientFactoryBean.java)
> 
> It should help.
> 
> --
> 
> Le 28 juil. 2012 à 01:11, job [ob@b20nine.com](mailto:ob@b20nine.com) a écrit :
> 
> > Ah, auto mapping.
> > 
> > How do I set the type programmatically from Java? At the moment, I inherited code like  
> > client.prepareIndex(INDEX, "event", "abc123")  
> > .setSource(json)  
> > .execute()  
> > .actionGet();
> > 
> > I'm a bit new here...
> > 
> > --Job

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 3:18am UTC](https://discuss.elastic.co/t/elasticsearch-thinks-my-map-string-string-should-be-datetime-and-fails/8547/6 "2017-07-06T03:18:43Z")

</div>