Same here. What do we need to add to solrconfig.xml to get it to work?
1. SOLR-5302 <https://issues.apache.org/jira/browse/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 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 indicates I can set olap=true to turn it on, > although this doesn't seem to do anything. The docs say it supports > limiting the results and doing math operations on statistics which is > exactly what I need. I'm not clear if I need to install this or if this > component is even used anymore. > > On Fri, Jun 12, 2015 at 12:00 PM Joel Bernstein [via Lucene] < > ml-node+s472066n4211422...@n3.nabble.com> wrote: > > > 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 < > > [hidden email] <http:///user/SendEmail.jtp?type=node&node=4211422&i=0>> > > 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 beautifully until I need to do stats on groups. I am > > hoping > > > to get this to work with Solr so I can stick to one database, but I am > > not > > > sure it's possible. > > > > > > If I had it in SQL Server, I could do it like so: > > > SELECT > > > site_id, > > > keyword, > > > SUM(visits) as visits, > > > CONVERT(DECIMAL(13, 3), SUM(bounces)) / SUM(visits) as bounce_rate, > > > SUM(pageviews) as pageviews, > > > CONVERT(DECIMAL(13, 3), SUM(pageviews)) / SUM(visits) as > > > avg_pages_per_visit > > > FROM > > > report_all_keywords_daily > > > WHERE > > > site_id = 55 AND date_key >= '20150606' AND date_key <= '20150608' > > > GROUP BY > > > site_id, keyword > > > ORDER BY visits DESC > > > > > > Now I need to replicate this in Solr. The closest I could get to this > is > > by > > > using the Stats component and then using field collapsing. > > > > > > > > > group=true&group.field=keyword&stats=true&stats.field=visits&stats.facet=keyword > > > > > > > > And here are some results I get back: > > > http://pastebin.com/raw.php?i=Fxhe2RA0 > > > > > > 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. > > > > > > Ultimately I'd like something like this which is what I would get in > > SQL: > > > <http://lucene.472066.n3.nabble.com/file/n4211402/pic.png> > > > > > > Is this possible or do I have to give up on the prospect of using Solr? > > I > > > have to query this data dynamically so I can't pre-summarize all of it. > > > > > > To clarify I having the following two problems: > > > - Paging is ignored for stats data > > > - I can't figure out how to divide two stats together to get a third > > stat. > > > Note: In some cases I would need to be able to sort on this combined > > stat > > > > > > > > > > > > -- > > > View this message in context: > > > > > > http://lucene.472066.n3.nabble.com/Division-with-Stats-Component-when-Grouping-in-Solr-tp4211402.html > > > Sent from the Solr - User mailing list archive at Nabble.com. > > > > > > > > > ------------------------------ > > If you reply to this email, your message will be added to the discussion > > below: > > > > > http://lucene.472066.n3.nabble.com/Division-with-Stats-Component-when-Grouping-in-Solr-tp4211402p4211422.html > > To unsubscribe from Division with Stats Component when Grouping in > Solr, click > > here > > < > http://lucene.472066.n3.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4211402&code=a2luZ29maHlwb2NyaXRlc0BnbWFpbC5jb218NDIxMTQwMnwtNDY4MDgyMzk1 > > > > . > > NAML > > < > http://lucene.472066.n3.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml > > > > > > > > > -- > View this message in context: > http://lucene.472066.n3.nabble.com/Division-with-Stats-Component-when-Grouping-in-Solr-tp4211402p4211525.html > Sent from the Solr - User mailing list archive at Nabble.com. > -- Bill Bell billnb...@gmail.com cell 720-256-8076
