lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Allison, Timothy B." <talli...@mitre.org>
Subject RE: find stores with sales of > $x in last 2 months ?
Date Mon, 06 Jun 2016 12:45:14 GMT
Thank you, Alex.

> Sorry, your question a bit confusing.
Y. Sorry.

> Also, is this last month as in 'January' (rolling monthly) or as in 'last 30 days'
(rolling daily).

Ideally, the latter, if this is possible to calculate dynamically in response to a query.
 My backoff method (if the 'rolling daily' method isn't possible), would be to index monthly
stats and then just use the range query as you suggested.

-----Original Message-----
From: Alexandre Rafalovitch [mailto:arafalov@gmail.com] 
Sent: Sunday, June 5, 2016 12:52 AM
To: solr-user <solr-user@lucene.apache.org>
Subject: Re: find stores with sales of > $x in last 2 months ?

Are you asking for just numerical comparison during search or about a way to aggregate numbers
from multiple records? Also, is this last month as in 'January' (rolling monthly) or as in
'last 30 days'
(rolling daily). Sorry, your question a bit confusing.

Numerical comparison is just a range (numField:[x TO *])  as per

https://cwiki.apache.org/confluence/display/solr/The+Standard+Query+Parser#TheStandardQueryParser-RangeSearches

https://cwiki.apache.org/confluence/display/solr/The+Standard+Query+Parser#TheStandardQueryParser-DifferencesbetweenLuceneQueryParserandtheSolrStandardQueryParser

Regards,
   Alex.
----
Newsletter and resources for Solr beginners and intermediates:
http://www.solr-start.com/


On 3 June 2016 at 23:23, Allison, Timothy B. <tallison@mitre.org> wrote:
> All,
>   This is a toy example, but is there a way to search for, say, stores with sales of
> $x in the last 2 months with Solr?
>   $x and the time frame are selected by the user at query time.
>
> If the queries could be constrained (this is still tbd), I could see updating "stats"
fields within each store document on a daily basis (sales_last_1_month, sales_last_2_months,
sales_last_3_months...etc).  The dataset is fairly small and daily updates of this nature
would not be prohibitive.
>
>    Or, is this trying to use a screw driver where a hammer is required?
>
>        Thank you.
>
>                Best,
>
>                      Tim
Mime
View raw message