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 Zheng Lin Edwin Yeo <ed...@gmail.com> on 2017/07/25 12:44:45 UTC
Sum of double fields in JSON Facet
Hi,
I'm trying to do a sum of two double fields in JSON Facet. One of the field
has a value of 69446961.2, while the other is 0. However, when I get the
result, I'm getting a value of 69446959.27. This is 1.93 lesser than the
original value.
What could be the reason?
I'm using Solr 6.5.1.
Regards,
Edwin
Re: Sum of double fields in JSON Facet
Posted by Zheng Lin Edwin Yeo <ed...@gmail.com>.
Hi Amrit,
Thanks for your reply.
So does this means that we can consider this as a bug in JSON Facets?
Regards,
Edwin
On 26 July 2017 at 01:57, Amrit Sarkar <sa...@gmail.com> wrote:
> Zheng,
>
> You may want to check https://issues.apache.org/jira/browse/SOLR-7452. I
> don't know whether they are absolutely related but I am sure I have seen
> complaints and enquiries regarding not precise statistics with JSON Facets.
>
> Amrit Sarkar
> Search Engineer
> Lucidworks, Inc.
> 415-589-9269
> www.lucidworks.com
> Twitter http://twitter.com/lucidworks
> LinkedIn: https://www.linkedin.com/in/sarkaramrit2
>
> On Tue, Jul 25, 2017 at 6:27 PM, Zheng Lin Edwin Yeo <edwinyeozl@gmail.com
> >
> wrote:
>
> > This is the way which I put my JSON facet.
> >
> > totalAmount:"sum(sum(amount1_d,amount2_d))"
> >
> > amount1_d: 69446961.2
> > amount2_d: 0
> >
> > Result I get: 69446959.27
> >
> >
> > Regards,
> > Edwin
> >
> >
> > On 25 July 2017 at 20:44, Zheng Lin Edwin Yeo <ed...@gmail.com>
> > wrote:
> >
> > > Hi,
> > >
> > > I'm trying to do a sum of two double fields in JSON Facet. One of the
> > > field has a value of 69446961.2, while the other is 0. However, when I
> > get
> > > the result, I'm getting a value of 69446959.27. This is 1.93 lesser
> than
> > > the original value.
> > >
> > > What could be the reason?
> > >
> > > I'm using Solr 6.5.1.
> > >
> > > Regards,
> > > Edwin
> > >
> >
>
Re: Sum of double fields in JSON Facet
Posted by Amrit Sarkar <sa...@gmail.com>.
Zheng,
You may want to check https://issues.apache.org/jira/browse/SOLR-7452. I
don't know whether they are absolutely related but I am sure I have seen
complaints and enquiries regarding not precise statistics with JSON Facets.
Amrit Sarkar
Search Engineer
Lucidworks, Inc.
415-589-9269
www.lucidworks.com
Twitter http://twitter.com/lucidworks
LinkedIn: https://www.linkedin.com/in/sarkaramrit2
On Tue, Jul 25, 2017 at 6:27 PM, Zheng Lin Edwin Yeo <ed...@gmail.com>
wrote:
> This is the way which I put my JSON facet.
>
> totalAmount:"sum(sum(amount1_d,amount2_d))"
>
> amount1_d: 69446961.2
> amount2_d: 0
>
> Result I get: 69446959.27
>
>
> Regards,
> Edwin
>
>
> On 25 July 2017 at 20:44, Zheng Lin Edwin Yeo <ed...@gmail.com>
> wrote:
>
> > Hi,
> >
> > I'm trying to do a sum of two double fields in JSON Facet. One of the
> > field has a value of 69446961.2, while the other is 0. However, when I
> get
> > the result, I'm getting a value of 69446959.27. This is 1.93 lesser than
> > the original value.
> >
> > What could be the reason?
> >
> > I'm using Solr 6.5.1.
> >
> > Regards,
> > Edwin
> >
>
Re: Sum of double fields in JSON Facet
Posted by Zheng Lin Edwin Yeo <ed...@gmail.com>.
This is the way which I put my JSON facet.
totalAmount:"sum(sum(amount1_d,amount2_d))"
amount1_d: 69446961.2
amount2_d: 0
Result I get: 69446959.27
Regards,
Edwin
On 25 July 2017 at 20:44, Zheng Lin Edwin Yeo <ed...@gmail.com> wrote:
> Hi,
>
> I'm trying to do a sum of two double fields in JSON Facet. One of the
> field has a value of 69446961.2, while the other is 0. However, when I get
> the result, I'm getting a value of 69446959.27. This is 1.93 lesser than
> the original value.
>
> What could be the reason?
>
> I'm using Solr 6.5.1.
>
> Regards,
> Edwin
>