Right, but for that to work, there's an implicit connection between the docs in core1 and core0, I assume provided by 123456 as a foreign key or something. There's nothing automatically built in like this in Solr 1.4 (joins come close, but those are trunk).
Whenever you try to make Solr act just like a database, you're probably doing something you shouldn't. Solr is a very good search engine, but it's not a RDBMS and shouldn't be asked to behave like one. In your case, consider de-normalizing the data and indexing all the related data in a single document, even if it means repeating the data. Sometimes this requires some judicious creativity, but it's the first thing I'd look at. Best Erick On Tue, May 15, 2012 at 10:54 AM, ravicv <ravichandra...@gmail.com> wrote: > Hi Erick , > > My Schema is as follows > > <field name="id" type="string" indexed="true" stored="true" required="true" > /> > <field name="value" type="string" indexed="true" stored="true" /> > <field name="column1" type="string" indexed="true" stored="true"/> > <field name="column2" type="string" indexed="true" stored="true" /> > > My data which i am indexing in core0 is > id:1, value:'123456', column1:'A', column2:'null' > id:2, value:'1234567895252', column1:'B', column2:'null' > > My data which i am indexing in core1 is > id:3, value:'123456', column1:'null', column2:'C' > > Now my query is > http://localhost:8983/solr/core0/select?shards=localhost:8983/solr/core0,localhost:8983/solr/core1&q=column1:"A"; > AND column2:"C" > > Response: No data > > In database we can achieve this by query querying separately > as follows > > select value from core0 where column1='A' > intersect > select value from core0 where column1='C' > > Same scenario i am trying to implement in my multi core SOLR setup. But i am > unable to do so. > Please let me know what should i do to implement this type of scenario in > SOLR. > > I am using SOLR 1.4 version. > > Thanks > Ravi > > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/Problem-with-AND-clause-in-multi-core-search-query-tp3983800p3983881.html > Sent from the Solr - User mailing list archive at Nabble.com.
