Re: Problem with AND clause in multi core search query

2012-05-16 Thread ravicv
Hi Eric, So for this scenario i wrote a custom request handler and get individual results from each core and then i am applying *AND * clause up on the results. Please let me know whether this approach will cause any other disturbances/Issues later? Or can you suggest me some other approach?

Re: Problem with AND clause in multi core search query

2012-05-15 Thread Erick Erickson
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 l

Re: Problem with AND clause in multi core search query

2012-05-15 Thread ravicv
Hi Erick , My Schema is as follows 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', colum

Re: Problem with AND clause in multi core search query

2012-05-15 Thread Erick Erickson
I really don't understand what you're trying to achieve. "query : column1:"A" should searched in core0 and column2:"B" should be searched in core1 and later the results from both queries should use condition AND and give final response.?" core1 and core0 are completely separate cores, with separa

Re: Problem with AND clause in multi core search query

2012-05-15 Thread ravicv
Thanks Tommaso . Could you please tell me is their any way to get this scenario to get worked? http://localhost:8983/solr/core0/select?shards=localhost:8983/solr/core0,localhost:8983/solr/core1&q=column1:"A"; AND column2:"B" Is their any way we can achieve this below scenario query : column1:

Re: Problem with AND clause in multi core search query

2012-05-14 Thread Tommaso Teofili
The latter is supposed to work: http://localhost:8983/solr/core0/select?shards=localhost:8983/solr/core0,localhost:8983/solr/core1&q=column1 :"A" OR column2:"B" The first query cannot work as there is no document neither in core0 nor in core1 which has A in field column1 and B in field column2 but