lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Erik Hatcher <erik.hatc...@gmail.com>
Subject Re: Unexpected results in Solr 4 Pivot Faceting
Date Fri, 07 Sep 2012 09:23:25 GMT
Pivot facets currently only work with individual terms, not ranges.

The response you provided does look odd in that there are duplicate timestamps listed, but
pivots were only implemented for textual (string being the most common type) fields initially.

	Erik

On Sep 6, 2012, at 19:04 , Dotan Cohen wrote:

> In Solr 4, using this faceting pivot:
> 
> &facet=true
> &facet.field=provider
> &facet.range=timestamp
> &f.timestamp.facet.range.start=1346968500
> &f.timestamp.facet.range.end=1346969000
> &f.timestamp.facet.range.gap=100
> &facet.pivot=timestamp,provider
> 
> I am getting facet results with the timestamp -1325191116. In fact,
> most of them have that date. What am I doing wrong? I am trying to get
> a table of facets for each provider for each time period:
> 1346968500 - 1346968600
> 1346968600 - 1346968700
> 1346968700 - 1346968800
> 1346968800 - 1346968900
> 1346968900 - 1346969000
> 
> Assuming 12 providers and 5 time periods, I should be getting 60
> results. But I'm not, I am getting repeated results like this:
> 
> 52     <lst name="facet_pivot">
> 53       <arr name="timestamp,provider">
> 54         <lst>
> 55           <str name="field"> timestamp </str>
> 56           <int name="value"> -1325191116 </int>
> 57           <int name="count"> 17 </int>
> 58           <arr name="pivot"/>
> 59         </lst>
> 60         <lst>
> 61           <str name="field"> timestamp </str>
> 62           <int name="value"> -1325191116 </int>
> 63           <int name="count"> 17 </int>
> 64           <arr name="pivot"/>
> 65         </lst>
> 66         <lst>
> 67           <str name="field"> timestamp </str>
> 68           <int name="value"> -1325191116 </int>
> 69           <int name="count"> 15 </int>
> 70           <arr name="pivot"/>
> 71         </lst>
> 72         <lst>
> 73           <str name="field"> timestamp </str>
> 74           <int name="value"> -1325191116 </int>
> 75           <int name="count"> 14 </int>
> 76           <arr name="pivot"/>
> 77         </lst>
> 78         <lst>
> 79           <str name="field"> timestamp </str>
> 80           <int name="value"> -1325191116 </int>
> 81           <int name="count"> 14 </int>
> 82           <arr name="pivot"/>
> 83         </lst>
> 
> Note that I am connecting to a Solr 4 instance. Thanks for providing
> any insight.
> 
> 
> 
> 
> 
> -- 
> Dotan Cohen
> 
> http://gibberish.co.il
> http://what-is-what.com


Mime
View raw message