Re: Division with Stats Component when Grouping in Solr

Why it isn't in core Solr... Because it doesn't (and probably can't) support distributed mode. The Streaming aggregation stuff, and the (in trunk Real Soon Now) Parallel SQL support are where the effort is going to support this kind of stuff. https://issues.apache.org/jira/browse/SOLR-7560 https:

Re: Division with Stats Component when Grouping in Solr

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

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

@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

@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

kingofhypocrites: Usually that's because your e-mail formats with html or some other non-plain-text format. Try sending them as plain text. On Sat, Jun 13, 2015 at 5:26 PM, kingofhypocrites wrote: > Not sure why but half of my posts are showing up as not accepted by the > mailing list. I've made

Re: Division with Stats Component when Grouping in Solr

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

It would be cool to be able to set 2 group by with facets >> GROUP BY >>site_id, keyword Bill Bell Sent from mobile On Jun 13, 2015, at 2:28 PM, Yonik Seeley wrote: >> GROUP BY >>site_id, keyword

Re: Division with Stats Component when Grouping in Solr

On Fri, Jun 12, 2015 at 10:30 AM, kingofhypocrites wrote: > 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 beauti

Re: Division with Stats Component when Grouping in Solr

OK. Kinda like pivoting stats... http://localhost:8983/solr/select?q=*%3A*&wt=json&indent=true&olap=true&olap.req1.fieldfacet=overall_score&facet=true&facet.field=overall_score&olap.req1.statistic.count=count(overall_score) Basically this does the same think in olap and facet. - response:

Re: Division with Stats Component when Grouping in Solr

Having a hard time getting this to work: http://localhost:8983/solr/select?q=*%3A*&wt=json&indent=true&olap=true&olap.req1.fieldfacet=overall_score and even tried... I made sure docValues was set for overall_score too. http://hgsolr2devmstr:8983/solr/survey/select?q=*%3A*&wt=json&indent=true&ol

Re: Division with Stats Component when Grouping in Solr

Not you need to enable docValues to get range stuff to work. docValues="true" on the field. On Sat, Jun 13, 2015 at 1:37 PM, William Bell wrote: > OK. That works with one more change. > > > > > > > http://localhost:8983/solr/select?q=*%3A*&wt=json&indent=true&stats=true&olap=true&olap.overal

Re: Division with Stats Component when Grouping in Solr

OK. That works with one more change. http://localhost:8983/solr/select?q=*%3A*&wt=json&indent=true&stats=true&olap=true&olap.overall_score.statistic.sum=sum(overall_score) On Sat, Jun 13, 2015 at 1:16 PM, William Bell wrote: > OK more info > > > > query > facet > an

Re: Division with Stats Component when Grouping in Solr

OK more info query facet analytics highlight debug expand I am going to try that after adding it to solrconfig.xml. On Sat, Jun 13, 2015 at 1:11 PM, William Bell wrote: > Same here. > > What do we need to add to solrconfig.xml to get it to

Re: Division with Stats Component when Grouping in Solr

Same here. What do we need to add to solrconfig.xml to get it to work? 1. SOLR-5302 2. 3. Help/ On Sat, Jun 13, 2015 at 8:34 AM, kingofhypocrites < kingofhypocri...@gmail.com> wrote: > This looks very promising if only I could get it

Re: Division with Stats Component when Grouping in Solr

This looks very promising if only I could get it to work: https://issues.apache.org/jira/browse/SOLR-5302 https://issues.apache.org/jira/secure/attachment/12606793/Search%20Analytics%20Component.pdf Various links it points to are broken now and i can't find anything about it online, but the PDF in

Re: Division with Stats Component when Grouping in Solr

: However, I need to do able to divide certain metrics. I tried including : functions in the stats.field such as div(sum(bounce_rate), (sum(visits)) but : it doesn't recognize the functions. Also it seems to ignoring the paging for : the stats results and returns all groups regardless. i'm lost o

Re: Division with Stats Component when Grouping in Solr

If you are a java programmer you may want to look at plugging in your own custom Streams into the Streaming API. The SQL stuff is built on top of the Streaming API. http://joelsolr.blogspot.com/2015/04/the-streaming-api-solrjio-basics.html Joel Bernstein http://joelsolr.blogspot.com/ On Fri, Jun

Re: Division with Stats Component when Grouping in Solr

https://issues.apache.org/jira/browse/SOLR-7560, will almost support this in Solr 5.3. The compound function support won't be there yet though. But it will be there in the near future. Joel Bernstein http://joelsolr.blogspot.com/ On Fri, Jun 12, 2015 at 9:30 AM, kingofhypocrites < kingofhypocri