lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Joel Bernstein <joels...@gmail.com>
Subject Re: distinct records based on a field
Date Wed, 05 Apr 2017 13:35:42 GMT
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 <jain02hcl@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.arnautovic@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/
> >
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message