realizes this.
All - Thank you all for your help and suggestions. It's greatly appreciated.
Thanks,
Adam
-Original Message-
From: Erick Erickson [mailto:erickerick...@gmail.com]
Sent: Monday, March 18, 2013 8:56 PM
To: solr-user@lucene.apache.org
Subject: Re: Group By and Sum
S
Second Walter's comment. Make really, _really_ sure that "the powers that
be" recognize that they're asking for something unreasonable and it'll cost
them dearly to get it.
Best
Erick
On Mon, Mar 18, 2013 at 12:04 PM, Alan Woodward wrote:
> Hi Adam,
>
> Have a look at the stats component:
> ht
Hi Adam,
Have a look at the stats component: http://wiki.apache.org/solr/StatsComponent.
In your case, I think you'd need to add an extra field for your month, and
then run a query filtered by your date range with stats.field=NetSales,
stats.field=TransCount, and stats.facet=month.
Make sure
d love to just keep using the SQL DB that we have been using but
> alas I am not allowed to.
>
> Thanks,
> Adam
>
> -Original Message-
> From: Walter Underwood [mailto:wun...@wunderwood.org]
> Sent: Monday, March 18, 2013 11:58 AM
> To: solr-user@lucene.apache
Hi Adam
Have you seen wiki about field collapsing?
http://wiki.apache.org/solr/FieldCollapsing
I think that this page help you to emule group by.
El 18/03/2013 17:48, Adam Harris escribió:
Hello All,
Pretty stuck here and I am hoping you might be the person to help me out. I am
working
-
From: Walter Underwood [mailto:wun...@wunderwood.org]
Sent: Monday, March 18, 2013 11:58 AM
To: solr-user@lucene.apache.org
Subject: Re: Group By and Sum
You should use a relational database. Solr is not really designed for this kind
of query.
wunder
On Mar 18, 2013, at 9:48 AM, Adam Harris
You should use a relational database. Solr is not really designed for this kind
of query.
wunder
On Mar 18, 2013, at 9:48 AM, Adam Harris wrote:
> Hello All,
>
> Pretty stuck here and I am hoping you might be the person to help me out. I
> am working with SOLR and JSONiq which are totally new
