In Solr 6 you can do a sql SELECT DISTINCT ... query as well. Joel Bernstein http://joelsolr.blogspot.com/
On Wed, Apr 5, 2017 at 9:11 AM, VJ <jain02...@gmail.com> wrote: > My document schema has fields like: > A,B,C > I am querying for documents with A="XYZ", suppose it returns 5 records > A B C > XYZ Foo cat1 > XYZ Foo cat2 > XYZ Bar cat1 > XYZ Bar cat1 > XYZ Bar cat2 > > out of those 10 records there may be duplicate values for B and then I am > faceting it on C, > So I get something like > Cat1:3 (Foo,Bar,Bar) > Cat2:2 (Foo,Bar) > > but I want the output as > Cat1:2 (Foo,Bar) > Cat2:2 (Foo,Bar) > > Is it possible to achieve the desired output with solr query? > > > Thanks, > VJ > > On Wed, Apr 5, 2017 at 6:26 PM, Emir Arnautovic < > emir.arnauto...@sematext.com> wrote: > > > Hi VJ, > > > > You can use field collapsing feature to do distinct ( > > https://cwiki.apache.org/confluence/display/solr/Result+Grouping) or > > maybe you can use facet pivoting and pivot on distinct field to get > number > > of doc in each if needed (https://cwiki.apache.org/conf > > luence/display/solr/Faceting#Faceting-Pivot(DecisionTree)Faceting). > > > > You might also want to explore JSON facet API. > > > > HTH, > > Emir > > > > > > > > On 05.04.2017 13:08, VJ wrote: > > > >> Hi, > >> > >> > >> Is there any way to pass only distinct records (based on a field) out > of a > >> solr query? > >> I want to facet the records based on a field but want to restrict the > >> results to distinct records before applying the facet. > >> > >> > >> > >> Thanks, > >> VJ > >> > >> > > -- > > Monitoring * Alerting * Anomaly Detection * Centralized Log Management > > Solr & Elasticsearch Support * http://sematext.com/ > > > > >
