Thanks for the report. Does it work if you create the index with the custom mapping beforehand, with tool like curl?
The JDBC river will use existing index then. Jörg On Wed, Apr 30, 2014 at 9:56 PM, Eric Sims <[email protected]>wrote: > i can't seem to understand how to fully set up my type mappings while > using jdbc rivers and sql server. > > here's an example. > > PUT /_river/mytest_river/_meta > { > "type": "jdbc", > "jdbc": { > "url":"jdbc:sqlserver://mydbserver:1433;databaseName=mydatabase", > "user":"myuser", > "password":"xxx", > "sql":"select * from dbo.musicalbum (nolock)", > "strategy" : "oneshot", > "index" : "myindex", > "type" : "album", > "bulk_size" : 100, > "max_retries": 5, > "max_retries_wait":"30s", > "max_bulk_requests" : 5, > "bulk_flush_interval" : "5s", > "type_mapping": { > "album": {"properties": { > "AlbumDescription": {"type": "string"}, > "AlbumID": {"type": "string"}, > "Artist": {"type": "string"}, > "Genre": {"type": "string","index" : "not_analyzed"}, > "Label": {"type": "string"}, > "Title": {"type": "string"}, > "_id" : {"path" : "AlbumID"} > } > } > } > } > } > > so you can see i've specified both a select statement (which normally > would dynamically produce the mapping for me) and also a type mapping. in > the type mapping i've tried to specify that i want the _id to be the same > as AlbumID, and also that i want the Genre to be not_analyzed. it ends up > throwing multiple errors, only indexing one document, and not creating my > full mapping. > > here's what the mapping ends up looking like: (skipping some of the > columns altogether!) > > { > "myindex": { > "mappings": { > "album": { > "properties": { > "AlbumDescription": { > "type": "string" > }, > "AlbumID": { > "type": "string" > }, > "Artist": { > "type": "string" > }, > "Genre": { > "type": "string" > }, > "Title": { > "type": "string" > } > } > } > } > } > } > > any assistance would be helpful. it's driving me nuts. > > -- > 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/4c9af783-cf6c-4e41-a287-83ff5589350e%40googlegroups.com<https://groups.google.com/d/msgid/elasticsearch/4c9af783-cf6c-4e41-a287-83ff5589350e%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/CAKdsXoEGjQfv%2BkRgia-GRu8D805hmv%2BLUkLXtCBX8VxHSFTTEQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
