You're misinterpreting the docs. _route_ is used to tell _queries_ where to go, or to route a document as part of the parameters when you send the doc, not a field in the doc.
So when you added the _route_ field to the doc, you didn't have it in the schema in the first place. So you could add a _route_ field to your schema and work that way, but then you have to also define router.field=_route_ when you create the colleciton. I'd advise instead just specifying router.field=Status to avoid confusion. Now, that said I really question whether this is a good way to set up your collection. I'd just use compositeId and when you want to restrict searches to one type or the other add &fq=Status:Active or &fq=Status:Terminated that way you can't forget to delete the doc from one shard or the other when the status changes. You won't have lopsided doc counts on your shards because you have 10,000,000 active docs and 10 terminated docs. And whatever ratio you start with, it'll change as the collection ages. FWIW, Erick On Fri, Dec 15, 2017 at 11:17 AM, hemanth <k.hemanthku...@gmail.com> wrote: > I created a collection with implicit routing mechanism and my shared names > are Active and Disabled , these are the values of one of my collection > field: Status. But when I am trying to upload the document using Solr UI > documents section : Upload using JSON format with all the fields including > field with value for Status as either Terminated or Active. It is going to > only one default shard. I tried to insert _route_ field with the value as > "Terminated" and when I try to insert the document , I am getting > > *unknown field '_route_' Error from server*. Am I trying in correct way? > Does the implicit routing works on the hash value of routing field and it > does not go to the shard based on the value of the routing field? > > I want to store the document with status field value : Active to > myCollectionn_Active shard and document with status field value: Terminated > to myCollection_Terminated shard automatically based on the value of my > status field in the document. I used implicit routing while creating > collection and given shard names as Active,Terminated. Plz help. I am using > Solr 6.6 version. > > > > -- > Sent from: http://lucene.472066.n3.nabble.com/Solr-User-f472068.html
