RE: Group By and Sum

2013-03-19 Thread Adam Harris
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

Re: Group By and Sum

2013-03-18 Thread Erick Erickson
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

Re: Group By and Sum

2013-03-18 Thread Alan Woodward
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

Re: Group By and Sum

2013-03-18 Thread Walter Underwood
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

Re: Group By and Sum

2013-03-18 Thread Miguel
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

RE: Group By and Sum

2013-03-18 Thread Adam Harris
- 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

Re: Group By and Sum

2013-03-18 Thread Walter Underwood
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

Group By and Sum

2013-03-18 Thread Adam Harris
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 to me and doing even the simplest of things is just escaping me. I know SQL pretty well however this simple requirement seems escape me. I'll jump right i