Custom_filters_score and percolator


(samuel merlet) #1

Hi,

Im doing a custom_filters_score query , i registered it as a percolator .
Then when i add or update a document that is supposed to match the query it
doesn't .
Is it because i use a custom_filters_score query ?

here is my query :

{
"query":{
"custom_filters_score":{
"query":{
"filtered":{
"query":{
"match_all":{}
},
"filter":{
"nested":{
"path":"profile_type.profile_roles",
"query":{
"term":{
"profile_type.profile_roles.role_id":"11"
}
}
}
}
}
},
"filters":[
{
"filter":{
"nested":{
"path":"profile_type.profile_roles",
"query":{
"filtered":{
"query":{
"match_all":{}
},
"filter":{
"and":[
{
"term":{
"profile_type.profile_roles.role_id":"11"
}
},
{
"terms":{

"profile_type.profile_roles.skills.skill_id":["8", "29"]
}
},
{
"terms":{
"profile_type.profile_roles.terms.term_id":["1",
"1", "2"]
}
}
]
}
}
}
}
},
"boost":10
},
{
"filter":{
"nested":{
"path":"profile_type.profile_roles",
"query":{
"filtered":{
"query":{
"match_all":{}
},
"filter":{
"and":[
{
"term":{
"profile_type.profile_roles.role_id":"11"
}
},
{
"terms":{

"profile_type.profile_roles.skills.skill_id":["8", "29"]
}
}
]
}
}
}
}
},
"boost":8
},
{
"filter":{
"nested":{
"path":"profile_type.profile_roles",
"query":{
"filtered":{
"query":{
"match_all":{}
},
"filter":{
"and":[
{
"term":{
"profile_type.profile_roles.role_id":"11"
}
},
{
"terms":{
"profile_type.profile_roles.terms.term_id":["1",
"1", "2"]
}
}
]
}
}
}
}
},
"boost":5
}
],
"score_mode":"total"
}
}
}

Any help will be really appreciated thanks

--


(Igor Motov) #2

Percolator fails because of "nested" queries. It cannot work with nested
documents yet.

On Thursday, November 1, 2012 12:29:24 PM UTC-4, samuel merlet wrote:

Hi,

Im doing a custom_filters_score query , i registered it as a percolator .
Then when i add or update a document that is supposed to match the query it
doesn't .
Is it because i use a custom_filters_score query ?

here is my query :

{
"query":{
"custom_filters_score":{
"query":{
"filtered":{
"query":{
"match_all":{}
},
"filter":{
"nested":{
"path":"profile_type.profile_roles",
"query":{
"term":{
"profile_type.profile_roles.role_id":"11"
}
}
}
}
}
},
"filters":[
{
"filter":{
"nested":{
"path":"profile_type.profile_roles",
"query":{
"filtered":{
"query":{
"match_all":{}
},
"filter":{
"and":[
{
"term":{
"profile_type.profile_roles.role_id":"11"
}
},
{
"terms":{

"profile_type.profile_roles.skills.skill_id":["8", "29"]
}
},
{
"terms":{
"profile_type.profile_roles.terms.term_id":["1",
"1", "2"]
}
}
]
}
}
}
}
},
"boost":10
},
{
"filter":{
"nested":{
"path":"profile_type.profile_roles",
"query":{
"filtered":{
"query":{
"match_all":{}
},
"filter":{
"and":[
{
"term":{
"profile_type.profile_roles.role_id":"11"
}
},
{
"terms":{

"profile_type.profile_roles.skills.skill_id":["8", "29"]
}
}
]
}
}
}
}
},
"boost":8
},
{
"filter":{
"nested":{
"path":"profile_type.profile_roles",
"query":{
"filtered":{
"query":{
"match_all":{}
},
"filter":{
"and":[
{
"term":{
"profile_type.profile_roles.role_id":"11"
}
},
{
"terms":{
"profile_type.profile_roles.terms.term_id":["1",
"1", "2"]
}
}
]
}
}
}
}
},
"boost":5
}
],
"score_mode":"total"
}
}
}

Any help will be really appreciated thanks

--


(samuel merlet) #3

OK i see , do you know if this will be supported somedays ? Is there any
work around ?

thanks

On Thursday, November 1, 2012 9:33:32 PM UTC+1, Igor Motov wrote:

Percolator fails because of "nested" queries. It cannot work with nested
documents yet.

On Thursday, November 1, 2012 12:29:24 PM UTC-4, samuel merlet wrote:

Hi,

Im doing a custom_filters_score query , i registered it as a percolator .
Then when i add or update a document that is supposed to match the query it
doesn't .
Is it because i use a custom_filters_score query ?

here is my query :

{
"query":{
"custom_filters_score":{
"query":{
"filtered":{
"query":{
"match_all":{}
},
"filter":{
"nested":{
"path":"profile_type.profile_roles",
"query":{
"term":{
"profile_type.profile_roles.role_id":"11"
}
}
}
}
}
},
"filters":[
{
"filter":{
"nested":{
"path":"profile_type.profile_roles",
"query":{
"filtered":{
"query":{
"match_all":{}
},
"filter":{
"and":[
{
"term":{
"profile_type.profile_roles.role_id":"11"
}
},
{
"terms":{

"profile_type.profile_roles.skills.skill_id":["8", "29"]
}
},
{
"terms":{

"profile_type.profile_roles.terms.term_id":["1", "1", "2"]
}
}
]
}
}
}
}
},
"boost":10
},
{
"filter":{
"nested":{
"path":"profile_type.profile_roles",
"query":{
"filtered":{
"query":{
"match_all":{}
},
"filter":{
"and":[
{
"term":{
"profile_type.profile_roles.role_id":"11"
}
},
{
"terms":{

"profile_type.profile_roles.skills.skill_id":["8", "29"]
}
}
]
}
}
}
}
},
"boost":8
},
{
"filter":{
"nested":{
"path":"profile_type.profile_roles",
"query":{
"filtered":{
"query":{
"match_all":{}
},
"filter":{
"and":[
{
"term":{
"profile_type.profile_roles.role_id":"11"
}
},
{
"terms":{

"profile_type.profile_roles.terms.term_id":["1", "1", "2"]
}
}
]
}
}
}
}
},
"boost":5
}
],
"score_mode":"total"
}
}
}

Any help will be really appreciated thanks

--


(system) #4