Re: Division with Stats Component when Grouping in Solr

2015-06-14 Thread kingofhypocrites
I think I have this about working with the analytics component. It seems to fill in all the gaps that the stats component and the json facet don't support. It solved the following problems for me: - I am able to perform math on stats to form other stats.. Then i can sort on those as needed. - When

Re: Division with Stats Component when Grouping in Solr

2015-06-13 Thread kingofhypocrites
I was able to get the new version of Solr installed. This query gets me really close, but it is averaging the rows BEFORE the grouping so it's not totally accurate. I need it to sum the visits and bounces by keyword and then perform the division. The avg here probably seems confusing and pointless,

Re: Division with Stats Component when Grouping in Solr

2015-06-13 Thread kingofhypocrites
@Billnbell What did you conclude with the Analytics component? It sounds like you are saying it does the same thing as the stats component but it has several other features that aren't supported by the stats library. I'd love to have a talk with you offline if possible. -- View this message in c

Re: Division with Stats Component when Grouping in Solr

2015-06-13 Thread kingofhypocrites
@Yonik, Thanks for this! I was actually just looking at your blog earlier today and thinking that the json facet feature may be just what I need. I'm using Solr. 4.3 currently as that is what comes with DataStax, so I'm trying to create a new build with the latest Solr version so i can test this f

Re: Division with Stats Component when Grouping in Solr

2015-06-13 Thread kingofhypocrites
Not sure why but half of my posts are showing up as not accepted by the mailing list. I've made a few replies to others that haven't gone through. I am not sure if it's because I'm replying via email or what the issue is. -- View this message in context: http://lucene.472066.n3.nabble.com/Divis

Re: Division with Stats Component when Grouping in Solr

2015-06-13 Thread kingofhypocrites
it will be there in the near future. > > > > Joel Bernstein > http://joelsolr.blogspot.com/ > > On Fri, Jun 12, 2015 at 9:30 AM, kingofhypocrites < > [hidden email] <http:///user/SendEmail.jtp?type=node&node=4211422&i=0>> > wrote: > > > I am m

Division with Stats Component when Grouping in Solr

2015-06-12 Thread kingofhypocrites
I am migrating a database from SQL Server to Cassandra. Currently I have a setup as follows: - Log data in Cassandra - Summarize data in Spark and put into Cassandra summary tables - Query data in Solr Everything fits beautifully until I need to do stats on groups. I am hoping to get this to work