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.
-
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
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
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:
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
kingofhypocri...@gmail.com wrote:
Not sure why but half of my posts are showing up as not accepted by the
@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
@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
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
OK more info
requestHandler name=standard class=solr.StandardRequestHandler
arr name=components
strquery/str
strfacet/str
stranalytics/str
strhighlight/str
strdebug/str
strexpand/str
/arr
/requestHandler
searchComponent name=analytics
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 billnb...@gmail.com wrote:
OK. That works with one more change.
lib dir=../../../dist/ regex=solr-analytics-.*\.jar /
lib dir=../../../dist/
OK. Kinda like pivoting stats...
http://localhost:8983/solr/select?q=*%3A*wt=jsonindent=trueolap=trueolap.req1.fieldfacet=overall_scorefacet=truefacet.field=overall_scoreolap.req1.statistic.count=count(overall_score)
Basically this does the same think in olap and facet.
- response:
{
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
OK. That works with one more change.
lib dir=../../../dist/ regex=solr-analytics-.*\.jar /
lib dir=../../../dist/ regex=solr-analysis-.*\.jar /
http://localhost:8983/solr/select?q=*%3A*wt=jsonindent=truestats=trueolap=trueolap.overall_score.statistic.sum=sum(overall_score)
On Sat, Jun 13,
Having a hard time getting this to work:
http://localhost:8983/solr/select?q=*%3A*wt=jsonindent=trueolap=trueolap.req1.fieldfacet=overall_score
and even tried... I made sure docValues was set for overall_score too.
On Fri, Jun 12, 2015 at 10:30 AM, kingofhypocrites
kingofhypocri...@gmail.com 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
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 ysee...@gmail.com wrote:
GROUP BY
site_id, keyword
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
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,
: 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
19 matches
Mail list logo