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 John Blythe <jo...@curvolabs.com> on 2017/01/13 01:44:35 UTC

Referencing a !key and !stat in facet.pivot

hi all

i'm having an issue with an attempt to assign a key to a facet.pivot while
simultaneously referencing one of my stat fields.

i've got something like this:

stats.field={!tag=pivot_stats}lastPrice&
> ...
> facet.pivot={!key=pivot} {!stats=pivot_stats}buyer,vendor& ...


i've attempted it without a space, wrapping the entire pivot in the !key's
{ } braces and anything else i could think of. some return errors, others
return the query results but w an empty

"facet_counts":{
>     ....
>     "facet_pivot":{
>       "pivot":[]}},


it will work if I totally remove the {!key=pivot} portion, however.

is there any way to have both present?

thanks!

Re: Referencing a !key and !stat in facet.pivot

Posted by John Blythe <jo...@curvolabs.com>.
Appreciated. Will give it a whirl tomorrow and report back!

On Sun, Jan 15, 2017 at 12:36 PM Chris Hostetter <ho...@fucit.org>
wrote:

>
>
> If i'm understanding your question correctly, what you're looking for is
>
> simply...
>
>
>
> stats.field={!tag=pivot_stats}lastPrice
>
> facet.pivot={!key=pivot stats=pivot_stats}buyer,vendor
>
>
>
> ...there should only ever be one set of "{}" in the facet.pivot, defining
>
> the set of local params, and there are 2 param=values definied inside
>
> those "{}" (just like if you wanted multiple local params for the
>
> stats.field to define what stats you want to compute)
>
>
>
>
> https://cwiki.apache.org/confluence/display/solr/Local+Parameters+in+Queries
>
>
>
>
> https://cwiki.apache.org/confluence/display/solr/Faceting#Faceting-CombiningStatsComponentWithPivots
>
>
> https://cwiki.apache.org/confluence/display/solr/Faceting#Faceting-LocalParametersforFaceting
>
>
> https://cwiki.apache.org/confluence/display/solr/The+Stats+Component#TheStatsComponent-LocalParameters
>
>
>
>
>
> : Date: Thu, 12 Jan 2017 20:44:35 -0500
>
> : From: John Blythe <jo...@curvolabs.com>
>
> : Reply-To: solr-user@lucene.apache.org
>
> : To: solr-user <so...@lucene.apache.org>
>
> : Subject: Referencing a !key and !stat in facet.pivot
>
> :
>
> : hi all
>
> :
>
> : i'm having an issue with an attempt to assign a key to a facet.pivot
> while
>
> : simultaneously referencing one of my stat fields.
>
> :
>
> : i've got something like this:
>
> :
>
> : stats.field={!tag=pivot_stats}lastPrice&
>
> : > ...
>
> : > facet.pivot={!key=pivot} {!stats=pivot_stats}buyer,vendor& ...
>
> :
>
> :
>
> : i've attempted it without a space, wrapping the entire pivot in the
> !key's
>
> : { } braces and anything else i could think of. some return errors, others
>
> : return the query results but w an empty
>
> :
>
> : "facet_counts":{
>
> : >     ....
>
> : >     "facet_pivot":{
>
> : >       "pivot":[]}},
>
> :
>
> :
>
> : it will work if I totally remove the {!key=pivot} portion, however.
>
> :
>
> : is there any way to have both present?
>
> :
>
> : thanks!
>
> :
>
>
>
> -Hoss
>
> http://www.lucidworks.com/
>
>

Re: Referencing a !key and !stat in facet.pivot

Posted by Chris Hostetter <ho...@fucit.org>.
If i'm understanding your question correctly, what you're looking for is 
simply...

stats.field={!tag=pivot_stats}lastPrice
facet.pivot={!key=pivot stats=pivot_stats}buyer,vendor

...there should only ever be one set of "{}" in the facet.pivot, defining 
the set of local params, and there are 2 param=values definied inside 
those "{}" (just like if you wanted multiple local params for the 
stats.field to define what stats you want to compute)

https://cwiki.apache.org/confluence/display/solr/Local+Parameters+in+Queries

https://cwiki.apache.org/confluence/display/solr/Faceting#Faceting-CombiningStatsComponentWithPivots
https://cwiki.apache.org/confluence/display/solr/Faceting#Faceting-LocalParametersforFaceting
https://cwiki.apache.org/confluence/display/solr/The+Stats+Component#TheStatsComponent-LocalParameters


: Date: Thu, 12 Jan 2017 20:44:35 -0500
: From: John Blythe <jo...@curvolabs.com>
: Reply-To: solr-user@lucene.apache.org
: To: solr-user <so...@lucene.apache.org>
: Subject: Referencing a !key and !stat in facet.pivot
: 
: hi all
: 
: i'm having an issue with an attempt to assign a key to a facet.pivot while
: simultaneously referencing one of my stat fields.
: 
: i've got something like this:
: 
: stats.field={!tag=pivot_stats}lastPrice&
: > ...
: > facet.pivot={!key=pivot} {!stats=pivot_stats}buyer,vendor& ...
: 
: 
: i've attempted it without a space, wrapping the entire pivot in the !key's
: { } braces and anything else i could think of. some return errors, others
: return the query results but w an empty
: 
: "facet_counts":{
: >     ....
: >     "facet_pivot":{
: >       "pivot":[]}},
: 
: 
: it will work if I totally remove the {!key=pivot} portion, however.
: 
: is there any way to have both present?
: 
: thanks!
: 

-Hoss
http://www.lucidworks.com/