Re: Solr 6: Use facet with Streaming Expressions- LeftOuterJoin
Thanks again ! I will try this and followup. -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-6-Use-facet-with-Streaming-Expressions-LeftOuterJoin-tp4290526p4292341.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Solr 6: Use facet with Streaming Expressions- LeftOuterJoin
Ah, the documentation is not clear on this. We need to fix that. The rollup() function supports multi-dimension aggregations like the facet expression. You just provide a comma delimited list of fields in the over parameter: over="a,b,c" You will need to sort the underlying stream by those fields well. sort="a asc, b asc, c asc" Joel Bernstein http://joelsolr.blogspot.com/ On Thu, Aug 18, 2016 at 5:42 AM, vrindavda <vrinda...@gmail.com> wrote: > I am not able to get count(*) for more than one field > > > > -- > View this message in context: http://lucene.472066.n3. > nabble.com/Solr-6-Use-facet-with-Streaming-Expressions-LeftOuterJoin- > tp4290526p4292208.html > Sent from the Solr - User mailing list archive at Nabble.com. >
Re: Solr 6: Use facet with Streaming Expressions- LeftOuterJoin
I am not able to get count(*) for more than one field -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-6-Use-facet-with-Streaming-Expressions-LeftOuterJoin-tp4290526p4292208.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Solr 6: Use facet with Streaming Expressions- LeftOuterJoin
What issue were you having with the rollup() function? Joel Bernstein http://joelsolr.blogspot.com/ On Fri, Aug 12, 2016 at 5:01 AM, vrindavda <vrinda...@gmail.com> wrote: > Hey Joel, > > Thanks for you quick response, I was able to merge documents using > OutherHashJoin. But I am not able to use rollup() to get count(*) for > multiple fields, as we get using facets. > > Please suggest if last option is to merge documents using atomic updates, > and then use facets(or json.facet). Is there any other way to merge > documents permanently ? > > Thank you, > Vrinda Davda > > > > -- > View this message in context: http://lucene.472066.n3. > nabble.com/Solr-6-Use-facet-with-Streaming-Expressions-LeftOuterJoin- > tp4290526p4291397.html > Sent from the Solr - User mailing list archive at Nabble.com. >
Re: Solr 6: Use facet with Streaming Expressions- LeftOuterJoin
Hey Joel, Thanks for you quick response, I was able to merge documents using OutherHashJoin. But I am not able to use rollup() to get count(*) for multiple fields, as we get using facets. Please suggest if last option is to merge documents using atomic updates, and then use facets(or json.facet). Is there any other way to merge documents permanently ? Thank you, Vrinda Davda -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-6-Use-facet-with-Streaming-Expressions-LeftOuterJoin-tp4290526p4291397.html Sent from the Solr - User mailing list archive at Nabble.com.
Re: Solr 6: Use facet with Streaming Expressions- LeftOuterJoin
If you need to aggregate after the join then you'll need to use the rollup() function. The rollup function requires the tuples be sorted by the group by fields. So it's easiest to accomplish this using the hashOuterJoin, which doesn't require a sort on the join keys. If you're doing a parallel join, you'll need to wrap the rollup() around the parallel() function unless the partionKeys for the join are the same as the rollup group by. Here is the psuedo code for a non-parallel join then rollup: rollup(hashOuterJoin(search(), search())) Here is the psuedo code for parallel join then rollup: rollup(parallel(outerHashJoin(search(),search()) In both cases the searches should be sorted by the rollup() group by fields. In the parallel case, the partitionKeys need to be the join keys. Joel Bernstein http://joelsolr.blogspot.com/ On Fri, Aug 5, 2016 at 7:21 AM, vrindavda <vrinda...@gmail.com> wrote: > Hello, > I have two collections and need to join the results on uniqueIds. > > I am able to do that with Streaming Expressions- LeftOuterJoin. Is there > any > way to use facets along with this? > > > > > > -- > View this message in context: http://lucene.472066.n3. > nabble.com/Solr-6-Use-facet-with-Streaming-Expressions- > LeftOuterJoin-tp4290526.html > Sent from the Solr - User mailing list archive at Nabble.com. >
Solr 6: Use facet with Streaming Expressions- LeftOuterJoin
Hello, I have two collections and need to join the results on uniqueIds. I am able to do that with Streaming Expressions- LeftOuterJoin. Is there any way to use facets along with this? -- View this message in context: http://lucene.472066.n3.nabble.com/Solr-6-Use-facet-with-Streaming-Expressions-LeftOuterJoin-tp4290526.html Sent from the Solr - User mailing list archive at Nabble.com.
