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 Solr User <so...@gmail.com> on 2010/11/22 19:42:55 UTC

Facet - Range Query issue

Hi,

I am having issue with querying and using facet.

This was working fine earlier:

/spell/?q=(sun) AND (pubyear:[1991 TO
2011])&rows=9&facet=true&facet.limit=-1&facet.mincount=1&facet.field=author&facet.field=pubyear&facet.field=format&facet.field=series&facet.field=season&facet.field=imprint&facet.field=category&facet.field=award&facet.field=age&facet.field=reading&facet.field=grade&facet.field=price&spellcheck=true&debugQuery=on

After modifying to use dismax handler with new schema the below query does
not work:

/select/?q=(sun) AND (pubyear:[1991 TO
2011])&rows=9&facet=true&facet.limit=-1&facet.mincount=1&facet.field=author&facet.field=pubyear_facet&facet.field=format_facet&facet.field=series_facet&facet.field=season_facet&facet.field=imprint_facet&facet.field=category_facet&facet.field=award_facet&facet.field=age_facet&facet.field=reading_facet&facet.field=grade_facet&facet.field=price_facet&spellcheck=true&debugQuery=on

<lst name="debug">
  <str name="rawquerystring">(sun) AND (pubyear:[1991 TO 2011])</str>
  <str name="querystring">(sun) AND (pubyear:[1991 TO 2011])</str>
  <str name="parsedquery">+((+DisjunctionMaxQuery((series:sun | desc:sun |
bisacsub:sun | award:sun | format:sun | shortdesc:sun | pubyear:sun |
author:sun^2.0 | category:sun | title:sun^9.0 | isbn10:sun | season:sun |
imprint:sun | subtitle:sun^3.0 | isbn13:sun))
+DisjunctionMaxQuery((series:"pubyear 1991" | desc:"pubyear 1991" |
bisacsub:"pubyear 1991" | award:"pubyear 1991" | format:"pubyear 1991" |
shortdesc:"pubyear 1991" | pubyear:"pubyear 1991" | author:"pubyear
1991"^2.0 | category:"pubyear 1991" | title:"pubyear 1991"^9.0 |
isbn10:"pubyear 1991" | season:"pubyear 1991" | imprint:"pubyear 1991" |
subtitle:"pubyear 1991"^3.0 | isbn13:"pubyear 1991"))
DisjunctionMaxQuery((series:2011 | desc:2011 | bisacsub:2011 | award:2011 |
format:2011 | shortdesc:2011 | pubyear:2011 | author:2011^2.0 |
category:2011 | title:2011^9.0 | isbn10:2011 | season:2011 | imprint:2011 |
subtitle:2011^3.0 | isbn13:2011)))~1) ()</str>
  <str name="parsedquery_toString">+((+(series:sun | desc:sun | bisacsub:sun
| award:sun | format:sun | shortdesc:sun | pubyear:sun | author:sun^2.0 |
category:sun | title:sun^9.0 | isbn10:sun | season:sun | imprint:sun |
subtitle:sun^3.0 | isbn13:sun) +(series:"pubyear 1991" | desc:"pubyear 1991"
| bisacsub:"pubyear 1991" | award:"pubyear 1991" | format:"pubyear 1991" |
shortdesc:"pubyear 1991" | pubyear:"pubyear 1991" | author:"pubyear
1991"^2.0 | category:"pubyear 1991" | title:"pubyear 1991"^9.0 |
isbn10:"pubyear 1991" | season:"pubyear 1991" | imprint:"pubyear 1991" |
subtitle:"pubyear 1991"^3.0 | isbn13:"pubyear 1991") (series:2011 |
desc:2011 | bisacsub:2011 | award:2011 | format:2011 | shortdesc:2011 |
pubyear:2011 | author:2011^2.0 | category:2011 | title:2011^9.0 |
isbn10:2011 | season:2011 | imprint:2011 | subtitle:2011^3.0 |
isbn13:2011))~1) ()</str>
  <lst name="explain" />
  <str name="QParser">DisMaxQParser</str>

Basically we are trying to pass the query string along with a facet field
and the range. Is there any syntax issue? Please help this is urgent as I
got stuck.

Thanks,
Solr user

Re: Facet - Range Query issue

Posted by Solr User <so...@gmail.com>.
Eric,

I solved the issue by adding fq parameter in the query. Thank you so much
for your reply.

Thanks,
Murali

On Mon, Nov 22, 2010 at 1:51 PM, Erick Erickson <er...@gmail.com>wrote:

> Well, without seeing the changes you made to the schema, it's hard to tell
> much.
> Also, could you define "not work"? What, exactly, fails to do what you
> expect?
>
> But the first question I have is "did you reindex after changing your
> schema?".
>
> And have you checked your index to verify that there values in the fields
> you
> changed?
>
> Best
> Erick
>
> On Mon, Nov 22, 2010 at 1:42 PM, Solr User <so...@gmail.com> wrote:
>
> > Hi,
> >
> > I am having issue with querying and using facet.
> >
> > This was working fine earlier:
> >
> > /spell/?q=(sun) AND (pubyear:[1991 TO
> >
> >
> 2011])&rows=9&facet=true&facet.limit=-1&facet.mincount=1&facet.field=author&facet.field=pubyear&facet.field=format&facet.field=series&facet.field=season&facet.field=imprint&facet.field=category&facet.field=award&facet.field=age&facet.field=reading&facet.field=grade&facet.field=price&spellcheck=true&debugQuery=on
> >
> > After modifying to use dismax handler with new schema the below query
> does
> > not work:
> >
> > /select/?q=(sun) AND (pubyear:[1991 TO
> >
> >
> 2011])&rows=9&facet=true&facet.limit=-1&facet.mincount=1&facet.field=author&facet.field=pubyear_facet&facet.field=format_facet&facet.field=series_facet&facet.field=season_facet&facet.field=imprint_facet&facet.field=category_facet&facet.field=award_facet&facet.field=age_facet&facet.field=reading_facet&facet.field=grade_facet&facet.field=price_facet&spellcheck=true&debugQuery=on
> >
> > <lst name="debug">
> >  <str name="rawquerystring">(sun) AND (pubyear:[1991 TO 2011])</str>
> >  <str name="querystring">(sun) AND (pubyear:[1991 TO 2011])</str>
> >  <str name="parsedquery">+((+DisjunctionMaxQuery((series:sun | desc:sun |
> > bisacsub:sun | award:sun | format:sun | shortdesc:sun | pubyear:sun |
> > author:sun^2.0 | category:sun | title:sun^9.0 | isbn10:sun | season:sun |
> > imprint:sun | subtitle:sun^3.0 | isbn13:sun))
> > +DisjunctionMaxQuery((series:"pubyear 1991" | desc:"pubyear 1991" |
> > bisacsub:"pubyear 1991" | award:"pubyear 1991" | format:"pubyear 1991" |
> > shortdesc:"pubyear 1991" | pubyear:"pubyear 1991" | author:"pubyear
> > 1991"^2.0 | category:"pubyear 1991" | title:"pubyear 1991"^9.0 |
> > isbn10:"pubyear 1991" | season:"pubyear 1991" | imprint:"pubyear 1991" |
> > subtitle:"pubyear 1991"^3.0 | isbn13:"pubyear 1991"))
> > DisjunctionMaxQuery((series:2011 | desc:2011 | bisacsub:2011 | award:2011
> |
> > format:2011 | shortdesc:2011 | pubyear:2011 | author:2011^2.0 |
> > category:2011 | title:2011^9.0 | isbn10:2011 | season:2011 | imprint:2011
> |
> > subtitle:2011^3.0 | isbn13:2011)))~1) ()</str>
> >  <str name="parsedquery_toString">+((+(series:sun | desc:sun |
> bisacsub:sun
> > | award:sun | format:sun | shortdesc:sun | pubyear:sun | author:sun^2.0 |
> > category:sun | title:sun^9.0 | isbn10:sun | season:sun | imprint:sun |
> > subtitle:sun^3.0 | isbn13:sun) +(series:"pubyear 1991" | desc:"pubyear
> > 1991"
> > | bisacsub:"pubyear 1991" | award:"pubyear 1991" | format:"pubyear 1991"
> |
> > shortdesc:"pubyear 1991" | pubyear:"pubyear 1991" | author:"pubyear
> > 1991"^2.0 | category:"pubyear 1991" | title:"pubyear 1991"^9.0 |
> > isbn10:"pubyear 1991" | season:"pubyear 1991" | imprint:"pubyear 1991" |
> > subtitle:"pubyear 1991"^3.0 | isbn13:"pubyear 1991") (series:2011 |
> > desc:2011 | bisacsub:2011 | award:2011 | format:2011 | shortdesc:2011 |
> > pubyear:2011 | author:2011^2.0 | category:2011 | title:2011^9.0 |
> > isbn10:2011 | season:2011 | imprint:2011 | subtitle:2011^3.0 |
> > isbn13:2011))~1) ()</str>
> >  <lst name="explain" />
> >  <str name="QParser">DisMaxQParser</str>
> >
> > Basically we are trying to pass the query string along with a facet field
> > and the range. Is there any syntax issue? Please help this is urgent as I
> > got stuck.
> >
> > Thanks,
> > Solr user
> >
>

Re: Facet - Range Query issue

Posted by Erick Erickson <er...@gmail.com>.
Well, without seeing the changes you made to the schema, it's hard to tell
much.
Also, could you define "not work"? What, exactly, fails to do what you
expect?

But the first question I have is "did you reindex after changing your
schema?".

And have you checked your index to verify that there values in the fields
you
changed?

Best
Erick

On Mon, Nov 22, 2010 at 1:42 PM, Solr User <so...@gmail.com> wrote:

> Hi,
>
> I am having issue with querying and using facet.
>
> This was working fine earlier:
>
> /spell/?q=(sun) AND (pubyear:[1991 TO
>
> 2011])&rows=9&facet=true&facet.limit=-1&facet.mincount=1&facet.field=author&facet.field=pubyear&facet.field=format&facet.field=series&facet.field=season&facet.field=imprint&facet.field=category&facet.field=award&facet.field=age&facet.field=reading&facet.field=grade&facet.field=price&spellcheck=true&debugQuery=on
>
> After modifying to use dismax handler with new schema the below query does
> not work:
>
> /select/?q=(sun) AND (pubyear:[1991 TO
>
> 2011])&rows=9&facet=true&facet.limit=-1&facet.mincount=1&facet.field=author&facet.field=pubyear_facet&facet.field=format_facet&facet.field=series_facet&facet.field=season_facet&facet.field=imprint_facet&facet.field=category_facet&facet.field=award_facet&facet.field=age_facet&facet.field=reading_facet&facet.field=grade_facet&facet.field=price_facet&spellcheck=true&debugQuery=on
>
> <lst name="debug">
>  <str name="rawquerystring">(sun) AND (pubyear:[1991 TO 2011])</str>
>  <str name="querystring">(sun) AND (pubyear:[1991 TO 2011])</str>
>  <str name="parsedquery">+((+DisjunctionMaxQuery((series:sun | desc:sun |
> bisacsub:sun | award:sun | format:sun | shortdesc:sun | pubyear:sun |
> author:sun^2.0 | category:sun | title:sun^9.0 | isbn10:sun | season:sun |
> imprint:sun | subtitle:sun^3.0 | isbn13:sun))
> +DisjunctionMaxQuery((series:"pubyear 1991" | desc:"pubyear 1991" |
> bisacsub:"pubyear 1991" | award:"pubyear 1991" | format:"pubyear 1991" |
> shortdesc:"pubyear 1991" | pubyear:"pubyear 1991" | author:"pubyear
> 1991"^2.0 | category:"pubyear 1991" | title:"pubyear 1991"^9.0 |
> isbn10:"pubyear 1991" | season:"pubyear 1991" | imprint:"pubyear 1991" |
> subtitle:"pubyear 1991"^3.0 | isbn13:"pubyear 1991"))
> DisjunctionMaxQuery((series:2011 | desc:2011 | bisacsub:2011 | award:2011 |
> format:2011 | shortdesc:2011 | pubyear:2011 | author:2011^2.0 |
> category:2011 | title:2011^9.0 | isbn10:2011 | season:2011 | imprint:2011 |
> subtitle:2011^3.0 | isbn13:2011)))~1) ()</str>
>  <str name="parsedquery_toString">+((+(series:sun | desc:sun | bisacsub:sun
> | award:sun | format:sun | shortdesc:sun | pubyear:sun | author:sun^2.0 |
> category:sun | title:sun^9.0 | isbn10:sun | season:sun | imprint:sun |
> subtitle:sun^3.0 | isbn13:sun) +(series:"pubyear 1991" | desc:"pubyear
> 1991"
> | bisacsub:"pubyear 1991" | award:"pubyear 1991" | format:"pubyear 1991" |
> shortdesc:"pubyear 1991" | pubyear:"pubyear 1991" | author:"pubyear
> 1991"^2.0 | category:"pubyear 1991" | title:"pubyear 1991"^9.0 |
> isbn10:"pubyear 1991" | season:"pubyear 1991" | imprint:"pubyear 1991" |
> subtitle:"pubyear 1991"^3.0 | isbn13:"pubyear 1991") (series:2011 |
> desc:2011 | bisacsub:2011 | award:2011 | format:2011 | shortdesc:2011 |
> pubyear:2011 | author:2011^2.0 | category:2011 | title:2011^9.0 |
> isbn10:2011 | season:2011 | imprint:2011 | subtitle:2011^3.0 |
> isbn13:2011))~1) ()</str>
>  <lst name="explain" />
>  <str name="QParser">DisMaxQParser</str>
>
> Basically we are trying to pass the query string along with a facet field
> and the range. Is there any syntax issue? Please help this is urgent as I
> got stuck.
>
> Thanks,
> Solr user
>