The couchdb river ignores my mapping and creates a dynamic mapping

Why can that be?

These are my commands:

[2013-03-05T16:22:16.333515]

curl -XPUT 'http://rhea:9200/test1_index_name?pretty=true'

[2013-03-05T16:22:16.807981]

curl -XPUT
'http://rhea:9200/test1_index_name/test1_mapping_id/_mapping?pretty=true' -d
'{"test1_mapping_id": {"dynamic": false, "properties": {"answer": {"index":
"analyzed", "boost": 1.0, "type": "string", "store": "yes"}, "end":
{"index": "analyzed", "boost": 1.0, "type": "string", "store": "yes"},
"dialednum": {"index": "analyzed", "boost": 1.0, "type": "string", "store":
"yes"}, "calldate": {"index": "analyzed", "boost": 1.0, "type": "string",
"store": "yes"}, "clidnum": {"index": "analyzed", "boost": 1.0, "type":
"string", "store": "yes"}}}}'

[2013-03-05T16:22:16.957609]

curl -XPUT 'http://rhea:9200/_river/test1_index_name/_meta?pretty=true' -d '{"index":
{"index": "test1_index_name", "type": "test1_index_type", "name":
"test1_index_name", "bulk_size": 100}, "couchdb": {"filter": null, "host":
"localhost", "db": "cdr", "port": 20138}, "type": "couchdb"}'

And this is the log:

[2013-03-05 16:27:48,893][INFO ][cluster.metadata ] [Asmodeus] [
test1_index_name] creating index, cause [api], shards [5]/[1], mappings []
[2013-03-05 16:27:49,382][INFO ][cluster.metadata ] [Asmodeus] [
test1_index_name] create_mapping [test1_mapping_id]
[2013-03-05 16:27:49,435][INFO ][cluster.metadata ] [Asmodeus] [
_river] creating index, cause [auto(index api)], shards [1]/[1], mappings []
[2013-03-05 16:27:49,714][INFO ][cluster.metadata ] [Asmodeus] [
_river] update_mapping [test1_index_name] (dynamic)
[2013-03-05 16:27:49,770][INFO ][river.couchdb ] [Asmodeus] [
couchdb][test1_index_name] starting couchdb stream: host [localhost], port [
20138], filter [null], db [cdr], indexing to [test1_index_name]/[
test1_index_ty
[2013-03-05 16:27:49,773][INFO ][cluster.metadata ] [Asmodeus] [
_river] update_mapping [test1_index_name] (dynamic)
[2013-03-05 16:27:49,921][INFO ][cluster.metadata ] [Asmodeus] [
_river] update_mapping [test1_index_name] (dynamic)
[2013-03-05 16:27:49,936][INFO ][cluster.metadata ] [Asmodeus] [
test1_index_name] update_mapping [test1_index_type] (dynamic)
[2013-03-05 16:27:49,980][INFO ][cluster.metadata ] [Asmodeus] [
test1_index_name] update_mapping [test1_index_type] (dynamic)
[2013-03-05 16:27:53,679][INFO ][cluster.metadata ] [Asmodeus] [
test1_index_name] update_mapping [test1_index_type] (dynamic)
[2013-03-05 16:27:53,704][INFO ][cluster.metadata ] [Asmodeus] [
test1_index_name] update_mapping [test1_index_type] (dynamic)
[2013-03-05 16:27:53,707][INFO ][cluster.metadata ] [Asmodeus] [
test1_index_name] update_mapping [test1_index_type] (dynamic)
[2013-03-05 16:27:54,354][INFO ][cluster.metadata ] [Asmodeus] [
test1_index_name] update_mapping [test1_index_type] (dynamic)
[2013-03-05 16:27:55,406][DEBUG][action.bulk ] [Asmodeus] [
test1_index_name][2] failed to bulk item (index) index {[test1_index_name][
test1_index_type][ee596d9d3bb846bfba6e9ac9e7c9d2db], source[{"calldate":
"2011-08
org.elasticsearch.index.mapper.MapperParsingException: Failed to parse
[billsec]
at
org.elasticsearch.index.mapper.core.AbstractFieldMapper.parse(AbstractFieldMapper.java:308)
at
org.elasticsearch.index.mapper.object.ObjectMapper.serializeValue(ObjectMapper.java:577)
at
org.elasticsearch.index.mapper.object.ObjectMapper.parse(ObjectMapper.java:443)
at
org.elasticsearch.index.mapper.DocumentMapper.parse(DocumentMapper.java:475)
at
org.elasticsearch.index.mapper.DocumentMapper.parse(DocumentMapper.java:416)
at
org.elasticsearch.index.shard.service.InternalIndexShard.prepareIndex(InternalIndexShard.java:302)
at
org.elasticsearch.action.bulk.TransportShardBulkAction.shardOperationOnPrimary(TransportShardBulkAction.java:136)
at
org.elasticsearch.action.support.replication.TransportShardReplicationOperationAction$AsyncShardOperationAction.performOnPrimary(TransportShardReplicationOperationAction.java:487)
at
org.elasticsearch.action.support.replication.TransportShardReplicationOperationAction$AsyncShardOperationAction$1.run(TransportShardReplicationOperationAction.java:400)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)

BR,
Daniel

--
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.
For more options, visit https://groups.google.com/groups/opt_out.

Hi Daniel,

Try this:
curl -XPUT 'http://rhea:9200/_river/test1_index_name/_meta?pretty=true' -d '{"index": {"index": "test1_index_name", "type": "test1_mapping_id", "name": "test1_index_name", "bulk_size": 100}, "couchdb": {"filter": null, "host": "localhost", "db": "cdr", "port": 20138}, "type": "couchdb"}'

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet | @elasticsearchfr | @scrutmydocs

Le 5 mars 2013 à 16:31, Daniel Gonzalez gonvaled@gmail.com a écrit :

Why can that be?

These are my commands:

[2013-03-05T16:22:16.333515]

curl -XPUT 'http://rhea:9200/test1_index_name?pretty=true'

[2013-03-05T16:22:16.807981]

curl -XPUT 'http://rhea:9200/test1_index_name/test1_mapping_id/_mapping?pretty=true' -d '{"test1_mapping_id": {"dynamic": false, "properties": {"answer": {"index": "analyzed", "boost": 1.0, "type": "string", "store": "yes"}, "end": {"index": "analyzed", "boost": 1.0, "type": "string", "store": "yes"}, "dialednum": {"index": "analyzed", "boost": 1.0, "type": "string", "store": "yes"}, "calldate": {"index": "analyzed", "boost": 1.0, "type": "string", "store": "yes"}, "clidnum": {"index": "analyzed", "boost": 1.0, "type": "string", "store": "yes"}}}}'

[2013-03-05T16:22:16.957609]

curl -XPUT 'http://rhea:9200/_river/test1_index_name/_meta?pretty=true' -d '{"index": {"index": "test1_index_name", "type": "test1_index_type", "name": "test1_index_name", "bulk_size": 100}, "couchdb": {"filter": null, "host": "localhost", "db": "cdr", "port": 20138}, "type": "couchdb"}'

And this is the log:

[2013-03-05 16:27:48,893][INFO ][cluster.metadata ] [Asmodeus] [test1_index_name] creating index, cause [api], shards [5]/[1], mappings
[2013-03-05 16:27:49,382][INFO ][cluster.metadata ] [Asmodeus] [test1_index_name] create_mapping [test1_mapping_id]
[2013-03-05 16:27:49,435][INFO ][cluster.metadata ] [Asmodeus] [_river] creating index, cause [auto(index api)], shards [1]/[1], mappings
[2013-03-05 16:27:49,714][INFO ][cluster.metadata ] [Asmodeus] [_river] update_mapping [test1_index_name] (dynamic)
[2013-03-05 16:27:49,770][INFO ][river.couchdb ] [Asmodeus] [couchdb][test1_index_name] starting couchdb stream: host [localhost], port [20138], filter [null], db [cdr], indexing to [test1_index_name]/[test1_index_ty
[2013-03-05 16:27:49,773][INFO ][cluster.metadata ] [Asmodeus] [_river] update_mapping [test1_index_name] (dynamic)
[2013-03-05 16:27:49,921][INFO ][cluster.metadata ] [Asmodeus] [_river] update_mapping [test1_index_name] (dynamic)
[2013-03-05 16:27:49,936][INFO ][cluster.metadata ] [Asmodeus] [test1_index_name] update_mapping [test1_index_type] (dynamic)
[2013-03-05 16:27:49,980][INFO ][cluster.metadata ] [Asmodeus] [test1_index_name] update_mapping [test1_index_type] (dynamic)
[2013-03-05 16:27:53,679][INFO ][cluster.metadata ] [Asmodeus] [test1_index_name] update_mapping [test1_index_type] (dynamic)
[2013-03-05 16:27:53,704][INFO ][cluster.metadata ] [Asmodeus] [test1_index_name] update_mapping [test1_index_type] (dynamic)
[2013-03-05 16:27:53,707][INFO ][cluster.metadata ] [Asmodeus] [test1_index_name] update_mapping [test1_index_type] (dynamic)
[2013-03-05 16:27:54,354][INFO ][cluster.metadata ] [Asmodeus] [test1_index_name] update_mapping [test1_index_type] (dynamic)
[2013-03-05 16:27:55,406][DEBUG][action.bulk ] [Asmodeus] [test1_index_name][2] failed to bulk item (index) index {[test1_index_name][test1_index_type][ee596d9d3bb846bfba6e9ac9e7c9d2db], source[{"calldate":"2011-08
org.elasticsearch.index.mapper.MapperParsingException: Failed to parse [billsec]
at org.elasticsearch.index.mapper.core.AbstractFieldMapper.parse(AbstractFieldMapper.java:308)
at org.elasticsearch.index.mapper.object.ObjectMapper.serializeValue(ObjectMapper.java:577)
at org.elasticsearch.index.mapper.object.ObjectMapper.parse(ObjectMapper.java:443)
at org.elasticsearch.index.mapper.DocumentMapper.parse(DocumentMapper.java:475)
at org.elasticsearch.index.mapper.DocumentMapper.parse(DocumentMapper.java:416)
at org.elasticsearch.index.shard.service.InternalIndexShard.prepareIndex(InternalIndexShard.java:302)
at org.elasticsearch.action.bulk.TransportShardBulkAction.shardOperationOnPrimary(TransportShardBulkAction.java:136)
at org.elasticsearch.action.support.replication.TransportShardReplicationOperationAction$AsyncShardOperationAction.performOnPrimary(TransportShardReplicationOperationAction.java:487)
at org.elasticsearch.action.support.replication.TransportShardReplicationOperationAction$AsyncShardOperationAction$1.run(TransportShardReplicationOperationAction.java:400)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)

BR,
Daniel

--
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.
For more options, visit https://groups.google.com/groups/opt_out.

--
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.
For more options, visit https://groups.google.com/groups/opt_out.

Thanks, that worked!

On Tuesday, March 5, 2013 6:05:53 PM UTC+1, David Pilato wrote:

Hi Daniel,

Try this:
curl -XPUT 'http://rhea:9200/_river/test1_index_name/_meta?pretty=true' -
d '{"index": {"index": "test1_index_name", "type": "test1_mapping_id",
"name": "test1_index_name", "bulk_size": 100}, "couchdb": {"filter": null,
"host": "localhost", "db": "cdr", "port": 20138}, "type": "couchdb"}'

--
David Pilato | Technical Advocate | Elasticsearch.com
@dadoonet https://twitter.com/dadoonet | @elasticsearchfrhttps://twitter.com/elasticsearchfr
| @scrutmydocs https://twitter.com/scrutmydocs

Le 5 mars 2013 à 16:31, Daniel Gonzalez <gonv...@gmail.com <javascript:>>
a écrit :

Why can that be?

These are my commands:

[2013-03-05T16:22:16.333515]

curl -XPUT 'http://rhea:9200/test1_index_name?pretty=true'

[2013-03-05T16:22:16.807981]

curl -XPUT '
http://rhea:9200/test1_index_name/test1_mapping_id/_mapping?pretty=true' -d
'{"test1_mapping_id": {"dynamic": false, "properties": {"answer":
{"index": "analyzed", "boost": 1.0, "type": "string", "store": "yes"},
"end": {"index": "analyzed", "boost": 1.0, "type": "string", "store":
"yes"}, "dialednum": {"index": "analyzed", "boost": 1.0, "type": "string",
"store": "yes"}, "calldate": {"index": "analyzed", "boost": 1.0, "type":
"string", "store": "yes"}, "clidnum": {"index": "analyzed", "boost": 1.0,
"type": "string", "store": "yes"}}}}'

[2013-03-05T16:22:16.957609]

curl -XPUT 'http://rhea:9200/_river/test1_index_name/_meta?pretty=true' -d
'{"index": {"index": "test1_index_name", "type": "test1_index_type",
"name": "test1_index_name", "bulk_size": 100}, "couchdb": {"filter": null,
"host": "localhost", "db": "cdr", "port": 20138}, "type": "couchdb"}'

And this is the log:

[2013-03-05 16:27:48,893][INFO ][cluster.metadata ] [Asmodeus] [
test1_index_name] creating index, cause [api], shards [5]/[1], mappings
[2013-03-05 16:27:49,382][INFO ][cluster.metadata ] [Asmodeus] [
test1_index_name] create_mapping [test1_mapping_id]
[2013-03-05 16:27:49,435][INFO ][cluster.metadata ] [Asmodeus] [
_river] creating index, cause [auto(index api)], shards [1]/[1], mappings

[2013-03-05 16:27:49,714][INFO ][cluster.metadata ] [Asmodeus] [
_river] update_mapping [test1_index_name] (dynamic)
[2013-03-05 16:27:49,770][INFO ][river.couchdb ] [Asmodeus] [
couchdb][test1_index_name] starting couchdb stream: host [localhost],port
[20138], filter [null], db [cdr], indexing to [test1_index_name]/[
test1_index_ty
[2013-03-05 16:27:49,773][INFO ][cluster.metadata ] [Asmodeus] [
_river] update_mapping [test1_index_name] (dynamic)
[2013-03-05 16:27:49,921][INFO ][cluster.metadata ] [Asmodeus] [
_river] update_mapping [test1_index_name] (dynamic)
[2013-03-05 16:27:49,936][INFO ][cluster.metadata ] [Asmodeus] [
test1_index_name] update_mapping [test1_index_type] (dynamic)
[2013-03-05 16:27:49,980][INFO ][cluster.metadata ] [Asmodeus] [
test1_index_name] update_mapping [test1_index_type] (dynamic)
[2013-03-05 16:27:53,679][INFO ][cluster.metadata ] [Asmodeus] [
test1_index_name] update_mapping [test1_index_type] (dynamic)
[2013-03-05 16:27:53,704][INFO ][cluster.metadata ] [Asmodeus] [
test1_index_name] update_mapping [test1_index_type] (dynamic)
[2013-03-05 16:27:53,707][INFO ][cluster.metadata ] [Asmodeus] [
test1_index_name] update_mapping [test1_index_type] (dynamic)
[2013-03-05 16:27:54,354][INFO ][cluster.metadata ] [Asmodeus] [
test1_index_name] update_mapping [test1_index_type] (dynamic)
[2013-03-05 16:27:55,406][DEBUG][action.bulk ] [Asmodeus] [
test1_index_name][2] failed to bulk item (index) index {[test1_index_name
][test1_index_type][ee596d9d3bb846bfba6e9ac9e7c9d2db], source[{"calldate":
"2011-08
org.elasticsearch.index.mapper.MapperParsingException: Failed to parse
[billsec]
at
org.elasticsearch.index.mapper.core.AbstractFieldMapper.parse(AbstractFieldMapper.java:308)
at
org.elasticsearch.index.mapper.object.ObjectMapper.serializeValue(ObjectMapper.java:577)
at
org.elasticsearch.index.mapper.object.ObjectMapper.parse(ObjectMapper.java:443)
at
org.elasticsearch.index.mapper.DocumentMapper.parse(DocumentMapper.java:475)
at
org.elasticsearch.index.mapper.DocumentMapper.parse(DocumentMapper.java:416)
at
org.elasticsearch.index.shard.service.InternalIndexShard.prepareIndex(InternalIndexShard.java:302)
at
org.elasticsearch.action.bulk.TransportShardBulkAction.shardOperationOnPrimary(TransportShardBulkAction.java:136)
at
org.elasticsearch.action.support.replication.TransportShardReplicationOperationAction$AsyncShardOperationAction.performOnPrimary(TransportShardReplicationOperationAction.java:487)
at
org.elasticsearch.action.support.replication.TransportShardReplicationOperationAction$AsyncShardOperationAction$1.run(TransportShardReplicationOperationAction.java:400)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)

BR,
Daniel

--
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 elasticsearc...@googlegroups.com <javascript:>.
For more options, visit https://groups.google.com/groups/opt_out.

--
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.
For more options, visit https://groups.google.com/groups/opt_out.