Comparing two numeric fields of a Document

Elastic Stack Elasticsearch
1

Hi,

Is it possible to compare 2 numeric fields of a document?
I want to fire a search query where I want to achieve n1 > n2, where n1 and
n2 are numeric terms of an Index.

Would really appreciate your help.

Thanks
Rahul.

--

2

Hi Rahul,

It's not really possible to do it with traditional query syntaxes
but Elasticsearch Platform — Find real-time answers at scale | Elastic
should be sufficient.

On Friday, November 23, 2012 8:21:24 AM UTC+13, Rahul Sharma wrote:

Hi,

Is it possible to compare 2 numeric fields of a document?
I want to fire a search query where I want to achieve n1 > n2, where n1
and n2 are numeric terms of an Index.

Would really appreciate your help.

Thanks
Rahul.

--

3

Thanks Chris for the response.

This solves my problem. But not sure how it really works. Does it translate
to lucene queries internally or filters works outside of it at reducer
level.
Will run some performance test.

Any of you have used this feature, would love to hear.

Thanks
Rahul

On Fri, Nov 23, 2012 at 5:53 AM, Chris Male gento0nz@gmail.com wrote:

Hi Rahul,

It's not really possible to do it with traditional query syntaxes but
Elasticsearch Platform — Find real-time answers at scale | Elastic be sufficient.

On Friday, November 23, 2012 8:21:24 AM UTC+13, Rahul Sharma wrote:

Hi,

Is it possible to compare 2 numeric fields of a document?
I want to fire a search query where I want to achieve n1 > n2, where n1
and n2 are numeric terms of an Index.

Would really appreciate your help.

Thanks
Rahul.

--

--