Solr usage reports

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
6 messages Options
Reply | Threaded
Open this post in threaded view
|

Solr usage reports

Becky Bonner
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

Reply | Threaded
Open this post in threaded view
|

Re: Solr usage reports

Upayavira
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
>
Reply | Threaded
Open this post in threaded view
|

RE: Solr usage reports

Becky Bonner
Thank you I reposted it on the user list - appreciate your help!


-----Original Message-----
From: Upayavira [mailto:[hidden email]]
Sent: Thursday, January 25, 2018 10:56 AM
To: [hidden email]
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
>
Reply | Threaded
Open this post in threaded view
|

Re: Solr usage reports

Erik Hatcher-4
In reply to this post by Upayavira
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 <[hidden email]> 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
>>
Reply | Threaded
Open this post in threaded view
|

Re: Solr usage reports

Charlie Hull-3
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" <[hidden email]> 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 <[hidden email]> 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
> >>
>
Reply | Threaded
Open this post in threaded view
|

RE: Solr usage reports

Becky Bonner
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:[hidden email]]
Sent: Thursday, January 25, 2018 12:58 PM
To: [hidden email]
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" <[hidden email]> 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 <[hidden email]> 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
> >>
>