You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by Jason Toy <ja...@gmail.com> on 2011/10/24 21:31:54 UTC
joins and filter queries effecting scoring
I have 2 types of docs, users and posts.
I want to view all the docs that belong to certain users by joining posts
and users together. I have to filter the users with a filter query of
"is_active_boolean:true" so that the score is not effected,but since I do a
join, I have to move the filter query to the query parameter so that I can
get the filter applied. The problem is that since the is_active_boolean is
moved to the query, the score is affected which returns back an order that I
don't want.
If I leave the is_active_boolean:true in the fq paramater, I get no
results back.
My question is how can I apply a filter query to users so that the score is
not effected?
Re: joins and filter queries effecting scoring
Posted by Jason Toy <ja...@gmail.com>.
Martijn,
I'm just seeing this reply today, please excuse the late reply.
I tried your suggestion, it I do get results back, but I get back a list of Users when I instead am trying to get back a list of Posts.
Is it not possible to arbitrarily sort by either side of the join in solr?
> Have your tried using the join in the fq instead of the q?
> Like this (assuming user_id_i is a field in the post document type and
> self_id_i a field in the user document type):
> q=posts_text:"hello"&fq={!join from=self_id_i
> to=user_id_i}is_active_boolean:true
>
> In this example the fq produces a docset that contains all user
> documents that are active. This docset is used as filter during the
> execution of the main query (q param),
> so it only returns posts with the contain the text hello for active users.
>
> Martijn
>
> On 28 October 2011 01:57, Jason Toy <ja...@gmail.com> wrote:
>> Does anyone have any idea on this issue?
>>
>> On Tue, Oct 25, 2011 at 11:40 AM, Jason Toy <ja...@gmail.com> wrote:
>>
>>> Hi Yonik,
>>>
>>> Without a Join I would normally query user docs with:
>>> q=data_text:"test"&fq=is_active_boolean:true
>>>
>>> With joining users with posts, I get no no results:
>>> q={!join from=self_id_i
>>> to=user_id_i}data_text:"test"&fq=is_active_boolean:true&fq=posts_text:"hello"
>>>
>>>
>>>
>>> I am able to use this query, but it gives me the results in an order that I
>>> dont want(nor do I understand its order):
>>> q={!join from=self_id_i to=user_id_i}data_text:"test" AND
>>> is_active_boolean:true&fq=posts_text:"hello"
>>>
>>> I want the order to be the same as I would get from my original
>>> "q=data_text:"test"&fq=is_active_boolean:true", but with the ability to join
>>> with the Posts docs.
>>>
>>>
>>>
>>>
>>>
>>> On Tue, Oct 25, 2011 at 11:30 AM, Yonik Seeley <yonik@lucidimagination.com
>>>> wrote:
>>>
>>>> Can you give an example of the request (URL) you are sending to Solr?
>>>>
>>>> -Yonik
>>>> http://www.lucidimagination.com
>>>>
>>>>
>>>>
>>>> On Mon, Oct 24, 2011 at 3:31 PM, Jason Toy <ja...@gmail.com> wrote:
>>>>> I have 2 types of docs, users and posts.
>>>>> I want to view all the docs that belong to certain users by joining
>>>> posts
>>>>> and users together. I have to filter the users with a filter query of
>>>>> "is_active_boolean:true" so that the score is not effected,but since I
>>>> do a
>>>>> join, I have to move the filter query to the query parameter so that I
>>>> can
>>>>> get the filter applied. The problem is that since the is_active_boolean
>>>> is
>>>>> moved to the query, the score is affected which returns back an order
>>>> that I
>>>>> don't want.
>>>>> If I leave the is_active_boolean:true in the fq paramater, I get no
>>>>> results back.
>>>>>
>>>>> My question is how can I apply a filter query to users so that the score
>>>> is
>>>>> not effected?
>>>>>
>>>>
>>>
>>>
>>>
>>> --
>>> - sent from my mobile
>>>
>>>
>>>
>>
>>
>> --
>> - sent from my mobile
>>
>
>
>
> --
> Met vriendelijke groet,
>
> Martijn van Groningen
Re: joins and filter queries effecting scoring
Posted by Martijn v Groningen <ma...@gmail.com>.
Have your tried using the join in the fq instead of the q?
Like this (assuming user_id_i is a field in the post document type and
self_id_i a field in the user document type):
q=posts_text:"hello"&fq={!join from=self_id_i
to=user_id_i}is_active_boolean:true
In this example the fq produces a docset that contains all user
documents that are active. This docset is used as filter during the
execution of the main query (q param),
so it only returns posts with the contain the text hello for active users.
Martijn
On 28 October 2011 01:57, Jason Toy <ja...@gmail.com> wrote:
> Does anyone have any idea on this issue?
>
> On Tue, Oct 25, 2011 at 11:40 AM, Jason Toy <ja...@gmail.com> wrote:
>
>> Hi Yonik,
>>
>> Without a Join I would normally query user docs with:
>> q=data_text:"test"&fq=is_active_boolean:true
>>
>> With joining users with posts, I get no no results:
>> q={!join from=self_id_i
>> to=user_id_i}data_text:"test"&fq=is_active_boolean:true&fq=posts_text:"hello"
>>
>>
>>
>> I am able to use this query, but it gives me the results in an order that I
>> dont want(nor do I understand its order):
>> q={!join from=self_id_i to=user_id_i}data_text:"test" AND
>> is_active_boolean:true&fq=posts_text:"hello"
>>
>> I want the order to be the same as I would get from my original
>> "q=data_text:"test"&fq=is_active_boolean:true", but with the ability to join
>> with the Posts docs.
>>
>>
>>
>>
>>
>> On Tue, Oct 25, 2011 at 11:30 AM, Yonik Seeley <yonik@lucidimagination.com
>> > wrote:
>>
>>> Can you give an example of the request (URL) you are sending to Solr?
>>>
>>> -Yonik
>>> http://www.lucidimagination.com
>>>
>>>
>>>
>>> On Mon, Oct 24, 2011 at 3:31 PM, Jason Toy <ja...@gmail.com> wrote:
>>> > I have 2 types of docs, users and posts.
>>> > I want to view all the docs that belong to certain users by joining
>>> posts
>>> > and users together. I have to filter the users with a filter query of
>>> > "is_active_boolean:true" so that the score is not effected,but since I
>>> do a
>>> > join, I have to move the filter query to the query parameter so that I
>>> can
>>> > get the filter applied. The problem is that since the is_active_boolean
>>> is
>>> > moved to the query, the score is affected which returns back an order
>>> that I
>>> > don't want.
>>> > If I leave the is_active_boolean:true in the fq paramater, I get no
>>> > results back.
>>> >
>>> > My question is how can I apply a filter query to users so that the score
>>> is
>>> > not effected?
>>> >
>>>
>>
>>
>>
>> --
>> - sent from my mobile
>>
>>
>>
>
>
> --
> - sent from my mobile
>
--
Met vriendelijke groet,
Martijn van Groningen
Re: joins and filter queries effecting scoring
Posted by Jason Toy <ja...@gmail.com>.
Does anyone have any idea on this issue?
On Tue, Oct 25, 2011 at 11:40 AM, Jason Toy <ja...@gmail.com> wrote:
> Hi Yonik,
>
> Without a Join I would normally query user docs with:
> q=data_text:"test"&fq=is_active_boolean:true
>
> With joining users with posts, I get no no results:
> q={!join from=self_id_i
> to=user_id_i}data_text:"test"&fq=is_active_boolean:true&fq=posts_text:"hello"
>
>
>
> I am able to use this query, but it gives me the results in an order that I
> dont want(nor do I understand its order):
> q={!join from=self_id_i to=user_id_i}data_text:"test" AND
> is_active_boolean:true&fq=posts_text:"hello"
>
> I want the order to be the same as I would get from my original
> "q=data_text:"test"&fq=is_active_boolean:true", but with the ability to join
> with the Posts docs.
>
>
>
>
>
> On Tue, Oct 25, 2011 at 11:30 AM, Yonik Seeley <yonik@lucidimagination.com
> > wrote:
>
>> Can you give an example of the request (URL) you are sending to Solr?
>>
>> -Yonik
>> http://www.lucidimagination.com
>>
>>
>>
>> On Mon, Oct 24, 2011 at 3:31 PM, Jason Toy <ja...@gmail.com> wrote:
>> > I have 2 types of docs, users and posts.
>> > I want to view all the docs that belong to certain users by joining
>> posts
>> > and users together. I have to filter the users with a filter query of
>> > "is_active_boolean:true" so that the score is not effected,but since I
>> do a
>> > join, I have to move the filter query to the query parameter so that I
>> can
>> > get the filter applied. The problem is that since the is_active_boolean
>> is
>> > moved to the query, the score is affected which returns back an order
>> that I
>> > don't want.
>> > If I leave the is_active_boolean:true in the fq paramater, I get no
>> > results back.
>> >
>> > My question is how can I apply a filter query to users so that the score
>> is
>> > not effected?
>> >
>>
>
>
>
> --
> - sent from my mobile
>
>
>
--
- sent from my mobile
Re: joins and filter queries effecting scoring
Posted by Jason Toy <ja...@gmail.com>.
Hi Yonik,
Without a Join I would normally query user docs with:
q=data_text:"test"&fq=is_active_boolean:true
With joining users with posts, I get no no results:
q={!join from=self_id_i
to=user_id_i}data_text:"test"&fq=is_active_boolean:true&fq=posts_text:"hello"
I am able to use this query, but it gives me the results in an order that I
dont want(nor do I understand its order):
q={!join from=self_id_i to=user_id_i}data_text:"test" AND
is_active_boolean:true&fq=posts_text:"hello"
I want the order to be the same as I would get from my original
"q=data_text:"test"&fq=is_active_boolean:true", but with the ability to join
with the Posts docs.
On Tue, Oct 25, 2011 at 11:30 AM, Yonik Seeley
<yo...@lucidimagination.com>wrote:
> Can you give an example of the request (URL) you are sending to Solr?
>
> -Yonik
> http://www.lucidimagination.com
>
>
>
> On Mon, Oct 24, 2011 at 3:31 PM, Jason Toy <ja...@gmail.com> wrote:
> > I have 2 types of docs, users and posts.
> > I want to view all the docs that belong to certain users by joining posts
> > and users together. I have to filter the users with a filter query of
> > "is_active_boolean:true" so that the score is not effected,but since I do
> a
> > join, I have to move the filter query to the query parameter so that I
> can
> > get the filter applied. The problem is that since the is_active_boolean
> is
> > moved to the query, the score is affected which returns back an order
> that I
> > don't want.
> > If I leave the is_active_boolean:true in the fq paramater, I get no
> > results back.
> >
> > My question is how can I apply a filter query to users so that the score
> is
> > not effected?
> >
>
--
- sent from my mobile
Re: joins and filter queries effecting scoring
Posted by Yonik Seeley <yo...@lucidimagination.com>.
Can you give an example of the request (URL) you are sending to Solr?
-Yonik
http://www.lucidimagination.com
On Mon, Oct 24, 2011 at 3:31 PM, Jason Toy <ja...@gmail.com> wrote:
> I have 2 types of docs, users and posts.
> I want to view all the docs that belong to certain users by joining posts
> and users together. I have to filter the users with a filter query of
> "is_active_boolean:true" so that the score is not effected,but since I do a
> join, I have to move the filter query to the query parameter so that I can
> get the filter applied. The problem is that since the is_active_boolean is
> moved to the query, the score is affected which returns back an order that I
> don't want.
> If I leave the is_active_boolean:true in the fq paramater, I get no
> results back.
>
> My question is how can I apply a filter query to users so that the score is
> not effected?
>