Mailing List Archive

Solr usage reports
Hi all,
We are in the process of replacing our Google Search Appliance with SOLR 7.1 and are needing one last piece of our requirements. We provide a monthly report to our business that shows the top 1000 query terms requested during the date range as well as the query terms requested that contained no results. Is there a way to log the requests and later query solr for these results? Or is there a plugin to add this functionality?

Your help appreciated.
Bcubed
Re: Solr usage reports [ In reply to ]
You should be asking on the solr-user list - you'd get more answers there and it is more relevant.

You can mine search terms from your log files, but that is likely a bit fraught. Better is just to record the search terms in a database or such before you call Solr - i.e. don't use Solr to record them.

Upayavira

On Thu, 25 Jan 2018, at 4:19 PM, Becky Bonner wrote:
> Hi all,
> We are in the process of replacing our Google Search Appliance with SOLR
> 7.1 and are needing one last piece of our requirements. We provide a
> monthly report to our business that shows the top 1000 query terms
> requested during the date range as well as the query terms requested
> that contained no results. Is there a way to log the requests and later
> query solr for these results? Or is there a plugin to add this
> functionality?
>
> Your help appreciated.
> Bcubed
>
RE: Solr usage reports [ In reply to ]
Thank you I reposted it on the user list - appreciate your help!


-----Original Message-----
From: Upayavira [mailto:uv@odoko.co.uk]
Sent: Thursday, January 25, 2018 10:56 AM
To: general@lucene.apache.org
Subject: Re: Solr usage reports

You should be asking on the solr-user list - you'd get more answers there and it is more relevant.

You can mine search terms from your log files, but that is likely a bit fraught. Better is just to record the search terms in a database or such before you call Solr - i.e. don't use Solr to record them.

Upayavira

On Thu, 25 Jan 2018, at 4:19 PM, Becky Bonner wrote:
> Hi all,
> We are in the process of replacing our Google Search Appliance with
> SOLR
> 7.1 and are needing one last piece of our requirements. We provide a
> monthly report to our business that shows the top 1000 query terms
> requested during the date range as well as the query terms requested
> that contained no results. Is there a way to log the requests and
> later query solr for these results? Or is there a plugin to add this
> functionality?
>
> Your help appreciated.
> Bcubed
>
Re: Solr usage reports [ In reply to ]
I respectfully beg to differ Upayavira :)

Recording Solr queries into another Solr collection is a powerful technique. It’s how I would recommend doing it. It’s also how our (commercial plug) Lucidworks Fusion platform does it to great benefit for mining for recommendations, analytics, and visualizations.

Erik

> On Jan 25, 2018, at 11:56, Upayavira <uv@odoko.co.uk> wrote:
>
> You should be asking on the solr-user list - you'd get more answers there and it is more relevant.
>
> You can mine search terms from your log files, but that is likely a bit fraught. Better is just to record the search terms in a database or such before you call Solr - i.e. don't use Solr to record them.
>
> Upayavira
>
>> On Thu, 25 Jan 2018, at 4:19 PM, Becky Bonner wrote:
>> Hi all,
>> We are in the process of replacing our Google Search Appliance with SOLR
>> 7.1 and are needing one last piece of our requirements. We provide a
>> monthly report to our business that shows the top 1000 query terms
>> requested during the date range as well as the query terms requested
>> that contained no results. Is there a way to log the requests and later
>> query solr for these results? Or is there a plugin to add this
>> functionality?
>>
>> Your help appreciated.
>> Bcubed
>>
Re: Solr usage reports [ In reply to ]
The guys at OSC have recently done exactly this
http://opensourceconnections.com/blog/2018/01/12/roll-your-own-analytics

Cheers

Charlie
___
Charlie Hull

On 25 Jan 2018 6:17 p.m., "Erik Hatcher" <erik.hatcher@gmail.com> wrote:

> I respectfully beg to differ Upayavira :)
>
> Recording Solr queries into another Solr collection is a powerful
> technique. It’s how I would recommend doing it. It’s also how our
> (commercial plug) Lucidworks Fusion platform does it to great benefit for
> mining for recommendations, analytics, and visualizations.
>
> Erik
>
> > On Jan 25, 2018, at 11:56, Upayavira <uv@odoko.co.uk> wrote:
> >
> > You should be asking on the solr-user list - you'd get more answers
> there and it is more relevant.
> >
> > You can mine search terms from your log files, but that is likely a bit
> fraught. Better is just to record the search terms in a database or such
> before you call Solr - i.e. don't use Solr to record them.
> >
> > Upayavira
> >
> >> On Thu, 25 Jan 2018, at 4:19 PM, Becky Bonner wrote:
> >> Hi all,
> >> We are in the process of replacing our Google Search Appliance with SOLR
> >> 7.1 and are needing one last piece of our requirements. We provide a
> >> monthly report to our business that shows the top 1000 query terms
> >> requested during the date range as well as the query terms requested
> >> that contained no results. Is there a way to log the requests and later
> >> query solr for these results? Or is there a plugin to add this
> >> functionality?
> >>
> >> Your help appreciated.
> >> Bcubed
> >>
>
RE: Solr usage reports [ In reply to ]
This looks awesome. I had already started writing the code to add the data to a solr collection. Zeppelin looks amazing to process the data! Exciting to try that out! Thank you !!!

-----Original Message-----
From: Charlie Hull [mailto:charlie@flax.co.uk]
Sent: Thursday, January 25, 2018 12:58 PM
To: general@lucene.apache.org
Subject: Re: Solr usage reports

The guys at OSC have recently done exactly this http://opensourceconnections.com/blog/2018/01/12/roll-your-own-analytics

Cheers

Charlie
___
Charlie Hull

On 25 Jan 2018 6:17 p.m., "Erik Hatcher" <erik.hatcher@gmail.com> wrote:

> I respectfully beg to differ Upayavira :)
>
> Recording Solr queries into another Solr collection is a powerful
> technique. It’s how I would recommend doing it. It’s also how our
> (commercial plug) Lucidworks Fusion platform does it to great benefit
> for mining for recommendations, analytics, and visualizations.
>
> Erik
>
> > On Jan 25, 2018, at 11:56, Upayavira <uv@odoko.co.uk> wrote:
> >
> > You should be asking on the solr-user list - you'd get more answers
> there and it is more relevant.
> >
> > You can mine search terms from your log files, but that is likely a
> > bit
> fraught. Better is just to record the search terms in a database or
> such before you call Solr - i.e. don't use Solr to record them.
> >
> > Upayavira
> >
> >> On Thu, 25 Jan 2018, at 4:19 PM, Becky Bonner wrote:
> >> Hi all,
> >> We are in the process of replacing our Google Search Appliance with
> >> SOLR
> >> 7.1 and are needing one last piece of our requirements. We provide
> >> a monthly report to our business that shows the top 1000 query
> >> terms requested during the date range as well as the query terms
> >> requested that contained no results. Is there a way to log the
> >> requests and later query solr for these results? Or is there a
> >> plugin to add this functionality?
> >>
> >> Your help appreciated.
> >> Bcubed
> >>
>