Thanks Json for your guidance, this is certainly helpful in proceeding
further ...
Ankit.
On Thu, Feb 11, 2021, 6:31 AM Jason Huynh wrote:
> Hi Ankit,
>
> I haven't had time to try this out but hopefully the answers get you on
> the correct path...
>
> > 1. How can i form an OQL query (synt
Hi Ankit,
I haven't had time to try this out but hopefully the answers get you on the
correct path...
> 1. How can i form an OQL query (syntax) to fetch the latest row based on
> MAX(versionId).
1.) maybe a nested query or use order by?
“Select x,y,z from /data-region d where d.versionId
Can some one pls guide how functionality like "BETWEEN" operator can be
achieved using geode OQL (for Date fields).
Thanks
Ankit
On Tue, Feb 9, 2021, 11:53 PM ankit Soni wrote:
> Thanks Dan for your input. I am able to try this at my end and it's
> working as expected.
>
> As a next steps I ne
Thanks Dan for your input. I am able to try this at my end and it's working
as expected.
As a next steps I need to support somewhat complex queries, so updated a
ValueObject, like
public class ValueObject implements PdxSerializable {
private static final long serialVersionUID = -7546452993728
For the best performance, you should store column2 as a java Map instead of a
String which contains a json document. If column2 was Map, you
could do a query like this:
SELECT * FROM /exampleRegion r WHERE r.column2['k1'] IN SET('v10', 'v15', 'v7')"
You can create an index on the map to optimi
