lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From VJ <jain02...@gmail.com>
Subject Re: distinct records based on a field
Date Wed, 05 Apr 2017 13:11:22 GMT
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