GemFire : OQL problems

94 Views Asked by At

I want to perform this query in GemFire

select a from /regionA a,/regionB b where sqrt(sqr(a.x-b.x)+sqr(a.y-b.y)) < a.d

but some operators are not supported such as +, - ... is there any solution to perform such queries ?

1

There are 1 best solutions below

0
On

This is a really old question but, still, is good to have the answer in case anyone else is searching for this... GemFire OQL doesn't support arithmetic operations (not even in the latest version), the list of supported operations and literals can be found in Supported Keywords.

That said, and as a workaround, you can write a simple Function to filter the data and execute the required arithmetic operations on the server side directly.

Cheers.