Re: How Solr join query works?
Hello, Did you consider using CollapsingQueryParser or FieldCollapsing? http://wiki.apache.org/solr/FieldCollapsing https://cwiki.apache.org/confluence/display/solr/Other+Parsers#OtherParsers-CollapsingQueryParser Ahmet On Monday, January 13, 2014 4:56 AM, solr2020 psgoms...@gmail.com wrote: Hi All, Can anyone please explain how solr join query works in solr4.2. we have 2 different documents.Both are in the same index. document1 contains the columns: docdate: 01-12-2012 previousmonthdate :01-11-2012 price:15 and some more fields. document2 contains: docdate :01-11-2012 previousmonthdate :01-10-2012 price:10 and some more fields. Here we have the same value in previousmonthdate (in document1) and docdate (in document2).So we want to make a join query based on this to retrieve these in a single document. the final document should look like this. docdate: 01-12-2012 previousmonthdate :01-11-2012 price:15 price:10(this is from document2) Is is possible using Solr join query??? Or do we have any other approach?. Please help.. Thanks. -- View this message in context: http://lucene.472066.n3.nabble.com/How-Solr-join-query-works-tp4110982.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: How Solr join query works?
It's called pseudo join for a reason. It's not built to do what you want. There's no way to combine fields in the from and to clauses in the output. The from clause can be thought of as a filter. The first choice is usually to denormalize the data if possible. Best, Erick On Sun, Jan 12, 2014 at 9:55 PM, solr2020 psgoms...@gmail.com wrote: Hi All, Can anyone please explain how solr join query works in solr4.2. we have 2 different documents.Both are in the same index. document1 contains the columns: docdate: 01-12-2012 previousmonthdate :01-11-2012 price:15 and some more fields. document2 contains: docdate :01-11-2012 previousmonthdate :01-10-2012 price:10 and some more fields. Here we have the same value in previousmonthdate (in document1) and docdate (in document2).So we want to make a join query based on this to retrieve these in a single document. the final document should look like this. docdate: 01-12-2012 previousmonthdate :01-11-2012 price:15 price:10(this is from document2) Is is possible using Solr join query??? Or do we have any other approach?. Please help.. Thanks. -- View this message in context: http://lucene.472066.n3.nabble.com/How-Solr-join-query-works-tp4110982.html Sent from the Solr - User mailing list archive at Nabble.com.