Thanks Erick,
The field is defined as a pfloat.
<field name="Value" type="pfloat" docValues="true" multiValued="false"
indexed="true" stored="true"/>
I took your advice and tried smaller result range and the counts look good. I
might try an index rebuild I’m wondering if the data has somehow been corrupted
by a combination of old and new index mappings.
Thanks again for your assistance.
"responseHeader":{
"zkConnected":true,
"status":0,
"QTime":7},
"response":{"numFound":3,"start":0,"docs":[
{
"Value":34.0},
{
"Value":34.0},
{
"Value":34.0}]
},
"facet_counts":
"facet_queries":{},
"facet_ranges":{
"Value:{
"counts":[
"0.0",3],
"gap":100.0,
"before":0,
"after":0,
"between":3,
"start":0.0,
"end":2000.0}}
________________________________
From: Erick Erickson <erickerick...@gmail.com>
Sent: Friday, 7 September 2018 12:54:48 PM
To: solr-user
Subject: Re: Solr range faceting
Indeed this doesn't look right. By my count, you're missing 599 counts
you'd expect in that range, although the after and between numbers
total the numFound.
What kind of a field is Value? Given the number of docs missing, I'd
guess you could get the number of docs down really small and post
them. Something like
values 1, 2, 3, 4, 5, ....
and your range query so we could try it.
What is the fieldType definition and field for Value?
And finally, do you get different results if you use json faceting?
Best,
Erick
On Thu, Sep 6, 2018 at 5:51 PM Dwane Hall <dwaneh...@hotmail.com> wrote:
>
> Thanks Jan that has fixed the bucket issue but I'm a little confused at why
> zero counts exist for some buckets when they appear to be values in them?
>
> "response":{"numFound":869,"start":0,"docs":[
> {
> "Value":9475.08},
> {
> "Value":780.0},
> {
> "Value":9475.08},
> {
> "Value":1000.0},
> {
> "Value":500000.0},
> {
> "Value":50.0},
> {
> "Value":0.0},
> {
> "Value":800.0},
> {
> "Value":0.0},
> {
> "Value":1000.0},
> {
> "Value":1000.0},
> {
> "Value":5000.0},
> {
> "Value":2000.0},
> {
> "Value":4000.0},
> {
> "Value":1500.0},
> {
> "Value":0.0},
> {
> "Value":10000.0},
> {
> "Value":5000.0},
> {
> "Value":1000.0},
> {
> "Value":0.0},
> {
> "Value":1200.0},
> {
> "Value":9000.0},
> {
> "Value":1500.0},
> {
> "Value":10000.0},
> {
> "Value":5000.0},
> {
> "Value":4000.0},
> {
> "Value":5000.0},
> {
> "Value":5000.0},
> {
> "Value":10000.0},
> {
> "Value":1000.0}]
> },
>
> "facet_counts":{
> "facet_queries":{},
> "facet_ranges":{
> "Value":{
> "counts":[
> "0.0",9,
> "100.0",0,
> "200.0",0,
> "300.0",0,
> "400.0",80,
> "500.0",0,
> "600.0",0,
> "700.0",69,
> "800.0",0,
> "900.0",0,
> "1000.0",0,
> "1100.0",0,
> "1200.0",0,
> "1300.0",0,
> "1400.0",0,
> "1500.0",0,
> "1600.0",0,
> "1700.0",0,
> "1800.0",0,
> "1900.0",9],
> "gap":100.0,
> "before":0,
> "after":103,
> "between":766,
> "start":0.0,
> "end":2000.0}
>
> Cheers,
>
> Dwane
> ________________________________
> From: Jan H?ydahl <jan....@cominvent.com>
> Sent: Friday, 7 September 2018 9:23:44 AM
> To: solr-user@lucene.apache.org
> Subject: Re: Solr range faceting
>
> Try facet.minCount=0
>
> Jan
>
> > 7. sep. 2018 kl. 01:07 skrev Dwane Hall <dwaneh...@hotmail.com>:
> >
> > Good morning Solr community. I'm having a few facet range issues for which
> > I'd appreciate some advice when somebody gets a spare couple of minutes.
> >
> > Environment
> > Solr Cloud (7.3.1)
> > Single Shard Index, No replicas
> >
> > Facet Configuration (I'm using the request params API and useParams at
> > runtime)
> > "facet":"true",
> > "facet.mincount":1,
> > "facet.missing":"false",
> > "facet.range":"Value"
> > "f.Value.facet.range.start":0.0,
> > "f.Value.facet.range.end":2000.0,
> > "f.Value.facet.range.gap":100,
> > "f.Value.facet.range.include":"edge",
> > "f.Value.facet.range.other":"all",
> >
> > My problem
> > With my range facet configuration I'm expecting to see a facet range entry
> > for every 'step' (100 in my case) between my facet.range.start and
> > facet.range.end settings. Something like the following 0.0,100.0,200.0,
> > ...2000.0 with a sum of the number of values that occur between each range
> > step. This does not appear to be the case and in some instances I don't
> > appear to get counts for some range steps (800.0 and 1000.0 for example are
> > present in my result set range below but I don't get a range value facets
> > for these values?)
> >
> > Am I completely misunderstanding how range facets are supposed to work or
> > is my configuration a little askew?
> >
> > Any advice would be greatly appreciated.
> >
> > The Solr Response
> > "responseHeader":{
> > "zkConnected":true,
> > "status":0,
> > "QTime":121},
> >
> > "response":{"numFound":869,"start":0,"docs":[
> > {
> > "Value":9475.08},
> > {
> > "Value":780.0},
> > {
> > "Value":1000.0},
> > {
> > "Value":500000.0},
> > {
> > "Value":50.0},
> > {
> > "Value":0.0},
> > {
> > "Value":800.0},
> > {
> > "Value":0.0},
> > {
> > "Value":1000.0},
> > {
> > "Value":1000.0},
> > {
> > "Value":5000.0},
> > {
> > "Value":2000.0},
> > {
> > "Value":4000.0},
> > {
> > "Value":1500.0},
> > {
> > "Value":0.0},
> > {
> > "Value":10000.0},
> > {
> > "Value":1000.0}]
> > },
> > "facet_counts":{
> > "facet_ranges":{
> > "Value":{
> > "counts":[
> > "0.0",9,
> > "400.0",80,
> > "700.0",69,
> > "1900.0",9],
> > "gap":100.0,
> > "before":0,
> > "after":103,
> > "between":766,
> > "start":0.0,
> > "end":2000.0}}
> >
> > Cheers,
> >
> > Dwane
