Comparing two numeric fields of a Document

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.

--

Hi Rahul,

It's not really possible to do it with traditional query syntaxes
but http://www.elasticsearch.org/guide/reference/query-dsl/script-filter.html
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.

--

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
http://www.elasticsearch.org/guide/reference/query-dsl/script-filter.htmlshould 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.

--

--