lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Emir Arnautovic <emir.arnauto...@sematext.com>
Subject Re: Select TOP 10 items from Solr Query
Date Mon, 20 Feb 2017 09:24:43 GMT
Hi Edwin,

I am also bit confused but, it seems to me that you could achieve what 
you need with pivot faceting: 
https://cwiki.apache.org/confluence/display/solr/Faceting#Faceting-Pivot(DecisionTree)Faceting

HTH,
Emir


On 18.02.2017 08:46, Zheng Lin Edwin Yeo wrote:
> Although I have nested documents in the schema, but if not looking for top
> 10 parents to facet on children.
>
> Currently, I'm only working on the information that is available in
> children. In my case, each line represents a transaction, and I'm doing the
> faceting based on these individual transaction.
>
> Regards,
> Edwin
>
>
> On 17 February 2017 at 22:10, Alexandre Rafalovitch <arafalov@gmail.com>
> wrote:
>
>> Am I missing something or do you have nested documents in the schema?
>>
>> It reads like you looking for top 10 parents and then want to facet on
>> children. Is that right?
>>
>> Regards,
>>     Alex
>>
>> On 17 Feb 2017 5:35 AM, "Zheng Lin Edwin Yeo" <edwinyeozl@gmail.com>
>> wrote:
>>
>> I'm looking at JSON facet for both of type:terms and type:range.
>>
>> For example, I may have 100 Items in my collections, and each item can have
>> many transactions. But I'm only interested to look at the top 10 items
>> which has the highest transaction rate (ie the highest count)
>>
>> I'm doing a calculation of the total amount and average amount. However, I
>> will only want the total amount and average amount to be calculated based
>> on the top 10 items which has the highest transaction rate, and not all the
>> 100 items.
>>
>> For now, I need the additional query to get the top 10 items first, before
>> I run the JSON Facet to get the total amount and average amount for that 10
>> items.
>>
>> Regards,
>> Edwin
>>
>>
>> On 17 February 2017 at 18:02, alessandro.benedetti <a.benedetti@sease.io>
>> wrote:
>>
>>> I think we are missing something here ...
>>> You want to fetch the top 10 results for your query, and allow the user
>> to
>>> navigate only those 10 results through facets ?
>>>
>>> Which facets are you interested in ?
>>> Field facets ?
>>> Whatever facet you want, calculating it in your client, on 10 results
>>> shouldn't be that problematic.
>>> Are we missing something ? Why you would need an additional query ?
>>>
>>> Cheers
>>>
>>>
>>>
>>> -----
>>> ---------------
>>> Alessandro Benedetti
>>> Search Consultant, R&D Software Engineer, Director
>>> Sease Ltd. - www.sease.io
>>> --
>>> View this message in context: http://lucene.472066.n3.
>>> nabble.com/Select-TOP-10-items-from-Solr-Query-tp4320863p4320910.html
>>> Sent from the Solr - User mailing list archive at Nabble.com.
>>>

-- 
Monitoring * Alerting * Anomaly Detection * Centralized Log Management
Solr & Elasticsearch Support * http://sematext.com/


Mime
View raw message