DateDiff

2013-11-05 Thread Adam Harris
Hey All, Using solr I want to get the difference between two dates, is this possible? Something similar to SELECT DateDiff(d, GetDate(), date_Field) as Diff FROM MyTable

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

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-19 Thread Adam Harris
> Make sure you use Solr 4.2 for this, by the way, as it's massively > faster > - I've found stats queries over ~500,000 documents dropping from 60 > seconds to 2 seconds with an upgrade from 4.0 to 4.2. > > Alan Woodward > www.flax.co.uk > > > On 18 Mar 2013